Post by danitaz » Tue Jan 08, 2013 5:07 am

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

New member

Posts

Joined
Wed Apr 21, 2010 9:02 am

Post by danitaz » Tue Jan 08, 2013 7:12 am

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

New member

Posts

Joined
Wed Apr 21, 2010 9:02 am

Post by danitaz » Tue Jan 08, 2013 9:58 am

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

Thanks.

Danita

New member

Posts

Joined
Wed Apr 21, 2010 9:02 am
Who is online

Users browsing this forum: No registered users and 38 guests