Reply to thread

Message

<blockquote data-quote="Ecko1223" data-source="post: 294747" data-attributes="member: 28896">The issue is there, &quot;table r64b.cms_news doesn't exist&quot; since the php can't find the table on your database, it brings the page up as an error. A normal phoenix database has this normally, but if you're using a different emulator, here's what to add into your database.P.S, You're on my hotel, it's Joe from habcast[CODE]/*MySQL BackupSource Server Version: 5.6.19Source Database: poppy123Date: 7/17/2014 15:56:58*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------&nbsp; Table structure for `cms_news`-- ----------------------------DROP TABLE IF EXISTS `cms_news`;CREATE TABLE `cms_news` (&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp; `title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,&nbsp; `shortstory` text COLLATE latin1_general_ci,&nbsp; `longstory` text COLLATE latin1_general_ci,&nbsp; `published` int(11) NOT NULL,&nbsp; `image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',&nbsp; `campaign` int(1) NOT NULL DEFAULT '0',&nbsp; `campaignimg` varchar(255) COLLATE latin1_general_ci DEFAULT '',&nbsp; `author` text COLLATE latin1_general_ci,&nbsp; PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=252 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;[/CODE]</blockquote>

[QUOTE="Ecko1223, post: 294747, member: 28896"] The issue is there, "table r64b.cms_news doesn't exist" since the php can't find the table on your database, it brings the page up as an error. A normal phoenix database has this normally, but if you're using a different emulator, here's what to add into your database. [B]P.S, You're on my hotel, it's Joe from habcast[/B] [CODE]/* MySQL Backup Source Server Version: 5.6.19 Source Database: poppy123 Date: 7/17/2014 15:56:58 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- 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(11) NOT NULL, `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 DEFAULT '', `author` text COLLATE latin1_general_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=252 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; [/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members