Can't upgrade opencart

After installation of latest version of opencart, it asks me to upgrade, however, can't get through all the process, the sys says:

Error Code(0): Error: Table 'xx.oc_url_alias' doesn't exist
Error No: 1146
SHOW INDEX FROM `oc_url_alias` WHERE Key_name != 'PRIMARY' in D:\localuser\ftp6187883\Web\system\library\db\mysqli.php on line 40

How can I solve this problem?

Thanks a lot.

What opencart version did you previously have? Pretty weird that it was missing the url_alias table. You could run this query in phpmyadmin on that database:

I just downloaded the latest version and installed it, and right after installation, when I tried to go to management console, it showed the Upgrade page and the error. Let me try your method and get back to you.

Thank you so much.

Thanks for your reply, and now I can pass all the patches of upgrade, after it shows successful installation of upgrade and I clicked the Continue button, it turns back to Upgrade page (page 1 of 2) , that's so wierd. Would you please help me again?

Thank you

florinsith wrote: ↑

Fri Jul 21, 2017 2:54 pm

What opencart version did you previously have? Pretty weird that it was missing the url_alias table. You could run this query in phpmyadmin on that database:

Code: Select all

CREATE TABLE `oc_url_alias` (
  `url_alias_id` int(11) NOT NULL AUTO_INCREMENT,
  `query` varchar(255) NOT NULL,
  `keyword` varchar(255) NOT NULL,
  PRIMARY KEY (`url_alias_id`),
  KEY `query` (`query`),
  KEY `keyword` (`keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

Check your config.php and admin/config.php files, are they getting written?