In Progress

OScommerce Site Error Correction

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 [url removed, login to view], 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

Skills: PHP

See more: work from home site, work from home for disabled, work from home disabled, when i come home from work, products manufacturers, manufacturers products, home instead, disabled work from home, oscommerce unknown column pproducts_id clause htaccess, site correction, what happen, text correction , pull-up, php fatal error, oscommerce help, on line shop, fatal, error, error php, correction, fatal error php, 1054 unknown column select, 1054 php, 1054 unknown, 1054

About the Employer:
( 10 reviews ) Prattville, United States

Project ID: #209985

Awarded to:

hautu

Thanks for the invitation. Let me fix it quickly for you. regards.

$30 USD in 0 days
(246 Reviews)
7.6

10 freelancers are bidding on average $35 for this job

cheapestandbest

OSCommerce certified programmers. I can finish this in 2 hours [url removed, login to view] after work is done.

$30 USD in 0 days
(574 Reviews)
8.7
value4u

Hi, please choose me right now. I will fix your bug in 1-2 hours :). Thanks you.

$30 USD in 0 days
(277 Reviews)
8.2
NickolaS

Hi, Charles, please, check your PM

$30 USD in 0 days
(329 Reviews)
7.5
pentium10

Professional work from professionals!

$30 USD in 0 days
(217 Reviews)
6.8
solutionD

Ready and excited.

$30 USD in 0 days
(54 Reviews)
6.2
rajinfosolu

Dear Sir I have 5+ years experience in php,mysql,smarty,oscommerce,ajax,javascript. Please view PM about my oscommerce projects. I will appreciate if you will provide this job to me. Regards Raj

$30 USD in 0 days
(48 Reviews)
6.2
wincent

can be done quickly, i have fixed some issues like this one.

$30 USD in 0 days
(79 Reviews)
6.0
ionix

Message in PM...

$50 USD in 0 days
(59 Reviews)
6.0
exitsol

Lets get started

$60 USD in 0 days
(107 Reviews)
5.8
sakwoya

Please see the pm - thank you

$30 USD in 1 day
(24 Reviews)
4.9