Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Phot shop install killed my gallery  (Read 6303 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.02 seconds with 20 queries.