Loading...
 
Architecture / Installation

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » [Install] Mysql Syntax error
 
Thread actions
PDF Print this page
  • Print all pages

    • [Install] Mysql Syntax error

    Posted by almering posts: 4

    Dear all,

    I'm doing a fresh install (v. 1.8.3) on a webserver with ftp acces, php 4.3 Mysql 4.1.7
    Everyting works fine until I renamed tiki-install.php and went directly to the site.

    This is the error I get:

    http://tm-twix.tm.tue.nl/~almering/tikiwiki/

    Warning: mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 1 in query:
    select `permName`,`type`,`level`,`permDesc` from `users_permissions` order by `permName` desc
    in /home/almering/public_html/tikiwiki/lib/tikidblib.php on line 133

    Fatal error: Call to a member function on a non-object in /home/almering/public_html/tikiwiki/lib/tikidblib.php on line 151

    here you can see my phpinfo command:
    http://tm-twix.tm.tue.nl/~almering/test.php

    Could someone help me out...??

    Thanks!


    Reads: 1853
    Link
    Posted by sylvie greverend posts: 1092
    mysql4.1 needs the last version of the adodb package
    Link
    Posted by Damian Parker posts: 2881 United Kingdom

    Hiya

    MySQL 4.1 doesnt work with any version of tikiwiki, because we still use negative numbers in limits for restricting rows returned.

    Damian
    http://tikihost.net

    Link

    Posted by almering posts: 4

    Thx for the replies!

    -Is installing the lastest version of the adodb package an option damian...?
    -Should I downgrade to mysl 3.X.???
    -Is a new version comming out which supports 4.1?

    Link