PDA

View Full Version : <<Help>>


assassingod
07-20-2002, 04:53 PM
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.php?action=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
07-20-2002, 04:59 PM
Unknown column 'rpgclass' in 'field list'

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

assassingod
07-20-2002, 05: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
07-20-2002, 05:10 PM
a query is an order to the database to change the content/structure or read something out of it

for example:
UPDATE user SET visible=1

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

assassingod
07-20-2002, 05:23 PM
Alright, cool, thanks a lot Xenon

Dean C
07-21-2002, 08:21 AM
i'd reccomend FireFly's "Run a query from your Admin CP" hack for running querys... its always worked for me :D

https://vborg.vbsupport.ru/showthread.php?s=&threadid=26272

- Mist