forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 plugins => Topic started by: Hot Rides on April 14, 2008, 08:44:33 pm
-
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
-
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.
-
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.