Database error in vBulletin 5.1.0

[marky]

This has no fix?

[marky]

Another:

[/FONT][/COLOR]

Seems to be getting more frequent now....

[marky]

This errors continue. A few minutes ago this one came up:

[/FONT][/COLOR]

Should we making the habit of clearing the cache tables every time or is there a better solution for...

[marky]

jt86, I was facing problems with deadlocks in my cache tables. Zachery from vBulletin said "Truncate the cache table, and cacheevent. Issue should go away, for a bit anyway."

I...

[marky]

Ok, Thanks. We have truncate the suggested cache tables.

Is this a common issue? Why is this happening?

[marky]

Got an error today (everything is verbatim except the bolded part):

Invalid SQL:
/** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_10_lvl1data' AND event = 'nodeChg_10')...

[marky]

We recently upgraded to v5.1.0 and noticed a couple of problems after the upgrade. It wasn't noticed when we had the 5.0.4 version.

1. vBulletin Version: vBulletin 5.1.0
2. PHP Version: 5.4.17
3. MySQL Version:

...

[marky]

Thanks. Upgrading to 5.1.0 seemed to fix the problem.

[marky]

Hi,

Whenever we try to create a new sub-forum we get the error in the image (see attached).

1. vBulletin Version: vBulletin 5.0.4 Patch Level 1
2. PHP Version: 5.4.17
3. MySQL Version: 5.5.31-log
4. Any

...

[marky]

Glenn: It didn't disappear. It only had a limit of 20

Wayne: Thanks. That fixed it! Was 20 or 0 the default?...

[marky]

Hi,

One of the users on my forums reported the following:

"It appears there is a 20 page limit of some sort and we are unable to see topics that should be on pages 21+....

[marky]

Thanks. The forum is on the same server as the database. According to the official site, 16MB is default for the client and 1MB is default for the server:

http://dev.mysql.com/doc/refman...

[marky]

Hi,

We're getting this error one one of our forum sections occasionally and this has prevented some of our users from posting on the forum. Not too sure what this is about or how this can...

[marky]

Hi,

We currently have vBulletin 5 and it's behind a load balancer on Amazon. Due to it behind a load balancer everyone who uses the forum has the same IP address.

I did some...

[marky]

Earlier today the forums stopped working. Nothing was changed on it and it's running 5.0.4 (we tried to upgrade to 5.0.5 last week but that caused more instability).

There are no errors in...

[marky]

Seems to be working fine now.

What we did:
1. Downloaded the new security patch for v5.0.4
2. Re-uploaded everything (except config.php file)
3. Ran the upgrade.php script...

[marky]

Yes, we just made a backup, but did not utilize it.

Basically:
1. Took a back up of code and db on the live server.
2. Extracted v5.0.4 zip file on local pc and then overrode...

[marky]

We turned the site off on the server from the Admin CP.

We did not install on localhost so we did not need to change the url. We wanted to upgrade and set it up on our server directly....

[marky]

We recently upgraded out forums from v5.0.3 to v5.0.4 but after we did that we faced 2 issues. This is what we did:

1. Backed up the DB and v5.0.3 code folder
2. Extract v5.0.4 on local...