OpenCart Community

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,

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?

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)

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

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 . "