error during creating user in vbulletin

Zakhar · November 25th, 2008, 04:01 PM

Hi Chuck,

I found new problem.

When I try to create user in admincp I got error:

Quote:

Database error in vBulletin 3.7.4:

Invalid SQL:
SHOW TABLE STATUS LIKE vb_user';

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 'vb_user'' at line 1
Error Number : 1064
Request Date : Tuesday, November 25th 2008 @ 11:30:12 PM
Error Date : Tuesday, November 25th 2008 @ 11:30:13 PM
Script : http://[cut]/forum/admincp/user.php?do=update
Referrer : http://[cut]/forum/admincp/user.php?do=add
IP Address : xxx.xxx.xxx.xxx
Username : admin
Classname : vB_Database
MySQL Version : 5.0.67-log

I found that this query used in
/vbgallery/useradmin_update_data.php

Code:

Content visible to verified customers only.

I changed this to

Code:

Content visible to verified customers only.

Now I can create usrers without error. Is this problem in my installation?

Chuck S · November 25th, 2008, 04:58 PM

from what I am seeing you get an error using the code but maybe try this?

Code:

Content visible to verified customers only.

Zakhar · November 25th, 2008, 08:06 PM

Thanks Chuck, your code looks better

I'm stupid!

I change it tomorrow, in Russia now deep night (4 am), and i go to sleep

Can you say that problem in my site or it's bug. I need to know that because i use bridge between joomla and vbulletin and may be this bridge give this effect and after next update i'll see real problem...

Chuck S · November 25th, 2008, 08:16 PM

its already changed you gave me server access

Zakhar · November 26th, 2008, 04:49 AM

Quote:

Originally Posted by Chuck S

its already changed you gave me server access

Ok. Thanks!

Chuck S · November 26th, 2008, 06:10 AM

Not a problem.

oneway · November 28th, 2008, 11:37 AM

I think my brain is not working right. Where can I find this file Chuck?

I have been having this problem for a long time and am happy I just found this thread.

oneway · November 28th, 2008, 11:45 AM

Never mind. I got it. I am so happy this works again.

Chuck S · November 29th, 2008, 11:01 AM

Not a problem have a good weekend.

0ptima · December 6th, 2008, 10:45 AM

Quote:

Originally Posted by Chuck S

from what I am seeing you get an error using the code but maybe try this?

Code:

Content visible to verified customers only.

I got this error this morning.... This fixed it

Chuck S · December 6th, 2008, 10:57 AM

Yes this is an old bug the file should be updated in the actual build glad this assist you.

0ptima · December 6th, 2008, 11:03 AM

When was the build updated?

Chuck S · December 6th, 2008, 11:05 AM

what I am saying is any bug fixes posted here have been updated in the current build and Michael has all the bug fixes for inclusion in the beta so vbgallery should be all set.

0ptima · December 6th, 2008, 11:07 AM

Quote:

Originally Posted by Chuck S

what I am saying is any bug fixes posted here have been updated in the current build and Michael has all the bug fixes for inclusion in the beta so vbgallery should be all set.

ok... I guess I have an older 2.4.3 build....

Chuck S · December 6th, 2008, 11:50 AM

I think any fixed files would be

editimage.php
showimage.php
useradmin_update_data.php

Mari D · December 7th, 2008, 12:02 AM

Lots of people are having this problem so looks like they don't have the latest build?? I just uploaded 2.4.3 a few weeks ago and just found this here to fix it.

Chuck S · December 7th, 2008, 09:36 AM

I would have to review when the actual bug was fixed.