Help?

DragonGirl1136 · Posted: Sun Dec 23, 2007 8:46 am Post subject: Help?

[b]I tried commenting on a friend's profile, but something messed it up. Here's the message I got:[/b]

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 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: attribute 67 has wrong type DETAIL: Table has type integer, but query expects smallint. 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] => 78180,[username] => KidRaccoon,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => Hello!,[submit] => Submit))
#2 call_user_func(comment_processing, Array ([uid] => 78180,[username] => KidRaccoon,[reply_to] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[comment_text] => Hello!!!,[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]

[b]Falconlobo reported the same thing, and you said it's because the person has too many comments. But the same thing happened on TheGirlBlue's profile, and she has nowhere near as many comments as KidRaccoon does. What's up with that??[/b]

Battou · Posted: Sun Dec 23, 2007 10:35 am Post subject:

So why did you not post in the exsisting thread?
_________________
[b]RPG[/b]-[i]n[/i]. A computer programing language designed for business reporting that generates specific programs from the users specifications.([b]R[/b]eport [b]P[/b]rogram [b]G[/b]enerator)[i]The American Heritage Dictionary[/i]

[u][url=http://www.photo-lucidity.com/user-Battou.php]Photo-Lucidity[/url][/u] - [u][url=http://www.fanart-central.net/user-battou.php]FaAC[/url][/u] - [u][url=http://www.funart-central.net/user-Battou.php]FuAC[/url][/u] - [u][url=http://forums.fanart-central.net/index.php]Joke of the day[/url][/u]

Sora121 · Posted: Sun Dec 23, 2007 12:30 pm Post subject:

This error is different. Its the query type and the table type on the database conflicting.

I'll talk to Denis and in the mean time see what I can do.

Falconlobo · Posted: Sun Dec 23, 2007 12:47 pm Post subject:

CSt Dennis is doing an upgrade of sorts

so all comments typing must be down

cuse i got an error for comments when trying to submit a pic

only thing i can figure is because of typing a description it messed up

cuse of this upgrade process
_________________
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 · Posted: Sun Dec 23, 2007 1:03 pm Post subject:

The data storage type and the data insertion type are different, thus the conflict, thus the error.

Please be patient.

Morpher · Posted: Sun Dec 23, 2007 2:02 pm Post subject:

there working on this error already so jus be patient theyll get it fix hopefully soon

Sora121 · Posted: Sun Dec 23, 2007 2:07 pm Post subject:

Not looking likely.

I can't seem to find it... The back trace is pointing to something else.
FAC config or something thats used here.

Hopefully Denis gets back quick.

My updates would keep it from happening again, after an update.
Denis is the only one who can fix this one.

cstdenis · Posted: Sun Dec 23, 2007 3:36 pm Post subject:

I don't know why it did that, the error doesn't really make sense, but I've fixed it.

Best bet is postgresql didn't invalidated the cached query plan when I changed the data type.
_________________
You will obey or molten silver will be poured into your ears.

Sora121 · Posted: Sun Dec 23, 2007 5:57 pm Post subject:

That would make some since. Even more so if FAC and its sister sites share a server with others.

Battou · Posted: Sun Dec 23, 2007 7:48 pm Post subject:

[quote="Sora121"]This error is different. Its the query type and the table type on the database conflicting.

I'll talk to Denis and in the mean time see what I can do.[/quote]

I don't know my way areound errors text, I based my comment on the bold text on the bottom of the original post.
_________________
[b]RPG[/b]-[i]n[/i]. A computer programing language designed for business reporting that generates specific programs from the users specifications.([b]R[/b]eport [b]P[/b]rogram [b]G[/b]enerator)[i]The American Heritage Dictionary[/i]

[u][url=http://www.photo-lucidity.com/user-Battou.php]Photo-Lucidity[/url][/u] - [u][url=http://www.fanart-central.net/user-battou.php]FaAC[/url][/u] - [u][url=http://www.funart-central.net/user-Battou.php]FuAC[/url][/u] - [u][url=http://forums.fanart-central.net/index.php]Joke of the day[/url][/u]

Sora121 · Posted: Sun Dec 23, 2007 9:06 pm Post subject:

[quote="Battou"][quote="Sora121"]This error is different. Its the query type and the table type on the database conflicting.

I'll talk to Denis and in the mean time see what I can do.[/quote]

I don't know my way areound errors text, I based my comment on the bold text on the bottom of the original post.[/quote]

Its a technical thing. They where both caused by (basically) the same thing.
At least its fixed now.