1054 Unknown column 'p.products_id' in 'on clause'

[schoolboy]

We had something similar: Got these errors:-

1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM categories c, categories_description cd LEFT JOIN categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='1' WHERE c.categories_id=cd.categories_id AND cd.language_id='1' 

Our problem appears to be a conflict between Ultimate SEO URLS, and Image Handler 2.

We switched off the SEO mod, changing all TRUE settings to FALSE as well.

Error vanished, site is now OK

[AngelT]

Hi DrByte,

We decided to upgrade to v1.3.7. I have done so, but when I load the shopping page it comes the same as v1.2.7 except by the Zen Cart sign at the bottom of the page.

When I go to Tools/Server Info on my Admin I see the Zen Cart v1.2.7. Dos this mean that the upgrade did not work out? or Do I have to do anything else to see the changes?

Please let me know!

Radhames

[DrByte]

We decided to upgrade to v1.3.7. I have done so, but when I load the shopping page it comes the same as v1.2.7 except by the Zen Cart sign at the bottom of the page.

When I go to Tools/Server Info on my Admin I see the Zen Cart v1.2.7. Dos this mean that the upgrade did not work out? or Do I have to do anything else to see the changes?

What exactly did you do to "upgrade" ?

[AngelT]

What exactly did you do to "upgrade" ?

1) I downloaded the v1.3.7 and unzip it up.
2) Uploaded v1.3.7 to a new directory to my site.
3) Made a databse backup from my site to my pc.
4) The configure.php files were empty both in new-directory/admin/includes
and in new-directory/includes, so I copied them from the old version 1.2.7
using the same directory structure.
5) Run zc_install and it gave me the upgrade option along with all the
information from the configure.php file: User, password, database name, etc.
6) All check boxes starting from Upgrade DB from 1.2.7 to 1.3.0 where
checkted up to the v1.3.7.
7) I hit the button Upgrada Database Now.
8) I assumed the process run accumulative from one version to another. But
because I saw the shopping page the same as the v1.2.7 except for the zen
cart sign at the bottom of the page, I said to myself maybe I have to run
separate for each version; then I did that until I reach v1.3.7.

Notes:

a) I run zc_install from the new-directory on top of the old database. I did not
do a new database.

b) The only message I got after the upgrade was "SKIPPED: Cannot insert
configuration_key (then the key name) because it already exist" for some
files.

c) I changed the prefix of the database files to a new one because the process
say that leaving the existing one could corrupt the database.

Thank you for your help!.

I'll be waiting for your reply to continue this process, please!

Best regards,

Radhames

[thedidgmaster]

Hi, I was trying to add new products into the catalog, I just installed zencart, and put in the canada post module, I know nothing about php, but I keep getting the following when I try to add a product and subsequently am unable to add products.

" 1054 Unknown column 'products_weight_type' in 'field list'
in:
[insert into products (products_quantity, products_type, products_model, products_price, products_date_available, products_weight, products_weight_type, products_dim_type, products_length, products_width, products_height, products_ready_to_ship, products_status, products_virtual, products_tax_class_id, manufacturers_id, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_discount_type, products_discount_type_from, products_price_sorter, products_image, products_date_added, master_categories_id) values ('0', '1', '', '0', null, '0', 'lbs', 'in', '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '', now(), '1')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."



Anyone know what might be going on?? Thanks

[DrByte]

I put in the canada post module, I know nothing about php, but I keep getting the following when I try to add a product and subsequently am unable to add products.

" 1054 Unknown column 'products_weight_type' in 'field list'

You missed a step in installing the CP module. There's an SQL patch to apply, which is documented in step #2 of the "Install_CP.txt" file in the module distribution files.