Re: MySQL Errors upgrading to PhpWiki 1.3.14

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".


2007/10/9, Morgan Aldridge <[email protected]>:
> I've inherited a PhpWiki installation running on Mac OS X 10.4.10
> (Tiger) Server with its default installation of PHP 4.4.7 & MySQL
> 4.1.22.
>
> Unfortunately, the previous owner either checked it from a version
> control repository or stripped out all documentation regarding the
> version number, so I don't know exactly which version it's running.
> Judging by features and dates I'm guessing it's definitely a 1.3.x
> release, probably 1.3.9 or later.

no, it is more likely 1.3.7 or earlier.

> However, I dropped the config file & pages directory into 1.3.14 and
> I get the following error when trying to run ?action=upgrade:
>
> ---
>
> check for necessary database updates - SQL
> db version: we want 1030.14
> db version: we have 0
> Backend type: mysql
>
> check for table session ...MISSING ...
> Fatal Error:
> lib/WikiDB/backend/PearDB.php:1059 Error:
> wikidb_backend_peardb_mysql: fatal database error
>
> DB Error: syntax error
> (
> CREATE TABLE (
> sess_id CHAR(32) NOT NULL DEFAULT '',
> sess_data BLOB NOT NULL,
> sess_date INT UNSIGNED NOT NULL,
> sess_ip CHAR(15) NOT NULL,
> PRIMARY KEY (sess_id),
> INDEX (sess_date)
> ) [nativecode=1064 ** 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 '(
> sess_id CHAR(32) NOT NULL DEFAULT '',
> sess_data BLOB NOT NULL,
> ' at line 1])
> Notice: "Undefined variable: session_tbl"
>
> Notice: "Undefined variable: session_tbl"
>
> ---
>
> Is this likely a 1.3.9 or 1.3.7 installation and I need to redo the
> config.ini and manually modify the MySQL database?
>
> Any suggestions as to how to get this upgraded to 1.3.14 would be
> greatly appreciated.
>
> Sincerely,
>
> 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/
> _______________________________________________
> Phpwiki-talk mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>


-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

-------------------------------------------------------------------------
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/