Error Message 1054 Unknown column 'products_height' in 'field list'

[dahubbpostal]

I made some adjustment and clearly stuffed something up.
I now get this error message when trying to add a new product.

Can you please tell me how to fix it.
Thanks

1054 Unknown column 'products_height' in 'field list'
in:
[insert into zen_products (products_quantity, products_type, products_model, products_price, products_date_available, products_weight, products_height, products_length, products_width, 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', '', '1', null, '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '', now(), '6')]
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.

[fairestcape]

By "some adjustment", do you mean you edited a core PHP file?

If you did, then finding your error should not be that difficult. Somewhere in your PHP files there is a reference to products_height, and I think that what you did was to look for products_weight and then alter it in the PHP, thinking that this might change the name of the input field in add/edit a product.

Under ADMIN>>>TOOLS>>>DEVELOPERS TOOL KIT, you will have a facility to search your PHP files for instances of products_height.

So, in the dev toolkit screen, scroll down to the very last field (KEY OR NAME) and type in products_height .

Then, in ALL FILES LOOK-UPS dropdown box, choose all files - catalog/admin .

Click the button.

If products_height exists in a PHP file, a list will be produced showing the file converned, and its path, and the line number where the string occurs.

(When editing a core PHP file, always make a copy of the original first store this on your local hard drive. Edit another copy of the file on your local drive, and make sure that when you FTP it back to its destination directory, you overwrite the one on the server. Now, if you've fouled up, you at least have a pristine original that you can send back to where it belongs. This is a little procedure we all learned - me included - the hard way!)

[dahubbpostal]

Thanks, I will search through and see.

I found a probable cause.

I am trying to add the Austpost shipping module, and the error happened after this.
I reinstalled the original Backup of the admin directory and the error no longer occurs.
Thank Heaven for Backups

I will search the Auspost admin directory for the line and see what happens.

Great speedy help Thanx.

[fairestcape]

Okay, if you are trying to add a module, things are different...

Some modules require a SQL patch to be uploaded - I imagine Auspost does.

I think you may have neglected to do the SQL patch when you installed your mod.

[dahubbpostal]

Thank you, i see the txt file included with the directions to make the patch.

What a lot of them.

I will summon my inner Zen and try it.

Keeping a Backup of course.....

[RodG]

Thank you, i see the txt file included with the directions to make the patch.

What a lot of them.

I will summon my inner Zen and try it.

Keeping a Backup of course.....

You don't need to manually patch anything.

The problem you experienced, namely:

1054 Unknown column 'products_height' in 'field list'

.....Is caused because you didn't *complete* the installation of the Australia Post module.
You obviously installed the files OK, but your next step should have been to log onto your store as admin, then click the 'install' button in the AustPost module. Until/unless you do this the files you installed will be looking for database fields that don't exist.

fairestcape is correct in that "Some modules require a SQL patch to be uploaded - I imagine Auspost does.", but in this case the SQL patch is applied during the install process rather than a seperate patch file that you need to run.


Cheers
RodG (Author AustPost Improved)

[fairestcape]

Thanks for the intervention Rod. I'm sure that will clear up this issue for dahubbpostal.

[dahubbpostal]

You don't need to manually patch anything.

The problem you experienced, namely:

1054 Unknown column 'products_height' in 'field list'

.....Is caused because you didn't *complete* the installation of the Australia Post module.
You obviously installed the files OK, but your next step should have been to log onto your store as admin, then click the 'install' button in the AustPost module. Until/unless you do this the files you installed will be looking for database fields that don't exist.

fairestcape is correct in that "Some modules require a SQL patch to be uploaded - I imagine Auspost does.", but in this case the SQL patch is applied during the install process rather than a seperate patch file that you need to run.


Cheers
RodG (Author AustPost Improved)

Then I have another problem because the Austpost module is not showing in the Shipping Module list for me to do an install on ??
ps I still have the original admin directory there at the moment, I will put back the Austpost one tomorrow, but the Module was not showing in the List.

[dahubbpostal]

I re uploaded the admin folder, in case i had damaged something, and went to the Modules/Shipping, but the Auspost was not here to install. ??

[RodG]

Then I have another problem because the Austpost module is not showing in the Shipping Module list for me to do an install on ??
ps I still have the original admin directory there at the moment, I will put back the Austpost one tomorrow, but the Module was not showing in the List.

If it isn't showing up under the shipping modules it will be because not all the files were installed, or they were not installed in the right places.

Please note, the files located under the /admin/ directory are NOT required for module functionality. They are there to provide a means to edit the new data fields (so in that sense they are essential), but you should be able to get the module itself to show and work even if you don't install the /admin/ ones.

Traps for N00bs.

The 'catalog' directory doesn't actually exist. This is just a placeholder for whatever directory your store actually uses
(often something like "public_html", "htdocs", "www", "home/user/domain/zencart/store", etc.

The "CUSTOM" folder doesn't actually exist. This needs to be set to whatever directory you are storing your own customisations into. If you haven't yet customised your store I strongly suggest that you download and install a couple of themes to change the look of your store. In doing so you will automatically be creating your own 'custom' directory (which will end up being called the same name as whatever theme you decide to settle on).

Cheers
RodG