cannot edit in admin panel

Try in the SQL a search on:

SELECT * FROM mmb_configuration WHERE use_function LIKE '%mmb%';

What comes up on that?

Then, go to your Zen Cart Admin and in the Tools ... Developers Tool Kit ... in the bottom input box enter:
mmb_

and do a search of the Catalog/Admin and see what comes up ...

When I enter "SELECT * FROM mmb_configuration WHERE use_function LIKE '%mmb%';" I get 37 lines. What am I looking for?

When I type in mmb_ I get the following:
/home2/fettaffe/public_html/zencart/includes/configure.php

Line #54 : define('DB_PREFIX', 'mmb_');

/home2/fettaffe/public_html/zencart/zenadmin/includes/configure.php

Line #68 : define('DB_PREFIX', 'mmb_');

This is my most recent debug file.

[08-Jun-2013 07:56:53 America/Denver] PHP Fatal error: Call to undefined function mmb_cfg_select_option() in /home2/fettaffe/public_html/zencart/zenadmin/modules.php(315) : eval()'d code on line 1

Don't understand code but does it mean anything to you?

In phpMyAdmin when you enter in the SQL:

SELECT * FROM mmb_configuration WHERE use_function LIKE '%mmb%';

Nothing should come up ...

If you are getting any results, can you post a good screen shot of it so we can see what configuration_keys might have those in the use_function?

I cannot see it until after I post it. If not big enough I will try something else.

Here is the right hand side of the screen.

I am trying to reload the images but it keeps failing.

This is the top left hand of the screen.

This is the top right side of the screen.

The fields:
use_function
set_function

should not contain things that start with:
mmb_

those should all start with:
zen_

I am not sure how all of those got changed to:
mmb_

and if you were to search for:

SELECT * FROM mmb_configuration WHERE set_function LIKE '%mmb%';

you would come up with a lot more records ...

Is this a new install of Zen Cart? Or is this a database with a lot of Products, Categories, Orders, Customers etc.

This is middle of screen left side

This is middle of screen right side.

Do you need to see all lines?

No ...

So far, things are not looking good ...

What comes up if your run in the SQL:

SELECT * FROM mmb_product_type_layout WHERE set_function LIKE '%mmb%';

and if you run:

SELECT * FROM mmb_product_type_layout WHERE use_function LIKE '%mmb%';

I do not need to see them, just need to know if any rows come up from the table:
mmb_product_type_layout

Before I check your latest post, I noticed that in the configuration screen of the admin panel that country and zone are blank. The three entries that are above that, I can edit. The entries below cannot be edited. The edit screen goes away. Here is a screen shot.

I was searching the forum and from an earlier post, you had someone type in STORE_NAME into the developers tool box, top line to see what happens. I did that for the top three lines and everything looked ok. When I typed in COUNTRY or ZONE, I got error messages. No matching configuration keys were found. Could this be part of the problem? The country and zone used to be there if I remember correctly.

You mentioned in the beginning, that you had changed hosting providers ...

How did your database get installed from your old hosting provider's server to your new hosting provider server?

Did they do the transfer for you or did you import all of your data for your database or how was this done?

The first string comes back with 134 rows, the second string comes back nothing.

I hired a computer guy (local) to do it. He is not good about answering my emails. Just got married and works another full time job. My oldest daughter knows him and says he is very intelligent. I could ask him your questions and wait for an answer.
I noticed in the manual that I downloaded when I set up the store in the beginning, that you need to enter the country and zone for things to work properly. Problem is, that can't be done.

The fields that we have been looking at that have the:
mmb_

in them in the two database tables as functions that the code needs to run various things about the data and managing editing/updating etc.

So where all those mmb_somethings are, they should all be zen_somethings that are the real functions in Zen Cart code ...

So what is happening is where those functions need to be run, they are calling the wrong functions and this is making everything appear to be broken ...

The problem is, how far reaching is the issue and whether or not there are other issues here ...

Has your site been Live since moving to the new hosting provider? Or are you just trying to get things working at this point?

I am hoping your computer guy has a good copy of your database from your old hosting provider or from before everything broke ...

While I might be able to give you 4 commands to run in the SQL to fix all of this, I do not know if that would ensure the integrity of your data ... so, I am rather hoping you can get a hold of your computer guy before we try anything like that to attempt to fix your database, unless there are no other possible alternatives of getting the database loaded with 100% good data ...

Yes, the site has been live since the transfer and I have had an order. I don't have a lot of products so if push comes to shove, I guess that I could just redo the whole thing.

I am not keen on this being the only solution, as other data could also be corrupt, but you can try it ...

Backup your database then runn these 4 SQL commands:

update mmb_configuration set set_function = replace(set_function,'mmb_','zen_');

update mmb_configuration set use_function = replace(use_function,'mmb_','zen_');

update mmb_product_type_layout set set_function = replace(set_function,'mmb_','zen_');

update mmb_product_type_layout set use_function = replace(use_function,'mmb_','zen_');

Otherwise, you may have to start from scratch if your computer guy is unable to restore your original backup of your database ...

Not knowing a whole lot about computers, php, sql's, and all the other lingo, as nervous as I was about doing this, guess what??? IT WORKED!!! Thank you so much for your time and trouble, it even populated the country of origin in the configuration dropdown menu where it was blank before. I guess time will tell if other parts are corrupted or not.
I guess I owe you a "cup o' coffee" (donation). :cheers: