bugHomesite Maker, the websites factory - Bugs: bug #16724, The limit for tinyint datatype in...

 
 

bug #16724: The limit for tinyint datatype in some primary keys has been reached and results to be insufficient

Submitted by:  Marcos Martínez Jiménez <melmak>
Submitted on:  Thu 01 Jun 2006 08:28:04 PM UTC  
 
Category: NoneSeverity: 4 - Important
Item Group: NoneStatus: Fixed
Privacy: PublicAssigned to: Marcos Martínez Jiménez <melmak>
Open/Closed: Closed

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

Tue 20 Jun 2006 09:40:42 PM UTC, comment #1:

The following changes has been done in the database:

ALTER TABLE album MODIFY id_album MEDIUMINT unsigned NOT NULL auto_increment;
ALTER TABLE album MODIFY id_author MEDIUMINT unsigned NOT NULL;

ALTER TABLE album_allow_to_add_list MODIFY id_album MEDIUMINT unsigned NOT NULL default '0';
ALTER TABLE album_allow_to_add_list MODIFY id_user MEDIUMINT unsigned NOT NULL auto_increment;

ALTER TABLE album_allow_to_see_list MODIFY id_album MEDIUMINT unsigned NOT NULL default '0';
ALTER TABLE album_allow_to_see_list MODIFY id_user MEDIUMINT unsigned NOT NULL auto_increment;

ALTER TABLE comment MODIFY id_comment SMALLINT unsigned NOT NULL auto_increment;
ALTER TABLE comment MODIFY id_info MEDIUMINT unsigned default NULL;
ALTER TABLE comment MODIFY id_author MEDIUMINT unsigned default NULL;
ALTER TABLE comment MODIFY father_comment SMALLINT unsigned default NULL;

ALTER TABLE diary MODIFY id_diary MEDIUMINT unsigned NOT NULL auto_increment;
ALTER TABLE diary MODIFY id_author MEDIUMINT unsigned default NULL;

ALTER TABLE info MODIFY id_info MEDIUMINT unsigned NOT NULL auto_increment;
ALTER TABLE info MODIFY id_author MEDIUMINT unsigned default NULL;

ALTER TABLE info_album MODIFY id_info MEDIUMINT unsigned NOT NULL default '0';

ALTER TABLE photo_album MODIFY id_album MEDIUMINT unsigned NOT NULL default '0';
ALTER TABLE photo_album MODIFY id_author MEDIUMINT unsigned NOT NULL default '0';

ALTER TABLE users MODIFY id_user MEDIUMINT unsigned NOT NULL auto_increment;

Marcos Martínez Jiménez <melmak>
Project AdministratorIn charge of this item.
Thu 01 Jun 2006 08:28:04 PM UTC, original submission:

The datatype (tinyint) of the primary keys in some tables of the database may have a small range to hold the required entries.
Some tables, such as the 'comments', allow only up to 255 entries.
One website that is in production using homesitemaker, advise me to increase this value because it has been overflowed recently.

Marcos Martínez Jiménez <melmak>
Project AdministratorIn charge of this item.

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Tue 20 Jun 2006 09:41:54 PM UTCmelmakOpen/ClosedOpen=>Closed
Tue 20 Jun 2006 09:40:42 PM UTCmelmakStatusIn Progress=>Fixed
Thu 15 Jun 2006 04:25:33 PM UTCmelmakStatusNone=>In Progress

Back to the top


Powered by Savane 3.1-cleanup1