Something in 2.3.4 is affecting the whole vBulletin 3.7

JulianD · May 6th, 2008, 05:32 PM

I managed to stop the sql errors by disabling the 2.3.4 gallery I installed yesterday.

vBGallery 2.3.4 (migrated from the lastest previous version)
vBulletin 3.7

Here's an example of sql errors, take a look, every query has one userid missing:

Code:

Content visible to verified customers only.

Code:

Content visible to verified customers only.

Code:

Content visible to verified customers only.

And so on... I have the sql error log full of this.

Zachariah · May 6th, 2008, 07:16 PM

What proceedure did you use when upgrade ?

- The querries you pasted here are not called by the gallery, but in them there was a call for userid and it is not there.

JulianD · May 6th, 2008, 07:42 PM

Hi,

I upgraded from 2.3.3 I think.

Maybe this is the problem. When I was upgrading the script timed out when it was inserting and updating the table ppgal_user. The table is really big and it timed out. I edited the scripts to skip that process and continue the upgrading process.

Maybe that table needs to be up to date in order to these queries to work?

Zachariah · May 6th, 2008, 08:23 PM

yes the table should be updated.

AdminCP => vBGallery => Maintenance
- Update User Counts

Also did the rest of the script on upgrade run ok ?

JulianD · May 7th, 2008, 09:33 PM

yeap.... I stripped the malfunctioning code and the rest of the upgrade went ok.

JulianD · May 7th, 2008, 11:14 PM

Same problem:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/laneros/public_html/includes/class_core.php on line 408

Can you provide a cli script or something that runs on the command line so it doesn't time out?

Zachariah · May 8th, 2008, 07:55 PM

I'll work on breaking up the operation into X amount of record updates per page refreash.

JulianD · July 4th, 2008, 10:44 AM

Any update on this? The gallery is half working because of this! :S

JulianD · July 30th, 2008, 12:39 AM

Is this application death or something? I'm have all kinds of problems with this gallery and I paid a lot for this. I'm being patient but this is enough. Zachariah said he'd come with a solution to paginate something in the upgrade scripts but still nothing.

Please someone answer me!

Chuck S · July 30th, 2008, 08:29 AM

Well I am not zachariah but if you have some upgrade script timeout issue my suggestion would be to add something like this to the top of the upgrade to make it not timeout.

Code:

Content visible to verified customers only.