Wiki URL Format

**migratoria** · August 8, 2014

When I click on: Wiki URL Format >/wiki/Prefix:Article i get the following error.

Code:

Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE `setting` SET `value` =  CASE `varname` 
		 WHEN 'vw_defer' THEN 1 
		 WHEN 'vw_enabled' THEN  
	 END  WHERE  `varname` IN ('vw_defer','vw_enabled');

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE  `varname` IN ('vw_defer','vw_enabled')' at line 4
Error Number  : 1064
Request Date  : Friday, August 8th 2014 @ 06:06:49 PM
Error Date    : Friday, August 8th 2014 @ 06:06:49 PM
Script        : [url]http://www.mysite.it/forum/admincp/wiki_cp.php?panel=settings&do=save[/url]
Referrer      : [url]http://www.mysite.it/forum/admincp/wiki_cp.php?panel=settings&group=server[/url]
IP Address    : xxx.xxx.xxx.xxx
Username      : xxxxxx
Classname     : vB_Database
MySQL Version : 5.5.37-0+wheezy1

I use vbseo
In Htaccess i set the following code as specified here:
https://www.vaultwiki.org/manual/Vau...les-like-vBSEO

but I get the error 404 file not found

My HTACCESS

Code:

<IfModule mod_rewrite.c>
  RewriteEngine on

  # Set to vbulletin directory
  RewriteBase /forum/

  # Retrieve gamedata requests and send to new dbtech locations
  RewriteRule ^arcade/gamedata/(.*) dbtech/vbarcade/media/$1 [L]

  # Retrieve crossdomain requests and send to new dbtech location
  RewriteRule ^crossdomain\.xml dbtech/vbarcade/crossdomain.xml [L]

  # Send hardcoded legacy scores to arcade instead
  RewriteCond %{REQUEST_URI} newscore\.php [OR]
  RewriteCond %{REQUEST_URI} viewgame\.php
  RewriteRule .* arcade.php?sendscore=legacy [L,QSA]

  # Send hardcoded legacy scores to arcade instead
  RewriteCond %{QUERY_STRING} func=storeScore [OR]
  RewriteCond %{QUERY_STRING} autocom=arcade [OR]
  RewriteCond %{QUERY_STRING} act=arcadelib [OR]
  RewriteCond %{QUERY_STRING} act=Arcade
  RewriteRule .* arcade.php [L,QSA]

  # Reroute v3arcade liveinstaller
  RewriteCond %{QUERY_STRING} do=liveinstall
  RewriteCond %{REQUEST_URI} v3arcade_admin\.php

  # If you renamed your admincp directory, change it here
  RewriteRule .* %{DOCUMENT_ROOT}/admincp/arcade_admin.php?%{QUERY_STRING}&do=review&import=browse&system=v3a [L,R=301]
</IfModule>
<ifmodule mod_rewrite.c>
RewriteEngine on

  # Comment the following line (add '#' at the beginning)
# to disable mod_rewrite functions.
# Please note: you still need to disable the hack in
# the vBSEO control panel to stop url rewrites.
RewriteEngine On

# Some servers require the Rewritebase directive to be
# enabled (remove '#' at the beginning to activate)
# Please note: when enabled, you must include the path
# to your root vB folder (i.e. RewriteBase /forums/)
#RewriteBase /

#RewriteCond %{HTTP_HOST} !^www\.yourdomain\.com
#RewriteRule (.*) http://www.yourdomain.com/forums/$1 [L,R=301]

RewriteRule ^((urllist|sitemap_).*\.(xml|txt)(\.gz)?)$ vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]

RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron|vbseo_sitemap|api|wiki|yui\.php)
RewriteRule ^((archive/)?(.*\.php(/.*)?))$ vbseo.php [L,QSA]

#RewriteCond %{REQUEST_FILENAME} !-f
#RewriteCond %{REQUEST_FILENAME} !-d
#RewriteCond %{REQUEST_FILENAME} !/(admincp|modcp|clientscript|cpstyles|images)/
#RewriteRule ^(.+)$ vbseo.php [L,QSA]
## Rewrite

	Options +FollowSymlinks

	RewriteCond %{REQUEST_FILENAME} -s [OR]
	RewriteCond %{REQUEST_FILENAME} -l [OR]
	RewriteCond %{REQUEST_FILENAME} -d
	RewriteRule ^.*$ - [NC,L]

	# vBTube
	ReWriteRule ^media/home vbtube.php [QSA]
	ReWriteRule ^media/rss vbtube.php?do=rss [QSA]
	ReWriteRule ^media/category-(\d+)-(.*)$ vbtube.php?do=cat&id=$1&t=$2 [QSA]		
	ReWriteRule ^media/photo-categories vbtube.php?do=list&ctype=2 [QSA]
	ReWriteRule ^media/adult-categories vbtube.php?do=list&ctype=4 [QSA]
	ReWriteRule ^media/categories vbtube.php?do=list [QSA]	
	ReWriteRule ^media/best-videos vbtube.php?do=topvideos [QSA]	
	ReWriteRule ^media/best-photos vbtube.php?do=topphotos [QSA]	
	ReWriteRule ^media/most-viewed vbtube.php?do=most_viewed [QSA]	
	ReWriteRule ^media/most-voted vbtube.php?do=most_voted [QSA]
	ReWriteRule ^media/upload vbtube_add.php?do=add&amp;pt=0 [QSA]
	ReWriteRule ^media/mymedia-u=(\d+)$ vbtube.php?do=mymedia&u=$1 [QSA]
	ReWriteRule ^media/myfavorites-u=(\d+)$ vbtube.php?do=myfavs&u=$1 [QSA]
	ReWriteRule ^media/youtube youtube_browser.php [QSA]
	ReWriteRule ^media/acp vbtube_admin.php?do=appro2 [QSA]
	ReWriteRule ^media/(\d+)-(.*)$ vbtube_show.php?tubeid=$1&sti=$2 [QSA]
	ReWriteRule ^media/(\d+)$ vbtube_show.php?tubeid=$1 [QSA]
	
</ifmodule>

Can you help me?

**pegasus** · August 9, 2014

Thanks for reporting this. After checking, it looks like RC 1 build 004 was never uploaded to our members area, so whenever you tried to download it, you would still only get build 003. Please try to download it again, as it should resolve this issue.

Also, the code you posted does not actually contain any rewrite rules for the wiki. Even if you use vBSEO, you still have to follow the directions for Apache first.