Urgent Help needed please!

[ShakaDula14]

Hi Guys, I am new here and I have a HUGE problem that I need help with ....

I set up this online store and things were great. But then tonight I decided to install an upgrade to my admin section and I lost EVERYTHING in admin! I was trying to upload admin_profiles add-on and I overwrote my admin folder without thinking about backing it up before attempting the install!

~D'OH~ on me! My brain stopped working and now I feel totally DUMB!

My store still works but I lost the ability to log in to my admin panel!

I went to myPHPadmin and recreated my admin password and am able to now log in to my main admin panel.

But clicking on ANYTHING in the admin panel brings back this script message

1146 Table 'levyspro_znc1.zen_admin_files' doesn't exist
in:
[select id from zen_admin_files where page = 'orders']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have NO IDEA what to do and I am flipping out because I need to access this panel to make critical changes to my admin settings.

Can anyone out there PLEASE give me a few moments to help me find a solution?

Pretty Please!?!?

[schoolboy]

What "upgrade" did you install into the admin system? And more to the point, what PROCEDURE did this "upgrade" involve?

Who are the providers of this "upgrade".

"Upgrade" and "Admin" are not terms that usually go together in zencart...

The error is being caused by a piece of script (php) that looks for data in a table called zen_admin_files. ... and this table does not exist, it seems.

Generally speaking, you can have additional tables in the database that can lie "dormant", as a database is little more than a repository for information.

So... GO THROUGH the original module (you must have a copy of it on your hard drive) to see what php FILES are used.

REMOVE them from your admin directories, and if any of the CORE files were replaced by the "upgrade", then these need to be restored to their original position.

DON'T mess about in the database... The problem can be resolved in the ADMIN FILES.

It would be good to know HOW you did this install...

Did you run any SQL patch during the install?

[ShakaDula14]

What "upgrade" did you install into the admin system? And more to the point, what PROCEDURE did this "upgrade" involve?

Who are the providers of this "upgrade".

"Upgrade" and "Admin" are not terms that usually go together in zencart...

The error is being caused by a piece of script (php) that looks for data in a table called zen_admin_files.

Generally speaking, you can have additional tables in the database that can lie "dormant", as a database is little more than a repository for information.

So... GO THROUGH the original module (you must have a copy of it on your hard drive) to see what php FILES are used.

REMOVE them from your admin directories, and if any of the CORE files were replaced by the "upgrade", then these need to be restored to their original position.

DON'T mess about in the database... The problem can be resolved in the ADMIN FILES.

I was trying to install the Admin Profiles add on

http://www.zen-cart.com/index.php?ma...products_id=86

Choose a user to have access to everything (you?) and check that user's ID on the Admin > Tools Admin Settings page. You'll see the ID in the left column. If it's not "1" edit the first line of the install_admin_profiles.sql to the correct value.

Run the install_admin_profiles.sql file using Zen Cart's Admin > Tools > Install SQL Patch facility


Step 2:
-------

Copy included files to appropriate places in admin. They already have the correct folder structure so a single drag and drag and drop of the "Admin" folder into the root directory for your store will put the files in the correct locations if you are using a good FTP client (e.g. FileZilla).

admin\admin_control.php
admin\denied.php
admin\images\icon_permissions.gif
admin\includes\admin_profiles.css
admin\includes\auto_loaders\config.admin_profiles.php
admin\includes\boxes\* (i.e. all files in the directory)
admin\includes\extra_datafiles\admin_profiles_data.php
admin\includes\functions\admin_profiles.php
admin\includes\init_includes\overrides\init_admin_auth.php
admin\includes\languages\english\images\buttons\button_edit_permissions.gif

There are 4 other steps but this is as far as I got.

As soon as I overwrote the admin folder, I lost the ability to even see the admin window.

So I panicked and reloaded the entire admin folder from the install file of 1.3.8a full file set.

Now I am able to log in to the admin page but am unable to access anything inside. I can only see the main admin window.

I have no idea what to do now ....

[ShakaDula14]

I was trying to install the Admin Profiles add on

http://www.zen-cart.com/index.php?ma...products_id=86



There are 4 other steps but this is as far as I got.

As soon as I overwrote the admin folder, I lost the ability to even see the admin window.

So I panicked and reloaded the entire admin folder from the install file of 1.3.8a full file set.

Now I am able to log in to the admin page but am unable to access anything inside. I can only see the main admin window.

