27-02-2004 22:02									#1
	Problems with database Support Apolyton, buy Call to Power 2

The queries are failing...

Time to do a maintenance?

	27-02-2004 22:38									#2
	Full PM-box? Change here!

Why do they start failing?

	27-02-2004 23:47									#3
	Support Apolyton buy from Amazon

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

	27-02-2004 23:49									#4
	Lose 30 kilos (of popups)

Possibly related to a faulty table, or somesuch.

In any case, attachments aren't working

	28-02-2004 00:03									#5
	Support Apolyton or Terrorists Win

blah

	28-02-2004 00:04									#6
	Full PM-box? Change here!

fixed

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

	28-02-2004 01:15									#7
	Support Apolyton, buy Call to Power 2

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

	28-02-2004 01:58									#8
	Remove this text

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

quote: 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','63949fb9398e6fd828c64f66884df1cd') 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...threadid=108754

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

quote: 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/newr...threadid=109506

Any idea what's going on?

	28-02-2004 02:00									#9
	Support Apolyton, buy Alpha Centauri

blah

	28-02-2004 02:01									#10
	Browse Apolyton AD-FREE

?

	28-02-2004 02:01									#11
	Remove this text

changes where needed in the posts table as well..

Attachment: im9.jpg
This has been downloaded 88 time(s).

	28-02-2004 02:16									#12
	Inflate your Upload Space

quote: 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?

	28-02-2004 02:29									#13
	Put an end to popups!

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

	28-02-2004 07:42									#14
	Enter the AD-FREE zone

Hosing the older attachments?

	28-02-2004 10:02									#15
	Browse Apolyton AD-FREE

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

	28-02-2004 11:33									#16
	Got spare money?

So what is the id column now?

	28-02-2004 11:54									#17
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

now it's an int(10)

should last a bit longer

	28-02-2004 19:51									#18
	Enter the AD-FREE zone

I thought the number in parantheses is the default display length while the max number can be held is determined by type of field? So tinyint (unsigned) holds 255, smallint holds 65535, etc?

	01-03-2004 20:47									#19
	Support Apolyton, buy GURPS/ Alpha Centauri

quote: Originally posted by Urban Ranger I thought the number in parantheses is the default display length while the max number can be held is determined by type of field? So tinyint (unsigned) holds 255, smallint holds 65535, etc?

mySQL fields don't work that way. They are literally the number of digits in the number. This is fairly standard among DB implementations.

	01-03-2004 21:43									#20
	Enter the AD-FREE zone

Then shouldn't int(5) be equal to 99999 instead of 65535 ?

Just wondering

	01-03-2004 22:53									#21
	Help yourself to an AD-FREE life

quote: Originally posted by alva Then shouldn't int(5) be equal to 99999 instead of 65535 ? Just wondering

Yes.

	02-03-2004 08:40									#22
	Help yourself to an AD-FREE life

quote: Originally posted by pchang mySQL fields don't work that way. They are literally the number of digits in the number. This is fairly standard among DB implementations.

Not according to MySQL (Second Edition) by Paul Dubois (Sam's 2003), pp. 102 - 104.