Jump to content

Nothing works after the upgrade to the 1.6.0.5 version today


Recommended Posts

After upgrading, I couldn't access the admin area, and so did some searching around, and enabled see the errors on the screen.  I can't access the site at all:

 

Here is the error message:

 

"Notice: Undefined index: DbCore in /.../.../public_html/classes/PrestaShopAutoload.php on line 121

Warning: require(/.../.../public_html) [function.require]: failed to open stream: No such device in /.../.../public_html/classes/PrestaShopAutoload.php on line 121
 

Fatal error: require() [function.require]: Failed opening required '/.../.../public_html/' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /.../.../public_html/classes/PrestaShopAutoload.php on line 121"

 

I then went to cache/class_index.php and deleted it (it auto-restored) and then the error message changes to on main page:

"Fatal error: Uncaught Unknown column 'module_shop.enable_device' in 'on clause'<br /><br /><pre>SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` </pre> thrown in /.../.../public_html/classes/db/Db.php on line 623"

 

AND

 

on admin page to:

"Fatal error: Uncaught Unknown column 'module_shop.enable_device' in 'on clause'<br /><br /><pre>SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` </pre> thrown in /.../.../public_html/classes/db/Db.php on line 623"

 

Help appreciated in trying to get this resolved.  I don't mind going back to the previous version (pre upgrade) but can't find where to restore backups.

 

Used softaculous to do all the upgrading etc, and afterwards it still thinks the version is 1.5.6.1. I cannot verify as I can't get in.

 
Thanks
K
Edited by excelsiorglobal (see edit history)
Link to comment
Share on other sites

The first fatal error seems like a permission issue, can you try setting the whole public_html folder to 775? Or 777 as a test.

 

As for the other, you can add that enable_device column to the module_shop table. I believe it's a TINYINT or INT (can't check right now)

Link to comment
Share on other sites

The first fatal error seems like a permission issue, can you try setting the whole public_html folder to 775? Or 777 as a test.

 

As for the other, you can add that enable_device column to the module_shop table. I believe it's a TINYINT or INT (can't check right now)

 

Thanks.

Changed all to 775 to get the following:

"Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, ... and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request."

 

Changing to 777 produces the same message.

 

Next bit I am in the database, but clicked on add column but do not know what I need to put in anywhere to add it.

Link to comment
Share on other sites

Error 500 is usually produced when there are htaccess errors, or dev mode is disabled. Weird, perhaps your server config doesn't allow 775/775 permission level. Try setting them back to how they were. Also, for the database, when you add the column, type enable_device as name, and set the type to TINYINT :)

Link to comment
Share on other sites

Right, the problem is now changed back to the original problem I had before it went to the server one, I upgraded to the latest as directed by softaculous auto installer, and after that I got to the admin folder and it returns a blank screen and the following in the address bar:

http://MYSITE/ADMINFOLDER/index.php?controller=AdminHome&token=4ttt1cdastbd84ee22ssb0e0ee4b8a4t

 

How to fix?  What to fix?

Link to comment
Share on other sites

Ok following on, I managed to get in to the site admin but it says "access denied" and although I have upgraded it still shows 1.5.6.1.

 

Also clicking on modules in the admin area produces this message:

[PrestaShop] Fatal error in module DbMySQLi:
Call to a member function fetch_assoc() on a non-object

Link to comment
Share on other sites

Right, so although the site is not doing business yet, I had edited things, will doing the above affect this?  Also how do I do what you say, would I be best not using softaculous autoinstaller and doing the install a different way?  Step by step assistance would be useful. 

 

Also how do I ensure the .htaccess says the right stuff?

Edited by excelsiorglobal (see edit history)
Link to comment
Share on other sites

It depend on what you mean by editing things:

- did you only modify things in the back office, like added products/categories etc?

- did you change tpl, php, css files?

 

In the first case, no worries, your changes will be lost. In the latter, make a backup, then re-apply your changes.

 

The only way to go is to login using an ftp client, and re-upload everything chosing to replace files (but save the config folder!)

Link to comment
Share on other sites

  • 2 weeks later...

No still unsolved.  My hosting provider is not being useful either.  I have a back up to restore to the state before the issues began, but they are not being responsive.  I used softaculous to install, and there is meant to be a restore button within that installer, but there isn't and so am being overly patient (mainly as I am busy on other projects) but might have to jump ship for hosting.  

 

Anyhow the problem remains unsolved.

Link to comment
Share on other sites

  • 1 month later...

Hi,

 

I got exactly similar problem when upgrading Prestashop using Softaculous.

It's supposed to update to 1.6.0 ver but its read as 1.5.6 ver.

 

in my case, what i do was:-

- open softaculous

- 'Edit Detail' on Prestashop

- 'Upgrade'

- there's a link for you to click and complete update, then xml code appeared. (not sure what is it actually) 

- done. prestashop shows 1.6.0 ver

 

idk why this happened and i believe this problem only occur when updating prestashop using softaculous.

 

best of luck

 

 

Link to comment
Share on other sites

Hi

 

Thanks for the input, hopefully someone finds this useful, I on the other hand could not get it to resolve at the time, and went to using a wordpress ecommerce solution as it was needed asap.  I will revisit prestashop at a future point.  So I will for now mark this as solved (not for me) but escapad provided a solution that might have worked for me, I can't recreate  the problem now.

Link to comment
Share on other sites

  • 1 year later...

hey i m getting error

 

Fatal error: Uncaught Unknown column 'original_wholesale_price' in 'field list'<br /><br /><pre>INSERT INTO `ps_order_detail` (`id_order`, `id_order_invoice`, `id_warehouse`, `id_shop`, `product_id`, `product_attribute_id`, `product_name`, `product_quantity`, `product_quantity_in_stock`, `product_quantity_return`, `product_quantity_refunded`, `product_quantity_reinjected`, `product_price`, `reduction_percent`, `reduction_amount`, `reduction_amount_tax_incl`, `reduction_amount_tax_excl`, `group_reduction`, `product_quantity_discount`, `product_ean13`, `product_upc`, `product_reference`, `product_supplier_reference`, `product_weight`, `tax_name`, `tax_rate`, `tax_computation_method`, `id_tax_rules_group`, `ecotax`, `ecotax_tax_rate`, `discount_quantity_applied`, `download_hash`, `download_nb`, `download_deadline`, `unit_price_tax_incl`, `unit_price_tax_excl`, `total_price_tax_incl`, `total_price_tax_excl`, `total_shipping_price_tax_excl`, `total_shipping_price_tax_incl`, `purchase_supplier_price`, `original_product_price`, in /home/rideotkj/public_html/classes/db/Db.php on line 791

 

 

cn anyone help me how to resolve it
 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...