Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Format for Run a sql Query


readersbookcase

Recommended Posts

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

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.

Link to comment
Share on other sites

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...