Bug New Registration Database error on Send Registration

[CoZmicShReddeR]

I was testing the advanced registration system and got this error

URL Link at Top:
http://www.cozworld.com/register.php?do=addmember

Database ERROR:
Database Error Database error
The CozWorld.com The Hybrid Gamers Zone database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following: •Load the page again by clicking the Refresh button in your web browser.
•Open the www.cozworld.com home page, then try to open another page.
•Click the Back button to try another link.

The www.cozworld.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.


I have no idea how long this has been happening but must have been a good while since I had tested prior to the last update and worked fine...

 

[Fillip H.]

Please show me the full database error message, you will find it via the "technicalemail" address you defined in config.php

 

[CoZmicShReddeR]

Give me some time I do not think it was DragonByte now as I disabled it and still got the error... I hate this crap! My site needs someone else to run it as I am getting more and more careless!

 

[CoZmicShReddeR]

Database error in vBulletin 4.2.1:

Invalid SQL:

UPDATE dbtech_vbactivity_points
SET registration = registration + 25
WHERE userid = '2867';

MySQL Error : Unknown column 'registration' in 'field list'
Error Number : 1054
Request Date : Monday, June 3rd 2013 @ 03:02:50 PM
Error Date : Monday, June 3rd 2013 @ 03:02:52 PM
Script : CozWorld.com The Hybrid Gamers Zone
Referrer : CozWorld.com The Hybrid Gamers Zone
IP Address : 99.158.232.194
Username : Fabar
Classname : vB_Database
MySQL Version :

 

[Ozzy47]

Give me some time I do not think it was DragonByte now as I disabled it and still got the error... I hate this crap! My site needs someone else to run it as I am getting more and more careless!

I know the feeling all to well, I just went through a bunch of stupid errors in vBSuper PM's that should never have been there, but for some reason I got careless and did not check everything like I usually do. So it can happen to the best of us. Best thing to do is take a step back an relax, then come back to it

 

[Fillip H.]

Database error in vBulletin 4.2.1:

Invalid SQL:

UPDATE dbtech_vbactivity_points
SET registration = registration + 25
WHERE userid = '2867';

MySQL Error : Unknown column 'registration' in 'field list'
Error Number : 1054
Request Date : Monday, June 3rd 2013 @ 03:02:50 PM
Error Date : Monday, June 3rd 2013 @ 03:02:52 PM
Script : CozWorld.com The Hybrid Gamers Zone
Referrer : CozWorld.com The Hybrid Gamers Zone
IP Address : 99.158.232.194
Username : Fabar
Classname : vB_Database
MySQL Version :

Run this:

ALTER TABLE dbtech_vbactivity_points ADD registration DOUBLE NOT NULL DEFAULT '0'

 

[CoZmicShReddeR]

Tada!

Thanks!

Also thanks for giving me the que to add my email to the config now hopefully it doesn't blow up my email!

Now all the spammers will be back!