Help! My store is broken and I don't know how to fix it

[kylor12]

Problem 1:

 

On 6/28 I entered admin area, added some new products and deleted some discontinued items. Exited admin, checked to make sure new products showed up in search and everything was fine. I then made a backup.

 

Now when I try to go to admin, the box pops up for password, then the next screen I see says only:

 

Fatal error: Cannot re-assign $this in /home/kylor12/public_html/admin/includes/classes/upload.php on line 31

 

Line 31 of that file simply says:

 

$this = null;

 

The time/date stamp on the file is over a year old, indicating that it hasn't been altered recently. I have no idea what any of that means since php is foreign to me.

 

I did a 'restore from backup' function in cpanel using the backup I made in June, but the error is still there.

 

Problem 2:

 

The main page of the store (www.kylorsales.com) loads normally with 4 featured products on the right. Clicking on any of the product categories on the left should show a page of the products in that category, but instead, the right side shows the message:

 

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 = '2257'

 

[TEP STOP]

The number at the end changes depending on which category is clicked.

 

My store is dead in the water and I have no clue how to rescue it. Can anyone tell me how to fix it?

 

Thanks for reading this,

Kylor12

[spax]

Your host has upgraded to PHP5 and MySQL5 so your older files need updating. This will get you working again but search for further updates on here or download the latest version which has a text file with all updates prior to RC2. You don't have to go as far as updating to RC2 if you don't want to.

 

http://www.oscommerce.com/ext/update-20051113.html

[kylor12]

Wow, what a fast reply. Thank you. I've edited those files and problem 2 is solved! Did I say THANK YOU!

 

(At the bottom, it said to perform 3 SQL queries, but I don't know what that means, but the categories work again.)

 

Problem 1 is still a problem, I can't get into the admin area.

 

Kylor12

[kylor12]

Oops, I got in too much of a hurry and skipped over the solution to Problem 1. It was there and it worked.

 

Everything is now in good working order, I think.

 

It's past my bedtime.

 

Thanks again for great information.

 

Kylor12

[spax]

You are welcome!

 

Make the other updates from that link also, the ones that didn't directly apply to your 2 problems. There were some security issues addressed in there, as well as in a later update - Update 060817