FUDforum: Bug Reports » Query failed

Home » FUDforum Development » Bug Reports » Query failed

Show: Today's Messages :: Polls :: Message Navigator

Query failed [message #29779]

Sat, 14 January 2006 21:00

Joss

Messages: 2
Registered: January 2006
Location: Edmonton Alberta

Karma: 0

Junior Member

I looked around and have not found any patches that fix this.
This ERROR pops up anytime ANYONE submits a posts.
Please check feel free check it out here.

Nothing regards style or anthing has been changed because we would like to get the forum to work first.

Thanks Joss

Warning: pg_query(): Query failed: ERROR: syntax error at or near "least" at character 42 in /usr/home/web/xpressentertainment.ca/forum/index.php on line 96
(/usr/home/web/xpressentertainment.ca/forum/index.php:96
/usr/home/web/xpressentertainment.ca/forum/index.php:150
/usr/home/web/xpressentertainment.ca/forum/theme/default/post.php:2769
/usr/home/web/xpressentertainment.ca/forum/theme/default/post.php:1656
/usr/home/web/xpressentertainment.ca/forum/theme/default/post.php:3893
/usr/home/web/xpressentertainment.ca/forum/index.php:1219
) : ERROR: syntax error at or near "least" at character 42
Query: SELECT id FROM fud26_search WHERE word=''least''
_GET: array ( 't' => 'post', )
_POST: array ( 'msg_subject' => 'Re: test', 'msg_icon' => '', 'fnt_size' => '', 'fnt_color' => '', 'fnt_face' => '', 'msg_body' => 'At least the cencor thing is working... now the submit error!', 'tmp_f_val' => '1', 'msg_show_sig' => 'Y', 'minimsg_pager_switch' => '0', 'S' => 'd6779f2c605ed05ea38e09df390b4fcf', 'SQ' => 'a8118d7fd36ca89b409c3f95c2b640c6', 'submitted' => '1', 'reply_to' => '22', 'th_id' => '1', 'frm_id' => '1', 'start' => '0', 'msg_id' => '0', 'pl_id' => '0', 'old_subject' => 'Re: test', 'prev_loaded' => '1', 'btn_submit' => 1, )
Server Version:
[Referring Page] http://www.xpressentertainment.ca/forum/index.php?t=post&reply_to=22&am p;S=d6779f2c605ed05ea38e09df390b4fcf

Report message to a moderator

Re: Query failed [message #29792 is a reply to message #29779]

Mon, 16 January 2006 14:45

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Get the latest isearch.inc.t from CVS, replace yours with it and rebuild the theme, it should do the trick.

You can find this file here:
http://cvs.prohost.org/c/index.cgi/FUDforum/getfile/install/forum_data/src/ isearch.inc.t?v=1.65

FUDforum Core Developer

Report message to a moderator

Re: Query failed [message #29799 is a reply to message #29792]

Mon, 16 January 2006 23:54

Joss

Messages: 2
Registered: January 2006
Location: Edmonton Alberta

Karma: 0

Junior Member

Thank you very much. I will give it a shot.

Report message to a moderator

Previous Topic:	Division by Zero in Compact Message
Next Topic:	Syntax error doing admimport -- V 2.7.3

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 09:09:49 GMT 2024

Total time taken to generate the page: 0.01973 seconds