Upload component - Failed
SQL Error DB function failed with error number 1064
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 'tynint(3) NOT NULL, PRIMARY KEY (`id`) )' at line 19 SQL=CREATE TABLE IF NOT EXISTS `jos_casino_games` ( `id` mediumint(5) NOT NULL auto_increment, `gamename` varchar(100) NOT NULL, `title` varchar(100) NOT NULL, `height` mediumint(4) NOT NULL default '400', `width` mediumint(4) NOT NULL default '500', `description` mediumtext NOT NULL, `numplayed` int(11) NOT NULL default '0', `imagename` varchar(100) NOT NULL, `filename` varchar(100) NOT NULL, `published` tinyint(1) NOT NULL default '0', `catid` tinyint(3) default NULL, `time_played` bigint(20) NOT NULL default '0', `totalwon` bigint(20) NOT NULL default '0', `totallost` bigint(20) NOT NULL default '0', `maxbuyin` mediumint(4) NOT NULL, `creditvar` char(20) NOT NULL default 'Credits', `winlimit` mediumint(6) NOT NULL, `payoutdeduction` tynint(3) NOT NULL, PRIMARY KEY (`id`) );
SQL =
CREATE TABLE IF NOT EXISTS `jos_casino_games` (
`id` mediumint(5) NOT NULL auto_increment,
`gamename` varchar(100) NOT NULL,
`title` varchar(100) NOT NULL,
`height` mediumint(4) NOT NULL default '400',
`width` mediumint(4) NOT NULL default '500',
`description` mediumtext NOT NULL,
`numplayed` int(11) NOT NULL default '0',
`imagename` varchar(100) NOT NULL,
`filename` varchar(100) NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`catid` tinyint(3) default NULL,
`time_played` bigint(20) NOT NULL default '0',
`totalwon` bigint(20) NOT NULL default '0',
`totallost` bigint(20) NOT NULL default '0',
`maxbuyin` mediumint(4) NOT NULL,
`creditvar` char(20) NOT NULL default 'Credits',
`winlimit` mediumint(6) NOT NULL,
`payoutdeduction` tynint(3) NOT NULL,
PRIMARY KEY (`id`)
);
Problem:
`payoutdeduction` tynint(3) NOT NULL,
FIX:
`payoutdeduction` tinyint(3) NOT NULL,
in both casino.xml and casino.j15.xml
Forum
