forum.coppermine-gallery.net

Support => Older/other versions => cpg1.3.x Support => Topic started by: adiboy on May 04, 2005, 09:19:43 pm

Title: error "There was an error while processing a database query"
Post by: adiboy on May 04, 2005, 09:19:43 pm

hi can some one please help me i am getting this error when i try to upload things to the site


"There was an error while processing a database query "


can sonn some one tell me what it could be ?
this is my site that the script is running on www.adiboy.co.uk/fun  or www.iplay247.com

Title: Re: error "There was an error while processing a database query"
Post by: Nibbler on May 05, 2005, 06:10:31 pm

Enable debug mode and post the sql error message...

Title: Re: error "There was an error while processing a database query"
Post by: adiboy on May 05, 2005, 11:06:52 pm

can you please tell me how do i do that? i realy dont know

Title: Re: error "There was an error while processing a database query"
Post by: adiboy on May 05, 2005, 11:32:26 pm

sorry i have found out now how to enable debug mode and this is the error that i am getting


While executing query "SELECT max_pics FROM cpg11d_albums WHERE aid = 62 AND limit_pics = 'YES'" on 0

mySQL error: Unknown column 'max_pics' in 'field list'

 File: /home/adiboy/public_html/fun/include/functions.inc.php - Line: 105



if you go to www.iplay247.com (http://www.iplay247.com) i think i have set it so every one can see the errors so it should be there i dont know what the problem can be i mean i know a buit of php but this is more advance then i know

Title: Re: error "There was an error while processing a database query"
Post by: Nibbler on May 06, 2005, 09:38:15 pm

Look like some modification you have made, that doesn't look like standard coppermine code to me.

Title: Re: error "There was an error while processing a database query"
Post by: adiboy on May 07, 2005, 05:57:32 pm

i dont think i have done any changing on the code but what is the best thing to do to get this working. can i updated to a better version and see if that will work or is ther any thing else that i can do about this.

Title: Re: error "There was an error while processing a database query"
Post by: Tranz on May 07, 2005, 06:21:37 pm

It looks like you are using 1.3.2 whereas the latest version is 1.3.3. Try upgrading to see if that helps.

Title: Re: error "There was an error while processing a database query"
Post by: adiboy on May 08, 2005, 01:36:09 am

thanks every one that worked fine and every thing is working very well.
see you  :)