Database:Error?

Dark_Angel_Of_Light · Posted: Wed Jun 21, 2006 6:02 pm Post subject:

The same thing happens to me, but my other 2 friends on this site have no problem putting pics up......... HELP!!! MY PICTURES ARE PILING UP ON ME DUE TO THE STUPID DATABASE ERROR!!! Crying or Very sad

Pooey........... This error is no fun.............

Guest · Posted: Fri Jun 23, 2006 9:34 am Post subject:

I'm having trouble sumiting my art. I fill out the whole thing and sumit it and it says piciture not processed or showes up a white pg that says database error. Sad

Can someone please help me?

Guest · Posted: Fri Jun 23, 2006 9:36 am Post subject:

And I 'm not a guest 'm a member i'm KyosGirl.

Stratadrake · Posted: Sat Jun 24, 2006 10:19 am Post subject:

Everyone! [b][color=red]You must give us SPECIFIC information about what you were doing at the time[/color][/b] (i.e. type of image you were uploading, category you selected, etc.) [b][color=red]or we will not be able to help you[/color][/b].

Guest · Posted: Sat Jun 24, 2006 1:08 pm Post subject:

(Sorry, the forums won't let me log in. I'm SusieBeeca.) Here's what I got when I tried to upload a JPG in the NINTENDO: MARIO SERIES category. (Other details: I listed it as a PhotoShop picture, high nudity, slash, minimal keywords and description).

Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near ")" at character 795 in /usr/home/.sites/33/site5/web/add_picture.php on line 212

Database Error: ERROR: syntax error at or near ")" at character 795

#0 dbError() called at [/usr/home/.sites/33/site5/web/add_picture.php:212]
#1 process_submission_new(Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => To get to the top...,[keywords] => grubba, rawk hawk,[decaf] => 0,[category] => 5074,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => ...you sometimes have to be on the bottom.,[rating_nudity] => 2,[rating_violence] => 2,[rating_sex] => 3,[rating_racism] => 0,[rating_spoilers] => 0,[rating_profanity] => 0,[__rating_yaoi] => 1,[rating_yaoi] => 1,[rating_yuri] => 0,[media_id] => 33,[time_taken] => ,[refrence] => ,[skill_level] => 2,[submit] => Submit it)) called at [/usr/home/.sites/33/site5/web/add_picture.php:26]
#2 process_submission(Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => To get to the top...,[keywords] => grubba, rawk hawk,[decaf] => 0,[category] => 5074,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => ...you sometimes have to be on the bottom.,[rating_nudity] => 2,[rating_violence] => 2,[rating_sex] => 3,[rating_racism] => 0,[rating_spoilers] => 0,[rating_profanity] => 0,[__rating_yaoi] => 1,[rating_yaoi] => 1,[rating_yuri] => 0,[media_id] => 33,[time_taken] => ,[refrence] => ,[skill_level] => 2,[submit] => Submit it))
#3 call_user_func(process_submission, Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => To get to the top...,[keywords] => grubba, rawk hawk,[decaf] => 0,[category] => 5074,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => ...you sometimes have to be on the bottom.,[rating_nudity] => 2,[rating_violence] => 2,[rating_sex] => 3,[rating_racism] => 0,[rating_spoilers] => 0,[rating_profanity] => 0,[__rating_yaoi] => 1,[rating_yaoi] => 1,[rating_yuri] => 0,[media_id] => 33,[time_taken] => ,[refrence] => ,[skill_level] => 2,[submit] => Submit it)) called at [/usr/local/share/pear/HTML/QuickForm.php:1601]
#4 HTML_QuickForm->process(process_submission, ) called at [/usr/home/.sites/33/site5/web/add_picture.php:563]

SusieBeeca · Newb Joined: 23 Apr 2006 Posts: 4

Haha, sorry about that. I managed to log in. Another problem: the "crop image" doesn't work. It just keeps returning to the "Browse" box, and never displays a picture.

Here's another error message I got when submitting a different JPG to the GAMES: NINTENDO: MARIO SERIES category.

Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near ")" at character 795 in /usr/home/.sites/33/site5/web/add_picture.php on line 212

Database Error: ERROR: syntax error at or near ")" at character 795

