OpenCart Community

Hi - I have an active OpenCart configuration on my site, and in another virtual host I'm trying to install a new copy of OpenCart (at http://www.hellmund.net/kbwedding/registry). It just comes up "blank". I'm getting errors in the log about

PHP Notice: 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 '-store WHERE REPLACE(`url`, 'www.', '') = 'http://hellmund.net/kbwedding/registr' at line 1<br />Error No: 1064<br />SELECT * FROM open-store WHERE REPLACE(`url`, 'www.', '') = 'http://hellmund.net/kbwedding/registry/' in /grpwise/web/katdocs/kbwedding/registry/system/database/mysql.php on line 49

This would be try I guess if the it's looking for "registr" and not "registry" at the end of the URL. I'm not an expert by any means at either mySQL or php, so I'm not sure what I'm supposed to fix here. Can someone point me in the right direction?

In case it matters, this is a subdirectory off of a wordpress site at http://www.hellmund.net/kbwedding - that site has mod_rewrite enabled for "friendly" URLs. The settings for that are


<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /kbwedding/
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /kbwedding/index.php [L]
</IfModule>

That said, I've moved it out from under the WordPress site and still have the issue.

Thanks!

Danita

By the way - I realize it probably isn't Zend - I started out the post thinking it might be, but then decided it wasn't and forgot to change the subject line! Oops.

Thanks

Danita

solved - I had used "open-" as the database prefix. Deleted everything and used "open_" and the world is all better!

Thanks.

Danita