Bug vBDonate Database error

[Drahnier]

I got this in an email;

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO `dbtech_vbdonate_donations`
(
userid,
amount,
dateline,
confirmed,
userip,
testdon
)
VALUES
(
122,
Infinite,
1345537253,
'0',
'*IP Removed*',
'0'
);

MySQL Error : Unknown column 'Infinite' in 'field list'
Error Number : 1054
Request Date : Tuesday, August 21st 2012 @ 02:20:53 AM
Error Date : Tuesday, August 21st 2012 @ 02:20:53 AM
Script : http://www.myur.coml/vbdonate.php?do=dodonate
Referrer : myurl.com: The Leading Domain Names Site on the Net
IP Address : *IP Removed*
Username : Fire
Classname : vB_Database
MySQL Version :






Amount:infinite does seem odd but perhaps there should be a catch for invalid entries

 

[Ozzy47]

Yeah infinite is definitely the issue, instead of typing a amount they typed in infinite, I'll look to see if there is a way to stop that.

 

[Ozzy47]

I have a fix for this that will be in the next version, it will not allow the user to type text in the box, but if they past text in the box it will still happen, but I doubt to many will do that.

 

[Ozzy47]

I actually have a better fix now, if a user inputs anything but a numeric value, (ie 5 or 5.00 a error message will pop up and say, This Field Must Contain Numbers Only!!! (ie 5 or 5.00

When they click on OK on the error message popup, it will clear what they entered in there.

 

[Ozzy47]

This has been fixed in the latest version, 1.2.2