There has been a critical error processing your request

[artist3412]

I tried to upgrade from 1.1.9 to 1.2 and received this:"There has been a critical error processing your request."
now I cannot log into my admin and this error shows instead of my page.

Here is what I found in my error logs
[Wed Feb 04 13:50:03 2015] [error] [client 173.9.234.218] File does not exist: /home/artist34/public_html/404.shtml
[Wed Feb 04 13:50:03 2015] [error] [client 173.9.234.218] File does not exist: /home/artist34/public_html/favicon.ico

I am finding the file favicon.ico, but not the 404.shtml

Please help.

[Basara]

Try manual upgrade http://docs.abantecart.com/pages/upgrade/manual.html

[artist3412]

I did the download of the upgrade file, however it does not  open properly. I only see symbols etc in the file, like its not "reading" it. I am sorry, I should not have attempted the upgrade, We just lost our 18 year old in a car accident and I may not be thinking clearly on how to do this.

[artist3412]

Okay, I found a couple of issues with how my files were opening, I have it fixed now and am doing the manual upgrade. I am a bit confused however on what I am to change the ac_ to. Again, I am sorry for asking.

[llegrand]

The ac_ is a database prefix,  you  can use ac_ or something else (keep it short)  or nothing.  It is appended to the front of a database table
e.g   you have a table called 'users'   if you have a prefix of 'ac_'   the table will be titled 'ac_users'.

This is most important if you have several different applications on the same domain and you have tables with the same name (highly probably) and you want  a way to segregate them.   If you only have AbanteCart database -  it's isn't important.

Hope this helps clarify for you.

Lee

[artist3412]

I have done the manual upgrade  and upgraded sql. My website still shows this error when trying to access it. (see attached). I really do not want to have to build it all over again. It has been up for a long time and It would take a extremely long time to redo it. Please if anyone has a suggestion, please advise.

[llegrand]

Can you login to your admin panel?

Assuming you can access your admin panel -
did you change the directory where your cart is installed?   If so,  did you update the system for the correct location.

Check your .htaccess file to be sure your rewrites are correct for your site location.

Not knowing your setup, I am just asking about places that have to correct for the site to open.

[artist3412]

I originally did the upgrade from the admin panel. I simply clicked the link in my messages like always. Then everything went to that error and I can no longer get onto my admin, it shows same as my website page does (See above attachment)

[artist3412]

At this point, I have manually upgraded every file and have done my sql upgrade (replacing with correct prefix). I do not know what else to do. If any of the admins could take a look for me before I delete everything and build a completely new site, I would appreciate it.

[eCommerce Core]

Are you sure you do not get any other errors in the log? Check your web server log as well.

In order to fix this, you need to fins the error in the logs.

[artist3412]

I only have one error log that I can check, that is on the Cpanel. I am pretty sure it has something to do with a file permission, but all of my ht access files and index.php files are 644. Since (as in the above attachment) it shows abantecart in the error, I am hoping the admins will know where this particular error page comes from.

[Basara]

In case you can not access admin you can locate AbanteCart error log directly in the file /system/logs/error.txt

[artist3412]

Thank you. Here is the error on the error log from that file:

Error No: 1054<br />SELECT p.page_id, controller, key_param, key_value, p.date_added, p.date_modified FROM ab_pages p LEFT JOIN ab_pages_layouts pl ON pl.page_id = p.page_id LEFT JOIN ab_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/artist34/public_html/AbanteCart/core/database/mysql.php</b> on line <b>114</b>

[artist3412]

I also tried running my sql update again and this is what I get (see attached)

[yonghan]

Hi, based on the sql error. Seems your table is already using v1.2 scheme. Please click on the customer_transaction table and click on structure to see if it's already using date_modified instead of update_date. Based of it, you should change the upgrade sql query.