Table doesn't exist

[Snappy]

@Data

using your cms with skybird emu with plus emu db @Data

 

[Data]

-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records of cms_news
-- ----------------------------
INSERT INTO `cms_news` VALUES ('1', 'News Filler', 'Space here.', 'You can delete this when you have two or more articles', '1388886077', 'DE_Promo0508.png', '0', '', '1');
INSERT INTO `cms_news` VALUES ('2', 'RevCMS Habbo Theme Edit', 'This revcms theme was modified by Lewis/Lewislol.', 'This revcms theme was released by Lewis on devbest.', '1388886077', 'DE_Promo0508.png', '0', '', '1');

 

[Snappy]

-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records of cms_news
-- ----------------------------
INSERT INTO `cms_news` VALUES ('1', 'News Filler', 'Space here.', 'You can delete this when you have two or more articles', '1388886077', 'DE_Promo0508.png', '0', '', '1');
INSERT INTO `cms_news` VALUES ('2', 'RevCMS Habbo Theme Edit', 'This revcms theme was modified by Lewis/Lewislol.', 'This revcms theme was released by Lewis on devbest.', '1388886077', 'DE_Promo0508.png', '0', '', '1');

Thank you mate

 

[Snappy]

-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
DROP TABLE IF EXISTS `cms_news`;
CREATE TABLE `cms_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
`shortstory` text COLLATE latin1_general_ci,
`longstory` text COLLATE latin1_general_ci,
`published` int(10) NOT NULL DEFAULT '0',
`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
`campaign` int(1) NOT NULL DEFAULT '0',
`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,
`author` int(6) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records of cms_news
-- ----------------------------
INSERT INTO `cms_news` VALUES ('1', 'News Filler', 'Space here.', 'You can delete this when you have two or more articles', '1388886077', 'DE_Promo0508.png', '0', '', '1');
INSERT INTO `cms_news` VALUES ('2', 'RevCMS Habbo Theme Edit', 'This revcms theme was modified by Lewis/Lewislol.', 'This revcms theme was released by Lewis on devbest.', '1388886077', 'DE_Promo0508.png', '0', '', '1');

 

[Snappy]

 

[Data]

Can't you fix a simple error give it a value??
Oh and I am not helping you will so simple stuff this is a one off.

ALTER TABLE `users` MODIFY COLUMN `postion` int(11) NULL DEFAULT '1';

 

[Snappy]

Can't you fix a simple error give it a value??
Oh and I am not helping you will so simple stuff this is a one off.

Thanks mate I m a bit rusty on retros but thanks all if fixed!

 

[zFamerzGamerz]

Well done

 

[zFamerzGamerz]

Hope your hotel get successful

 

[zFamerzGamerz]

btw what EMU and CMS you on?

 

[zFamerzGamerz]

just wondering

 

[Snappy]

just wondering

Phoenix 3.11.0 RevCMS

 

[zFamerzGamerz]

oh nice. pop u for a chat?

 

[zFamerzGamerz]

yeh?