New Server And New Problems

[healthstatus]

When I go to the admin page I get the error:

Fatal error: Cannot re-assign $this in /usr/local/www/vhosts/university.biz/htdocs/adminnimda/includes/classes/upload.php on line 31

 

which may be a permissions error but I can't seem to figure it out.

 

As a user,

When I drill down to a product I get the error:

 

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

 

both the products and the specials tables contain the field products_id

[Guest]

When I go to the admin page I get the error:

Fatal error: Cannot re-assign $this in /usr/local/www/vhosts/university.biz/htdocs/adminnimda/includes/classes/upload.php on line 31

 

which may be a permissions error but I can't seem to figure it out.

 

As a user,

When I drill down to a product I get the error:

 

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

 

both the products and the specials tables contain the field products_id

upgrade your store to the latest osC

http://www.oscommerce.com/solutions/downloads

[healthstatus]

upgrade your store to the latest osC

http://www.oscommerce.com/solutions/downloads

I downloaded that, but I don't see any instructions for upgrades, will my template and existing database remain in tact?

[Guest]

I downloaded that, but I don't see any instructions for upgrades, will my template and existing database remain in tact?

Have you read the included instructions to upgrade manually?

[healthstatus]

Have you read the included instructions to upgrade manually?

I don't see any manual upgrade instructions in the documentation.pdf file included in the tarball, am I looking in the wrong spot?

[Guest]

I am going to take a guess and say your new server is PHP5,

 

In upload.php change

 

// self destruct
$this = null;

 

to

 

// self destruct
// $this = null;
unset($this);

[healthstatus]

I am going to take a guess and say your new server is PHP5,

 

In upload.php change

 

// self destruct
$this = null;

 

to

 

// self destruct
// $this = null;
unset($this);

 

That took care of half the problem.

 

Apparently mySQL is now 5.0.41 which is a problem with the old code. So enigma1's recommendation to upgrade looks like that will take care of that if I can find the manual upgrade steps documentation somewhere.

[Guest]

There is a PHP5 contribution, look there first.

[Guest]

Sorry correction, there is a PHP5 / MSQL5 contribution.

[Guest]

I don't see any manual upgrade instructions in the documentation.pdf file included in the tarball, am I looking in the wrong spot?

look in the update-20060817.txt file.