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

Home » FUDforum Development » Bug Reports » BUGs: LIMIT clause in postgresql
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
BUGs: LIMIT clause in postgresql [message #8039] Thu, 09 January 2003 03:16 Go to previous message
laser is currently offline  laser   China
Messages: 9
Registered: January 2003
Karma:
Junior Member
Seems no one use FUDforum with PostgreSQL, and less test in it.
but if you use it with current version of PostgreSQL (7.3.1),
you'll find there are lots of bugs:

first one is the the users table (in fuduser.tbl or something), the CREATE TABLE come with and
extra comma ',' at the end of last line, the consraint, causing installation on PostgreSQL failed.

second one is very big: in PostgreSQL 7.3.1, the "LIMIT #,#" clause are obsolete, you should use "LIMIT # OFFSET #", the later
is SQL standard compliant, but the formal is not. (I think it's
mysql specefic). There are many places with direct hard coded
LIMIT #,# and not using qry_limit() function, cost a few hours to check. Sad

finally, I want to ask how to change the code in install.php directly? those md5() check and LIMIT clause *did* annoying me
while I want do fix those bugs in install.php directly, and failed at last.

any comment?
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: bad default sql table prefix
Next Topic: 2.3.6 listing bug?
Goto Forum:
  

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

Current Time: Tue Nov 05 18:24:22 GMT 2024

Total time taken to generate the page: 0.04458 seconds