Data base error $ banner dont shows up

[SeNsiR]

Everytime I click on the subcategories like "cd rom" or "graphic cards" is always shown this 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 = '4'

 

[TEP STOP]

 

 

you can see the print over here --> http://free.7host07.com/enfim/oscommerce/error.JPG

 

 

 

--------------------- ---------------------------------------------------- ----------------------------------------------

 

And the other problem is that the banner doesnt shows up :S It says active...but it doesn't shows up...I've checked the path and the sheluded date....it's everything alright...but the banner doesnt shows up :(

[♥Monika in Germany]

Hi,

 

I'm pretty sure you are using mysql5 and are experiencing the issues to to stricter queries. Dowload the updrage file from the original osC version Nov13 and it will have the updates you need to make. Your specials table has to be positioned directly after the products tale with no commas.

 

here is an excerpt of the upgrade file.

------------------------------------------------------------------------------

MySQL 5.0 Compatibility

------------------------------------------------------------------------------

 

Problem:

 

MySQL 5.0 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries. This is performed by default with setting STRICT_TRANS_TABLES as a Server SQL mode.

 

Due to this new setting, MySQL fails on certain SQL queries and produces error messages on the screen.

.............

[change] to:

to:

 

$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id";

[SeNsiR]

Dowload the updrage file from the original osC version Nov13 and it will have the updates you need to make.

 

Hi

 

where can I download the upgrade file?

 

and thx for the help =)

[♥Monika in Germany]

Hi

 

where can I download the upgrade file?

 

and thx for the help =)

 

http://www.oscommerce.com/solutions/downloads has the whole new version and the upgrades. I attach the single file also.

[SeNsiR]

sorry =( but I have one error more

 

 

1062 - Duplicate entry '2-17' for key 1

 

insert into products_to_categories (products_id, categories_id) values ('2', '17')

 

 

what should I do? could you tell me if you don't minda =( I'm nwbie in SQL :blush: :(

 

thx again

[SeNsiR]

sorry =( but I have one error more

1062 - Duplicate entry '2-17' for key 1

 

insert into products_to_categories (products_id, categories_id) values ('2', '17')

what should I do? could you tell me if you don't minda =( I'm nwbie in SQL :blush: :(

 

thx again

 

 

I forgot to say that I have that error when i'm insrting a new product =(