OScommerce Site Error Correction

OScommerce Site Error Correction is project number 209985 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider hautu)

Status:	Closed
Budget:	$30-100
Created:	01/04/2008 at 9:57 EST
Bidding Ends:	01/09/2008 at 9:57 EST
Project Creator:	charleshall   Buyer Rating: (9 reviews)
Description:	For Hautu Only Please..... I recently noticed that my site wouldn't pull up but instead would show the following error: "FATAL ERROR: register_globals is disabled in php.ini, please enable it!" I'm not sure why this happened because I had not done any work on the site lately to break it. I contacted my host provider and they told me to make a file called "php.ini" and to put a line of text in it "register_globals = On" And then they said to put another line of text in the "/public_html/.htaccess file as follows: "suPHP_ConfigPath /home/ameri23/public_html" Now my site does come up but the product pages (when you click on the shop by catagory) will not come up but instead show something like this: "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 = '42' [TEP STOP]" I would like also like to know what happend to make this take place. And if something can be done to help it not to happen in the future. Please Help, Charles
Job Type:	PHP
Database:	MS SQL
Operating system:	Linux
Bid count:	11
Average bid:	$ 35