Australia Post Module problem - "unknown column p.products_height"

**dail** · 16 May 2007, 04:41 PM

I am new to Zen Cart and had several items in testing and setting up the cart. I added the Australia post module now I cannot get access to the products again. Comes up with string of errors. It appears that the then new module has added fields for size and weight components that were not entered prior to adding items.
How can I fix this without deleting items and starting over?

**dail** · 20 May 2007, 05:55 AM

Does anyone know how to fix this issue. I think it was created by the Aus Post Module?
1054 Unknown column 'p.products_height' in 'field list'
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_height,p.products_length, p.products_width, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = '2' and p.products_id = pd.products_id and pd.language_id = '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.

**dail** · 22 May 2007, 05:38 AM

Doesn't help as error is there days after the event and backspace history is gone.

**DrByte** · 22 May 2007, 07:21 AM

Originally Posted by dail

I am new to Zen Cart and had several items in testing and setting up the cart. I added the Australia post module now I cannot get access to the products again. Comes up with string of errors. It appears that the then new module has added fields for size and weight components that were not entered prior to adding items.
How can I fix this without deleting items and starting over?

Originally Posted by dail

Does anyone know how to fix this issue. I think it was created by the Aus Post Module?
1054 Unknown column 'p.products_height' in 'field list'

I know nothing about the auspost module, but if you had to install PHP files that now ask for new fields in the database .... but you didn't install the database updates so that those fields are available ... then it makes sense that you'd get errors like "field doesn't exist".

So ... was there a readme with the module? Did it tell you to run some database/SQL commands? Was there a .sql file in the module files? Did you run it on your database? If you didn't, then ... you need to.

**RodG** · 22 May 2007, 01:35 PM

dail, DrByte,
This *is* a bug caused by the AustPost module V1.3. I've been waiting for the last couple of days for one of the people I emailed the fix to to confirm that it is indeed fixed. I'm pretty confident it is, but I've still no confirmation, so I've uploaded the updated version (v1.4) to the downloads area anyway.

DrByte, FYI, the installation process updates the tables - well it should have done <embarrasement mode on> I was using a hardcoded table name during development and ended up forgetting to replace it with the predefined constant prior to release, as such, those using table prefixes ended up with a broken system<embarassment mode off>.

Note: To get the best out of this module a couple of the admin files have also been updated <optional>. The included README file gives full details about this (it adds dimensions to products to cater for 'cubing' rules).

dail, if you wish to recover your system before the update is made avialable simply revert the changed files in the /admin/ directory. (if you didn't back them up first, just replace the relevent files from a default zencart install.
Only two files are affected, collect_info.php and update_product.php

Cheers
Rod

**dail** · 23 May 2007, 06:35 AM

Thanks for your help Rod, I thought I was going mad. I did replace the 2 files and it did not fix the problem, the error still existed. I then deleted the whole installation and reinstalled zen cart and restored the data and all came good again. I can't understand why by replacing he 2 files the error still existed after reading your comments.
I will try installing v 1.4 now.

**RodG** · 23 May 2007, 08:10 AM

> I will try installing v 1.4 now

<big sigh>. Sorry dail, V1.4 is still broken. I'll be uploading V1.4.1 shortly.

Cheers
Rod

**romy** · 23 May 2007, 08:23 AM

Does anyone have the answer to this..
want to add t-shirt sizes and color choices to my options and get this error..
Option Values
1054 Unknown column 'pov.products_options_values_quantity' in 'field list'
in:
[select pov.products_options_values_id, pov.products_options_values_name, pov.products_options_values_quantity, pov2po.products_options_id, pov.products_options_values_sort_order from cart1_products_options_values pov left join cart1_products_options_values_to_products_options pov2po on pov.products_options_values_id = pov2po.products_options_values_id left join cart1_products_options po on pov2po.products_options_id = po.products_options_id where pov.language_id = '1' and pov2po.products_options_values_id !='0' order by po.products_options_name, LPAD(pov.products_options_values_sort_order,11,'0'), pov.products_options_values_name]
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.

I am working with the current zencart.

**dail** · 24 May 2007, 03:45 AM

I think you have the same problem I had. Go back to the redme.txt file that came with the module and you will probably find that you have to add several lines of code to several files. Hope it works out for you.

**dail** · 25 May 2007, 01:15 AM

I installed V1.5, I changed the 2 files but on a new install of ZEN CART there was only the first file that had to be modified then other already had the mods in it for weight, height, length etc.
When I added a product the folling occurred. The URL
http://www.plaza.com.au/hits/admin/p...insert_product

Result: Parse error: syntax error, unexpected '.' in /home/plaza/public_html/hits/admin/includes/modules/update_product.php on line 31

Line 31 for the File update_product.php:
$tmp_value = zen_db_prepare_input($_POST['products_weight']);
$products_weight = (!zen_not_null($tmp_value) || $tmp_value=='' || $tmp_value == 0) ? 0 : $tmp_value;