forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: krümel on May 11, 2005, 04:34:56 pm

Title: Fatal Error...
Post by: krümel on May 11, 2005, 04:34:56 pm

I have a Problem...

There was an error while processing a database query

Here is' my debug info:

Queries:
Array
(
   

• => SELECT userid as user_id, username as user_name, usergroupid as mgroup, password FROM `v073543`.kB_vB_user WHERE userid='1'
[1] => SELECT * FROM kB_vB_photo_usergroups WHERE group_id = '6'
    [2] => DELETE FROM kB_vB_photo_banned WHERE expiry < '1115821685'
    [3] => SELECT * FROM kB_vB_photo_banned WHERE ip_addr='84.133.69.143' OR ip_addr='84.133.69.143' OR user_id=1
    [4] => SELECT aid FROM kB_vB_photo_albums WHERE visibility != '0' AND visibility !='10001' AND visibility NOT IN (6)
    [5] => SELECT name, parent FROM kB_vB_photo_categories WHERE cid = '1'
    [6] => SELECT cid, name, description FROM kB_vB_photo_categories WHERE parent = '1'  ORDER BY pos
    [7] => SELECT aid FROM kB_vB_photo_albums WHERE category >= 10000
    [8] => SELECT (category - 10000) as user_id,  '???' as user_name,  COUNT(DISTINCT a.aid) as alb_count,  COUNT(DISTINCT pid) as pic_count,  MAX(pid) as thumb_pid FROM kB_vB_photo_albums AS a INNER JOIN kB_vB_photo_pictures AS p ON p.aid = a.aid WHERE approved = 'YES' AND category > 10000 AND AND p.aid NOT IN (24)  GROUP BY category ORDER BY category
)

plz, help me  :-\\

Title: Re: Fatal Error...
Post by: krümel on May 11, 2005, 11:08:55 pm

I need help  :-\\

Title: Re: Fatal Error...
Post by: Joachim Müller on May 12, 2005, 08:57:32 am

we don't need the debug output, but the actual error message (the query that failed) - you should see it if you have debug mode enabled. Also post what you were doing when you encountered the error. A link might help as well.
Additionally, you might want to read http://coppermine.sourceforge.net/faq.php#lamesupport

Title: Re: Fatal Error...
Post by: krümel on May 12, 2005, 03:21:11 pm

Hi,

here is the photo album... click on "User Gallery"
http://www.kuruboard.de/vB/photo/index.php

I did not do anything before the error arose.  :\'(


ps; my english is' not good...

Title: Re: Fatal Error...
Post by: Joachim Müller on May 13, 2005, 09:57:22 am

you have to enable debug mode for everyone, I just can see

Quote

There was an error while processing a database query

. If you don't want to enable debug mode for everyone, do as suggested and post the error message (with the query that actually fails).
Please note that there can only be very limited support, as you're running an outdated version of coppermine (cpg1.2.1), which none of the devs is running anymore. Upgrading to the most recent stable (cpg1.3.3) is highly recommended.

Title: Re: Fatal Error...
Post by: krümel on May 13, 2005, 07:52:34 pm

i I will times update and hope it thereafter again go  ;)

Title: Re: Fatal Error...
Post by: krümel on May 13, 2005, 08:56:33 pm

Hm... Thank you ^^ !!!

Title: Re: Fatal Error...
Post by: Joachim Müller on May 14, 2005, 04:30:29 pm

is your issue solved then?