Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Admin Error


proman2008

Recommended Posts

Posted

I try to install template which I bought from Templatemonster.com

 

but there are a huge errors

 

1. I can not access in admin panel - even I can no see where is amdin username and passwrod?

 

this is a first error

 

 

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

 

what the heck I need to do ?

Posted

here is a second error - when I am tryting to press on category

 

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

 

[TEP STOP]

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

simply download the original oscommerce and using the WinMerge utility compare the code.

 

 

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

 

[TEP STOP]

try this contribution:

http://www.oscommerce.com/community/contributions,4654

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Posted

What kind of CHMOD I need to set for this error?

 

Warning: I am able to write to the configuration file: /home/kkurdadz/public_html/pizza/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.

Posted
here is a second error - when I am tryting to press on category

 

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

 

[TEP STOP]

Alex above has made some good suggestions. The cause of the problem is that you are tyring to install "older" code onto a "newer" version of osCommerce as well as uploading code that includes non-compatible MySQL 5 queries and your server is running MySQL 5.

 

Both situations can be resolved by reinstalling osC and then merging in the differences of the template.

 

:thumbsup: I think a better solution would be to install the Simple Template System that would allow you to easily merge in the "design" of the purchased template into "any" version of osC without destroying the functions of the newer osC version such as what you did with the newer Admin login functions.

 

Here is a step by step on how to do the above using STS:

 

http://www.oscommerce.com/forums/index.php?sho...p;#entry1156100

 

Hope you found this useful,

Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Posted

bkellum

 

I read this post - from top to end - the MT got a serious problem - :(

 

thanks a lot for providing interesting link

Posted
bkellum

 

I read this post - from top to end - the MT got a serious problem - :(

 

thanks a lot for providing interesting link

Now you just need to act on the advice and TM templates are not supported here.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...