edit specials.php gives error

[shirley]

1052 - Column 'products_id' in from clause is ambiguous

select p.products_id, pd.products_name, IF(pg.customers_group_price IS NOT NULL, pg.customers_group_price, p.products_price) as products_price, s.specials_new_products_price, s.expires_date, s.customers_group_id from products p, products_description pd, specials s LEFT JOIN products_groups pg using (products_id, customers_group_id) where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id and s.specials_id = '3'

when I press edit on the specials page for a product, this error occurs.
Looked everywhere and found no answer. I created the specials product from a dropdown product. I can delete the special and add it back but I do not like giving this code to my customer. Any similars?
any fixes?
Additional warning on admin screen "Warning: Division by zero in /mnt/w0209/d46/s24/b026add5/www/store/catalog/admin/specials.php on line 331"

[jpf]

Simple solution - Restore file.

What did you edit? You make an error.

Search for

Get Them While They\'re Hot!

[shirley]

Specials : Glenda Cason Gallery
Above link shows my specials page with the heading changed. I am familiar with the escape character.

The price change used '.' for the decimal (tried it several ways tho).
I have not touched the admin/specials.php file but reloaded it anyway as per your suggestion. I believe the edit page is re-established from the database once I press edit. line 332 price is the error location so what is wrong with the special price I put in? It will not create the correct record to be edited?

I don't do sql or much php but I can read a logic statement. I can delete the price change and re-enter it - works fine. So create is different from edit. Can you look at it again? and does your edit work fine? Maybe I need to download the oscmax files again. I am using the latest version. Also, I just looked at my Easy Populate and the record is there.

[jpf]

Not sure what you mean by

The price change used '.' for the decimal (tried it several ways tho).

I see no issues with your site specials.

Please explain what your tiring to do and what you want to accomplish.

[shirley]

"The change used '.' for the decimal (tried it several ways tho)."
Oh, this was documented one of the specials.php about entering periods and apostrophes. Not necessary though. Forget it.
All I tried to do was enter a product special price.
Then I pressed the EDIT button and the SQL message above appeared.
It looks like the program tried to divide by zero when it was bringing up the price change record again. That's all.I tried this with several products but none worked when I went to edit. I have to delete the price change and re enter it.
Could this have something to do with my SQL version or cache?
I can send you any of the files.
Also, I want to show a "Fall/Monthly Specials" info box on my home page.
I may have to create a Specials Category and move the products in there (using link, of course). Thanks,

[jpf]

Can you re-create this issue in the TEST system below?

[shirley]

I go to the admin trying my username and password, no go

Next, i try the admin demo demoonly and still can't get in.

what do i do to get in to admin to test the specials edit function?

the catalog specials looks just like mine.

sorry to be so dense. how many files could cause this error?
I thought I had replaced them all.

[shirley]

Okay, I got into the admin demo site...must have been you fixing it. thanks,

I went to the specials, pressed edit and made a price update.
It works fine...

Please tell me what phps I have to reload to get this going....
languages/english/specials.php
catalog/specials.php
catalog/admin/specials.php
contents/specials.tpl.php

any more? thanks again
I just reloaded these from my originals but no change...should I download the package files again?

added just now...
Here is the code from the admin specials.php that seems to be the culprit...

<?php
if ( ($action == 'new') || ($action == 'edit') ) {
$form_action = 'insert';
if ( ($action == 'edit') && isset($HTTP_GET_VARS['sID']) ) {
$form_action = 'update';
// BOF: MOD - Separate Pricing Per Customer



// LINE CHANGED: Bugfix 0000061
// $product_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, s.specials_new_products_price, s.expires_date, s.customers_group_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = s.products_id and s.specials_id = '" . (int)$HTTP_GET_VARS['sID'] . "'");
$product_query = tep_db_query("select p.products_id, pd.products_name, IF(pg.customers_group_price IS NOT NULL, pg.customers_group_price, p.products_price) as products_price, s.specials_new_products_price, s.expires_date, s.customers_group_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s LEFT JOIN " . TABLE_PRODUCTS_GROUPS . " pg using (products_id, customers_group_id) where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = s.products_id and s.specials_id = '" . (int)$HTTP_GET_VARS['sID'] . "'");
// EOF: MOD - Separate Pricing Per Customer

[jpf]

Demo site is down for a while... will (hopefully) fix later today.

[jpf]

Test/Demo Server back on line and refreshed too...