Page 1 of 1
Create New Linkshell Error..
Posted: Sun Apr 06, 2014 1:17 pm
by tagban
When creating a new linkshell, get the message "The linkshell name you entered is already in use or otherwise unavailible. Please choose another name"
There are currently no linkshells on the server as its fairly newly installed/configured/setup. It might be something I did, but just wanted to mention it incase anyone else has the same issue?
Re: Create New Linkshell Error..
Posted: Sun Apr 06, 2014 1:41 pm
by atom0s
If you recently updated your source, I'd suggest looking at the sql changes closely.
Re: Create New Linkshell Error..
Posted: Sun Apr 06, 2014 1:58 pm
by tagban
Yea I updated today, but also imported all the sql stuff.
Re: Create New Linkshell Error..
Posted: Sun Apr 06, 2014 2:08 pm
by tagban
Got it! The issue is "BLOB" field for the LS message doesn't have a default value. When I right clicked/Design Table, and was able to set it to "Allow NULL", let me create the new Linkshell. That seems like something that should probably be adjusted for future updates though.
Re: Create New Linkshell Error..
Posted: Sun Apr 06, 2014 2:22 pm
by tagban
The table structure was wrong.
Code: Select all
CREATE TABLE `linkshells` (
`linkshellid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL DEFAULT '',
`color` smallint(5) unsigned NOT NULL DEFAULT '61440',
`poster` varchar(15) NOT NULL DEFAULT '',
`message` blob,
`messagetime` int(10) unsigned NOT NULL DEFAULT '0',
`postrights` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`linkshellid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
That fixed it for me.
- `message` varchar(115) NOT NULL DEFAULT '',
+ `message` BLOB NOT NULL,