Error on A Friend's Pro?

[Falconlobo]

Warning: pg_query() [function.pg-query]: Query failed: ERROR: smallint out of range 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 73

Database Error: ERROR: smallint out of range 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:73]
#1 comment_processing(Array ([uid] => 79960,[username] => tallestpurple101,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => ?,[submit] => Submit))
#2 call_user_func(comment_processing, Array ([uid] => 79960,[username] => tallestpurple101,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => ?,[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:172]

error on a friend's pro

what is up with this?

is this gonna happen to other pros too?
_________________
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]

That is just wrong.

The error "smallint out of range" means there are too many comments for the counter to store in its range of -32768 to +32767

Nobody should have more than THIRTY-TWO THOUSAND comments on their profile......

I guess I'll have to raise it to a 32bit integer.....that should be good to around 2billion.
_________________
You will obey or molten silver will be poured into your ears.

[Morpher]

you hav the same problem to? man that sucks i like to help but have no info bout it sorry

[Falconlobo]

okay

Warning: pg_query() [function.pg-query]: Query failed: ERROR: attribute 67 has wrong type DETAIL: Table has type integer, but query expects smallint. 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: attribute 67 has wrong type DETAIL: Table has type integer, but query expects smallint. 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] => 652418,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => cute and creepy^^,[vote] => 0,[submit] => Submit))
#2 call_user_func(comment_processing, Array ([pid] => 652418,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => cute and creepy^^,[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.php:170]

now the pics won't allow comments is this temporary

wonder if the pros won't allow them either
_________________
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

[Sora121]

Small mishap. Its being taken care of, please be patient.

[cstdenis]

Fixed.
_________________
You will obey or molten silver will be poured into your ears.