PgSQL Bug [message #9438] |
Fri, 28 March 2003 03:14 |
Ramon
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
|
|
|