Create New Linkshell Error..

[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?

[atom0s]

If you recently updated your source, I'd suggest looking at the sql changes closely.

[tagban]

Yea I updated today, but also imported all the sql stuff.

[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.

[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,