Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Phot shop install killed my gallery  (Read 5492 times)

0 Members and 1 Guest are viewing this topic.

Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Phot shop install killed my gallery
« 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!!!
Logged

Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Re: Phot shop install killed my gallery
« Reply #1 on: April 14, 2008, 09:06:12 pm »

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
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Phot shop install killed my gallery
« Reply #2 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

Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Re: Phot shop install killed my gallery
« Reply #3 on: April 15, 2008, 03:53:04 am »

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.
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Phot shop install killed my gallery
« Reply #4 on: April 15, 2008, 08:14:59 am »

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

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Re: Phot shop install killed my gallery
« Reply #5 on: April 15, 2008, 03:35:57 pm »

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
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Phot shop install killed my gallery
« Reply #6 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.

Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Re: Phot shop install killed my gallery
« Reply #7 on: April 16, 2008, 12:07:35 pm »

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?
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Phot shop install killed my gallery
« Reply #8 on: April 17, 2008, 12:59:42 pm »

Usually MySQL spits out an error number and a message. The MySQL error log may contain info or your host may know more.
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.