Re: MySQL Errors upgrading to PhpWiki 1.3.14

On Oct 9, 2007, at 10:30 AM, Reini Urban wrote:

> Try to add the missing tables manually from schemas/mysql- 
> initialize.sql and
> continue then with ?action=upgrade.
>
> CREATE TABLE session (
>     	sess_id 	CHAR(32) NOT NULL DEFAULT '',
>     	sess_data 	BLOB NOT NULL,
>     	sess_date 	INT UNSIGNED NOT NULL,
>     	sess_ip 	CHAR(40) NOT NULL,
>     	PRIMARY KEY (sess_id),
> 	INDEX (sess_date)
> );
> and so on.
>
> The error you get is a php problem, $session_tbl is empty and should
> be "session".

Interestingly enough, I actually already have a table named  
'wwn_session' which MySQL's 'DESCRIBE TABLE' shows matches the format  
of the above 'CREATE TABLE' command. Looking at the config/config.ini  
file it appears the I do have 'DATABASE_PREFIX = wwn_' set.

I checked config/config-dist.ini and the comments seem to imply that  
DATABASE_PREFIX is still the correct setting to modify. Is there an  
issue with the database prefix not being correctly applied in 1.3.14?

Morgan Aldridge
--
[email protected]
http://www.makkintosshu.com/


-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/