vbgallery causing a DB error on new user creation
 

We're running vbulletin 3.7.3 and vbgallery, when I try to create a new user in vbulletin manually, I get the following error:

If I disable photopost, the error goes away. I've disabled all of my plugins and this is the only one causing the problem.

In case it matters, I'm running vbgallery ina different DB that vbulletin is.

What shall I do?

Thanks!
Buster

Try redownloading vbgallery 2.43 and reupload all the files except config file as I beleive this is something that has already been fixed in the code.

Now the exact file is this that needs to be uploaded.

\forums\includes\vbgallery\useradmin_update_data.php

The query should look like this

Well I ddi and that code is still incorrect in the current download. The current download reads:

Even If I take out the extra ', it still blows up on manually adding a new user to the forum. So, I disbaled the vbgallery plugin for the forum and the gallery still laods, for some reason.

What do you mean it blows up the query I posted should be fine so what is the error? I am sure it would change if you change the code.

Manually attempting to add a new user, after replacing the line of code in my file with yours in the post above, is generating this MYSQL error:

Does the code work fine on users registering themselves?

If I just go to my registration screen as a new member and create an account, yep, visitors can create accounts. It's only when trying to do manually "add user" from the vbulletin admincp that it blows up.

Let me remind you that my vbulletin and vbgallery reside in different databases in case that makes a difference in anything.

Thanks Chuck!
Buster

Buster

vbgallery and vbulletin can not reside in different databases there is no option for that in vbgallery so I am lost a little on that statement.

I stand corrected. I created a new database for the vbgallery install and had that it the back of my mind from a month or so ago, not recallaing that the data never went into my photopost database, but rather that it went directly into the vbulletin database.

Thanks for that reminder and clarification. So, with that not being an option for the problem, what other ideas do you ahve?

Thanks!
Buster

vbgallery always installs into the vb database thats it.

I would need to see your site. You can send via the contact link the admin login url and ftp info.

Yeah, I wasn't recalling the install clearly. What type of ftp info do you need me to send. In other words, to what folder do you need access? Will you need ftp info for the forums folder and everything below it or what?

And I just use "Contact Us" at the top of this forum. How do I assure it goes to you or are you the only one that gets it?

Thanks Chuck!
Buster

Buster the contact link goes to our support helpdesk which I read.

I need access to the forums and gallery folders.

Sent, thanks Chuck!

Chuck, did you get a chance to look into this yet?

Thanks!
Buster

Did I get the information or respond to you? I show no open tickets by you that I see

I sent the info the 30th but never got a response back.

Did you not receive it. I sent it through your "contact us" link aroun d 5:25pm.

Thanks!
Buster

Yes we did reply to it and never got a response

Please also send a url to the gallery install and the vbulletin admin login

Sorry, that email slipped by. I just responded to it with the information you requested.

Thanks Chuck!

Buster

not a problem I am responding to emails and other support tickets but when I get a chance I will look into it. Will probally take me longer to look into than other issues since it seems quite complex meaning a user can register and it works fine but you cant do it manually.

I have the same issue:
Adding a user manually is not possible at the moment.

Please release an update for the Gallery!