My site has been upgraded recently from v7.0.0. to v7.0.1. The auto upgrade install stops in the middle of the process but I am able to enter the SQL of few modules manually using phpmyadmin.
However, I encountered below error when entering the SQL file of the following modules.
Is this mean that I have a missing tables. I hope somebody could advise how to set up the missing tables. I need it to proceed from 7.0.1 to 7.0.2 upgrades. Thanks in advance.
'FILE' module.
-------- SQL query: UPDATE `[db_prefix]_types` SET `Icon` = '006.png' WHERE `Type` = 'application/octet-stream'
MySQL said: #1146 - Table 'mydomainnamehere.[db_prefix]_types' doesn't exist
BLOGS Module
-----ALTER TABLE `[db_prefix]_posts` ADD FULLTEXT KEY `ftTags` ( `Tags` ) ;
MySQL said: #1146 - Table 'mydomainnamehere.[db_prefix]_posts' doesn't exist
PAYMENT Modules
----- SQL query:
ALTER TABLE `[db_prefix]providers_options` ADD `order` tinyint( 4 ) NOT NULL default '0';
MySQL said: #1146 - Table 'mydomainnamehere.[db_prefix]providers_options' doesn't
exist
----
MAP PROFILES module
-----UPDATE `[db_prefix]countries` SET `lat` = 41.4097,
`lng` = 21.687,
`failed` =0 WHERE `country` = 'MK';
MySQL said: #1146 - Table 'mydomainnamehere.[db_prefix]countries' doesn't exist
Please help.
