I need help

[seanymph]

I dont know what I have done but I am unable to get into my zen cart admin panel. All I get is the Http 500 internal server error. This only started happening after I installed the Edit Orders v4.0.3, I haven't installed the SQL as yet.

Is there a way to get the admin panel back without losing all the details or having to reinstall the whole site again or having to pay my webhost to restore the site.

I did a back up before installing the module and tried to reinstall that but it didnt work either, I am still getting the http 500 message.

If someone could please help me asap in this I would really appreciate it even if its just to remove the module to sort it all out.

Advanced Thanks.
seanymph

[lat9]

Are there any debug*.log files in your store's /cache folder? If so, they'll be indicative of what the underlying error is ...

[seanymph]

This is what was in the cache

[16-Dec-2012 00:54:23] PHP Fatal error: 1062uplicate entry 'zc_1bb761a3a593e628e1eddaeb1321bda4' for key 1 :: insert into zen_db_cache set cache_entry_name = 'zc_1bb761a3a593e628e1eddaeb1321bda4',
cache_data = 'YToxMjp7aTowO2E6NDp7czoxMzoiY2F0ZWdvcmllc19pZCI7czoyOiI4NyI7czoxNToiY2F0ZWdvcml lc19uYW1lIjtzOjEyOiJBcHBvaW50bWVudHMiO3M6OToicGFyZW50X2lkIjtzOjE6IjAiO3M6MTY6ImN hdGVnb3JpZXNfaW1hZ2UiO047fWk6MTthOjQ6e3M6MTM6ImNhdGVnb3JpZXNfaWQiO3M6MToiMSI7czo xNToiY2F0ZWdvcmllc19uYW1lIjtzOjI1OiJPcmlnaW5hbCBGYW50YXN5IEFydHdvcmtzIjtzOjk6InB hcmVudF9pZCI7czoxOiIwIjtzOjE2OiJjYXRlZ29yaWVzX2ltYWdlIjtzOjEwOiJIYXRob3IuanBnIjt 9aToyO2E6NDp7czoxMzoiY2F0ZWdvcmllc19pZCI7czoyOiIzOSI7czoxNToiY2F0ZWdvcmllc19uYW1 lIjtzOjE4OiJGYW50YXN5IEFydCBQcmludHMiO3M6OToicGFyZW50X2lkIjtzOjE6IjAiO3M6MTY6ImN hdGVnb3JpZXNfaW1hZ2UiO3M6MTQ6ImRyYWdvbmZpcmUuanBnIjt9aTozO2E6NDp7czoxMzoiY2F0ZWd vcmllc19pZCI7czoyOiI2MSI7czoxNToiY2F0ZWdvcmllc19uYW1lIjtzOjU6IkNhcmRzIjtzOjk6InB hcmVudF9pZCI7czoxOiIwIjtzOjE2OiJjYXRlZ29yaWVzX2ltYWdlIjtzOjEzOiJHY2FyZElzaXMuanB nIjt9aTo0O2E6NDp7czoxMzoiY2F0ZWdvcmllc19pZCI7czoyOiIxMCI7czoxNToiY2F0ZWdvcmllc19 uYW1lIjtzOjg6IkdpZnR3YXJlIjtzOjk6InBhcmVudF9pZCI7czoxOiIwIjtzOjE2OiJjYXRlZ29yaWV zX2ltYWdlIjtzOjE4OiJGYWlyeW1vb25jbG9jay5qcGciO31pOjU7YTo0OntzOjEzOiJjYXRlZ29yaWV zX2lkIjtzOjE6IjkiO3M6MTU6ImNhdGVnb3JpZXNfbmFtZSI7czo5OiJKZXdlbGxlcnkiO3M6OToicGF yZW50X2lkIjtzOjE6IjAiO3M6MTY6ImNhdGVnb3JpZXNfaW1hZ2UiO3M6MTk6ImFtZXRoeXN0Y2l0cml uZS5qcGciO31pOjY7YTo0OntzOjEzOiJjYXRlZ29yaWVzX2lkIjtzOjI6IjMyIjtzOjE1OiJjYXRlZ29 yaWVzX25hbWUiO3M6MjA6IkNyeXN0YWxzICYgR2Vtc3RvbmVzIjtzOjk6InBhcmVudF9pZCI7czoxOiI wIjtzOjE2OiJjYXRlZ29yaWVzX2ltYWdlIjtzOjEwOiJXQU0wMDEuanBnIjt9aTo3O2E6NDp7czoxMzo iY2F0ZWdvcmllc19pZCI7czoyOiI0OSI7czoxNToiY2F0ZWdvcmllc19uYW1lIjtzOjc6IlBhcnRpZXM iO3M6OToicGFyZW50X2lkIjtzOjE6IjAiO3M6MTY6ImNhdGVnb3JpZXNfaW1hZ2UiO3M6MTE6InRhcm9 0dDEuanBnIjt9aTo4O2E6NDp7czoxMzoiY2F0ZWdvcmllc19pZCI7czoyOiIxMSI7czoxNToiY2F0ZWd vcmllc19uYW1lIjtzOjIxOiJSZWlraS9FbmVyZ3kgSGVhbGluZ3MiO3M6OToicGFyZW50X2lkIjtzOjE 6IjAiO3M6MTY6ImNhdGVnb3JpZXNfaW1hZ2UiO3M6MDoiIjt9aTo5O2E6NDp7czoxMzoiY2F0ZWdvcml lc19pZCI7czoyOiI4NiI7czoxNToiY2F0ZWdvcmllc19uYW1lIjtzOjI1OiJSZWlraSBDb3Vyc2VzL0F 0dHVuZW1lbnRzIjtzOjk6InBhcmVudF9pZCI7czoxOiIwIjtzOjE2OiJjYXRlZ29yaWVzX2ltYWdlIjt zOjg6InVzdWkuanBnIjt9aToxMDthOjQ6e3M6MTM6ImNhdGVnb3JpZXNfaWQiO3M6MjoiMzAiO3M6MTU 6ImNhdGVnb3JpZXNfbmFtZSI7czoxOToiVGFyb3QgQ2FyZCBSZWFkaW5ncyI7czo5OiJwYXJlbnRfaWQ iO3M6MToiMCI7czoxNjoiY2F0ZWdvcmllc19pbWFnZSI7czoxNzoiVGFyb3QgUmVhZGluZy5qcGciO31 pOjExO2E6NDp7czoxMzoiY2F0ZWdvcmllc19pZCI7czoyOiI0MSI7czoxNToiY2F0ZWdvcmllc19uYW1 lIjtzOjIzOiJXaWNjYW4vU3Bpcml0dWFsIEVib29rcyI7czo5OiJwYXJlbnRfaWQiO3M6MToiMCI7czo xNjoiY2F0ZWdvcmllc19pbWFnZSI7czoxNzoid29uZGVyc193aWNjYS5qcGciO319',
cache_entry_created = '1355579663' in /home/spiritc/public_html/catalogue/includes/classes/db/mysql/query_factory.php on line 101

Does that make any sense to you?

Thanks
seanymph

[lat9]

You can edit your /YOUR_ADMIN/includes/configure.php and find, towards the bottom of the file:

  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache 
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash  
  define('SQL_CACHE_METHOD', 'database');

and change that to

  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache 
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash  
  define('SQL_CACHE_METHOD', 'none');

Note: This does not correct the issue that you're having with the cache; it simply masks the problem by disabling the writing of the cached information to the database so that you can get into your admin.

[countrycharm]

Also you didn't install edit orders right and that's the reason your getting the 500 error. See your PM.

[seanymph]

Thanks lat9 and countrycharm