WARNING: An Error occurred, please refresh the page and try again.
I have upgraded from v1.3.9 to v1.5 and I have read and reread and tried all the suggestions and I still cannot access my admin. At first it was the error 500, I fixed that. Now its back to the 'WARNING: refresh the page'. I noticed that my admin/includes/config.php file was empty so I placed a new one in there. I ran the zc_install again and I am still where I was litterally 4 hours ago. I have looked in the cache for the 'myDebug' and I have all but that particular file in there. The php errors that were listed during the upgrade are as follows:
upgrade_exception_id sql_file reason errordate sqlstatement
1 sql/mysql_upgrade_zencart_139_to_150.sql
Cannot drop index
page_accessed on table
admin_activity_log
because it does not
exist.
2012-08-
15
09:48:51
ALTER TABLE
admin_activity_log
DROP INDEX
page_accessed;
2 sql/mysql_upgrade_zencart_139_to_150.sql
Cannot drop index
access_date on table
admin_activity_log
because it does not
exist.
2012-08-
15
09:48:51
ALTER TABLE
admin_activity_log
DROP INDEX
access_date;
3 sql/mysql_upgrade_zencart_139_to_150.sql
Cannot add index
idx_page_accessed_zen
to table
admin_activity_log
because it already
exists.
2012-08-
15
09:48:51
ALTER TABLE
admin_activity_log
ADD INDEX
idx_page_accessed_zen
(page_accessed);
4 sql/mysql_upgrade_zencart_139_to_150.sql
Cannot add index
idx_access_date_zen to
table
admin_activity_log
because it already
exists.
2012-08-
15
09:48:51
ALTER TABLE
admin_activity_log
ADD INDEX
idx_access_date_z
I don't know what to do. Will anyone help? :(
Re: I don't have a 'myDebug' file
So, apart from quoting some warning messages which simply indicate that the upgrader encountered some steps that it didn't need to do and reported as much, what is the actual problem you're having NOW?
Re: I don't have a 'myDebug' file
www.sayitbestshirts.com/zc_admin is my site and no matter what I have tried, the admin will not open. "WARNING: An Error occurred, please refresh the page and try again." is all that I get. I have looked at the configure.php, I have looked at the database log, I have looked at every file inside of the cache folder. I have gone through the zc_install several times thinking maybe I've missed something and if I have, I don't know where to find it or where to put it.
Re: I don't have a 'myDebug' file
That message indicates that there was a problem trying to access some information from the database
Typical causes are outlined here: http://www.zen-cart.com/content.php?...-and-try-again along with some suggestions on how to identify what exact database query is triggering the problem.
Also see this article: http://www.zen-cart.com/content.php?...rror_reporting
Re: I don't have a 'myDebug' file
Ok. I have looked at what could possibly be wrong, so starting with the mysql not running. How do I check and fix it?
And the dbxxxx setting in the config.php, where do I find that information and where do I put it?