PDA

View Full Version : Database error in vbulletin v.3.7


geevest.com
05-03-2008, 05:53 AM
i get some email warning message :

Database error in vBulletin 3.7.0:

Invalid SQL:

INSERT INTO referrers
(url, count, title)
VALUES
('google.co.id%2Fsearch%3Fhl%3Did%26amp%3Bclient%3 Dfirefox-a%26amp%3Brls%3Dorg.mozilla%3Aen-US%3Aofficial%26amp%3Bhs%3Dcnq%26amp%3Bsa%3DX%26am p%3Boi%3Dspell%26amp%3Bresnum%3D0%26amp%3Bct%3Dres ult%26amp%3Bcd%3D1%26amp%3Bq%3Dmenghilangkan%2Bjer awat%2Bdan%2Bbekasnya%26amp%3Bspell%3D1', 1, 'Google');

MySQL Error : Duplicate entry '%s' for key 1
Error Number : 1062
Request Date : Saturday, May 3rd 2008 @ 07:47:12 AM
Error Date : Saturday, May 3rd 2008 @ 07:47:13 AM
Script : http://anakayam.us/forum/etc-product/6461-jerawat-flex-hitam-kulit-kusam-saatnya-dihapus-dengan-blossoms-guarantee.html
Referrer : http://www.google.co.id/search?hl=id&client=firefox-a&rls=org.mozilla:en-US:official&hs=cnq&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=menghilangkan+jerawat+dan+bekasnya&spell=1
IP Address : 125.161.111.112
Username : Unregistered
Classname : vB_Database
MySQL Version :

how ti fixed this,before im using vb.3.6.8 im not found any error message.
but now for vb.3.7 i get some error database.

Dismounted
05-03-2008, 06:25 AM
This is caused by a modification you have installed. Specifically, one that logs referrers.

geevest.com
05-03-2008, 06:34 AM
and how to fixed this?

--------------- Added 1209809065 at 1209809065 ---------------

and now i get some error message :

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE user SET
### Bitfield: user.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = 'Ayam Sutra',
customtitle = 0,
birthday_search = '',
birthday = '',
referrerid = 0,
caninvitation = 0,
usergroupid = 5,
joindate = 1204861620,
lastactivity = 1209808740,
lastpost = 1209808320,
membergroupids = '',
vbp_receivespoints = 1,
vbp_storeaccess = 1,
vbbux = 180,
vbbank = 0,
vbp_nextbankinterest = 0,
vbp_genericperm = 0,
vbp_modperm = 0,
vbp_adminperm = 0,
vbp_nametextcolor = '',
vbp_nameglowcolor = '',
vbp_nameshadowcolor = '',
vbp_titletextcolor = '',
vbp_changealwaysitems = '',
### Bitfield: user.vbp_displayflags ###
vbp_displayflags = IF(vbp_displayflags & 1, vbp_displayflags - 1, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 2, vbp_displayflags - 2, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 4, vbp_displayflags - 4, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 8, vbp_displayflags - 8, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 16, vbp_displayflags - 16, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 32, vbp_displayflags - 32, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 64, vbp_displayflags - 64, vbp_displayflags),
vbp_displayflags = IF(vbp_displayflags & 128, vbp_displayflags - 128, vbp_displayflags),
### Bitfield: user.vbp_otherflags ###
vbp_otherflags = IF(vbp_otherflags & 1, vbp_otherflags - 1, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 2, vbp_otherflags - 2, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 4, vbp_otherflags - 4, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 8, vbp_otherflags - 8, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 16, vbp_otherflags - 16, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 32, vbp_otherflags - 32, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 64, vbp_otherflags - 64, vbp_otherflags),
vbp_otherflags = IF(vbp_otherflags & 256, vbp_otherflags - 256, vbp_otherflags),
### Bitfield: user.vbp_immunity ###
vbp_immunity = IF(vbp_immunity & 1, vbp_immunity - 1, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 2, vbp_immunity - 2, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 4, vbp_immunity - 4, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 8, vbp_immunity - 8, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 16, vbp_immunity - 16, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 32, vbp_immunity - 32, vbp_immunity),
vbp_immunity = IF(vbp_immunity & 64, vbp_immunity - 64, vbp_immunity),
displaygroupid = 0
WHERE userid = 5818;

MySQL Error : Unknown column 'caninvitation' in 'field list'
Error Number : 1054
Request Date : Saturday, May 3rd 2008 @ 11:00:04 AM
Error Date : Saturday, May 3rd 2008 @ 11:00:04 AM
Script : http://anakayam.us/forum/admincp/user.php?do=update
Referrer : http://anakayam.us/forum/admincp/user.php?do=edit&u=5818
IP Address : 209.190.12.11
Username : zHaZha
Classname : vB_Database
MySQL Version : 4.1.22-standard