Replace:
PHP Code:
$query['new'][] = "CREATE TABLE `ticketreply` (
`replyid` int(10) unsigned NOT NULL auto_increment,
`ticketid` int(10) unsigned NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`pagetext` mediumtext NOT NULL,
`ipaddress` varchar(15) NOT NULL default '',
PRIMARY KEY (`replyid`),
KEY `userid` (`userid`),
KEY `threadid` (`ticketid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1";
$query['new'][] = "CREATE TABLE `ticket` (
`ticketid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`open` smallint(6) NOT NULL default '1',
`ownerid` int(10) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`postusername` varchar(50) NOT NULL default '',
`postuserid` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(50) NOT NULL default '',
`lastupdate` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ticketid`),
KEY `postuserid` (`postuserid`)
) TYPE=MyISAM AUTO_INCREMENT=1";
with:
PHP Code:
$query['new'][] = "CREATE TABLE `".TABLE_PREFIX."ticketreply` (
`replyid` int(10) unsigned NOT NULL auto_increment,
`ticketid` int(10) unsigned NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`pagetext` mediumtext NOT NULL,
`ipaddress` varchar(15) NOT NULL default '',
PRIMARY KEY (`replyid`),
KEY `userid` (`userid`),
KEY `threadid` (`ticketid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1";
$query['new'][] = "CREATE TABLE `".TABLE_PREFIX."ticket` (
`ticketid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`open` smallint(6) NOT NULL default '1',
`ownerid` int(10) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`postusername` varchar(50) NOT NULL default '',
`postuserid` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(50) NOT NULL default '',
`lastupdate` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ticketid`),
KEY `postuserid` (`postuserid`)
) TYPE=MyISAM AUTO_INCREMENT=1";
In the helpdesk_install.php .
Hope it helps.