Loading...
 
Features / Usability

Features / Usability


syntax error in query

posts: 2

Hi, I have an error with db:

Warning: MYSQL error: DB Error: syntax error in query:
select permName,type,level,permDesc from users_permissions order by permName desc limit 0,-1
in /da/lib/tikilib.php on line 101

I don't know what can I do :-(:(

posts: 2881 United Kingdom

Most likely because you are using mySQL 4.1 and 4.1 does not support limit -1.

There is currently no official fix, but the word in general is to substitude the -1 for a very large number. It requires a hacking ability to PHP and TikiWiki sourcecode.

You can search on mysql.com for the list of all the differences between 4.1 and 4.0

Damian
http://tikihost.net


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting