February 27, 2004, 13:02
|
#1
|
|
Deity
Local Time: 02:29
Local Date: November 3, 2010
Join Date: May 1999
Location: The City State of Noosphere, CPA special envoy
Posts: 14,606
|
Problems with database
The queries are failing...
Time to do a maintenance?
__________________
(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."
|
|
|
|
|
February 27, 2004, 13:38
|
#2
|
|
Deity
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Sep 2001
Location: Republic of Flanders
Posts: 10,747
|
Why do they start failing?
__________________
#There’s a city in my mind
Come along and take that ride
And it’s all right, baby, it’s all right #
|
|
|
|
|
|
February 27, 2004, 14:47
|
#3
|
|
Deity
Local Time: 02:29
Local Date: November 3, 2010
Join Date: May 1999
Location: The City State of Noosphere, CPA special envoy
Posts: 14,606
|
No idea why, not a guru of MySQL. All I know is it wouldn't let me attach images.
__________________
(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."
|
|
|
|
|
|
February 27, 2004, 14:49
|
#4
|
|
Emperor
Local Time: 06:29
Local Date: November 3, 2010
Join Date: Aug 2002
Location: Mad.
Posts: 4,142
|
Possibly related to a faulty table, or somesuch.
In any case, attachments aren't working
|
|
|
|
|
|
February 27, 2004, 15:03
|
#5
|
|
Apolyton CS Co-Founder
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
blah
|
|
|
|
|
|
February 27, 2004, 15:04
|
#6
|
|
Apolyton CS Co-Founder
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
fixed
we've managed to max out the allowed space for id's(65k) on the attachment table 
|
|
|
|
|
|
February 27, 2004, 16:15
|
#7
|
|
Emperor
Local Time: 19:29
Local Date: November 2, 2010
Join Date: Aug 2000
Location: Howling at the moon
Posts: 4,421
|
No error message any more, but attachments aren't showing.
|
|
|
|
|
|
February 27, 2004, 16:58
|
#8
|
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Jul 1999
Location: Gent, Belgium
Posts: 10,712
|
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','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:
|
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/newre...hreadid=109506
|
Any idea what's going on? 
__________________
Contraria sunt Complementa. -- Niels Bohr
Mods: SMAniaC (SMAC) & Planetfall (Civ4)
|
|
|
|
|
|
February 27, 2004, 17:00
|
#9
|
|
Apolyton CS Co-Founder
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
blah
|
|
|
|
|
|
February 27, 2004, 17:01
|
#10
|
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Jul 1999
Location: Gent, Belgium
Posts: 10,712
|
?
__________________
Contraria sunt Complementa. -- Niels Bohr
Mods: SMAniaC (SMAC) & Planetfall (Civ4)
|
|
|
|
|
|
February 27, 2004, 17:01
|
#11
|
|
Apolyton CS Co-Founder
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
changes where needed in the posts table as well..
|
|
|
|
|
|
February 27, 2004, 17:16
|
#12
|
|
Deity
Local Time: 14:29
Local Date: November 2, 2010
Join Date: Nov 2001
Location: Oviedo, Fl
Posts: 14,103
|
|
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?
|
|
|
|
|
|
February 27, 2004, 17:29
|
#13
|
|
Apolyton CS Co-Founder
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
it's not an issue if inactive users, this was about the attachments sql table
|
|
|
|
|
|
February 27, 2004, 22:42
|
#14
|
|
Deity
Local Time: 02:29
Local Date: November 3, 2010
Join Date: May 1999
Location: The City State of Noosphere, CPA special envoy
Posts: 14,606
|
Hosing the older attachments?
__________________
(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."
|
|
|
|
|
|
February 28, 2004, 01:02
|
#15
|
|
Apolyton CS Co-Founder
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
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
|
|
|
|
|
|
February 28, 2004, 02:33
|
#16
|
Local Time: 05:29
Local Date: November 3, 2010
Join Date: Aug 2001
Location: Skanky Father
Posts: 16,530
|
So what is the id column now?
__________________
I'm building a wagon! On some other part of the internets, obviously (but not that other site).
|
|
|
|
|
|
February 28, 2004, 02:54
|
#17
|
|
Apolyton CS Co-Founder
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Aug 1998
Location: Macedonia, Greece
Posts: 24,480
|
now it's an int(10)
should last a bit longer
|
|
|
|
|
|
February 28, 2004, 10:51
|
#18
|
|
Deity
Local Time: 02:29
Local Date: November 3, 2010
Join Date: May 1999
Location: The City State of Noosphere, CPA special envoy
Posts: 14,606
|
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?
__________________
(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."
|
|
|
|
|
|
March 1, 2004, 11:47
|
#19
|
|
King
Local Time: 18:29
Local Date: November 2, 2010
Join Date: Aug 1999
Location: Mill Valley
Posts: 2,887
|
|
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.
__________________
That's not the real world. Your job has little to do with the sort of thing most people do for a living. - Agathon
If social security were private, it would be prosecuted as a Ponzi scheme.
|
|
|
|
|
|
March 1, 2004, 12:43
|
#20
|
|
Deity
Local Time: 20:29
Local Date: November 2, 2010
Join Date: Sep 2001
Location: Republic of Flanders
Posts: 10,747
|
Then shouldn't int(5) be equal to 99999 instead of 65535 ?
Just wondering
__________________
#There’s a city in my mind
Come along and take that ride
And it’s all right, baby, it’s all right #
|
|
|
|
|
|
March 1, 2004, 13:53
|
#21
|
|
King
Local Time: 18:29
Local Date: November 2, 2010
Join Date: Aug 1999
Location: Mill Valley
Posts: 2,887
|
|
Quote:
|
Originally posted by alva
Then shouldn't int(5) be equal to 99999 instead of 65535 ?
Just wondering
|
Yes.
__________________
That's not the real world. Your job has little to do with the sort of thing most people do for a living. - Agathon
If social security were private, it would be prosecuted as a Ponzi scheme.
|
|
|
|
|
|
March 1, 2004, 23:40
|
#22
|
|
Deity
Local Time: 02:29
Local Date: November 3, 2010
Join Date: May 1999
Location: The City State of Noosphere, CPA special envoy
Posts: 14,606
|
|
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.
__________________
(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."
|
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
All times are GMT -4. The time now is 14:29.
|
|
