Architecture / Installation

Posted by joelg 07 Jun 2004 08:25 GMT-0000 posts: 104

I'm battling with my problem of incorrect accented characters display on tiki-browse_categories. I decide to load tiki 1.8.2 and 1.7.7 both on my localhost (Windows/XP) to see if any difference between the two.

First horror story👻 using Tiki1.8.2

I load the software (Apache works fine, databases are created called Tiki18 and Tiki17), I run the install script. It shows me the first window asking for details of a database connection, I enter the details and press the button and.... nothing happens. The fields are blanked out and that's all. No error message, no nothing. Apache works fine, I can connect to DB using mysql, all looks ok.

What's going wrong? Never had this problem before...

I sort this out - for some reason, despite the fact the SQL Control Center shows user tikiadmin as being enabled for the database with all privileges, the install process only goes beyond the first screen if I enter user name "root"...

So, on I go: the database script to install the tables seems to work fine, at least nothing appears in the error window and all the tables appear to be there as far as I can judge (I just asked for default installation).

I click on the link to enter Tiki and I get this:
Values:
Array ( )
$result is false
$result is empty

And in the error log it says this:
(client 127.0.0.1) 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` order by `permName` desc in C:\Apache\Apache2\htdocs\tiki18\lib\tikidblib.php on line 133, referer: http://localhost/tiki18/tiki-install.php

I am using MySQL version 14.3 Distrib 4.1.1a-alpha (that's what it says when i do mysql --version)

I've never had this much trouble before after doing several installs. What is going wrong? Bad DB version, what? 😢

Thanks for help