AbanteCart Community

eCommerce construction => Installation and Configuration => Upgrade => Topic started by: alevene on October 13, 2018, 11:49:09 AM

Title: Error running 1.2.13 PHPMyAdmin command
Post by: alevene on October 13, 2018, 11:49:09 AM

I copied over the contents of 1.2.13 upgrade.sql in a PHPmyAdmin database SQL Query window after editing the command prefix from abc_ to ac_. It failed -

This is the upgrade.sql file contents -

ALTER TABLE `ac_store_descriptions`
CHANGE COLUMN `description` `description` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `title` `title` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `meta_description` `meta_description` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `meta_keywords` `meta_keywords` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ;

ALTER TABLE `ac_customer_transactions`
  CHANGE COLUMN `credit` `credit` DECIMAL(15,4) NULL DEFAULT '0',
  CHANGE COLUMN `debit` `debit` DECIMAL(15,4) NULL DEFAULT '0';

It showed this error -

Error

SQL query:

ALTER TABLE `ac_store_descriptions`
CHANGE COLUMN `description` `description` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `title` `title` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `meta_description` `meta_description` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `meta_keywords` `meta_keywords` LONGTEXT NULL DEFAULT '' COMMENT 'translatable'

MySQL said: Documentation
#1054 - Unknown column 'title' in 'ac_store_descriptions'

Any ideas on how to fix this problem?

Title: Re: Error running 1.2.13 PHPMyAdmin command
Post by: Basara on October 15, 2018, 02:13:37 AM

Quote from: alevene on October 13, 2018, 11:49:09 AM

MySQL said: Documentation
#1054 - Unknown column 'title' in 'ac_store_descriptions'

Any ideas on how to fix this problem?

Add this column manually

Title: Re: Error running 1.2.13 PHPMyAdmin command
Post by: alevene on October 15, 2018, 08:43:52 AM

I will try that, but I installed a demo version and checked that table. It didn't have a column either.