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: Error for non-registered users viewing album list  (Read 3468 times)

0 Members and 1 Guest are viewing this topic.

nanothree

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 70
    • RockThoseLocks
Error for non-registered users viewing album list
« on: December 23, 2004, 12:15:51 pm »

If i logout when i try to view all teh albums i get this error:
There was an error while processing a database query

if i login i can see them though
the url is http://www.rockthoselocks.com/Gallery/index.php?cat=1
« Last Edit: January 07, 2005, 11:28:23 am by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Error for non-registered users viewing album list
« Reply #1 on: December 23, 2004, 02:37:46 pm »

enable debug_mode in coppermine config to see what query actually fails. If you can't go to the config screen, use a tool like phpMyAdmin, browse the coppermine config table and set debug_mode to "1". Post the error message here.

Joachim
Logged

nanothree

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 70
    • RockThoseLocks
Re: Error for non-registered users viewing album list
« Reply #2 on: December 25, 2004, 02:20:19 pm »

sorry about the delay, i never got the notification this is what comes up when i enable debig mode

While executing query "SELECT user_id,      user_name,      COUNT(DISTINCT a.aid) as alb_count,      COUNT(DISTINCT pid) as pic_count,      MAX(pid) as thumb_pid FROM cpg11d_users AS u INNER JOIN cpg11d_albums AS a ON category = 10000 + user_id INNER JOIN cpg11d_pictures AS p ON p.aid = a.aid WHERE approved = 'YES' p.aid NOT IN (37,70,76,113)  GROUP BY user_id ORDER BY user_name " on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.aid NOT IN (37,70,76,113)  GROUP BY user_id ORDER BY user_nam
Logged

nanothree

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 70
    • RockThoseLocks
Ahhhh gallery is still broken!
« Reply #3 on: December 30, 2004, 11:50:38 am »

I posted this a while ago but, probably due to my bad memory, it has just sort have been forgotten, When a non registered user tries to view all the albums ithey get this error:

There was an error while processing a database query.

So i turned on debug mode las requested in the old topic and this came up:

While executing query "SELECT user_id,      user_name,      COUNT(DISTINCT a.aid) as alb_count,      COUNT(DISTINCT pid) as pic_count,      MAX(pid) as thumb_pid FROM cpg11d_users AS u INNER JOIN cpg11d_albums AS a ON category = 10000 + user_id INNER JOIN cpg11d_pictures AS p ON p.aid = a.aid WHERE approved = 'YES' p.aid NOT IN (37,70,76,113)  GROUP BY user_id ORDER BY user_name " on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.aid NOT IN (37,70,76,113)  GROUP BY user_id ORDER BY user_nam
and this:

File: /home/liam/public_html/Gallery/include/functions.inc.php - Line: 105


Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: Error for non-registered users viewing album list
« Reply #4 on: December 30, 2004, 11:58:07 am »

If you can't remember where you posted something, click on the profile button that will show your account info. Click on Show Posts to show all that you have posted. That will prevent you from creating a duplicate thread, which is a big no-no.

I have merged the threads.
Logged

nanothree

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 70
    • RockThoseLocks
Re: Error for non-registered users viewing album list
« Reply #5 on: December 31, 2004, 02:17:12 pm »

sorry  :-[, can any one help?
Logged

nanothree

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 70
    • RockThoseLocks
Re: Error for non-registered users viewing album list
« Reply #6 on: January 07, 2005, 11:23:15 am »

Its ok i have fixed it, i just uploaded the index file again, i must have messed it up
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.