[X-Files]

Originally Posted by Reef

I just installed this (3.5.4) a few days ago and now some of my members are getting database errors while logging in. This happened to me once yesterday as well.


Each time I have to go into phpmyadmin and erase the vbbux, vbbank and
vbp_nextbankinterest cells in order for them to be able to log in. I probably dont need to erase all 3 but it works.

Hopefully someone can help me with this quickly so I don't have to go through restoring all of the permission settings back again that I changed for this mod to work. That took a whole day to figure out lol

				UPDATE user
				SET
					50000.00000 = 50000.00000 * 1.03,
					vbp_nextbankinterest = 1142248638
				WHERE userid = '3'
					AND vbp_receivespoints = '1';

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 '50000.00000 = 50000.00000 * 1.03,
					vbp_nextbankinterest = 1142248638
				WHE' at line 3
Error Number : 1064

Try reinstaling with Allow overwrite set to yes.