Post by Qphoria » Wed Feb 04, 2009 7:07 am

not quite done. don't forget that all countries are disabled by default so you will still need to go back and enable the few countries you do need

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Andrew_M » Wed Feb 04, 2009 7:17 am

I don't see "SQL Query" anywhere. Should I import the .sql to the OpenCart database?

New member

Posts

Joined
Sat Jan 03, 2009 1:38 am

Post by Qphoria » Wed Feb 04, 2009 7:33 am

if using 0.7.9 rc8 or final, you can actually upload the sql file by using via database backup/restore page under admin->configuration->backup/restore

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Andrew_M » Wed Feb 04, 2009 10:54 am

Qphoria wrote: if using 0.7.9 rc8 or final, you can actually upload the sql file by using via database backup/restore page under admin->configuration->backup/restore
Okay I tried that and now I get this:

Code: Select all

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `zone` ADD `zone_status` int(1) NOT NULL default '1' After `name`' at line 14
Error No: 1064
# # ALTER TABLE STRUCTURE FOR: `country` # Default is '0' all countries disabled, set default to '1' to enable all countries # ALTER TABLE `country` ADD `country_status` int(1) NOT NULL default '0' After `name`; # # ALTER TABLE STRUCTURE FOR: 'zone' # Default is '1' all zones enabled, set default to '0' to disable all zones # ALTER TABLE `zone` ADD `zone_status` int(1) NOT NULL default '1' After `name`;

New member

Posts

Joined
Sat Jan 03, 2009 1:38 am

User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Andrew_M » Wed Feb 04, 2009 10:07 pm

I know how to use phpmyadmin and cpanel, I'm just wondering if I should import the .sql to the OpenCart database?

New member

Posts

Joined
Sat Jan 03, 2009 1:38 am

Post by Qphoria » Wed Feb 04, 2009 10:40 pm

yes

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 2 guests