Re: MySQL Errors upgrading to PhpWiki 1.3.14

On Oct 11, 2007, at 1:11 AM, Reini Urban wrote:

> Just for you now, yes please.
> I remember that lib/upgrade.php had this kind of bug in 1.3.14
>
>       function CheckDatabaseUpdate() {
> -       global $DBAuthParams;
> +       global $DBAuthParams, $DBParams;
>
> Revision 1.60  2007/08/25 18:43:35  rurban
>    add missing DBParams. Detected by Sacha Schär.

I was starting to feel that I was barking up the wrong tree since it  
should've found the table I already had, so thanks for that fix!  
After applying that change I now get a bit further and have the  
following errors:

---

check for table session ...OK
check for table pref ...OK
check for table member ...OK
Rebuild entire database to upgrade relation links ...
Fatal Error:
lib/WikiDB/backend/PearDB.php:1059 Error:  
wikidb_backend_peardb_mysql: fatal database error

DB Error: no such field
(INSERT INTO wwn_link (linkfrom, linkto, relation) VALUES (2, 3, 0)  
[nativecode=1054 ** Unknown column 'relation' in 'field list'])

---

Okay, so now my wwn_link table is missing the 'relation' column. Upon  
further inspection, the wwn_pref table is missing the 'passwd' &  
'groupname' columns and the wwn_rating & wwn_accesslog tables are  
missing (but they appear to be optional, judging by comments in  
schemas/mysql-initialize.sql).

I've not seen notes in the UPGRADING document regarding changes to  
the link & pref tables. Should I be able to just add the column and  
it'll handle it correctly?

Also, does this give any hints as to what version I've got running?

Interestingly, I've got numerous tables without the 'wwn_' prefix  
(pages, link, pref, etc.) as well, but the data seems to also be in  
the 'wwn_' prefixed tables, so I think someone must've just left the  
old tables in there during a previous upgrade.

Thanks in advance for any additional assistance or suggestions you  
can provide.

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/