Changing the Url links/paths in categories menu - Please help!

[happyfeetprod]

Okay im sooo frustrated and iv looked every where, ipower my hosting company decide to move to a new platform and its been a big mess since.

 

I have finally got most things done but I NEED TO KNOW how to change the url links in the catogories.. for example

 

If u go to my site and click on body you get an error which i kno whow to fix but i dont know how to edit the link to change its url/path http://ayurmedic90210.com//osCommerce/catalog/index.php go there click on body and you get an error that i will post at the buttom

 

so my question is, how can i change the links/url in my catogories i need to change the path from

 

http://ayurmedic90210.com//osCommerce/cata...b51eb318eefe913

 

and change it to http://host382.ipowerweb.com/~ayurmedi/osC...5340ee6c4dfac3e

 

see if you fallow that above link with the host382 it works, but if you change the host382 to ayurmedic90210 it gives an errror that i will post below.. anyway agian how do i change the url links in the categories section?

 

heres the error by the way

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '23'

 

[TEP STOP]

[happyfeetprod]

Can somebody help me find which file has the url to the catoegories section, so i can edit the urls/links? so i can change it.. pleeeeeeeeeeeease

[bkellum]

Can somebody help me find which file has the url to the catoegories section, so i can edit the urls/links? so i can change it.. pleeeeeeeeeeeease

 

The links in osCommerce are based on your settings in two configure.php files:

catalog/admin/includes/configure.php

catalog/includes/configure.php

 

If your site has been moved, then you need to make the necessary changes to your settings.

 

For example: If your catalog directory was once in the "myshop" folder, but now resides in your root folder,

You would need to change the setting for catalog from '/myshop/' to '/'

 

Take a look at your previous configure.php files that once worked and then make the changes.

 

Hope this helps,