The Arcive of vBulletin Modifications Site.

<<Help>> · **Released**: 07-20-2002

Hey,

I just installed a new hack(Class Hack v1.0) and it was going well until I finished it:

I had finished uploading the images, and decided to test it out, so I went to edit my profile, and selected a class, then hit "Submit Modifcations", and the white screen came up saying there was a slight problem with the database, then below that in a text area was this message:

Database error in vBulletin 2.2.6:

Invalid SQL: UPDATE user SET birthday='1988-1-29',signature='ywsaswm',customtitle='1',usertitle= '◊Crystal God◊',email='ffmaster2@ffmaster2.com',parentemail= '',coppauser='0',homepage='http://www.ff-dc.com',icq='',aim='jamierengj834',yahoo='None',us ergroupid='6', rpgclass='0' WHERE userid='1'
mysql error: Unknown column 'rpgclass' in 'field list'

mysql error number: 1054

Date: Saturday 20th of July 2002 05:49:10 PM
Script: http://www.ff-dc.com/forums/forums/member.php
Referer: http://www.ff-dc.com/forums/member.p...on=editprofile

So after being very disappointed, I decided to look for the problem, and thought I found it -there was 2 semi colons ;; instead of one;- so I quickly changed that, saved the file, uploaded it, and tried it again, same problem, but then I noticed it wasnt uploading properly, so I gave the file to my S.I.C (second in command) and he said it uploaded fine, so, checking once again if it worked, I clicked the button, but again, the same problem

I can not figure out what is going wrong, someone help me?

Xenon · #2 07-20-2002, 03:59 PM

Quote:

Unknown column 'rpgclass' in 'field list'

are you sure you have run the queries to install the hack correct?

assassingod · #3 07-20-2002, 04:05 PM

Yeah, I found that out just a second ago:

This is probably the most stupidest question on the earthm but whats a querie??

Xenon · #4 07-20-2002, 04:10 PM

a query is an order to the database to change the content/structure or read something out of it

for example:
[sql]UPDATE user SET visible=1[/sql]

klick on the link above the box to see how you have to run querys

assassingod · #5 07-20-2002, 04:23 PM

Alright, cool, thanks a lot Xenon

Dean C · #6 07-21-2002, 07:21 AM

i'd reccomend FireFly's "Run a query from your Admin CP" hack for running querys... its always worked for me

https://vborg.vbsupport.ru/showthrea...threadid=26272

- Mist