vbgallery causing a DB error on new user creation

busterw · September 29th, 2008, 10:45 PM

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:

Code:

Content visible to verified customers only.

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

Chuck S · September 29th, 2008, 11:11 PM

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

Code:

Content visible to verified customers only.

busterw · September 29th, 2008, 11:37 PM

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

Code:

Content visible to verified customers only.

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.

Chuck S · September 30th, 2008, 12:59 PM

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.

busterw · September 30th, 2008, 01:58 PM

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:

Code:

Content visible to verified customers only.

Chuck S · September 30th, 2008, 02:06 PM

Does the code work fine on users registering themselves?

busterw · September 30th, 2008, 02:12 PM

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

Chuck S · September 30th, 2008, 02:28 PM

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.

busterw · September 30th, 2008, 03:28 PM

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

Chuck S · September 30th, 2008, 03:45 PM

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.

busterw · September 30th, 2008, 03:49 PM

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

Chuck S · September 30th, 2008, 03:59 PM

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

I need access to the forums and gallery folders.

busterw · September 30th, 2008, 04:27 PM

Sent, thanks Chuck!

busterw · October 2nd, 2008, 12:34 PM

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

Thanks!
Buster

Chuck S · October 2nd, 2008, 09:26 PM

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

busterw · October 2nd, 2008, 10:04 PM

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

Chuck S · October 3rd, 2008, 05:51 AM

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

busterw · October 3rd, 2008, 08:23 AM

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

Thanks Chuck!

Buster

Chuck S · October 3rd, 2008, 06:22 PM

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.

JLuerken · October 29th, 2008, 03:39 AM

I have the same issue:

Code:

Content visible to verified customers only.

Adding a user manually is not possible at the moment.

Please release an update for the Gallery!