From: Thomas H. <tom...@gm...> - 2006-04-04 03:54:27
|
I am a bit embarrassed, but my wiki blues turned out to be largely self-inflicted. That said, I am still singing them, though I have made a lot of progress. To begin with, the correct URL is (sorry) http://hawsedc.com/phpwiki-1.3.12p2/index.php That url gives one error that seems to indicate I need to upgrade. But when I go to: http://hawsedc.com/phpwiki-1.3.12p2/index.php?action=3Dupgrade I get a tantalizing view of phpwiki, but it says, "*Missing PagePermission: change HomePage is disallowed on this wiki for not authenticated user ' 70.176.232.214' (level: ANON)." and * lib/WikiDB/backend/PearDB.php:1027: Error: WikiDB_backend_PearDB_mysql: fatal database error - DB Error: no such table - (INSERT INTO accesslog (time_stamp,remote_host,remote_user,request_method,request_line,request_= uri,request_args,request_time,status,bytes_sent,referer,agent,request_durat= ion) VALUES(1144122753,'ip70-176-232-214.ph.ph.cox.net','-','GET','GET /phpwiki-1.3.12p2/index.php?action=3Dupgrade HTTP/1.1','/phpwiki- 1.3.12p2/index.php?action=3Dupgrade','action=3Dupgrade','03/Apr/2006:23:= 52:33 -0400',200,0,'','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: 1.8.0.1) Gecko/20060111 Firefox/1.5.0.1','0.327347040176') [nativecode=3D1146 ** Table 'jconstru_phpwiki1.accesslog' doesn't exist]= ) So now I guess I am really close, but still broke. Oh, yeah. Tom Haws |
From: Thomas H. <tom...@gm...> - 2006-04-06 14:29:14
|
Joel wrote: Perhaps if you're just setting up a wiki for the first time and want to see > it running quickly you could try the file based db. It's a little easier > and quicker than the other methods if you just want to see your wiki up > and > running and try it out. Read the notes and it will tell you what you > need > to know about picking where the wiki saves to, and then making sure the > apache (or whatever user runs the website) has write permission to that > directory. That sounds attractive. Unfortunately I have been running previous version= s of phpWiki on mySQL for quite a while. I have only a few dozen pages in mySQL. I think its better that I get mySQL running again. Reini wrote: > If you use a SQL database you have to configure and initialize the > database. > There are some README's about that. Thanks, Reini. I had tried to run schema/mysql-initialize.sql on Saturday, but mySQL reported a Page Already Exists error and phpWiki?action=3Dupgrade continues not to work. If this can't work, I will go ahead and see if the old version in Fantastic= o will work with php5/mysql5 -- Tom Haws |
From: Reini U. <ru...@x-...> - 2006-04-07 08:20:12
|
2006/4/6, Thomas Haws <tom...@gm...>: > Joel wrote: > > Perhaps if you're just setting up a wiki for the first time and want to > see > > it running quickly you could try the file based db. It's a little easi= er > > and quicker than the other methods if you just want to see your wiki up > and > > running and try it out. Read the notes and it will tell you what you > need > > to know about picking where the wiki saves to, and then making sure the > > apache (or whatever user runs the website) has write permission to that > > directory. > > > That sounds attractive. Unfortunately I have been running previous versi= ons > of phpWiki on mySQL for quite a while. I have only a few dozen pages in > mySQL. I think its better that I get mySQL running again. > > Reini wrote: > > > If you use a SQL database you have to configure and initialize the > > database. > > There are some README's about that. > > Thanks, Reini. I had tried to run schema/mysql- initialize.sql on Saturd= ay, > but mySQL reported a Page Already Exists error and phpWiki?action=3Dupgra= de > continues not to work. > > If this can't work, I will go ahead and see if the old version in Fantast= ico > will work with php5/mysql5 You cannot just run the whole SQL schema file. Look at the content of the file and the also existing mysql sql update file= and add the tables and columns you are missing by hand. phpwiki gave you already all the information what you are missing. -- Reini Urban http://phpwiki.org/ http://spacemovie.mur.at/ http://helsinki.at/ |
From: Thomas H. <tom...@gm...> - 2006-04-07 03:29:28
|
I apologize for taking all the time I have on the list, but I had phpwiki working for a long time, and I relied on it for various uses. I would really like now to get it installed again (any version) and port my old pages to it. Please don't give up on me. Here are the facts: Previous phpwiki version: 1.3.7 Form of previous pages: mysql table only (no phpwiki dump) Current system: Jaguarpc web hosting server running php5 and mysql5. Jaguarpc is a very generic Linux host. Please hold my hand as I do the following steps: 1. Choose a version 2. Install and choose a database system 3. Port my old pages from 1.3.7 If you will help me, I will document at the support wiki what I have done t= o get success. Thanks again, Tom Haws (not a new wiki user) |
From: Thomas H. <tom...@gm...> - 2006-04-08 14:07:12
|
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 file= and add the tables and columns you are missing by hand. phpwiki's error messages give you all the information that you are missing.= " 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?action= =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? Tom |
From: Reini U. <ru...@x-...> - 2006-04-08 16:27:18
|
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 |
From: Thomas H. <tom...@gm...> - 2006-04-11 17:13:48
|
Reini, I really appreciate the good effort you have made to help me get my old phpwiki back up and running. You said: > yes, > fix the db perms manually or let phpwiki do it for you. I tried both approaches without success. I removed all permissions from the dbuser, then re-granted all permissions. The only thing I can think of at the moment is to delete and recreate the dbuser. Can you think of any other approach? Here's the message again in case you forgot: check for mysql LOCK TABLE privilege ...lock_tables_priv missing. The DB Admin must run mysql_fix_privilege_tables Please let me know if there is anything I can do to repay your efforts (I may be able to help you with your ACADWiki. I am an AutoLISP developer and I have started the sourceforge FreeLand project for a free land development suite for AutoCAD.=20 http://sourceforge.net/project/showfiles.php?group_id=3D124596 ) Thanks again, Tom -- Tom Haws 480-201-5476 "There are many causes that I am prepared to die for but no causes that I am prepared to kill for" Gandhi |
From: Reini U. <ru...@x-...> - 2006-04-11 19:07:50
|
2006/4/11, Thomas Haws <tom...@gm...>: > I really appreciate the good effort you have made to help me get my > old phpwiki back up and running. > > You said: > > yes, > > fix the db perms manually or let phpwiki do it for you. > > I tried both approaches without success. I removed all permissions > from the dbuser, then re-granted all permissions. The only thing I > can think of at the moment is to delete and recreate the dbuser. Can > you think of any other approach? > > Here's the message again in case you forgot: > check for mysql LOCK TABLE privilege ...lock_tables_priv missing. The > DB Admin must run mysql_fix_privilege_tables In this case I can only think of contacting the admin to give you the db lock perms. And fix the privilege_tables. > Please let me know if there is anything I can do to repay your efforts > (I may be able to help you with your ACADWiki. I am an AutoLISP > developer and I have started the sourceforge FreeLand project for a > free land development suite for AutoCAD. > http://sourceforge.net/project/showfiles.php?group_id=3D124596 ) I'd need new hardware :) -- Reini Urban http://phpwiki.org/ http://spacemovie.mur.at/ http://helsinki.at/ |
From: Thomas H. <tom...@gm...> - 2006-04-11 19:53:37
|
On 4/11/06, Reini Urban <ru...@x-...> wrote: > 2006/4/11, Thomas Haws <tom...@gm...>: > > Please let me know if there is anything I can do to repay your efforts > I'd need new hardware :) What kind of hardware? Where are you located? -- Tom Haws 480-201-5476 "There are many causes that I am prepared to die for but no causes that I am prepared to kill for" Gandhi |
From: Reini U. <ru...@x-...> - 2006-04-13 18:51:28
|
Thomas Haws schrieb: > On 4/11/06, Reini Urban <ru...@x-...> wrote: >> 2006/4/11, Thomas Haws <tom...@gm...>: >>> Please let me know if there is anything I can do to repay your efforts > >> I'd need new hardware :) > > What kind of hardware? Where are you located? Anything as good as our broken high performance server at the university. Quite expensive piece in fact :) One HW Raid with 2 Sony SCSI 30GB harddiscs for the system, another HW raid with 4 120GB IDE harddiscs for /home, and an ordinary double-cpu system. CPU speed not important, IO and RAM is. Graz, Austria -- Reini Urban http://phpwiki.org/ http://helsinki.at/ http://spacemovie.mur.at/ |
From: Thomas H. <tom...@gm...> - 2006-04-14 02:44:20
|
Yeowww! You don't need new hardware. So are you out of AutoCAD mode now? Tom On 4/13/06, Reini Urban <ru...@x-...> wrote: > Thomas Haws schrieb: > > On 4/11/06, Reini Urban <ru...@x-...> wrote: > >> 2006/4/11, Thomas Haws <tom...@gm...>: > >>> Please let me know if there is anything I can do to repay your effort= s > > > >> I'd need new hardware :) > > > > What kind of hardware? Where are you located? > > Anything as good as our broken high performance server at the university. > Quite expensive piece in fact :) > > One HW Raid with 2 Sony SCSI 30GB harddiscs for the system, > another HW raid with 4 120GB IDE harddiscs for /home, > and an ordinary double-cpu system. > CPU speed not important, IO and RAM is. > > Graz, Austria > -- > Reini Urban > http://phpwiki.org/ > http://helsinki.at/ http://spacemovie.mur.at/ |
From: Thomas H. <tom...@gm...> - 2006-04-10 05:51:24
|
> 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=3D3Dupgrade) > ;DBADMIN_USER =3D3D > ;DBADMIN_PASSWD =3D3D Thanks so much for taking the time to help me through this. I added the highest level DBADMIN_USER and DBADMIN_PASSWD=3D to config.ini, but it didn't move me forward at all. I don't have the root password. I also tried to grant the permissions manually, and the error persists. Any ideas? -- Tom Haws 480-201-5476 "There are many causes that I am prepared to die for but no causes that I am prepared to kill for" Gandhi |
From: Thomas H. <tom...@gm...> - 2006-04-12 20:07:45
|
I am upgrading my old phpwiki. http://www.hawsedc.com/pwnew/index.php?action=3Dupgrade with user admin and pw admin gives this error: check for mysql LOCK TABLE privilege ...lock_tables_priv missing. The DB Admin must run mysql_fix_privilege_tables The jaguarpc senior tech says: The privileges are already assigned. Please provide this output to the phpwiki developers: mysql> select * from db where user=3D'jconstru_phpwiki' and db=3D'jconstru_phpwiki1'; +-------------+--------------------+------------------+ | Host | Db | User | +-------------+--------------------+------------------+ | localhost | jconstru_phpwiki1 | jconstru_phpwiki | | 192.168.1.% | jconstru_phpwiki1 | jconstru_phpwiki | +-------------+--------------------+------------------+ -------------+-------------+-------------+-------------+ Select_priv | Insert_priv | Update_priv | Delete_priv | -------------+-------------+-------------+-------------+ Y | Y | Y | Y | Y | Y | Y | Y | -------------+-------------+-------------+-------------+ -------------+-----------+------------+-----------------+ Create_priv | Drop_priv | Grant_priv | References_priv | -------------+-----------+------------+-----------------+ Y | Y | N | Y | Y | Y | N | Y | -------------+-----------+------------+-----------------+ ------------+------------+-----------------------+------------------+ Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | ------------+------------+-----------------------+------------------+ Y | Y | Y | Y | Y | Y | Y | Y | ------------+------------+-----------------------+------------------+ 2 rows in set (0.00 sec) -- Tom Haws 480-201-5476 "There are many causes that I am prepared to die for but no causes that I am prepared to kill for" Gandhi |
From: Thomas H. <tom...@gm...> - 2006-04-13 02:46:34
|
Addendum: Server tech says: "Yes the command was successfully executed. As I have given you the result previously that lock_tables_priv is NOT missing." -- Tom Haws 480-201-5476 "There are many causes that I am prepared to die for but no causes that I am prepared to kill for" Gandhi |
From: Reini U. <ru...@x-...> - 2006-04-13 10:58:51
|
2006/4/13, Thomas Haws <tom...@gm...>: > Addendum: > Server tech says: > > "Yes the command was successfully executed. As I have given you the > result previously that lock_tables_priv is NOT missing." Thanks for the result in your previous mail. Something within action=3Dupgrade seems to be borked. -- Reini Urban http://phpwiki.org/ http://spacemovie.mur.at/ http://helsinki.at/ |
From: Thomas H. <tom...@gm...> - 2006-04-13 14:53:38
|
Thank you so much. Just let me know when there is another action for me to take. No huge rush. Tom On 4/13/06, Reini Urban <ru...@x-...> wrote: > 2006/4/13, Thomas Haws <tom...@gm...>: > > Addendum: > > Server tech says: > > > > "Yes the command was successfully executed. As I have given you the > > result previously that lock_tables_priv is NOT missing." > > Thanks for the result in your previous mail. > Something within action=3Dupgrade seems to be borked. > -- > Reini Urban > http://phpwiki.org/ > http://spacemovie.mur.at/ http://helsinki.at/ > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting langua= ge > that extends applications into web and mobile media. Attend the live webc= ast > and join the prime developer group breaking into this new coding territor= y! > http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642 > _______________________________________________ > Phpwiki-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk > -- Tom Haws 480-201-5476 "There are many causes that I am prepared to die for but no causes that I am prepared to kill for" Gandhi |
From: Reini U. <ru...@x-...> - 2006-04-13 18:15:21
|
Thomas Haws schrieb: > Thank you so much. Just let me know when there is another action for > me to take. No huge rush. > > Tom > > On 4/13/06, Reini Urban <ru...@x-...> wrote: >> 2006/4/13, Thomas Haws <tom...@gm...>: >>> Addendum: >>> Server tech says: >>> >>> "Yes the command was successfully executed. As I have given you the >>> result previously that lock_tables_priv is NOT missing." >> Thanks for the result in your previous mail. >> Something within action=upgrade seems to be borked. I was able to confirm this, and even noticed that I already disabled the "mysql >= 4.0.4 requires LOCK TABLE privileges" check in lib\upgrade.php in CVS HEAD, at 14-Nov-05. To continue please disable this check by editing lib\upgrade.php goto // mysql >= 4.0.4 requires LOCK TABLE privileges and change the line below to if (0 and substr($backend_type,0,5) == 'mysql'/* and $DBParams['dbtype'] != 'PDO' */) { |
From: Thomas H. <tom...@gm...> - 2006-04-14 02:09:53
|
Wonderful. Thanks. It works now. On 4/13/06, Reini Urban <ru...@x-...> wrote: > Thomas Haws schrieb: > > Thank you so much. Just let me know when there is another action for > > me to take. No huge rush. > > > > Tom > > > > On 4/13/06, Reini Urban <ru...@x-...> wrote: > >> 2006/4/13, Thomas Haws <tom...@gm...>: > >>> Addendum: > >>> Server tech says: > >>> > >>> "Yes the command was successfully executed. As I have given you the > >>> result previously that lock_tables_priv is NOT missing." > >> Thanks for the result in your previous mail. > >> Something within action=3Dupgrade seems to be borked. > > I was able to confirm this, and even noticed that I already disabled the > "mysql >=3D 4.0.4 requires LOCK TABLE privileges" check in lib\upgrade.ph= p > in CVS HEAD, at 14-Nov-05. > > To continue please disable this check by editing lib\upgrade.php > > goto // mysql >=3D 4.0.4 requires LOCK TABLE privileges > > and change the line below to > > if (0 and substr($backend_type,0,5) =3D=3D 'mysql'/* and > $DBParams['dbtype'] !=3D 'PDO' */) { > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting langua= ge > that extends applications into web and mobile media. Attend the live webc= ast > and join the prime developer group breaking into this new coding territor= y! > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat= =3D121642 > _______________________________________________ > Phpwiki-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk > -- Tom Haws 480-201-5476 "There are many causes that I am prepared to die for but no causes that I am prepared to kill for" Gandhi |
From: Thomas H. <tom...@gm...> - 2006-04-14 06:30:48
|
Do you know why it would give me this message on saving a page now? Warning! /home/jconstru/public_html/hawsedc/phpwiki/lib/WikiDB.php:908: Notice: Optimizing database -- Tom Haws 480-201-5476 "There are many causes that I am prepared to die for but no causes that I am prepared to kill for" Gandhi |
From: Reini U. <ru...@x-...> - 2006-04-14 06:38:14
|
The Warning is wrong. It's just a notice. 2006/4/14, Thomas Haws <tom...@gm...>: > Do you know why it would give me this message on saving a page now? > > Warning! > > /home/jconstru/public_html/hawsedc/phpwiki/lib/WikiDB.php:908: Notice: > Optimizing database > > -- > Tom Haws 480-201-5476 > "There are many causes that I am prepared to die for but no causes > that I am prepared to kill for" Gandhi > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting langua= ge > that extends applications into web and mobile media. Attend the live webc= ast > and join the prime developer group breaking into this new coding territor= y! > http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642 > _______________________________________________ > Phpwiki-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk > -- Reini Urban http://phpwiki.org/ http://spacemovie.mur.at/ http://helsinki.at/ |
From: Thomas H. <tom...@gm...> - 2006-04-14 22:48:22
|
Here's a little bug: At http://hawsedc.constructionnotesmanager.com/thomas/PhpWikiAdministration in Email verification. WikiAdminUtils says: . Page Name Click to reverse sort order =09 . E-Mail . =09 . Verification Status . Cancel Okay /home/jconstru/public_html/hawsedc/phpwiki/lib/plugin/WikiAdminUtils.php:23= 1: Notice: Undefined property: PageList::$_rows Tom |
From: Reini U. <ru...@x-...> - 2006-04-15 10:18:33
|
2006/4/15, Thomas Haws <tom...@gm...>: > Here's a little bug: > > At http://hawsedc.constructionnotesmanager.com/thomas/PhpWikiAdministrati= on > in Email verification. > > WikiAdminUtils says: > . Page Name Click to reverse sort order . E-Mail . . > Verification Status . > > Cancel > > Okay > > /home/jconstru/public_html/hawsedc/phpwiki/lib/plugin/WikiAdminUtils.php:= 231: > Notice: Undefined property: PageList::$_rows Thanks. Changed to: $group =3D (int)(count($pagelist->_pages) / $pagelist->_group_rows); -- Reini Urban http://phpwiki.org/ http://spacemovie.mur.at/ http://helsinki.at/ |
From: Thomas H. <tom...@gm...> - 2006-04-15 16:42:09
|
Thanks for the report for my use. I just may send you a little fix so the XHTML Snapshot download doesn't break on [Pages with spaces]. Tom On 4/15/06, Reini Urban <ru...@x-...> wrote: > 2006/4/15, Thomas Haws <tom...@gm...>: > > Here's a little bug: > > > > At http://hawsedc.constructionnotesmanager.com/thomas/PhpWikiAdministra= tion > > in Email verification. > > > > WikiAdminUtils says: > > . Page Name Click to reverse sort order . E-Mail . . > > Verification Status . > > > > Cancel > > > > Okay > > > > /home/jconstru/public_html/hawsedc/phpwiki/lib/plugin/WikiAdminUtils.ph= p:231: > > Notice: Undefined property: PageList::$_rows > > Thanks. > Changed to: > $group =3D (int)(count($pagelist->_pages) / > $pagelist->_group_rows); > > > -- > Reini Urban > http://phpwiki.org/ > http://spacemovie.mur.at/ http://helsinki.at/ > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting langua= ge > that extends applications into web and mobile media. Attend the live webc= ast > and join the prime developer group breaking into this new coding territor= y! > http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642 > _______________________________________________ > Phpwiki-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk > -- Tom Haws 480-201-5476 "There are many causes that I am prepared to die for but no causes that I am prepared to kill for" Gandhi |
From: Thomas H. <tom...@gm...> - 2006-04-25 21:25:48
|
This e-mail notice was a surprise. Is the PhpWiki programming team really crawling the web and updating wikis? LoadDump Editar: The PhpWiki programming team Loaded the following pages: ReglasDeFormatoDeTexto BuscarP=E1gina ViejoReglasDeFormatoDeTexto MasAcercadeLaMecanica KBrown P=E1ginaPrincipal ComoUsarWiki EditarElTexto CajaDeArena VisitantesRecientes MasPopulares BuenEstilo TodasLasPaginas CambiosRecientes AgregarPaginas CreatePage RelatedChanges Tom Haws |
From: Reini U. <ru...@x-...> - 2006-04-26 06:07:11
|
Thomas Haws schrieb: > This e-mail notice was a surprise. Is the PhpWiki programming team > really crawling the web and updating wikis? No. It's a generated message. The virgin setup is trggered when the HOME_PAGE is not available. WHich might be case here, when the language is changed. Here it looks like thet you didn't set your language DEFAULT_LANG=en, and that it is autodetected. When someone with a spanish browser gets to your wiki, some spanish pages are pulled in. That's all. > LoadDump > Editar: The PhpWiki programming team > > Loaded the following pages: > ReglasDeFormatoDeTexto > BuscarPágina > ViejoReglasDeFormatoDeTexto > MasAcercadeLaMecanica > KBrown > PáginaPrincipal > ComoUsarWiki > EditarElTexto > CajaDeArena > VisitantesRecientes > MasPopulares > BuenEstilo > TodasLasPaginas > CambiosRecientes > AgregarPaginas > CreatePage > RelatedChanges > > Tom Haws -- Reini Urban http://phpwiki.org/ http://helsinki.at/ http://spacemovie.mur.at/ |