-
Wiki URL Format
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&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?
-
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.
-
Installed build 004 and add rules for apache in htaccess but error persist.
-
Please submit a Ticket Support service via the Members tab, so I can have a look at your installation.
-
Installed Build 005
Problem solved