Post by Ghostie » Tue Aug 05, 2008 10:01 pm

I have just downloaded v0.7.8 and tried to install it. Firstly, I am not getting the "pre-requisite" check screen when I navigate to the /install directory - it goes straight to the db config screen.

I put in the db details (and I've checked via phpMyAdmin that the db is all correct) but get the following 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 '# DROP TABLE IF EXISTS `oc_address`' at line 1
Anyone seen this before? All I have done to the opencart.sql file is to insert a table prefix throughout the file (oc_) to keep the db tidy.

Regards,

Newbie

Posts

Joined
Sat Jan 05, 2008 1:00 am

Post by hm2k » Tue Aug 05, 2008 10:09 pm

There is no "pre-requisite" screen in v0.7.8, you'll only see it if there's a problem, and it cannot continue.

Table prefixes is something that is not currently supported by OpenCart, but could be in the future.

The issue is that even if you do change the table names in the opencart.sql, you have to ask, how will opencart know what the new tables are called?

UK Web Hosting


User avatar
Global Moderator

Posts

Joined
Tue Mar 11, 2008 9:06 am
Location - UK

Post by Qphoria » Tue Aug 05, 2008 10:19 pm

Perhaps you could append it to the config:

define('DB_PREFIX', 'beta_');
define('DB_NAME', DB_PREFIX . 'opencart');

(haven't tested if that is the correct syntax)

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by bruce » Tue Aug 05, 2008 10:47 pm

and then go through and carefully modify every sql statement in the entire project ???

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by Qphoria » Wed Aug 06, 2008 3:57 am

ah whoops I was thinking of prefixed database, not prefixed tables.

All the same, it needs to be done, so semi-globally change:
from
to
from " . DB_PREFIX . "

Image
Donate!|OpenCart Basics|GeoZones
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