excelsiorglobal Posted March 21, 2014 Share Posted March 21, 2014 (edited) 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 March 22, 2014 by excelsiorglobal (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted March 22, 2014 Share Posted March 22, 2014 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 More sharing options...
excelsiorglobal Posted March 22, 2014 Author Share Posted March 22, 2014 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 More sharing options...
NemoPS Posted March 24, 2014 Share Posted March 24, 2014 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 More sharing options...
excelsiorglobal Posted March 27, 2014 Author Share Posted March 27, 2014 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 More sharing options...
excelsiorglobal Posted March 27, 2014 Author Share Posted March 27, 2014 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 More sharing options...
NemoPS Posted March 28, 2014 Share Posted March 28, 2014 At this point replace all files/folders except the config ones with a fresh 1.6 package, see if this helps Link to comment Share on other sites More sharing options...
excelsiorglobal Posted March 28, 2014 Author Share Posted March 28, 2014 (edited) 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 March 28, 2014 by excelsiorglobal (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted March 29, 2014 Share Posted March 29, 2014 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 More sharing options...
fincosat Posted April 8, 2014 Share Posted April 8, 2014 Hi. I have same problem I you have solved this problem ? Link to comment Share on other sites More sharing options...
excelsiorglobal Posted April 8, 2014 Author Share Posted April 8, 2014 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 More sharing options...
escapad Posted June 4, 2014 Share Posted June 4, 2014 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 More sharing options...
excelsiorglobal Posted June 4, 2014 Author Share Posted June 4, 2014 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 More sharing options...
SANJEEV10121990 Posted October 26, 2015 Share Posted October 26, 2015 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 More sharing options...
NemoPS Posted October 28, 2015 Share Posted October 28, 2015 You need to add that column to the db, to ps_order_detail, as decimal(20,6) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now