Prepared statement already exists [message #22399] |
Tue, 01 February 2005 14:52 |
Tangaloor
Messages: 20 Registered: October 2004 Location: Minneapolis, MN
Karma: 0
|
Junior Member |
|
|
I hope someone has some insight into this one. Ever since upgrading PostgreSQL to 7.4.6 (I upgraded to make searching functional), users have been getting the following error when posting:
*Warning*: pg_query(): Query failed: ERROR: prepared statement
"fud25_srch_ins" already exists in */home/usr/httpd/virtual/tanga/WilsoNet/theme/Retro/post.php* on line *2737*
*Warning*: pg_query(): Query failed: ERROR: prepared statement
"fud25_srch_sel" already exists in */home/usr/httpd/virtual/tanga/WilsoNet/theme/Retro/post.php* on line *2738*
*Warning*: Cannot modify header information - headers already sent by (output started at /home/usr/httpd/virtual/tanga/WilsoNet/theme/Retro/post.php:2737) in */home/usr/httpd/virtual/tanga/WilsoNet/theme/Retro/post.php* on line *3983*
|
|
|
|
|
|
|
|
|
|
|
Re: Prepared statement already exists [message #22452 is a reply to message #22449] |
Thu, 03 February 2005 16:52 |
Tangaloor
Messages: 20 Registered: October 2004 Location: Minneapolis, MN
Karma: 0
|
Junior Member |
|
|
Okay. I did 'Rebuild All Themes' and then after I tried optimizing them I got the following errors (and get them when I attempt to rebuild the themes now):
SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt, u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq FROM fud25_ses s INNER JOIN fud25_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) INNER JOIN fud25_themes t ON t.id=u.theme WHERE s.ses_id='fe0e9c845856ee57f02dfc2d8d2a6442'
query count: 1 time taken: 0.009732
Affected rows: 0
total sql time: 0.009732
Warning: Cannot modify header information - headers already sent by (output started at /home/usra/jwilson/fudforum_data/include/theme/default/db.inc:2) in /home/usra/jwilson/fudforum_data/include/theme/default/users.inc on line 2
Warning: Cannot modify header information - headers already sent by (output started at /home/usra/jwilson/fudforum_data/include/theme/default/db.inc:2) in /home/usra/jwilson/fudforum_data/include/theme/default/users.inc on line 2
Warning: Cannot modify header information - headers already sent by (output started at /home/usra/jwilson/fudforum_data/include/theme/default/db.inc:2) in /home/usra/jwilson/fudforum_data/include/theme/default/users.inc on line 2
UPDATE fud25_users SET last_visit=1107449433 WHERE id=2
query count: 2 time taken: 0.048545
Affected rows: 1
total sql time: 0.058277
SELECT theme, lang, name FROM fud25_themes
query count: 3 time taken: 0.002673
Affected rows: 0
total sql time: 0.06095
|
|
|
|
|
Re: Prepared statement already exists [message #22458 is a reply to message #22455] |
Thu, 03 February 2005 22:01 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Don't run the theme optimizer, it causes problems on some PHP installations. I am trying to trackdown the reason, but so far cannot replicate on my own system.
It seems that in some cases the language parser screws up when there is a conditional function declaration on the same line.
FUDforum Core Developer
|
|
|
|
|
|
Re: Prepared statement already exists [message #22464 is a reply to message #22463] |
Fri, 04 February 2005 00:39 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Can you try restarting the PostgreSQL server so that all persistent connections with live version of the prepared statment go away.
FUDforum Core Developer
|
|
|
|