Loading...
 
Architecture / Installation

Architecture / Installation


1.8.4.1 Installed but wont run.

posts: 5

Running:
- Apache 1.3.31/PHP 4.3.9/MySQL 3.23.49
- Fresh install of Tikiwiki 1.8.4.1
- Windows XP Profession SP2

Install when perfect. When I went to enter site nothing. So I enabled error logging and here is what im seeing.

03-Jan-2005 00:54:31 PHP Warning: session_start(): open(\\sess_svp78sn74f5lh83gbmahusdqv5, O_RDWR) failed: Invalid argument (22) in c:\pam\htdocs\tikiwiki\tiki-setup_base.php on line 178

03-Jan-2005 00:54:31 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:<br/>select `permName`,`type`,`level`,`permDesc` from `users_permissions` order by `permName` desc <br/> in c:\pam\htdocs\tikiwiki\lib\tikidblib.php on line 133


03-Jan-2005 00:54:31 PHP Fatal error: Call to a member function on a non-object in c:\pam\htdocs\tikiwiki\lib\tikidblib.php on line 151

03-Jan-2005 00:54:31 PHP Warning: Unknown(): open(\\sess_svp78sn74f5lh83gbmahusdqv5, O_RDWR) failed: Invalid argument (22) in Unknown on line 0

03-Jan-2005 00:54:31 PHP Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (\) in Unknown on line 0


posts: 2881 United Kingdom


Create a new folder c:\tmp

Edit your php.ini and look for session.save_path and set it to session.savepath=c:\tmp

Then restart Apache and smile

Damian
http://tikihost.net

posts: 5

Thankx Damian, I set the session_path to c:\pam\temp\ since I have everything needed for test webserv er under PAM directory, and it fixed the problem.

However now I have an SQL syntax error that I'm going to look into.

03-Jan-2005 16:12:36 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:\pam\htdocs\tikiwiki\lib\tikidblib.php on line 133

03-Jan-2005 16:12:36 PHP Fatal error: Call to a member function on a non-object in c:\pam\htdocs\tikiwiki\lib\tikidblib.php on line 151

posts: 5

OK I verified the Tiki requirements:

A MySQL database under version 4.1, or PostgreSQL.
TikiWiki 1.9 -sirius- is moving towards support for 4.1.x with a upgrade in the ADOdb layer, however 1.8.x does not support MySQL 4.1.x

I am running MySQL 3.23.49 which should be fine. I can go in and update the SQL query but beleive I'll just have plenty more, but while Im waiting for a reply here I'll give it a shot.

posts: 5

The error is comming from lib/userlib.php, line 903:

$query = "select `permName`,`type`,`level`,`permDesc` from `users_permissions` $mid order by $sort_mode ";

I added a trace to see the actual query:

TRACE: userlib.php->line 903->SQL=select `permName`,`type`,`level`,`permDesc` from `users_permissions` order by `permName` desc

I'll play around with it more later, just found out my Zend debugger is not working...AGAIN!


posts: 5

Well I'm stuck cry
I Search tiki forums for related issues and most people that had same error where running MySQL 4.1 > and I am running MySQL 3.23.49. It has to be something minor, something not in the cod ebecause 1.8.4.1 is not a major release, so I know it workds..hense..i don't want to go changing the code all over.

Help?


posts: 1

I found a way around the mysql error (the one on line 133 of tikidblib.php)

the workaround is to replace:

$numrows = intval($numrows);
$offset = intval($offset);

by

$numrows = -1; //intval($numrows);
$offset = -1; // intval($offset);

on line 64 and 65 of lib/tikidblib.php

I had the idea coming from an other post that set they removed the "limits" from the queries. As the fix was give as a diff command, I had trouble make it work on Windows so I looked for the function that used those parameters.

Hope it helps biggrin


posts: 9 Germany

Thanks to gnairolf! This also works in my environment with MySQL 4.1. Interesting hack. biggrin

Jens


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