url_alias table not updated when upgrade to the new seo_url table OC 3.0.2.0 anyone know how to doing manually.

everything was upgraded almost perfect

IP_CAM wrote: ↑

Thu Jun 21, 2018 2:56 am

everything was upgraded almost perfect

Well, you possibly feel this way
But since you did not mention, in detail, on how you 'upgraded', and what you
upgraded, nobody probably really believes, that your thing will ever work again as
planned. But so, it's of no use, to bother about, just to start another discussion on
this, this place is already full of it.

But please, don't take it personal, it's just an information, since most Upgraders
forget, that 99.99 percent of all OC Users don't use a strictly default Version OC,
but one, in some ways Extension-enhanced and/or modified. With the consequence,
that NO upgrade can work, as planned, in such setups. But that's not OpenCart's
fault, it's, at best, just poor or non-existing Communication, adding to a lot of
problemes, by a lot of OC Users, eager, to mock up their existing System,
with incompatible Parts ... like uploading Win10 Drivers and DLL's onto an XP!

Good Luck!
Ernie

CREATE TABLE IF NOT EXISTS `url_alias` (
  `url_alias_id` int(11) NOT NULL,
  `query` varchar(255) NOT NULL,
  `keyword` varchar(255) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `seo_url` (
  `seo_url_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `query` varchar(255) NOT NULL,
  `keyword` varchar(255) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=DEFAULT CHARSET=utf8;

kestas wrote: ↑

Fri Jun 22, 2018 7:23 am

You can try do it in your phpMyAdmin.

IMPORTANT!!! Before you try, please make backup all of your tables.
If you have both oc_seo_url and oc_url_alias (old and new) tables and new table is empty DROP new table.
Open your DB in phpMyAdmin click tab SQL

Make sure what prefix of your tables if not "oc" change it in code below.
first add:

Code: Select all

ALTER TABLE `oc_url_alias` RENAME TO `oc_seo_url`

click GO

next click tab SQL add:

Code: Select all

ALTER TABLE `oc_seo_url`
CHANGE COLUMN  `url_alias_id`  seo_url_id int(11) NOT NULL

click GO

next click tab SQL add:

Code: Select all

ALTER TABLE `oc_seo_url`
ADD COLUMN  `store_id` int(11) NOT NULL
AFTER       `seo_url_id`

click GO

next click tab SQL add:

Code: Select all

ALTER TABLE `oc_seo_url`
ADD COLUMN  `language_id` int(11) NOT NULL
AFTER       `store_id`

click GO
IMPORTANT!!! Before you try, please make backup all of your tables.

UPDATE `oc_seo_url` SET `language_id` = '1';

ALTER TABLE `oc_seo_url`
ADD COLUMN  `language_id` int(11) NOT NULL DEFAULT '1'
AFTER       `store_id`

OpenCode wrote: ↑

Sat Jun 23, 2018 1:16 am

kestas, I like to buy you a cup of coffee. please let me know how to do that.

To kestas,
For your cup of coffee.
For helping me on the DB solution
From OpenCode.
Thank you