Re: [Phpwiki-talk] RE: Wiki Blues

[Reini U. <ru...@x-...>]

2006/4/8, Thomas Haws <tom...@gm...>:
> Based on this statement of Reini's, I have hade better success:
>
> "You cannot just run the whole SQL schema file.
> Look at the content of the file and the also existing mysql sql update fi=
le and
> add the tables and columns you are missing by hand.
> phpwiki's error messages give you all the information that you are missin=
g."
>
> This statement needs to be added to the distro docs.
>
> I am now to the point that I am getting a phpwiki page
> http://hawsedc.constructionnotesmanager.com/pwnew/index.php/HomePage?acti=
on=3Dupgrade
> with this error
> check for mysql LOCK TABLE privilege ...lock_tables_priv missing. The
> DB Admin must run mysql_fix_privilege_tables
>
> I tried to run mysql_fix_privilege_tables, but I couldn't.
>
> I tried to get my host, Jaguarpc, to run it, but they said:
> "I have tried the command you have provided with the root access but
> the command is not getting through."
>
> Any ideas where I can go from here?

yes,
fix the db perms manually or let phpwiki do it for you.

See your config.ini compared to config-dist.ini
and add the appropriate DBADMIN user and password entries,

; Optional: administrative SQL DB access (for action=3Dupgrade)
;DBADMIN_USER =3D
;DBADMIN_PASSWD =3D

http://cvs.sourceforge.net/viewcvs.py/phpwiki/phpwiki/config/config-dist.in=
i
?view=3Dmarkup