I have no idea what to do now ....

FTR I used Filezilla.

[schoolboy]

You didn't "overwrite" the admin folder...

FTP does not overwrite entire folders - it can only overwrite FILES inside those folders - and ONLY IF the files are the same name and in the same path.

Is there a "SQL patch file" that comes with the module?

[ShakaDula14]

You didn't "overwrite" the admin folder...

FTP does not overwrite entire folders - it can only overwrite FILES inside those folders - and ONLY IF the files are the same name and in the same path.

Is there a "SQL patch file" that comes with the module?

yeah there is one in "extras - patched files for ZC1.3.8a/admin/admin.php

and one in "extras - patched files for ZC1.3.8a/admin/includes/languages/english.php


Oh, and now I just get a 403 forbidden screen for my admin login panel .....

~smacking head on table~

I think I just need to wait for some help instead of trying to move files around .......

**ADDED: FYI, I'm actually really panicking at the moment. I've never felt so stupid about working on a PC before ... it just feels like a bunch of bone headed decisions made in a rush out of panic .....

[schoolboy]

As none of these FILES in the module overwrite CORE files, when you re-loaded the 1.3.8 admin files, you STILL have these modules files in it.

It is POSSIBLE too, that you have damaged your configure.php file which is in

admin/includes/configure.php

CREATE a separate folder for it in your home computer hard drive...

Then, go to includes/configure.php and do the same (ie: port a copy back to your hard drive and pit it in a separate folder too

So you have COPIES of both on your hard drive:

admin/includes/configure.php
includes/configure.php

You do understand the difference between:

admin/includes/configure.php
includes/configure.php

Open up BOTH files (not at the same time) and see if the settings are similar.

Now... here's a bit of a radical step...

In your FTP program, RE-NAME the existing admin folder to admin_old

Then, FTP a fresh zencart 1.3.8a admin folder to the server.

Then, ftp the admin/includes/configure.php file to that location in the new admin folder.

[ShakaDula14]

As none of these FILES in the module overwrite CORE files, when you re-loaded the 1.3.8 admin files, you STILL have these modules files in it.

It is POSSIBLE too, that you have damaged your configure.php file which is in

admin/includes/configure.php

CREATE a separate folder for it in your home computer hard drive...

Then, go to includes/configure.php and do the same (ie: port a copy back to your hard drive and pit it in a separate folder too

So you have COPIES of both on your hard drive:

admin/includes/configure.php
includes/configure.php

You do understand the difference between:

admin/includes/configure.php
includes/configure.php

Open up BOTH files (not at the same time) and see if the settings are similar.

Now... here's a bit of a radical step...

In your FTP program, RE-NAME the existing admin folder to admin_old

Then, FTP a fresh zencart 1.3.8a admin folder to the server.

Then, ftp the admin/includes/configure.php file to that location in the new admin folder.

Okay,

First of all, yes, I understand what you mean.

I downloaded the 2 files and compared. They are identical.

[ShakaDula14]

As none of these FILES in the module overwrite CORE files, when you re-loaded the 1.3.8 admin files, you STILL have these modules files in it.

It is POSSIBLE too, that you have damaged your configure.php file which is in

admin/includes/configure.php

CREATE a separate folder for it in your home computer hard drive...

Then, go to includes/configure.php and do the same (ie: port a copy back to your hard drive and pit it in a separate folder too

So you have COPIES of both on your hard drive:

admin/includes/configure.php
includes/configure.php

You do understand the difference between:

admin/includes/configure.php
includes/configure.php

Open up BOTH files (not at the same time) and see if the settings are similar.

Now... here's a bit of a radical step...

In your FTP program, RE-NAME the existing admin folder to admin_old

Then, FTP a fresh zencart 1.3.8a admin folder to the server.

Then, ftp the admin/includes/configure.php file to that location in the new admin folder.

WOOT WOOT!!!!!!!

YOU ARE MY HERO!!!!!!!!!!!!

Your second "radical solution" did the trick!

Oh my God How can I EVER repay you for your help!?!?!?!?!

[schoolboy]

WOOT WOOT!!!!!!!

YOU ARE MY HERO!!!!!!!!!!!!

Your second "radical solution" did the trick!

Oh my God How can I EVER repay you for your help!?!?!?!?!

I think the best way to "repay" is this...

When you become an "expert" in years to come you can also help others...