Re: [Phpwiki-talk] "Fatal Database Error"

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

Tony Laszlo schrieb:
> According to: 
> http://phpwiki.sourceforge.net/phpwiki/FixedBugs
> 
> this bug has been fixed in the CVS. 
> I tried the most recent PearDB.php but the problem persists. 
> http://talking.to/isshowiki/?pagename=PolyglotBang
> 
> Does it require some other file to be replaced? 

No,
according Jeff's problem description:

DB Error: already exists
   ?  (INSERT INTO ms_page (id,pagename,hits) VALUES (1137,' ',0) 
nativecode=Duplicate entry '' for key 2 ...

your page or link table is corrupt.
Try to delete all pages with empty pagename AND all links to it.

Someone has a SQL statement handy?
first try  PhpWikiAdministration: Exorcise WikiDB

Maybe this will work: (mysql for sure not)
here i assume the wrong pagename = ' ' (you have to provide the exact 
sql error)

DELETE FROM link RIGHT JOIN page USING (link.linkfrom = page.id) WHERE 
page.pagename=' ';
DELETE FROM page WHERE page.name=' ';

or can your db do subselects?
DELETE FROM link WHERE SELECT link FROM link, page WHERE (link.linkfrom 
= page.id or link.linkto = page.id) AND page.pagename=' ';

just a guess. untested

BTW: fine WikiChump plugin!
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/