Keep getting database errors

**iphoneclub** · April 14, 2010

Posting this here as I think it's isolated to my install (done by Pegasus) and thus not cluttering the project tools, but I keep getting several database errors per day.

Code:

Database error in vBulletin (version removed):

Invalid SQL:

				UPDATE vb_vault_link
				SET targetid = 3400
				WHERE namespace = 6
					AND title_lower = 'dfu';

MySQL Error   : Can't find record in 'vb_vault_link'
Error Number  : 1032
Request Date  : Wednesday, April 14th 2010 @ 10:21:53 PM
Error Date    : Wednesday, April 14th 2010 @ 10:21:53 PM
Script        : http://www.iphoneclub.nl/forum/wiki/DFU
Referrer      : http://www.iphoneclub.nl/forum/f14/iphone-jailbreak-unlock/f65/jailbreak/43956-custom-3-1-2-firmware.html
IP Address    : ***.***.***.***
Username      : Niet geregistreerd
Classname     : vB_Database
MySQL Version :

All these errors are the same, but differ in targetid, title and obviously referer and IP. For today alone I already have 42 errors in my email.

Any clue what seems to be the problem here?

**pegasus** · April 15, 2010

Your database may be nearly full, or the vb_vault_link table was corrupted. If the table is corrupt, you can try running the following MySQL query:

Code:

REPAIR TABLE vb_vault_link

There is also a bug (in MySQL) which causes this in MySQL < 4.1.13. You removed your MySQL version so I don't know if this is related.

**iphoneclub** · April 15, 2010

I'm running on MySQL 5.0.67.
REPAIR TABLE didn't help much. The REPAIR command did execute, but I get this output in phpMyAdmin, presumably since the table structure is InnoDB?

screen-capture-1.jpg

This is the table structure in phpMyAdmin. Please note the huge negative number for vb_vault_link.
screen-capture.jpg

I've not used InnoDB before, so I don't know whether this is correct or not.

**pegasus** · April 15, 2010

Try:

Code:

TRUNCATE TABLE vb_vault_link

**iphoneclub** · April 15, 2010

That looks much better. Now let's wait if the database errors stop, but I'm fairly confident this was the solution.

**iphoneclub** · April 16, 2010

Another day, new database errors and a corrupted vb_vault_link table again :-( What does this table do and how are the inserts being triggered? I truncated the table again and it helps temporarily, but I don't want to keep doing this. Any help is much appreciated.