Crazy_Land1 wrote:still get this error while trying to install
....
Crazy, note that I can copie the SQL
you stated above, and drop it in phpmyadmin - it will add the record to the table roster_addon without any troubles.
The error being mentioned isn't ok : wrnet_id can be anything, even an empty string (your case) will be accepted - it will default to 0, as many addons have this value.
Even when wrnet_id isn't defined in the installer (in install.def.php : class armorysyncInstall) the the value thrown in the database table will default to 0.
This doesn't seem an armorysync error to me.
Check the structure of your table roster_addon :
- Code: Select all
CREATE TABLE IF NOT EXISTS `roster_addon` (
`addon_id` int(11) NOT NULL auto_increment,
`basename` varchar(16) NOT NULL default '',
`version` varchar(16) NOT NULL default '0',
`active` int(1) NOT NULL default '1',
`access` int(1) NOT NULL default '0',
`fullname` tinytext NOT NULL,
`description` mediumtext NOT NULL,
`credits` mediumtext NOT NULL,
`icon` varchar(64) NOT NULL default '',
`wrnet_id` int(4) NOT NULL default '0',
`versioncache` tinytext,
PRIMARY KEY (`addon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=155 ;