Phot shop install killed my gallery

[Hot Rides]

  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!!!

[Hot Rides]

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

[Stramm]

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

[Hot Rides]

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.

[Stramm]

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_).

[Hot Rides]

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

[Stramm]

If there's no error message it'S hard to tell you a solution. I'd have to see it.

[Hot Rides]

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?

[Stramm]

Usually MySQL spits out an error number and a message. The MySQL error log may contain info or your host may know more.