restoring access to catalog

[cscomputers]

Hi, I just screwed up I was in phpmyadmin part of my web host admin access to my OSCommerce website. The extension is /3rdparty/phpMyAdmin/index.php My database includes the reviews part of my websites home page. I wanted to get rid of the reviews section because we won't need it and it's taking up room where somthing else could go. So using the phpmyadmin gui program I deleted the reviews database. I thought great I finally figured out how to get rid of these sections on our website that we don't want like the front top part of the home page that says What's New. I want that to be removed too. But i guess thats not the right way to get rid of these sections because now when I go to our websites admin the catalog listing is gone. So how do I restore access to the catalog and remove the reviews and the what's new sections of our website?

 

 

Thanks Jim O

 

 

 

 

:(

[♥Vger]

Hope fully you took a backup of your database before editing it? If you didn't you're in trouble and will need to start again with a new default database and re-enter your products.

 

I would worry more about getting the database sorted out and less about removing features you don't like. That can be sorted later.

 

Vger

[cscomputers]

Hope fully you took a backup of your database before editing it? If you didn't you're in trouble and will need to start again with a new default database and re-enter your products.

 

I would worry more about getting the database sorted out and less about removing features you don't like. That can be sorted later.

 

Vger

 

 

Well they say the best way to learn is the hard way, so what do I need to do to start over?

 

 

 

Thanks Jim O

[Guest]

use the oscommerce.sql file which is in the install directory you should have locally, then using phpmyadmin you would insert that into your database.

 

then backup the database.

 

and do as Rhea stated, dont worry about the small stuff, you can sort it later, get it functioning properly, then as you go along you will find out all you had to do is comment out the call to reviews.php via a // in the column_right.php filee.

[cscomputers]

use the oscommerce.sql file which is in the install directory you should have locally, then using phpmyadmin you would insert that into your database.

 

then backup the database.

 

and do as Rhea stated, dont worry about the small stuff, you can sort it later, get it functioning properly, then as you go along you will find out all you had to do is comment out the call to reviews.php via a // in the column_right.php filee.

Thanks for your input, I am a network person not a web designer, so I need a more detailed step by step instructions on how to install this oscommerce.sql file into my database using phpmyadmin. Where do I put this file and how do I install this file?

 

 

Thanks Jim O :blink:

[Flyer5]

Thanks for your input, I am a network person not a web designer, so I need a more detailed step by step instructions on how to install this oscommerce.sql file into my database using phpmyadmin. Where do I put this file and how do I install this file?

Thanks Jim O :blink:

 

Hi

 

the easiest way is probably...

 

open the sql file in notepad

select all the contents

right click and copy them

go to phpmayadmin

select the sql tab

past your clipboard into the window

click the go button

 

I sometimes find if you use the "location of textfile" method and poibnt to the file it times out. maybe its my dodgy firewall, i dunno. :)