readersbookcase Posted August 16, 2008 Share Posted August 16, 2008 I have been told of the Need to run Query for a new install Problems with syntax?? UPDATE 'os7.pages' SET showredirect = 'no' WHERE showredirect = 'yes'; OR Is that even close to what I need Error message: Page Editor 1146 - Table 'os7.pages' doesn't exist select p.pages_id, p.pages_name, p.pages_image, p.pages_status, p.sort_order, pd.pages_title from pages p, pages_description pd where p.pages_id = pd.pages_id and pd.language_id = '1' order by p.sort_order [TEP STOP] Link to comment Share on other sites More sharing options...
♥FWR Media Posted August 16, 2008 Share Posted August 16, 2008 I have been told of the Need to run Query for a new install Problems with syntax?? UPDATE 'os7.pages' SET showredirect = 'no' WHERE showredirect = 'yes'; OR Is that even close to what I need Error message: Page Editor 1146 - Table 'os7.pages' doesn't exist select p.pages_id, p.pages_name, p.pages_image, p.pages_status, p.sort_order, pd.pages_title from pages p, pages_description pd where p.pages_id = pd.pages_id and pd.language_id = '1' order by p.sort_order [TEP STOP] There should be an SQL install file that you need to run as the pages table currently does not exist. Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
readersbookcase Posted August 16, 2008 Author Share Posted August 16, 2008 There should be an SQL install file that you need to run as the pages table currently does not exist. Thanks Robert There is so much to figure out... There was pages.sql and I ran that query as CREATE TABLE `pages` ( `pages_id` int(11) NOT NULL auto_increment, `pages_name` varchar(32) NOT NULL default '', `pages_image` varchar(64) NOT NULL default '', `sort_order` int(3) NOT NULL default '0', `pages_status` tinyint(1) NOT NULL default '0', PRIMARY KEY (`pages_id`) ) TYPE=MyISAM ; #---------------------------- # Records for table pages #---------------------------- INSERT INTO `pages` VALUES (1, 'home', '', -100, 1); INSERT INTO `pages` VALUES (2, 'contact_us', '', -100, 1); INSERT INTO `pages` VALUES (3, 'shipping', '', 1, 1); INSERT INTO `pages` VALUES (4, 'conditions', '', 3, 1); INSERT INTO `pages` VALUES (5, 'privacy', '', 2, 1); #---------------------------- # Table structure for pages_description #---------------------------- CREATE TABLE `pages_description` ( `pages_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '0', `pages_title` varchar(255) NOT NULL default '', `pages_body` text NOT NULL, PRIMARY KEY (`pages_id`,`language_id`) ) TYPE=MyISAM ; #---------------------------- # Records for table pages_description #---------------------------- INSERT INTO `pages_description` VALUES (1, 1, 'Home Page', 'Place your home page text here...'); INSERT INTO `pages_description` VALUES (2, 1, 'Contact Us', 'Place your contact us text here...'); INSERT INTO `pages_description` VALUES (3, 1, 'Shipping & Returns', 'Place your shipping and returns text here...'); INSERT INTO `pages_description` VALUES (4, 1, 'Conditions of Use', 'Place your conditions of use text here...'); INSERT INTO `pages_description` VALUES (5, 1, 'Privacy Notice', 'Place your privacy notice text here...'); INSERT INTO `pages_description` VALUES (1, 2, 'Home Page', 'Fügen Sie hier Ihre home tekst ein.'); INSERT INTO `pages_description` VALUES (2, 2, 'Kontakt', 'Fügen Sie hier Ihre kontakt tekst ein.'); INSERT INTO `pages_description` VALUES (3, 2, 'Liefer- und Versandkosten', 'Fügen Sie hier Ihre Informationen über Liefer- und Versandkosten ein.'); INSERT INTO `pages_description` VALUES (4, 2, 'Unsere AGBs', 'Fügen Sie hier Ihre allgemeinen Geschäftsbedingungen ein.'); INSERT INTO `pages_description` VALUES (5, 2, 'Privatsphäre', 'Fügen Sie hier Ihre Informationen über Privatsphäre und Datenschutz ein.'); INSERT INTO `pages_description` VALUES (1, 4, 'Home Page', 'Vul hier uw eigen tekst in'); INSERT INTO `pages_description` VALUES (2, 4, 'Neem contact op', 'Vul hier uw eigen tekst in'); INSERT INTO `pages_description` VALUES (3, 4, 'Verzenden & Retouneren', 'Vul hier uw eigen tekst in'); INSERT INTO `pages_description` VALUES (4, 4, 'Algemene voorwaarden', 'Vul hier uw eigen tekst in'); INSERT INTO `pages_description` VALUES (5, 4, 'Privacy verklaring', 'Vul hier uw eigen tekst in'); Pages were created But now ERROR is 146 - Table 'os7.pages_description' doesn't exist select p.pages_id, p.pages_name, p.pages_image, p.pages_status, p.sort_order, pd.pages_title from pages p, pages_description pd where p.pages_id = pd.pages_id and pd.language_id = '1' order by p.sort_order [TEP STOP] I didn't want to attempt to add page description to the above for the Query but rather to work on them later. Since the pages are created how do I run a successful query to create pages_description. Link to comment Share on other sites More sharing options...
readersbookcase Posted August 16, 2008 Author Share Posted August 16, 2008 I was able to use the syntax above by just eliminating the parts with ---------------------- So it may be solved Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.