Problems with database

[Urban Ranger]

The queries are failing...

Time to do a maintenance?

[alva]

Why do they start failing?

[Urban Ranger]

No idea why, not a guru of MySQL. All I know is it wouldn't let me attach images.

[Frozzy]

Possibly related to a faulty table, or somesuch.

In any case, attachments aren't working

[MarkG]

blah

[MarkG]

fixed

we've managed to max out the allowed space for id's(65k) on the attachment table

[Bugs ****ing Bunny]

No error message any more, but attachments aren't showing.

[Maniac]

When a few hours ago I tried to post a Superhero image in that off topic thread, I get the following message:

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

We apologise for the inconvenience.


Database error in vBulletin: Invalid SQL: INSERT INTO attachment (attachmentid,userid,dateline,filename,visible,has h) VALUES (NULL,3088,1077899568,'obstructor.jpg','1','63949f b9398e6fd828c64f66884df1cd')
mysql error: Duplicate entry '65535' for key 1
mysql error number: 1062
Date: Friday 27th of February 2004 11:32:48 AM
Script: /forums/newreply.php
Referer: http://apolyton.net/forums/newreply....hreadid=108754

When I tried again now, I got the following message:

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

We apologise for the inconvenience.


Database error in vBulletin: Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,iconid,visible) VALUES (NULL,'109506','','Maniac','3088','1077915061','65 559','Test','1','1','80.200.248.206','0','1')
mysql error: Server shutdown in progress
mysql error number: 1053
Date: Friday 27th of February 2004 03:53:57 PM
Script: /forums/newreply.php
Referer: http://www.apolyton.com/forums/newre...hreadid=109506

Any idea what's going on?

[MarkG]

blah

[Maniac]

?

[MarkG]

changes where needed in the posts table as well..

[vmxa1]

Originally posted by MarkG
fixed

we've managed to max out the allowed space for id's(65k) on the attachment table

Time to purge some of the inactive users. What criteria do you use for this process?

[MarkG]

it's not an issue if inactive users, this was about the attachments sql table

[Urban Ranger]

Hosing the older attachments?

[MarkG]

no, the actual data of the attachments is not in the database any longer

the attachment table has an id column which was an int(5) so it had a maximum value of 65535. we've reached that number(we have less than 65535 attachments but when an entry is deleted the id is not used by a new one) and had to alter the table structure to be usable again