Post by mbeerden » Mon Nov 19, 2012 10:34 pm

I have synced all the upgrade files with my current (demo) installation. Everything seems allright, but after running mysite.com/install/ i'm getting the following error:

Could not Execute: ALTER TABLE customer ADD token varchar(255) NOT NULL COMMENT '' COLLATE utf8_bin AFTER approved;
Unknown column 'approved' in 'customer'

is there a manual for DB changes so i can change the DB manually?

New member

Posts

Joined
Tue Nov 03, 2009 5:06 am

Post by mbeerden » Tue Nov 20, 2012 1:27 am

allright.. i've updated my table manually with a SQL file i've found.

now i'm encountering the following error when trying to reacht the admin section:

Parse error: syntax error, unexpected T_VARIABLE in /var/www/vhosts/******.nl/httpdocs/testmaster/admin/controller/common/header.php on line 141

Line 141 is:

Code: Select all

$this->data['language'] = $this->url->link('localisation/language', 'token=' . $this->session->data['token'], 'SSL');
The setting in the admin is en for the default admin language. Anybody an idea what causes this problem?

New member

Posts

Joined
Tue Nov 03, 2009 5:06 am

Post by mbeerden » Tue Nov 20, 2012 1:47 am

found it.. just forgot a ; at the rule before..

New member

Posts

Joined
Tue Nov 03, 2009 5:06 am

Post by mbeerden » Tue Nov 20, 2012 1:55 am

upgrade goes well. but now i found the following problem. I have manually updated the DB but i haven't imported the FULLTEXT keys. Anyone knows the SQL code to import these FULLTEXT keys? I need the following:

It's in the table categories_description

FULLTEXT KEY `description` (`description`),
FULLTEXT KEY `tag` (`tag`)

I can't just remove the table because of this table is filled with lots of categories.

Original code:

Code: Select all

CREATE TABLE `oc_product_description` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `language_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `description` text COLLATE utf8_bin NOT NULL,
  `meta_description` varchar(255) COLLATE utf8_bin NOT NULL,
  `meta_keyword` varchar(255) COLLATE utf8_bin NOT NULL,
  `tag` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`product_id`,`language_id`),
  KEY `name` (`name`),
  FULLTEXT KEY `description` (`description`),
  FULLTEXT KEY `tag` (`tag`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

New member

Posts

Joined
Tue Nov 03, 2009 5:06 am

Post by mbeerden » Wed Nov 21, 2012 4:43 am

anyone knows how i can add the fulltext key?

New member

Posts

Joined
Tue Nov 03, 2009 5:06 am

Post by mbeerden » Sun Nov 25, 2012 2:29 am

aint there anyone with this Opencart DB knowledge?

New member

Posts

Joined
Tue Nov 03, 2009 5:06 am
Who is online

Users browsing this forum: No registered users and 26 guests