Hey just need a bit of help. I am able to import the sql file into my database I get this error -
[Err] 1054 - Unknown column 'roomid' in 'field list'
[Err] CREATE TABLE IF NOT EXISTS `bans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bantype` enum('user','ip') NOT NULL DEFAULT 'user',
`value` varchar(50) NOT NULL,
`reason` text NOT NULL,
`expire` double NOT NULL DEFAULT '0',
`added_by` varchar(50) NOT NULL,
`added_date` varchar(50) NOT NULL,
`appeal_state` enum('0','1','2') NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
CREATE TABLE IF NOT EXISTS `client_crashes` (
`id` int(250) NOT NULL AUTO_INCREMENT,
`error_cat` varchar(250) NOT NULL,
`debug` text NOT NULL,
`error_desc` text NOT NULL,
`system` text NOT NULL,
`port` varchar(250) NOT NULL,
`last_room` varchar(250) NOT NULL,
`crash_time` varchar(250) NOT NULL,
`agent` text NOT NULL,
`error_ctx` varchar(250) NOT NULL,
`flash_version` varchar(250) NOT NULL,
`in_room` varchar(250) NOT NULL,
`avg_update` varchar(250) NOT NULL,
`host` varchar(250) NOT NULL,
`start_time` varchar(250) NOT NULL,
`is_fatal` varchar(250) NOT NULL,
`player_ip` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;
CREATE TABLE IF NOT EXISTS `client_messages` (
`id` int(250) NOT NULL AUTO_INCREMENT,
`by_username` varchar(250) NOT NULL DEFAULT 'unknown',
`text` text NOT NULL,
`enable` enum('yes','no') NOT NULL DEFAULT 'yes',
`code` varchar(10) NOT NULL DEFAULT '0000000000',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
CREATE TABLE IF NOT EXISTS `cms_alerts` (
`id` int(250) NOT NULL AUTO_INCREMENT,
`sent_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`sent_by` varchar(250) NOT NULL,
`sort` varchar(250) NOT NULL,
`message` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
CREATE TABLE IF NOT EXISTS `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`image` varchar(100) NOT NULL,
`shortstory` text NOT NULL,
`longstory` text NOT NULL,
`author` varchar(100) NOT NULL,
`date` int(11) NOT NULL,
`type` varchar(100) NOT NULL,
`roomid` varchar(100) NOT NULL,
`updated` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
INSERT INTO `cms_news` (`id`, `title`, `image`, `shortstory`, `longstory`, `author`, `date`, `type`, `roomid`, `updated`) VALUES
(5, 'Iplace CMS', '%hotel_url%/images/web_promo/133707798066703.png', 'Welcome to Iplace CMS!', 'Welcome to Iplace CMS! Powered by Jasler.nl.<br />\r\n<br />\r\nAny questions or ideas for this CMS? Tell Jasler (<a href="http://jasler.nl">Jasler.nl</a>) about it!<br />\r\n<br />\r\nGreets,<br />\r\nJasper Vriends<br />\r\n<span style="font-size:11px">(Maker of this CMS AND owner Jasler.nl)</span>', '', 1386276213, 'news', '0', '0'),
(6, 'Iplace CMS', '%hotel_url%/images/web_promo/133707798066703.png', 'Welcome to the new CMS of Iplace! Powered by Jasler.nl', 'New updates:\r\n<ul>\r\n<li>Group add</li>\r\n<li>Group page edit</li>\r\n<li>Group badge edit online</li>\r\n<li>Group badge edit online</li>\r\n<li>Top menu change</li>\r\n<li>News reactions</li>\r\n<li>News reactions delete</li>\r\n</ul>\r\nMade by Jasler.nl', '', 1387125423, 'news', '0', '1');
CREATE TABLE IF NOT EXISTS `cms_news_reactions` (
`id` int(250) NOT NULL AUTO_INCREMENT,
`userId` int(250) NOT NULL,
`articleId` int(250) NOT NULL,
`ups` int(50) NOT NULL,
`downs` int(50) NOT NULL,
`time` varchar(250) NOT NULL,
`text` text NOT NULL,
`reported` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
CREATE TABLE IF NOT EXISTS `groups` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(50) NOT NULL,
`OwnerId` int(11) NOT NULL,
`OwnerName` varchar(50) NOT NULL,
`Description` text NOT NULL,
`RoomId` int(11) NOT NULL,
`Image` text NOT NULL,
`CustomColor1` int(11) NOT NUL
[Err] 1146 - Table 'r63b.site_shop_items' doesn't exist
[Err] --
-- Gegevens worden uitgevoerd voor tabel `site_shop_items`
--
INSERT INTO `site_shop_items` (`id`, `price`, `skin`, `type`, `categoryId`, `amount`, `ItemName`, `ItemPack`, `ItemsContent`) VALUES
(1460, 1, 's_stickers_uruguay', 'Sticker', 66, 0, '', 0, ''),
(1462, 1, 's_stickers_peru', 'Sticker', 66, 0, '', 0, ''),
(1456, 1, 's_stickers_paraguay', 'Sticker', 66, 0, '', 0, ''),
(1459, 1, 's_stickers_panama', 'Sticker', 66, 0, '', 0, ''),
(1454, 1, 's_stickers_nicaragua', 'Sticker', 66, 0, '', 0, ''),
(1465, 1, 's_stickers_mexico', 'Sticker', 66, 0, '', 0, ''),
(1455, 1, 's_stickers_honduras', 'Sticker', 66, 0, '', 0, ''),
(1452, 1, 's_stickers_espain', 'Sticker', 66, 0, '', 0, ''),
(1453, 1, 's_stickers_elsalvador', 'Sticker', 66, 0, '', 0, ''),
(1461, 1, 's_stickers_ecuador', 'Sticker', 66, 0, '', 0, ''),
(1458, 1, 's_stickers_costarica', 'Sticker', 66, 0, '', 0, ''),
(1464, 1, 's_stickers_colombia', 'Sticker', 66, 0, '', 0, ''),
(1467, 1, 's_stickers_chile', 'Sticker', 66, 0, '', 0, ''),
(1457, 1, 's_stickers_bolivia', 'Sticker', 66, 0, '', 0, ''),
(1466, 1, 's_stickers_argentina', 'Sticker', 66, 0, '', 0, ''),
(1463, 1, 's_stickers_venezuela', 'Sticker', 66, 0, '', 0, ''),
(303, 1, 's_trax_sfx', 'Sticker', 27, 0, 'Trax Sonidos fx', 0, ''),
(307, 1, 's_trax_disco', 'Sticker', 27, 0, 'Trax Disco', 0, ''),
(300, 1, 's_trax_8_bit', 'Sticker', 27, 0, 'Trax Habbo', 0, ''),
(305, 1, 's_trax_electro', 'Sticker', 27, 0, 'Trax Electr�nica', 0, ''),
(304, 1, 's_trax_reggae', 'Sticker', 27, 0, 'Trax Reggae', 0, ''),
(301, 1, 's_trax_ambient', 'Sticker', 27, 0, 'Trax Ambiente', 0, ''),
(302, 1, 's_trax_bling', 'Sticker', 27, 0, 'Trax Bling', 0, ''),
(306, 1, 's_trax_heavy', 'Sticker', 27, 0, 'Trax Heavy', 0, ''),
(308, 1, 's_trax_latin', 'Sticker', 27, 0, 'Trax Latina', 0, ''),
(651, 1, 's_trax_rock', 'Sticker', 27, 0, 'Trax Rock', 0, ''),
(530, 1, 's_a', 'Sticker', 29, 0, 'A', 0, ''),
(539, 1, 's_b_2', 'Sticker', 29, 0, 'B', 0, ''),
(540, 1, 's_c', 'Sticker', 29, 0, 'C', 0, ''),
(552, 1, 's_d', 'Sticker', 29, 0, 'D', 0, ''),
(556, 1, 's_e', 'Sticker', 29, 0, 'E', 0, ''),
(568, 1, 's_f', 'Sticker', 29, 0, 'F', 0, ''),
(569, 1, 's_g', 'Sticker', 29, 0, 'G', 0, ''),
(573, 1, 's_h', 'Sticker', 29, 0, 'H', 0, ''),
(574, 1, 's_i', 'Sticker', 29, 0, 'I', 0, ''),
(576, 1, 's_j', 'Sticker', 29, 0, 'J', 0, ''),
(577, 1, 's_k', 'Sticker', 29, 0, 'K', 0, ''),
(578, 1, 's_l', 'Sticker', 29, 0, 'L', 0, ''),
(584, 1, 's_m', 'Sticker', 29, 0, 'M', 0, ''),
(585, 1, 's_n', 'Sticker', 29, 0, 'N', 0, ''),
(595, 1, 's_o', 'Sticker', 29, 0, 'O', 0, ''),
(597, 1, 's_p', 'Sticker', 29, 0, 'P', 0, ''),
(603, 1, 's_q', 'Sticker', 29, 0, 'Q', 0, ''),
(604, 1, 's_r', 'Sticker', 29, 0, 'R', 0, ''),
(606, 1, 's_s', 'Sticker', 29, 0, 'S', 0, ''),
(650, 1, 's_t', 'Sticker', 29, 0, 'T', 0, ''),
(652, 1, 's_u', 'Sticker', 29, 0, 'U', 0, ''),
(655, 1, 's_v', 'Sticker', 29, 0, 'V', 0, ''),
(677, 1, 's_w', 'Sticker', 29, 0, 'W', 0, ''),
(679, 1, 's_x', 'Sticker', 29, 0, 'X', 0, ''),
(690, 1, 's_y', 'Sticker', 29, 0, 'Y', 0, ''),
(691, 1, 's_z', 'Sticker', 29, 0, 'Z', 0, ''),
(533, 1, 's_a_with_circle', 'Sticker', 29, 0, 'A', 0, ''),
(534, 1, 's_a_with_dots', 'Sticker', 29, 0, 'A', 0, ''),
(596, 1, 's_o_with_dots', 'Sticker', 29, 0, 'O', 0, ''),
(554, 1, 's_dot', 'Sticker', 29, 0, 'Punto', 0, ''),
(531, 1, 's_acsent1', 'Sticker', 29, 0, 'Ap�strofe', 0, ''),
(532, 1, 's_acsent2', 'Sticker', 29, 0, 'Tilde', 0, ''),
(654, 1, 's_underscore', 'Sticker', 29, 0, 'Gui�n', 0, ''),
(137, 1, 's_bling_star', 'Sticker', 30, 0, 'Estrella Bling', 0, ''),
(107, 1, 's_bling_a', 'Sticker', 30, 0, 'A Bling', 0, ''),
(108, 1, 's_bling_b', 'Sticker', 30, 0, 'B Bling', 0, ''),
(109, 1, 's_bling_c', 'Sticker', 30, 0, 'C Bling', 0, ''),
(110, 1, 's_bling_d', 'Sticker', 30, 0, 'D Bling', 0, ''),
(111, 1, 's_bling_e', 'Sticker', 30, 0, 'E Bling', 0, ''),
(112, 1, 's_bling_f', 'Sticker', 30, 0, 'F Bling', 0, ''),
(113, 1, 's_bling_g', 'Sticker', 30, 0, 'G Bling', 0, ''),
(114, 1, 's_bling_h', 'Sticker', 30, 0, 'H B
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Im assuming this is why i cant register,
thank for your help in advance.
Jon