#0 dbError() called at [/usr/home/.sites/33/site5/web/add_picture.php:212]
#1 process_submission_new(Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => To get to the top...,[keywords] => grubba, rawk hawk,[decaf] => 0,[category] => 5074,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => ...you sometimes have to be on the bottom.,[rating_nudity] => 2,[rating_violence] => 2,[rating_sex] => 3,[rating_racism] => 0,[rating_spoilers] => 0,[rating_profanity] => 0,[__rating_yaoi] => 1,[rating_yaoi] => 1,[rating_yuri] => 0,[media_id] => 33,[time_taken] => ,[refrence] => ,[skill_level] => 2,[submit] => Submit it)) called at [/usr/home/.sites/33/site5/web/add_picture.php:26]
#2 process_submission(Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => To get to the top...,[keywords] => grubba, rawk hawk,[decaf] => 0,[category] => 5074,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => ...you sometimes have to be on the bottom.,[rating_nudity] => 2,[rating_violence] => 2,[rating_sex] => 3,[rating_racism] => 0,[rating_spoilers] => 0,[rating_profanity] => 0,[__rating_yaoi] => 1,[rating_yaoi] => 1,[rating_yuri] => 0,[media_id] => 33,[time_taken] => ,[refrence] => ,[skill_level] => 2,[submit] => Submit it))
#3 call_user_func(process_submission, Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => To get to the top...,[keywords] => grubba, rawk hawk,[decaf] => 0,[category] => 5074,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => ...you sometimes have to be on the bottom.,[rating_nudity] => 2,[rating_violence] => 2,[rating_sex] => 3,[rating_racism] => 0,[rating_spoilers] => 0,[rating_profanity] => 0,[__rating_yaoi] => 1,[rating_yaoi] => 1,[rating_yuri] => 0,[media_id] => 33,[time_taken] => ,[refrence] => ,[skill_level] => 2,[submit] => Submit it)) called at [/usr/local/share/pear/HTML/QuickForm.php:1601]
#4 HTML_QuickForm->process(process_submission, ) called at [/usr/home/.sites/33/site5/web/add_picture.php:563]

Stratadrake · Posted: Sat Jun 24, 2006 1:57 pm Post subject:

THANK YOU.

Okay, an explanation: Some category entries are actually redirects to existing categories elsewhere in the system, however the redirecting system currently has bugs on the submissions end of things (though it works fine on the browsing end).

Case in point: "[i]Games > Nintendo > Mario[/i]" redirects to [b]Games > Mario[/b]. You can submit to Games > Mario just fine, but if you try to submit to Games > Nintendo > Mario, you get the above error message.

For more information about where to submit to certain categories, please refer to this thread.
http://forums.fanart-central.net/viewtopic.php?t=25195

SusieBeeca · Newb Joined: 23 Apr 2006 Posts: 4

Well whaddaya know---using that system, it works like a charm. Thanks a bunch! Very Happy

cstdenis · Posted: Sat Jun 24, 2006 7:06 pm Post subject:

Extra debugging added to the submission page to help track down the error.

Guest · Posted: Sat Jun 24, 2006 11:23 pm Post subject:

Parse error: syntax error, unexpected T_IF in /usr/home/.sites/33/site5/web/add_picture.php on line 149. I tried to uplaoad a single picture/flash then I went to uplaoad a picture from my computor and got that. help please. DX

Ky-Kiske · Very bored Joined: 11 Apr 2005 Posts: 114 Location: <w<

I do believe I'm getting a similar problem as with the guest above me. When I go to upload a picture from my computer, it gives me a white screen with:

[b]Parse error: syntax error, unexpected T_IF in /usr/home/.sites/33/site5/web/add_picture.php on line 149[/b]

So *shrugs* mmmm Syntax Errors~ <3

Just figured I'd throw mine in as well here.

Knightwasp · Newb Joined: 24 Jun 2006 Posts: 21

Whoops, should have read this thread before starting my own, because this is the exact same problem I'm getting. Embarassed

[img]http://img205.imageshack.us/img205/9804/uploaderror6gb.jpg[/img]

Stratadrake · Posted: Sun Jun 25, 2006 11:15 am Post subject:

Standard PHP error generally caused by a typo on the server side of things.

Denis, your cue....

cstdenis · Posted: Sun Jun 25, 2006 1:40 pm Post subject:

I forgot a semi-colon when I added the extra debugging info.

My bad. Crying or Very sad

Fixed now.