FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » PgSQL Bug
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
PgSQL Bug [message #9438] Fri, 28 March 2003 03:14 Go to previous message
Ramon is currently offline  Ramon   Belgium
Messages: 4
Registered: March 2003
Karma:
Junior Member
Hi

When trying to split a thread, I get an error about an invalid SQL statement.

So, say I have thread with 10 Messages, Test1 to Test10, and I split out Test5 to Test8, then I get the error message below

--------------------------------
Warning: pg_query() [function.pg-query]: Query failed: ERROR: parser: parse error at or near "," at character 250 . in /XXX/forum/index.php on line 131
(t=msg&th=31&rid=13&S=e29eaf3a378ca27ebcd7af9cbda7790c) :
Query: SELECT fud_msg.id, fud_msg.subject FROM fud_thread_view INNER JOIN fud_thread ON fud_thread_view.thread_id=fud_thread.id INNER JOIN fud_msg ON fud_thread.root_msg_id=fud_msg.id WHERE fud_thread_view.forum_id=3 AND fud_thread_view.page IN(, -1) AND fud_thread.moved_to=0 AND (fud_thread_view.page * 25 + fud_thread_view.pos) < 0 ORDER BY page DESC, pos DESC LIMIT 1
Server Version: PostgreSQL 7.3.2 on i386-portbld-freebsd4.8, compiled by GCC 2.95.4
[Referring Page] http://XXX/forum/index.php?t=split_th&rid=13&S=e29eaf3a378ca27ebcd7 af9cbda7790c&th=27
-----------------------------------
Furtheron, assume that this thread was in a Forum with (originally) 5 threads, then -- after returning to the forum --
the forum-index states that there are 6 threads in that forum.
(which is correct, because the new split-out thread should have been created) BUT when going into that forum I still see just 5.

The only remedie seems to run "Forum Consistency". Afterwards the forum correctly lists the 6 threads.

Evidently, this is rather cumbersome in a production environment.

independent remark:

FUDForum runs on a (non-production, test) P-400 system with 0.75 GB RAM, generous pgSQL cache and very low load, over domain sockets, yet typically needs around 1 sec for a page.
According to my experience PostgreSQL, while beeing considerably more stable and reliable than mySQL, should perform roughly equal ...

Thank you
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: edit signature
Next Topic: reset password error
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 01 21:39:23 GMT 2024

Total time taken to generate the page: 0.04171 seconds