AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: artist3412 on February 04, 2015, 07:21:13 PM

Title: There has been a critical error processing your request
Post by: artist3412 on February 04, 2015, 07:21:13 PM: 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.
Title: Re: There has been a critical error processing your request
Post by: Basara on February 05, 2015, 02:40:12 AM: Try manual upgrade http://docs.abantecart.com/pages/upgrade/manual.html
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 06, 2015, 10:07:28 AM: 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.
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 07, 2015, 02:16:28 PM: 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.
Title: Re: There has been a critical error processing your request
Post by: llegrand on February 07, 2015, 03:18:56 PM: 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
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 13, 2015, 04:46:27 PM: 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.
Title: Re: There has been a critical error processing your request
Post by: llegrand on February 13, 2015, 06:08:54 PM: 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.
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 13, 2015, 06:21:38 PM: 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)
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 16, 2015, 11:20:29 AM: 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.
Title: Re: There has been a critical error processing your request
Post by: eCommerce Core on February 17, 2015, 08:32:28 AM: 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.
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 17, 2015, 08:51:32 AM: 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.
Title: Re: There has been a critical error processing your request
Post by: Basara on February 18, 2015, 08:08:58 AM: In case you can not access admin you can locate AbanteCart error log directly in the file /system/logs/error.txt
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 18, 2015, 10:21:07 AM: Thank you. Here is the error on the error log from that file:

Error No: 1054 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 /home/artist34/public_html/AbanteCart/core/database/mysql.php on line 114
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 18, 2015, 12:05:43 PM: I also tried running my sql update again and this is what I get (see attached)
Title: Re: There has been a critical error processing your request
Post by: yonghan on February 22, 2015, 11:47:23 AM: 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.
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 22, 2015, 11:55:55 AM: It says Date_modified. Is this what it should say?
Title: Re: There has been a critical error processing your request
Post by: yonghan on February 22, 2015, 11:59:30 AM: Yes it's correct for v1.2. Which file did you use for the mysql update routine?
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 22, 2015, 12:05:17 PM: This is what I used, this is after replacing the ac_ with my prefix ab_
Title: Re: There has been a critical error processing your request
Post by: yonghan on February 22, 2015, 12:29:31 PM: You need to open up the sql file and compare it with the table scheme/structure start from line 58. Or you can ask for your hosting provider help to fix the issue. Since it will need to have a basic mysql knowledge.
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 22, 2015, 03:11:08 PM: I am simply not seeing anything that is incorrect. I still wonder if this has nothing to do with SQL and is simply an issue with permissions.
Title: Re: There has been a critical error processing your request
Post by: artist3412 on February 23, 2015, 06:14:13 PM: I have been with a site for too long now. I want to thank those of you that responded, however I am going to have to delete the entire site and build a new one.