Simple Machines Bug and Feature Tracker

My View | View Issues
  

Viewing Issue Simple Details [ Jump to Notes ] [ View Advanced ] [ Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000001 [SMF 1.1] tweak always 2006-08-29 14:57 2007-02-17 06:19
Reporter Ben_S View Status public  
Assigned To
Priority normal Resolution fixed  
Status closed  
Summary 0000001: Buddy list field is tinytext
Description Currently the field for buddylist in the members table is a tinytext field, on a large board with 5 digit member ID's this only lets a user select a low number of buddys before it stops working.

This could do with being a text field to stop it being so limited.
Additional Information
Tags No tags attached.
Attached Files

- Relationships

-  Notes
(0000001)
Thantos (Tester)
2006-08-29 16:37

 I don't see any reason why we can't make this change. Any objections?
(0000002)
akabugeyes (Team Member)
2006-08-29 17:35

 I think it makes sense. As what he said sounds true. If your buddies have ids with 5 or more digits, its going to fill up rather fast.
(0000006)
Thantos (Tester)
2006-08-30 13:29

 ! Changed the column type to allow for a larger buddy list. (upgrade_1-1.sql, install_1-1.sql)
(0000009)
user4
2006-08-31 01:41

 When applying the latest CVS (smf_1-1-cvs20060831_update)
I got the following error:

Adding more room for the buddy list
Unsuccessful!
This query:

    ALTER TABLE smf_members
    CHANGE buddy_list text NOT NULL;

Caused the error:

    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL' at line 2
(0000010)
akabugeyes (Team Member)
2006-08-31 10:12

 I think the query needs to be:

ALTER TABLE {$db_prefix}members
CHANGE buddy_list buddy_list text NOT NULL
(0000011)
Thantos (Tester)
2006-08-31 11:04

 Corrected with
CHANGE COLUMN buddy_list buddy_list text NOT NULL;
Mantis 1.1.8[^] Copyright © 2000 - 2008 Mantis Group