There is no column named 'gp' (also 'pap') in the XML file.
Code:
- <installcode>
- <![CDATA[
$vbulletin->db->hide_errors();
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "pprmComments` (
`cID` int(11) NOT NULL auto_increment,
`prID` int(11) NOT NULL,
`uID` int(11) NOT NULL,
`comment` longtext NOT NULL,
`commenttime` int(11) NOT NULL,
`commentstatus` mediumtext NOT NULL,
PRIMARY KEY (`cID`)
)");
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "pprmOptions` (
`fieldname` char(20) NOT NULL,
`value` tinyint(4) NOT NULL,
PRIMARY KEY (`fieldname`)
)");
$vbulletin->db->query_write("INSERT INTO `" . TABLE_PREFIX . "pprmOptions` (`fieldname`, `value`) VALUES
('usepermissions', 0),
('e-mail', 0)");
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "pprmReports` (
`prID` int(11) NOT NULL auto_increment,
`type` varchar(255) NOT NULL,
`status` varchar(255) NOT NULL,
`posterID` int(11) NOT NULL,
`reporterID` int(11) NOT NULL,
`post-picture` int(11) NOT NULL,
`thread-album-profile` int(11) NOT NULL,
`forum-group` varchar(255) NOT NULL,
`reason` longtext NOT NULL,
`url` longtext NOT NULL,
`content` longtext NOT NULL,
`discussionID` int(11) NOT NULL,
`reporttime` int(11) NOT NULL,
`closedtime` int(11) NOT NULL,
PRIMARY KEY (`prID`)
)");
]]>
</installcode>