[SkyCatcher]

Originally Posted by SkyCatcher

Hi Guys,

A couple of my users (not very many at all) are having problems accessing the bank for some reason.

This is the email I get:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: UPDATE user SET uttpoints=uttpoints-75,70 WHERE userid='186'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '70 WHERE userid='186'' at line 1

mysql error number: 1064

Date: Monday 14th of June 2004 07:38:07 AM
Script: http://www.probetreff.com/forum/usho...shortname=bank



It works for 99% of the people but for some reason they get an error...they are using internet explorer and 1 user is betting this error on 4 different computers


Any Ideas?

Ok I solved the problem, not 100% sure why though.

The users couldn't access the bank so I deleted what was in the bank_query in my phpmyadmin and they got access...

Then I noticed that some users used a , (comma) instead of a . (period) for decimal places and that somehow screwed up they're points.