Admin Panel Issue

[ipdigitalgr]

Hello All,

We just upgraded our version from 1.7.1 to 1.7.5 and almost is ok. I saw almost cause we have an issue with the admin panel. 

I have uploaded a screeshot. 

Any help would be appreciated.

Thanks

John

[JBW]

Looks like missing CSS. Try to clear your shop cache and your browser cache&cookies.

[ipdigitalgr]

Hello and thank you for your answer.

Yes this was the problem , thank a lot.

I got another issue now. After upgrating to 1.7.5 i can't copy, add new product. All the time i get an 500 internal error.

Any suggestions where or what to search?

Thank you community again!!!

John

[JBW]

Enable debug mode to see the details for the 500 error by following these instructions:

 

[ipdigitalgr]

Hello my dear Friend,

Yes i did that and got a page with a lot of errors.

This is the first part that i took

764. if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768.             if ($sql) {
769.                 throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770.             }
772.             throw new PrestaShopDatabaseException($this->getMsgError());
773.         }
774.     }

 

 

Any suggestions?

 

Thank you

John

[JBW]

This is some part of php source code but not the error message itself. Can you post the full errors here?

Edited January 17, 2019 by JBW (see edit history)

[ipdigitalgr]

Hello thank you for your answer.

 

Here is the first part

 

Unknown column 'additional_delivery_times' in 'field list'<br /><br /><pre>INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES ('1', '18', '0', '701-0082-0011', '', '', '0', '0', '0', '1', '0', '3800146262259', '', '', '0', '0', '0', '1', '1', '127', '53', '0', '0', '0', '1', NULL, '0', '16.129031', '0', '', '0', '0', '0', '0', '0', '0', '404', '0', '1', '0000-00-00', '0', 'new', '1', '0', 'both', '0', '0', '2019-01-17 12:22:28', '2019-01-17 12:22:28', '3')</pre>

And this

 

Uncaught Exception: Unknown column 'additional_delivery_times' in 'field list'<br /><br /><pre>INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES ('1', '18', '0', '701-0082-0011', '', '', '0', '0', '0', '1', '0', '3800146262259', '', '', '0', '0', '0', '1', '1', '127', '53', '0', '0', '0', '1', NULL, '0', '16.129031', '0', '', '0', '0', '0', '0', '0', '0', '404', '0', '1', '0000-00-00', '0', 'new', '1', '0', 'both', '0', '0', '2019-01-17 12:22:28', '2019-01-17 12:22:28', '3')</pre>

 

And this

 

Uncaught PHP Exception PrestaShopDatabaseException: "Unknown column 'additional_delivery_times' in 'field list'<br /><br /><pre>INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES ('1', '18', '0', '701-0082-0011', '', '', '0', '0', '0', '1', '0', '3800146262259', '', '', '0', '0', '0', '1', '1', '127', '53', '0', '0', '0', '1', NULL, '0', '16.129031', '0', '', '0', '0', '0', '0', '0', '0', '404', '0', '1', '0000-00-00', '0', 'new', '1', '0', 'both', '0', '0', '2019-01-17 12:22:28', '2019-01-17 12:22:28', '3')</pre>" at /home/new10547/public_html/classes/db/Db.php line 769

 

Tell me if that hels you.

Thanks

John

 

 

[JBW]

Yes it helps me to understand. Bad news are that there are fields missing in your database, seems there was something seriously wrong with the upgrade. Hope you didn't do this on your live shop!?

[ipdigitalgr]

Hello

No it is our test site but we have worked a lot on it.

Is there something i can do or should i restore my backup and then try to upgrade again?

What are your suggestions?

[JBW]

If you want to use this test site later on in a live shop I would recommend to restore your backup to be sure there are no further things missing. If you  just want to test on it you can add the missing field 'additional_delivery_times' to table `ps_product' in the database manually and check if this solves your issue

[ipdigitalgr]

Hello my friend,

I restored my backup and now it is working as i want. I will stay at this version cause in 3-4 days we want to go live.

I have a couple of issues and would need a little bit of help. First of the reason that i updated the version is a js issue. The theme owner asked me to update the whole

version in order to solve it. I asked him to help me around with this issue. The other issue that i have is with the link widget. I made a test so i could add a block but after

deleting the link my whole theme went crazy. You can take a look here.

 

new.beboulino.gr

 

Any suggestions for this? Could the cache be the problem? I cleared the cache but nothing. I aslo searched around for css issues but still problems.

Thanks

John

[JBW]

Try to disable/reset/reinstall the link widget if this has caused the issues.