Logo
FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in
Commenting problem...again

 
Post new topic   Reply to topic    www.fanart-central.net Forum Index -> General Help
View previous topic :: View next topic  
Author Message
Morpher
Forum Scalleywag


Joined: 07 Dec 2007
Posts: 941
Location: Land of the dragons

PostPosted: Fri Feb 08, 2008 6:52 pm    Post subject: Commenting problem...again Reply with quote

Warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "image_limit" violates not-null constraint CONTEXT: SQL statement "update users set profile_comment_count = profile_comment_count + 1 where user_id = $1 " PL/pgSQL function "update_profile_comment_count" line 3 at SQL statement in /usr/home/.sites/28/site1/web/profile.php on line 95

Database Error: ERROR: null value in column "image_limit" violates not-null constraint CONTEXT: SQL statement "update users set profile_comment_count = profile_comment_count + 1 where user_id = $1 " PL/pgSQL function "update_profile_comment_count" line 3 at SQL statement

#0 dbError() called at [/usr/home/.sites/28/site1/web/profile.php:95]
#1 comment_processing(Array ([uid] => 42654,[username] => Sonic_the_Hedgehog,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => gtg byebye for now,[submit] => Submit))
#2 call_user_func(comment_processing, Array ([uid] => 42654,[username] => Sonic_the_Hedgehog,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => gtg byebye for now,[submit] => Submit)) called at [/usr/local/share/pear/HTML/QuickForm.php:1620]
#3 HTML_QuickForm->process(comment_processing, ) called at [/usr/home/.sites/28/site1/web/profile.php:195]

i thought this was fixed?!?!?!
_________________
THIS SIGNATURE IS CURRENTLY UNAVAILABLE.
Back to top
View user's profile Send private message
Falconlobo
Forum Stalker


Joined: 18 Apr 2006
Posts: 1570
Location: Home

PostPosted: Fri Feb 08, 2008 6:58 pm    Post subject: Reply with quote

me too got the same thing trying to comment on someone's pro to say thanks for a comment on a pic


Warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "image_limit" violates not-null constraint CONTEXT: SQL statement "update users set profile_comment_count = profile_comment_count + 1 where user_id = $1 " PL/pgSQL function "update_profile_comment_count" line 3 at SQL statement in /usr/home/.sites/28/site1/web/profile.php on line 95

Database Error: ERROR: null value in column "image_limit" violates not-null constraint CONTEXT: SQL statement "update users set profile_comment_count = profile_comment_count + 1 where user_id = $1 " PL/pgSQL function "update_profile_comment_count" line 3 at SQL statement

#0 dbError() called at [/usr/home/.sites/28/site1/web/profile.php:95]
#1 comment_processing(Array ([uid] => 81751,[username] => AnimeAngel87,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => thanks^^,[submit] => Submit))
#2 call_user_func(comment_processing, Array ([uid] => 81751,[username] => AnimeAngel87,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => thanks^^,[submit] => Submit)) called at [/usr/local/share/pear/HTML/QuickForm.php:1620]
#3 HTML_QuickForm->process(comment_processing, ) called at [/usr/home/.sites/28/site1/web/profile.

what is this error for pros

this one just happened on a pic


Warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "image_limit" violates not-null constraint CONTEXT: SQL statement "update users set comment_count = comment_count + 1 where user_id = $1 " PL/pgSQL function "update_user_comments_count" line 3 at SQL statement in /usr/home/.sites/28/site1/web/pictures.php on line 109

Database Error: ERROR: null value in column "image_limit" violates not-null constraint CONTEXT: SQL statement "update users set comment_count = comment_count + 1 where user_id = $1 " PL/pgSQL function "update_user_comments_count" line 3 at SQL statement

#0 dbError() called at [/usr/home/.sites/28/site1/web/pictures.php:109]
#1 comment_processing(Array ([pid] => 664887,[reply_to] => 3026386,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => thanks somehow comments on pros are broken again,[vote] => 0,[submit] => Submit))
#2 call_user_func(comment_processing, Array ([pid] => 664887,[reply_to] => 3026386,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => thanks somehow comments on pros are broken again,[vote] => 0,[submit] => Submit)) called at [/usr/local/share/pear/HTML/QuickForm.php:1620]
#3 HTML_QuickForm->process(comment_processing, ) called at [/usr/home/.sites/28/site1/web/pictures

