Re: [Phpwiki-talk] MySQL Errors upgrading to PhpWiki 1.3.14

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

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=E4r.

I was starting to feel that I was barking up the wrong tree since it =20
should've found the table I already had, so thanks for that fix! =20
After applying that change I now get a bit further and have the =20
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: =20
wikidb_backend_peardb_mysql: fatal database error

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

---

Okay, so now my wwn_link table is missing the 'relation' column. Upon =20=

further inspection, the wwn_pref table is missing the 'passwd' & =20
'groupname' columns and the wwn_rating & wwn_accesslog tables are =20
missing (but they appear to be optional, judging by comments in =20
schemas/mysql-initialize.sql).

I've not seen notes in the UPGRADING document regarding changes to =20
the link & pref tables. Should I be able to just add the column and =20
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 =20
(pages, link, pref, etc.) as well, but the data seems to also be in =20
the 'wwn_' prefixed tables, so I think someone must've just left the =20
old tables in there during a previous upgrade.

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

Sincerely,

Morgan Aldridge
--
mo...@ma...
http://www.makkintosshu.com/