ERROR

[hakutheblindedsoul]

Yeah, whenever I try to submit a pic, this pops up:

Warning: pg_query() [function.pg-query]: Query failed: ERROR: record "old" is not assigned yet DETAIL: The tuple structure of a not-yet-assigned record is indeterminate. CONTEXT: PL/pgSQL function "update_user_pictures_count" line 8 during statement block local variable initialization in /usr/home/sites/www.fanart-central.net/www/add_picture.php on line 332

Database Error: ERROR: record "old" is not assigned yet DETAIL: The tuple structure of a not-yet-assigned record is indeterminate. CONTEXT: PL/pgSQL function "update_user_pictures_count" line 8 during statement block local variable initialization

I REALLY have no clue what that all means, like at all. So I have no idea about what is going on or what I'm doing wrong. Could someone help, please?
_________________
[img]http://img.photobucket.com/albums/v203/Nefika/Mai%20HiME%20Otome/shizuru2.gif[/img][img]http://img.photobucket.com/albums/v203/Nefika/Mai%20HiME%20Otome/NatsukiShizuru.gif[/img][img]http://img.photobucket.com/albums/v203/Nefika/Mai%20HiME%20Otome/thMyu.gif[/img]

[cstdenis]

Fixed.


Strata...seriously....test your code.....

No more stored procedures for you, they cause too much damage when submitted in a completely untested form.
_________________
You will obey or molten silver will be poured into your ears.

[hakutheblindedsoul]

Thank you so much!
_________________
[img]http://img.photobucket.com/albums/v203/Nefika/Mai%20HiME%20Otome/shizuru2.gif[/img][img]http://img.photobucket.com/albums/v203/Nefika/Mai%20HiME%20Otome/NatsukiShizuru.gif[/img][img]http://img.photobucket.com/albums/v203/Nefika/Mai%20HiME%20Otome/thMyu.gif[/img]

[Stratadrake]

[quote="cstdenis"]...completely untested....[/quote]
Not entirely true there, but that doesn't change anything important. So . . . yeah.
_________________
Strata here: [url=http://www.nanowrimo.org/eng/user/242293]Nanowrimo[/url] - [url=www.fanart-central.net/user-Stratadrake.php]FAC[/url] - [url=http://stratadrake.deviantart.com]dA[/url] - [url=www.furaffinity.net/user/Stratadrake/]FA[/url]
[size=9]Disclaimer: Posts may contain URLs. Click [url=http://tvtropes.org/pmwiki/pmwiki.php/Main/TVTropesWillRuinYourLife]at your own risk.[/url][/size]

[Falconlobo]

same error again
_________________
The Eclectic Collector
random note to anyone i saw a Ups truck being towed by a tow truck lol
if a computer and keyboard had a punctuation semi-colon cleaning would it be a semi-colonoscopy

[img]http://i274.photobucket.com/albums/jj257/esmtie14/2hpoaao.gif[/img]
LOL dancing TMNT's

[cstdenis]

Works for me. Don't think it can be the same error. Post new error.
_________________
You will obey or molten silver will be poured into your ears.

[Falconlobo]

[quote="cstdenis"]Works for me. Don't think it can be the same error. Post new error.[/quote]



Warning: pg_query() [function.pg-query]: Query failed: ERROR: Update category(master_refrence) failed; category_hier(hier_id=<NULL>) does not belong to category(cat_id=474) CONTEXT: SQL statement "update category set picture_count = picture_count + 1 where cat_id = $1 " PL/pgSQL function "update_category_pictures_count" line 3 at SQL statement in /usr/home/sites/www.fanart-central.net/www/add_picture.php on line 334

Database Error: ERROR: Update category(master_refrence) failed; category_hier(hier_id=) does not belong to category(cat_id=474) CONTEXT: SQL statement "update category set picture_count = picture_count + 1 where cat_id = $1 " PL/pgSQL function "update_category_pictures_count" line 3 at SQL statement

#0 dbError() called at [/usr/home/sites/www.fanart-central.net/www/add_picture.php:334]
#1 process_submission_new(Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => Blue Grass B Day Pic For Gee^^,[keywords] => Blue Grass B Day Pic For Gee^^,[category] => 5546,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => Just a random B day pic for a friend on Fac

posting in case it is soon or has past

and cuse fac is acting up so i don''t know if it wil post or not

It''''s the Blue Aardvark from the Ant And The Aardvark

from the old Pink Panther series hope they will like it

he''''s catching zzz''s in the grass Lol his tongue is out^^

i used colored pencils and edited in HP Image,[rating_nudity] => 0,[rating_violence] => 0,[rating_sex] => 0,[rating_racism] => 0,[rating_spoilers] => 0,[rating_profanity] => 0,[rating_yaoi] => 0,[rating_yuri] => 0,[media_id] => 6,[time_taken] => 40 minutes or Less I forget,[refrence] => none,[skill_level] => 2,[comments_type] => 0,[agree] => 1,[submit] => Submit it,[action] => )) called at [/usr/home/sites/www.fanart-central.net/www/add_picture.php:78]
#2 process_submission(Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => Blue Grass B Day Pic For Gee^^,[keywords] => Blue Grass B Day Pic For Gee^^,[category] => 5546,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => Just a random B day pic for a friend on Fac