it was fine a short while ago~~
_________________
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
Back to top
View user's profile Send private message
Morpher
Forum Scalleywag


Joined: 07 Dec 2007
Posts: 941
Location: Land of the dragons

PostPosted: Fri Feb 08, 2008 7:03 pm    Post subject: Reply with quote

[quote="Falconlobo"]me too got the same thing trying to comment on someone's pro to say thanks for a comment on a pic


Warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "image_limit" violates not-null constraint CONTEXT: SQL statement "update users set profile_comment_count = profile_comment_count + 1 where user_id = $1 " PL/pgSQL function "update_profile_comment_count" line 3 at SQL statement in /usr/home/.sites/28/site1/web/profile.php on line 95

Database Error: ERROR: null value in column "image_limit" violates not-null constraint CONTEXT: SQL statement "update users set profile_comment_count = profile_comment_count + 1 where user_id = $1 " PL/pgSQL function "update_profile_comment_count" line 3 at SQL statement

#0 dbError() called at [/usr/home/.sites/28/site1/web/profile.php:95]
#1 comment_processing(Array ([uid] => 81751,[username] => AnimeAngel87,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => thanks^^,[submit] => Submit))
#2 call_user_func(comment_processing, Array ([uid] => 81751,[username] => AnimeAngel87,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => thanks^^,[submit] => Submit)) called at [/usr/local/share/pear/HTML/QuickForm.php:1620]
#3 HTML_QuickForm->process(comment_processing, ) called at [/usr/home/.sites/28/site1/web/profile.

what is this error for pros

this one just happened on a pic


Warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "image_limit" violates not-null constraint CONTEXT: SQL statement "update users set comment_count = comment_count + 1 where user_id = $1 " PL/pgSQL function "update_user_comments_count" line 3 at SQL statement in /usr/home/.sites/28/site1/web/pictures.php on line 109

Database Error: ERROR: null value in column "image_limit" violates not-null constraint CONTEXT: SQL statement "update users set comment_count = comment_count + 1 where user_id = $1 " PL/pgSQL function "update_user_comments_count" line 3 at SQL statement

#0 dbError() called at [/usr/home/.sites/28/site1/web/pictures.php:109]
#1 comment_processing(Array ([pid] => 664887,[reply_to] => 3026386,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => thanks somehow comments on pros are broken again,[vote] => 0,[submit] => Submit))
#2 call_user_func(comment_processing, Array ([pid] => 664887,[reply_to] => 3026386,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => thanks somehow comments on pros are broken again,[vote] => 0,[submit] => Submit)) called at [/usr/local/share/pear/HTML/QuickForm.php:1620]
#3 HTML_QuickForm->process(comment_processing, ) called at [/usr/home/.sites/28/site1/web/pictures

it was fine a short while ago~~[/quote]

i know it was fine a few minute ago...
_________________
THIS SIGNATURE IS CURRENTLY UNAVAILABLE.
Back to top
View user's profile Send private message
cstdenis
Evil Overlord


Joined: 31 Dec 1969
Posts: 6490
Location: In the tubes.

PostPosted: Fri Feb 08, 2008 7:03 pm    Post subject: Reply with quote

Getting ready for a new release. The database changes shouldn't have done this but for some reason they did break it. I've made changes to fix it.
_________________
You will obey or molten silver will be poured into your ears.
Back to top
View user's profile Send private message Visit poster's website
Morpher
Forum Scalleywag


Joined: 07 Dec 2007
Posts: 941
Location: Land of the dragons

PostPosted: Fri Feb 08, 2008 7:06 pm    Post subject: Reply with quote

[quote="cstdenis"]Getting ready for a new release. The database changes shouldn't have done this but for some reason they did break it. I've made changes to fix it.[/quote]

Yay! its fixed!Very Happy
_________________
THIS SIGNATURE IS CURRENTLY UNAVAILABLE.
Back to top
View user's profile Send private message
Falconlobo
Forum Stalker


Joined: 18 Apr 2006
Posts: 1570
Location: Home

PostPosted: Fri Feb 08, 2008 7:09 pm    Post subject: Reply with quote

good
_________________
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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    www.fanart-central.net Forum Index -> General Help All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum