No access to back office

I really have no idea what I have done. when I go to my admin logon page I get "WARNING: An Error occurred, please refresh the page and try again."

Help

Probably some sort of database access problem.

http://www.zen-cart.com/content.php?311-warning-an-error-occurred-please-refresh-the-page-and-try-again

stevesh:

Probably some sort of database access problem.

http://www.zen-cart.com/content.php?311-warning-an-error-occurred-please-refresh-the-page-and-try-again

I think you are right but cannot get in to sort it.

adb34:

I think you are right but cannot get in to sort it.

However I have done nothing to the database

adb34:

However I have done nothing to the database

Check your logs folder..

Also check you admin/includes/configure and includes/configure make sure you database is correct and password as well good luck..

you seem to have some problems with the configure.php on the admin side, you could try to reupload all the files from the admin folder (backup first) and see what that does for you ..
you could allso try to look in the debug folder to see the debug logs, this can point you in the right direction.

Mayb you can tell us what extra modules/plugins you have installed this can cause problems too

What is your zencart version ?

wrickspam:

you seem to have some problems with the configure.php on the admin side, you could try to reupload all the files from the admin folder (backup first) and see what that does for you ..
you could allso try to look in the debug folder to see the debug logs, this can point you in the right direction.

Mayb you can tell us what extra modules/plugins you have installed this can cause problems too

What is your zencart version ?

I have re-loaded my admin folder, not that. I think something has happened to the db. Yes i did not do a backup, so i am requesting one from my ISP. v151

adb34:

I have re-loaded my admin folder, not that. I think something has happened to the db. Yes i did not do a backup, so i am requesting one from my ISP. v151

For the third time, what errors are in your logs folder?

ftp to your site, goto the logs folder found in the subdirectory of where your store is.

Ie what leads you to believe you have a corrupt database, what was changed between thelast successful use and now?

Obscure the aadmin folder name before posting here.

mc12345678:

For the third time, what errors are in your logs folder?

ftp to your site, goto the logs folder found in the subdirectory of where your store is.

Ie what leads you to believe you have a corrupt database, what was changed between thelast successful use and now?

Obscure the aadmin folder name before posting here.

Very good point and well presented. I will look at the log files and get back to you.

adb34:

Very good point and well presented. I will look at the log files and get back to you.

Some total of the log file 'myDEBUG-adm-1408617696-60801.log'

[21-Aug-2014 11:41:36] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO main_configuration VALUES (NULL, 'Display Name field options','RETURN_NAME','1','Display Name field as:<br />0 = Display as Optional<br />1 = Display as Required<br />2 = Do not Display', '50',1, NULL, NOW(), NULL, 'zen_cfg_select_option(array('0', '1', '2'),') in /homepages/20/d503465712/htdocs/shops/ZenCart/main_shop/includes/classes/db/mysql/query_factory.php on line 120

adb34:

Some total of the log file 'myDEBUG-adm-1408617696-60801.log'

[21-Aug-2014 11:41:36] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO main_configuration VALUES (NULL, 'Display Name field options','RETURN_NAME','1','Display Name field as:<br />0 = Display as Optional<br />1 = Display as Required<br />2 = Do not Display', '50',1, NULL, NOW(), NULL, 'zen_cfg_select_option(array('0', '1', '2'),') in /homepages/20/d503465712/htdocs/shops/ZenCart/main_shop/includes/classes/db/mysql/query_factory.php on line 120
You have a module that is performing a "blind-insert" into the configuration table, making the (invalid) assumption that no columns have been added to that table. Make the changes I suggested (they're included in Zen Cart v1.5.3) here: http://www.zen-cart.com/showthread.php?211396-Use-debug_backtrace%28%29-to-determine-query_factory-caller-on-error and then report back what the updated message is. The change suggested will allow the query_factory module to report who called it so that you can deduce where the error originates.

lat9:

You have a module that is performing a "blind-insert" into the configuration table, making the (invalid) assumption that no columns have been added to that table. Make the changes I suggested (they're included in Zen Cart v1.5.3) here: http://www.zen-cart.com/showthread.php?211396-Use-debug_backtrace%28%29-to-determine-query_factory-caller-on-error and then report back what the updated message is. The change suggested will allow the query_factory module to report who called it so that you can deduce where the error originates.

I tried to follow what you are talking about but got lost. So I deleted the shop and uploaded a backup of it. All OK. I know it was one of the plug in I was installing that caused the problem. I will try and replicate this and get back to with the plug-in.