Lost site after update

[Olenka]

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?

[Basara]

Hello.

First check AbanteCart error log

[Olenka]

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.

[Basara]

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

[abolabo]

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.