No wiki article links work

**optikalefx** · September 3, 2009

I only have 1 wiki forum and in the thread list all of the links are this

http://www.mp3car.com/vbulletin/showwiki.php?title=

I can't tell what happened, i updated to 2.5.2 last night, so i guess that. But i installed 2.5.2 no a different machine fresh and it's not happening. Where can i look to fix this?

thanks!

**pegasus** · September 3, 2009

Although there are multiple ways to get this problem, this is one possible outcome of improper inline moderation handling by the wiki (you mentioned in a report you had made some file edits to the inlinemod plugin file).

Check CES VaultWiki > Wiki URL Manager > Edit URL Replacements to make sure everything is okay there. If it looks right, you can try "Rebuild Page URLs".

**optikalefx** · September 4, 2009

Not sure what im looking for in the url replacements, never been there before.

I tried to rebuild the page urls, but i get a sql error

Code:

Database error in vBulletin 3.8.2:

Invalid SQL:

				UPDATE vault_protect
				SET title_lower = CASE protectid
					
WHEN 7 THEN ''
WHEN 1 THEN ''
				END
				WHERE protectid IN (7,1);

MySQL Error   : Duplicate entry '6-' for key 2
Error Number  : 1062
Request Date  : Friday, September 4th 2009 @ 01:14:13 AM
Error Date    : Friday, September 4th 2009 @ 01:14:14 AM
Script        : http://www.mp3car.com/vbulletin/admincp/vaultwiki_url.php?do=rebuild
Referrer      : http://www.mp3car.com/vbulletin/admincp/vaultwiki_url.php?do=modify
IP Address    : 69.143.217.136
Username      : optikalefx
Classname     : vB_Database
MySQL Version : 5.0.81-community

I have never edited those pages.

In response to the changes i did make, i put them back the way i found it for now. (still no go though)

Any other suggestions?

**optikalefx** · September 4, 2009

I also tried using the rebuild link in the namespace manager and there too i get a sql error

Code:

Database error in vBulletin 3.8.2:

Invalid SQL:

					UPDATE vault_protect
					SET title_lower = CASE protectid
						
WHEN 7 THEN ''
WHEN 1 THEN ''
WHEN 6 THEN ''
WHEN 5 THEN ''
WHEN 4 THEN ''
WHEN 3 THEN ''
WHEN 2 THEN ''
					END
					WHERE protectid IN (7,1,6,5,4,3,2);

MySQL Error   : Duplicate entry '6-' for key 2
Error Number  : 1062
Request Date  : Friday, September 4th 2009 @ 01:16:45 AM
Error Date    : Friday, September 4th 2009 @ 01:16:46 AM
Script        : http://www.mp3car.com/vbulletin/admincp/vaultwiki_namespace.php?do=rebuild&namespaceid=6
Referrer      : http://www.mp3car.com/vbulletin/admincp/vaultwiki_namespace.php?do=modify
IP Address    : 69.143.217.136
Username      : optikalefx
Classname     : vB_Database
MySQL Version : 5.0.81-community

**pegasus** · September 4, 2009

Try: CES VaultWiki > Wiki URL Manager > Import. Import the default xml file. Rebuild Page URLs.

If this has no effect, please post the contents of: vBulletin Options > vBulletin Options > Version Info and Other Untouchables > URL Replacements.

**optikalefx** · September 4, 2009

That worked!! You're awesome!

Any technical reason why that happened? Maybe how to prevent this from the future? Thanks!

**pegasus** · September 6, 2009

There was an issue with the first revision of the latest build. In updating the replacement format so an import was possible, the upgrader ignored these changes and reapplied the old format.

Note that this only occurred on upgrades from 2.5.1 to 2.5.2 (not fresh installs), and AFAIK this issue was fixed. If you or anyone else downloads the product after this post and encounters this, let me know.