OpenCart Community

When attempting to upgrade from 1.5.4 to 1.5.4.1 I am getting the following error


Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/ptgpete/sports.ptgamesinc.com/store/install/model/upgrade.php on line 50
Could not Execute: ALTER TABLE product_tag ADD INDEX product_id (product_id);
Table 'sports_ptgamesinc_com_open_carts.product_tag' doesn't exist

Please help.

Have u tried this?

avvici wrote:Open the database in Your PHP MY ADMIN . Click on the SQL TAB and paste this code in the box:

Code: Select all

CREATE TABLE `oc_product_tag` (
  `product_tag_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `tag` varchar(32) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`product_tag_id`),
  KEY `product_id` (`product_id`),
  KEY `language_id` (`language_id`),
  KEY `tag` (`tag`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 

Just press GO and it will create the table you are missing.

YOU NEED TO REPLACE the oc_ prefix with your own prefix or just delete it if you have none.

You don't need to run the upgrade script. There are no database changes.

growlbox wrote:Have u tried this?

avvici wrote:Open the database in Your PHP MY ADMIN . Click on the SQL TAB and paste this code in the box:

Code: Select all

CREATE TABLE `oc_product_tag` (
  `product_tag_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `tag` varchar(32) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`product_tag_id`),
  KEY `product_id` (`product_id`),
  KEY `language_id` (`language_id`),
  KEY `tag` (`tag`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Just press GO and it will create the table you are missing.

YOU NEED TO REPLACE the oc_ prefix with your own prefix or just delete it if you have none.

Hi thank you for the reply. Before I go monkeying with the DB can anyone else confirm this table structure? Also if there are no database changes in 1.5.4.1 then why would my database be missing this table?

Again thanks for the help.

It's a bug in the upgrade script. Like I said, don't worry about it. Only one file is changed between the two releases.