[Phpwiki-talk] MySQL Errors upgrading to PhpWiki 1.3.14

[Morgan A. <mak...@ma...>]

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.

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
--
mo...@ma...
http://www.makkintosshu.com/