Quote:
Originally Posted by Kirby  To get an SQL error:
- Deactive vBGallery
- Create a new User via ACP
- Activate vBGallery
- View the profile of the newly created user
|
Well i guess the problem comes also from tha fact that the user was not inserted into the gallery user table, as the gallery was shut off.. ( this is a guess)
If you run updateuserposts every time you shut off the gallery for maintenance.. (and if you turn it on again) the poblem should only be there for the time the gallery is turned off on the profile of the user that registered..
code snippet from update user posts in gallery functions..
Code:
Content visible to verified customers only.
this updates the ppgal_user with the data from the vbull usertable..
I agree this is not a fix.. but you can resynchronize the tables by running this.. and the problem will only arise next time you turn gallery off AND a user registers during that time..
Luc
PS: These are just thoughts for finding a real fix