posting in case it is soon or has past

and cuse fac is acting up so i don''t know if it wil post or not

It''''s the Blue Aardvark from the Ant And The Aardvark

from the old Pink Panther series hope they will like it

he''''s catching zzz''s in the grass Lol his tongue is out^^

i used colored pencils and edited in HP Image,[rating_nudity] => 0,[rating_violence] => 0,[rating_sex] => 0,[rating_racism] => 0,[rating_spoilers] => 0,[rating_profanity] => 0,[rating_yaoi] => 0,[rating_yuri] => 0,[media_id] => 6,[time_taken] => 40 minutes or Less I forget,[refrence] => none,[skill_level] => 2,[comments_type] => 0,[agree] => 1,[submit] => Submit it))
#3 call_user_func(process_submission, Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => Blue Grass B Day Pic For Gee^^,[keywords] => Blue Grass B Day Pic For Gee^^,[category] => 5546,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => Just a random B day pic for a friend on Fac

posting in case it is soon or has past

and cuse fac is acting up so i don''t know if it wil post or not

It''''s the Blue Aardvark from the Ant And The Aardvark

from the old Pink Panther series hope they will like it

he''''s catching zzz''s in the grass Lol his tongue is out^^

i used colored pencils and edited in HP Image,[rating_nudity] => 0,[rating_violence] => 0,[rating_sex] => 0,[rating_racism] => 0,[rating_spoilers] => 0,[rating_profanity] => 0,[rating_yaoi] => 0,[rating_yuri] => 0,[media_id] => 6,[time_taken] => 40 minutes or Less I forget,[refrence] => none,[skill_level] => 2,[comments_type] => 0,[agree] => 1,[submit] => Submit it)) called at [/usr/local/share/pear/HTML/QuickForm.php:1660]
#4 HTML_QuickForm->process(process_submission, ) called at [/usr/home/sites/www.fanart-central.net/www/add_picture.php:835]


Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /usr/home/sites/www.fanart-central.net/www/functions.php on line 484

Database Error: ERROR: current transaction is aborted, commands ignored until end of transaction block

#0 dbError() called at [/usr/home/sites/www.fanart-central.net/www/functions.php:484]
#1 UserInfo->__destruct()
_________________
The Eclectic Collector
random note to anyone i saw a Ups truck being towed by a tow truck lol
if a computer and keyboard had a punctuation semi-colon cleaning would it be a semi-colonoscopy

[img]http://i274.photobucket.com/albums/jj257/esmtie14/2hpoaao.gif[/img]
LOL dancing TMNT's

[cstdenis]

Definitely a different error.

Looks to be category related. Try submitting into a different category if there is another one that applies.

I'm too tired to debug this right now, and since this is Strata's code I'll leave it for him to fix.
_________________
You will obey or molten silver will be poured into your ears.

[Stratadrake]

Denis, for now let's just disable that trigger entirely. It'll take too long to debug.
_________________
Strata here: [url=http://www.nanowrimo.org/eng/user/242293]Nanowrimo[/url] - [url=www.fanart-central.net/user-Stratadrake.php]FAC[/url] - [url=http://stratadrake.deviantart.com]dA[/url] - [url=www.furaffinity.net/user/Stratadrake/]FA[/url]
[size=9]Disclaimer: Posts may contain URLs. Click [url=http://tvtropes.org/pmwiki/pmwiki.php/Main/TVTropesWillRuinYourLife]at your own risk.[/url][/size]

[cstdenis]

I've disabled it.
_________________
You will obey or molten silver will be poured into your ears.