Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database -Help


yulises

Recommended Posts

Hello ,

On the contrubution "Meta Tags on the fly " there is a file called sql.txt it said that :Copy the contents of the sql.txt file and run the query on your database.

Please if any one can help me how to do it .

 

Thank you in advance

Link to comment
Share on other sites

For managing databases most hosting providers offer a tool called phpmyadmin to their customers through their control panel.

Hello

I know this , but , can you pls explain me step by step how do do this :

INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` )

VALUES (

'40', 'Meta Tags', 'Default Keyword and Description Tags', '40', '1'

);

 

INSERT INTO `configuration` ( `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `date_added` )

VALUES (

'' 'Default Keyword ', 'KEYWORD_TAG', 'Add your Keywords', 'These keywords will display in the meta tag on your main index page and all non-product pages. Seperate words with commas.', '40', '1', now()

);

 

INSERT INTO `configuration` (`configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `date_added` )

VALUES (

 

Thank you

Nimrod

Link to comment
Share on other sites

Hello

I know this , but , can you pls explain me step by step how do do this :

INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` )

VALUES (

'40', 'Meta Tags', 'Default Keyword and Description Tags', '40', '1'

);

 

INSERT INTO `configuration` ( `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `date_added` )

VALUES (

'' 'Default Keyword ', 'KEYWORD_TAG', 'Add your Keywords', 'These keywords will display in the meta tag on your main index page and all non-product pages. Seperate words with commas.', '40', '1', now()

);

 

INSERT INTO `configuration` (`configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `date_added` )

VALUES (

 

Thank you

Nimrod

Link to comment
Share on other sites

Sorry, my reply didn't load completely.

 

Go to your cpanel (your host will help if you are unsure. Click on something like MySQL databases. The on phpMyAdmin. Then on a button that says SQL. Paste your code into that and click on the GO button. That should be it and your database is updated. Backup first though!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...