Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • Error message

    Posted by Jens Tolkmitt posts: 9 Germany

    Hi folks,

    I hope, anyone can help me.

    Ic have installed a Tiki on Windows platform with MySQL 4.1 database server. All works fine. But after three weeks I cannot open the index-Page (tiki-index.php). I see that the processors attche the data but I get back a blank white page.

    OK - I tryed to access the page tiki-my_tiki.php - it opens a page. From there I can access all data in the Wiki, articles or forums. But when I start to logon and put my username and password in the Logon box, I get back the following error message:


    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` where `type`= ? order by `permName` desc
    in d:\web\jens.tolkmitt\msx-info.de\htdocs\MSXwiki\lib\tikidblib.php on line 133

    Fatal error: Call to a member function on a non-object in d:\web\jens.tolkmitt\msx-info.de\htdocs\MSXwiki\lib\tikidblib.php on line 151
    PHP 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` where `type`= ? order by `permName` desc
    in d:\web\jens.tolkmitt\msx-info.de\htdocs\MSXwiki\lib\tikidblib.php on line 133 PHP Fatal error: Call to a member function on a non-object in d:\web\jens.tolkmitt\msx-info.de\htdocs\MSXwiki\lib\tikidblib.php on line 151


    I don't know what this can be. I already backed up my database, I reconfigured the whole environment - every the same. Access is not possible. I don't change any configuration e.g. before I get this error. I don't understand the error message because I don't found the source where this SQL statement came from (it's not in tikidblib.php).

    Any hints?

    Thanks in advance.

    Jens 😢

    Reads: 1035
    Posted by Damian Parker posts: 2881 United Kingdom

    TikiWiki does not work with MySQL 4.1 yet. There are issues to resolve in the Limit -1 syntax which we use. MySQL dropped it in the 4.1 release

    Damian


    Posted by Jens Tolkmitt posts: 9 Germany

    Oh yes, I see. I'll try this with an SQL Server 2000 database. Hope this works.

    Thanks. Jens