Community Forums

by **Qphoria** » Tue Feb 03, 2009 11:07 pm

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

by **Andrew_M** » Tue Feb 03, 2009 11:17 pm

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

by **Qphoria** » Tue Feb 03, 2009 11:33 pm

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

by **Andrew_M** » Wed Feb 04, 2009 2: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`;

by **Qphoria** » Wed Feb 04, 2009 3:42 am

well i dunno..

back to phpmyadmin

Some tutorials to get you started understanding cpanel and mysql and phpmyadmin:
http://www.cpanel.net/docs/cpanel/phpMyAdmin.htm
http://www.cpanel.net/support/docs/11/c ... s_php.html
http://www.php-editors.com/articles/sql_phpmyadmin.php
http://www.tutorialized.com/tutorial/Cr ... dmin/23140

by **Andrew_M** » Wed Feb 04, 2009 2:07 pm

Qphoria wrote:well i dunno..

back to phpmyadmin

Some tutorials to get you started understanding cpanel and mysql and phpmyadmin:
http://www.cpanel.net/docs/cpanel/phpMyAdmin.htm
http://www.cpanel.net/support/docs/11/c ... s_php.html
http://www.php-editors.com/articles/sql_phpmyadmin.php
http://www.tutorialized.com/tutorial/Cr ... dmin/23140

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