HELP!!!

elyo11 · Still very bored Joined: 09 Aug 2005 Posts: 341

Help me! I can't submit a new picture! I get this text every time:
[quote]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 picture_count = picture_count + 1 where user_id = $1 and $2 > 0" PL/pgSQL function "update_user_pictures_count" line 3 at SQL statement in /usr/home/.sites/28/site1/web/add_picture.php on line 273

Database Error: ERROR: attribute 67 has wrong type DETAIL: Table has type integer, but query expects smallint. CONTEXT: SQL statement "update users set picture_count = picture_count + 1 where user_id = $1 and $2 > 0" PL/pgSQL function "update_user_pictures_count" line 3 at SQL statement

SQL: insert into pictures (pid, user_id, title, filename, keywords, description, rating_nudity, rating_violence, rating_racism, rating_sex, rating_spoilers, rating_yaoi, rating_yuri, rating_profanity, approved, ipaddr, image_type, media_id, refrence, time_taken, skill_level, section_id, faves_count, requested_by, trade_with, collaboration_with, contest_entry, gift_for, size_width, size_height, category, sha1 ) VALUES ('652580', '32368', 'Naruto Movie 4 poster', currval('pictures_pid_seq') || '.jpg', 'Naruto Movie 4 poster', '...', '0', '0', '0', '0', '0', '0', '0', '0', 2, '82.75.6.225', 1, '3', '', '', '1', '0', 0, null, null, null, '', null, 947, 673, 5123, '486c3ea6ab28254efee933d2362b21a976c0339a' )

#0 dbError(insert into pictures (pid, user_id, title, filename, keywords, description,
rating_nudity, rating_violence,
rating_racism, rating_sex, rating_spoilers, rating_yaoi, rating_yuri, rating_profanity,
approved, ipaddr,
image_type, media_id, refrence, time_taken,
skill_level, section_id, faves_count, requested_by,
trade_with, collaboration_with, contest_entry,
gift_for, size_width, size_height, category, sha1 )
VALUES ('652580', '32368', 'Naruto Movie 4 poster',
currval('pictures_pid_seq') || '.jpg',
'Naruto Movie 4 poster', '...',
'0', '0',
'0', '0', '0', '0', '0',
'0',
2, '82.75.6.225', 1, '3',
'', '',
'1', '0', 0,
null, null,
null, '',
null, 947, 673, 5123, '486c3ea6ab28254efee933d2362b21a976c0339a'
)) called at [/usr/home/.sites/28/site1/web/add_picture.php:273]
#1 process_submission_new(Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => Naruto Movie 4 poster,[keywords] => Naruto Movie 4 poster,[category] => 5563,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => ...,[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] => 3,[time_taken] => ,[refrence] => ,[skill_level] => 1,[agree] => 1,[submit] => Submit it)) called at [/usr/home/.sites/28/site1/web/add_picture.php:28]
#2 process_submission(Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => Naruto Movie 4 poster,[keywords] => Naruto Movie 4 poster,[category] => 5563,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => ...,[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] => 3,[time_taken] => ,[refrence] => ,[skill_level] => 1,[agree] => 1,[submit] => Submit it))
#3 call_user_func(process_submission, Array ([MAX_FILE_SIZE] => 10485760,[method] => upload,[title] => Naruto Movie 4 poster,[keywords] => Naruto Movie 4 poster,[category] => 5563,[section_id] => 0,[fnt_size] => ,[fnt_color] => ,[fnt_face] => ,[description] => ...,[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] => 3,[time_taken] => ,[refrence] => ,[skill_level] => 1,[agree] => 1,[submit] => Submit it)) called at [/usr/local/share/pear/HTML/QuickForm.php:1620]
#4 HTML_QuickForm->process(process_submission, ) called at [/usr/home/.sites/28/site1/web/add_picture.php:726]

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /usr/home/.sites/28/site1/web/functions.php on line 556

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

#0 dbError() called at [/usr/home/.sites/28/site1/web/functions.php:556]
#1 UserInfo->__destruct()

[/quote]

Can someone help me????
_________________
[img]http://i170.photobucket.com/albums/u247/Valariz/Ulquiorra1.png[/img]
Friendship is like a glass. Be carefull with it 'couse if you break it, it will be hard to repair.

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

it must have to do with typing into fac

CstDennis is doing an upgrade for comments

must have affected all typing on fac except for pms and forums

so descriptions for pics must be down cuse it is typing
_________________
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

dth1971 · Member Joined: 03 Sep 2005 Posts: 63

Hope it gets fixed as soon as possible so we can post pics and comments again even with Christmas slowly approaching!

germanname · Newb Joined: 15 Apr 2006 Posts: 9

I'm getting the same type of error myself. I checked the forum if anyone else is going through this. Since this was confirmed, I hope you guys will get back on track ASAP. Wink

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

This problem would be fixed by the end of the day at latest.

elyo11 · Still very bored Joined: 09 Aug 2005 Posts: 341

oh thnx!!! I'm soo glad. I MUST post christmas pictures as soon as possible.
_________________
[img]http://i170.photobucket.com/albums/u247/Valariz/Ulquiorra1.png[/img]
Friendship is like a glass. Be carefull with it 'couse if you break it, it will be hard to repair.

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

Still doesn't make sense. But should be fixed along with the other one.
_________________
You will obey or molten silver will be poured into your ears.

Falconlobo · Posted: Sun Dec 23, 2007 3:48 pm Post subject:

it isn't fixed i just tried comments work but i got the same error as the pic one mentioned here 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 · Posted: Sun Dec 23, 2007 3:53 pm Post subject:

I just submitted one ok.
_________________
You will obey or molten silver will be poured into your ears.

Falconlobo · Posted: Sun Dec 23, 2007 3:55 pm Post subject:

then how come i got the same error again

is it now fixed before your reply?
_________________
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 · Posted: Sun Dec 23, 2007 3:58 pm Post subject:

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

Falconlobo · Posted: Sun Dec 23, 2007 3:59 pm Post subject:

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. in /usr/home/.sites/28/site1/web/config.php on line 85
Logo

Error
Error connecting to database

got this when i tried
_________________
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 · Posted: Sun Dec 23, 2007 4:00 pm Post subject:

thats normal for a minute after a reload. Try again.
_________________
You will obey or molten silver will be poured into your ears.

Falconlobo · Posted: Sun Dec 23, 2007 4:01 pm Post subject:

fine
_________________
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 5:54 pm Post subject:

Thats a load off.

Any more info as to the real cause?
Looking at backtracing got me know where, all the file line pointers pointed to things totally irrelevant to the problem. Confused

elyo11 · Still very bored Joined: 09 Aug 2005 Posts: 341

lol, I was just trying to say something. I dont even have christmas drawings XD but thnx denis.
_________________
[img]http://i170.photobucket.com/albums/u247/Valariz/Ulquiorra1.png[/img]
Friendship is like a glass. Be carefull with it 'couse if you break it, it will be hard to repair.

cstdenis · Posted: Sun Dec 23, 2007 11:54 pm Post subject:

It was just the comment insertion triggering a stored procedure. Still don't know the problem. I commented it out and put it back and now it started working *shrugs*
_________________
You will obey or molten silver will be poured into your ears.

Sora121 · Posted: Mon Dec 24, 2007 12:45 am Post subject:

You don't mind if I see that bit of code do you?
It is in the beta files, right? I couldn't tell from how the back trace pointed to files and lines.

cstdenis · Posted: Mon Dec 24, 2007 7:35 pm Post subject:

I'll make a dump of the tables and stored procedures at some point.
_________________
You will obey or molten silver will be poured into your ears.