Cannot create new User

[Lloyd]

I'm attempting to create a New User from the vB Admin Control Panel and get a DB error:
Database error in vBulletin 3.8.1:

Invalid SQL:
SHOW TABLE STATUS LIKE 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 'user'' at line 1
Error Number : 1064
Request Date : Wednesday, March 11th 2009 @ 12:33:31 AM
Error Date : Wednesday, March 11th 2009 @ 12:33:31 AM
Script : Log in - Forums - vBulletin Admin Control Panel
Referrer : Log in - Forums - vBulletin Admin Control Panel
IP Address : 71.50.7.54
Username : Lloyd
Classname : vb_database
MySQL Version : 5.0.67-log

I found a post like this from 2007 that suggested turning off vGallery and so I tried that but still get the same error.

I can create a user by going through the Registration process and then I can login as Administrator and make changes to the profile, including changing the record to Administrator.

Any suggestions?

[Chuck S]

The query in the includes\vbgallery\useradmin_update_data.php should be valid as this

Content visible to verified customers only.

[Luciano]

mine works fine even with gallery enabled...
try following:
open your forum/includes/config.php
right at the top below the <?php add:

define('DISABLE_HOOKS', true);

then.. try to add a new user..
if it works.. then its a plugin problem you have

remove the line above

and go to your plugin manager.. and start disabling plugins...
one by one..

each time you disabled one.. try to add user...

at the moment it works and you dont get the error any more.. you know its the plugin you disabled last that is involved...

So you reenable all other plugins.. except that one.. IF you still can add a user without errors.. then you know it is that plugin..

Luc

[Lloyd]

Luc,
Thanks for your reply. I modified config.php as you suggested and could then add a new user. I removed that line and could then not add a new user.

Since this is a new site, PhotoPost is the only Plug-in I have installed. I disabled vbGallery and could then add a new user so the problem is definitely related to vbGallery.

Since this is a new installation, I have almost nothing in the database. Would it be your recommendation that I remove vbGallery and start over with the installation?

Thanks for your help.
Lloyd

[Luciano]

Originally Posted by Lloyd

Since this is a new installation, I have almost nothing in the database. Would it be your recommendation that I remove vbGallery and start over with the installation?

Yes definetely...
because chuck has been updating the files every time a bug was found..
so if you did not dowload in the last 24 hours..
get a fresh version and do the install..
if it was a fresh download.. then no.. leave it as is..
and do the following:

you have vbgallery as the only product installed...
open the plugin manager.. (NOT the product-manager)
there you should have (in the section Product : PhotoPost vBGallery) about 20 to 30 plugins...
you can enable or disable them by checking the box and save status..

do as explained above.. (disabling plugins one by one)

Luc

[Lloyd]

Originally Posted by Chuck S

The query in the includes\vbgallery\useradmin_update_data.php should be valid as this

Content visible to verified customers only.

Hi Chuck,
I only have two files in the includes\vbgallery folder:
fetch_userinfo_query.php and template_groups.php but no \useradmin_update_data.php

I have done the things Luc has recommended in his posts in this thread. I've disabled one-by-one the plugins that are installed. Only when I disabled vbGallery could I add a new user.

I was going to install the latest version of vbGallery as Luc suggested, but the build date you have listed is 2/28/09 which is the version I installed.

Is there a new version that might resolve this?

Thanks,
Lloyd

[Luciano]

Originally Posted by Lloyd

Hi Chuck,
I only have two files in the includes\vbgallery folder:
fetch_userinfo_query.php and template_groups.php but no \useradmin_update_data.php

this is because you are using 2.5 beta and not 2.43
but the code is the same.. only its directly in database...

the strange thing is your error message...
because it has no table prefix in it..
is it correct you are not using a table prefix?
like vb_
(defined in forum/includes/config.php --
// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'vb_';
)

because the error output should be..
Invalid SQL:
SHOW TABLE STATUS LIKE vb_user';

if you have vb_ as prefix...
Luc

[Chuck S]

Correct most includes where moved into plugins to be as effecient as possible. Only two files where left that needed to be left.

[Lloyd]

Chuck,
The only reason I'm using the 2.5 Beta is that on the member's Downloads page, it clearly says that PhotoPost 2.43 is for vBulleting 3.7 only. From that page, it says that the only version of PhotoPost Pro or vbGallery that is for vB 3.8.1 is the 2.5 Beta.
The last thing I want to do is use beta software on a production site, but I also don't want to install a product (2.43) when in bold letters it says it only supports 3.7.
What product should I install? The only thing I care about is that there is a single registration between PhotoPost and vBulletin and that it actually is a supported product for 3.8.1.
Lloyd

[Luciano]

there have not been any code changes concerning that plugin..
so using 2.5 beta is ok.. and shouldnt make differences when creating a new user..
did you check your table prefix? have you got one?
Luc

[Chuck S]

vb 2.5 beta is fine to use IMO

Luciano his sql output should be

SHOW TABLE STATUS LIKE 'user';

I wonder why in his error the first single quote is missing.

[Luciano]

Originally Posted by Chuck S

I wonder why in his error the first single quote is missing.

good find.. just checked the 2.5 product file for the plugin..
cut&paste below

Content visible to verified customers only.

seems the single quote is not there !
Luc

PS i still use the file plugins.. thats why it works on my install.. I just updated with file-compare..

[Chuck S]

Michael Michael Michael LOL

He must be using older files as this was and is fixed in 2.43 code so I will send that to him

[sjpritchard]

Hi, I'm getting this problem too with vbGallery 2.5 Beta (3/12/09). I tried installing the latest build and it hasn't fixed it. Where can I get a fix from?

Thanks,

Steve

[Chuck S]

Find the code Luciano notes above he notes and replace with this in the xml file in the admincp directory or edit the plugin directly through the plugin manager

Content visible to verified customers only.

[sjpritchard]

I updated the XML file but it didn't work. Do I need to reload or re-import it to activate the change?

Here is the error I get:

Database error in vBulletin 3.7.5:

Invalid SQL:
SHOW TABLE STATUS LIKE 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 'user'' at line 1
Error Number : 1064
Request Date : Saturday, March 21st 2009 @ 02:34:24 PM
Error Date : Saturday, March 21st 2009 @ 02:34:24 PM
Script : Log in - Z Special Unit Forums - vBulletin Admin Control Panel
Referrer : Log in - Z Special Unit Forums - vBulletin Admin Control Panel
IP Address : 124.170.103.85
Username : Preacher
Classname : vB_Database
MySQL Version : 5.1.30-community

[sjpritchard]

I had a look at my old product xml file and I can see the error in it. The latest build of v2.5 seems to already have the fix but it's not implemented on my site. When I tried to follow the upgrade procedure from the old to the new build of v2.5 it said it was already installed, so I'm guessing that the new XML file hasn't been configured. should I be de-installing and re-installing everything?

[Chuck S]

You need to reimport the plugin sure or edit the already installed plugin.