Critical error
There was an error while processing a database query
installed photo shop 1.3.6
on a bridged 1.4.17 with the modpak
used plugin manager, clicked install button, next page showed changes made, clicked ok, got error
site; www.hot-rides.net/coppermine/
enabled debugging;
While executing query "SELECT * FROM cpg_shop_config ORDER BY priority ASC" on 0
mySQL error:
need help fast!!!
I was doing some looking, I think thw plugin install did not create the database table needed.
cpg_shop_config does not exsist in my coppermine dattabase
uninstall the plugin and rerun the setup then
edit: ahmm, if you do not know how to do this... phpmyadmin: browse table cpg14x_plugins and delete the photo_shop entry
Quote from: Stramm on April 14, 2008, 09:13:24 PM
uninstall the plugin and rerun the setup then
edit: ahmm, if you do not know how to do this... phpmyadmin: browse table cpg14x_plugins and delete the photo_shop entry
uninstalled and reran 4 times, same result each time, even tried reuploading the directory tree to the plugin directory manually instead of using the plugin manager upload.
weird, have you tried to use phpmyadmin to create the necessary SQL (if it's missing)? It's in the plugins dir sql/basic.sql. You need to change the table prefix to the one your using (eg. from CPG_ to cpg14x_).
Manually inserted cpg_shop, cpg_shop_config, cpg_prices
now I have an error when trying to access the 'shop' tab in the admin menu
---
While executing query "SELECT s.*, u.memberName, u.emailAddress FROM cpg_shop AS s LEFT JOIN `dodgeste_smf1`.smf_members as u ON u.ID_MEMBER = s.uid WHERE aktive=0 AND cd=1 ORDER BY oid DESC LIMIT 0, 25" on
mySQL error:
---
not to mention, none of the options appear in the dropdown box to add to the shopping basket
If there's no error message it'S hard to tell you a solution. I'd have to see it.
Quote from: Stramm on April 16, 2008, 08:17:30 AM
If there's no error message it'S hard to tell you a solution. I'd have to see it.
thats all it says, is there anyway to get more information?
Usually MySQL spits out an error number and a message. The MySQL error log may contain info or your host may know more.