AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: Olenka on July 29, 2015, 02:04:17 PM

Title: Lost site after update
Post by: Olenka on July 29, 2015, 02:04:17 PM

Hi,
I updated site 1.1.9 to 1.2 and this error appear:

There has been a critical error processing your request
Please check AbanteCart and webserver error logs for more details. You can check error log in the control panel if it is functional. Otherwise, refer to error log located on your web server

I am green in the IT things, so I dont know what to do now. I cannot enter to my site. My customers cannot order products and I am loosing money :-/ How to fix this problem, please?

Title: Re: Lost site after update
Post by: Basara on July 30, 2015, 05:16:11 AM

Hello.

First check AbanteCart error log (http://forum.abantecart.com/index.php/topic,834.msg3085.html#msg3085)

Title: Re: Lost site after update
Post by: Olenka on July 30, 2015, 03:51:13 PM

2015-07-30 19:30:26 - database error:  AbanteCart core v.1.2.0 Error: <br />SELECT p.page_id, controller, key_param, key_value, p.date_added, p.date_modified FROM oeli_pages p LEFT JOIN oeli_pages_layouts pl ON pl.page_id = p.page_id LEFT JOIN oeli_layouts l ON l.layout_id = pl.layout_id WHERE controller = 'pages/product/category'  AND ( COALESCE( key_param, '' ) = ''
                              OR
                              ( key_param = 'path'
                                 AND key_value = '1' ) )
                        AND template_id = 'default_html5' ORDER BY key_param DESC, key_value DESC, p.page_id ASC in <b>/home/u523407559/public_html/shop/core/database/amysqli.php</b> on line <b>105</b>
2015-07-30 19:33:02 - database error:  AbanteCart core v.1.2.0 Error: <br />SELECT p.page_id, controller, key_param, key_value, p.date_added, p.date_modified FROM oeli_pages p LEFT JOIN oeli_pages_layouts pl ON pl.page_id = p.page_id LEFT JOIN oeli_layouts l ON l.layout_id = pl.layout_id WHERE controller = 'pages/index/home' ORDER BY key_param DESC, key_value DESC, p.page_id ASC in <b>/home/u523407559/public_html/shop/core/database/amysqli.php</b> on line <b>105</b>
2015-07-30 19:41:16 - database error:  AbanteCart core v.1.2.0 Error: <br />SELECT p.page_id, controller, key_param, key_value, p.date_added, p.date_modified FROM oeli_pages p LEFT JOIN oeli_pages_layouts pl ON pl.page_id = p.page_id LEFT JOIN oeli_layouts l ON l.layout_id = pl.layout_id WHERE controller = 'pages/index/home' ORDER BY key_param DESC, key_value DESC, p.page_id ASC in <b>/home/u523407559/public_html/shop/core/database/amysqli.php</b> on line <b>105</b>


I copied last ones I think so.

Title: Re: Lost site after update
Post by: Basara on July 31, 2015, 02:43:38 AM

Hi.

 I suggest you need to restore backup.
Latest AbanteCart is 1.2.3 so maybe better for you is install it and import all orders/products from old site http://www.abantecart.com/ecommerce-documentation/admin-user-manual/system/data

Title: Re: Lost site after update
Post by: abolabo on July 31, 2015, 02:49:57 AM

i guess to solve this problem you should to make some database changes via phpMyAdmin.
For ex. check your error sql query in it and try to define what is wrong. I do not see any problems in your error-log.
Also since 1.2.0 template "default_html5" became "default". Probably issue in it.
But best solution is install clear 1.2.3 version.