Post by lukkaino » Fri Feb 06, 2009 7:55 pm

I imported the database opencart "inside phpadmin and generated error :



query SQL:

INSERT INTO `currency` (`currency_id`, `title`, `code`, `symbol_left`, `symbol_right`, `decimal_place`, `value`, `status`, `date_modified`) VALUES ('1', 'Pound Sterling', 'GBP', '�', '', '2', '1.00000000', '1', '2009-01-27 16:43:14');

MySQL Message: 

#1366 - Incorrect string value: '\xA3' for column 'symbol_left' at row 1


Result after installation step 1:

Incorrect datetime value: '' for column 'date_modified' at row 1.

Thank you for your attention.

Lukkaino from Italy

Newbie

Posts

Joined
Fri Feb 06, 2009 7:46 pm

Post by Qphoria » Fri Feb 06, 2009 8:46 pm

The file wasn't meant to be imported to phpmyadmin, not that it should matter... But why not use the installer?

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by lukkaino » Fri Feb 06, 2009 11:00 pm

Thank You  ;)

Newbie

Posts

Joined
Fri Feb 06, 2009 7:46 pm
Who is online

Users browsing this forum: No registered users and 6 guests