Edit button gone

[JakeLawless]

jake,
not sure how your database got screwed up. assuming you ran the query correctly.

i ran the following sql commands:

SELECT count(*)
FROM `configuration`;

SELECT count(*) FROM `configuration` WHERE `set_function` LIKE 'cfg_select_option%';

SELECT count(*) FROM `configuration` WHERE `set_function` LIKE 'zen_cfg_select_option%';

my counts are:

919
0
425

now your numbers can be different; but your problem is that the 2nd query should be 0. unless you have defined a function call cfg_select_option which does NOT look to be part of the ZC base package.

best.

Just ran it and my counts are;

1298
385
28


?

[carlwhat]

jake,
you are a funny guy. i admire your resourcefulness.

#1 - your database is screwed up. someone did that. someone with access to your database. perhaps you accidentally did it; or someone before you. it does NOT strike me as a hacker. it does strike me as an admin making a mistake.
#2 - perhaps this link will shed some light on the situation you are in:
https://www.zen-cart.com/showthread....fter-upgrading
#3 - great people over at stackoverflow. some of us here are even over there. your reputation of 1 suggests you are not an avid user of that site. and your question getting downvoted is indicative of that.
#4 - you will have better odds of getting your problem resolved here on the ZC forum than there. but again, props to u for trying over there.

now back to your problem at hand. your db is screwed up. hopefully you read the link i provided above and perhaps you understood it. the question to me is whether there are other zen_cfg_* functions that were replaced or not. you can compare the count my running this sql statement:

SELECT count(*) FROM `configuration` WHERE `set_function` LIKE 'cfg_%';

you can compare to the count of 385 to see if there are other problems. again, this total should be 0.

if there are more functions that got removed in the database, then i would suggest to you to fix the database. not an easy process, although doable for sure. that is probably the ideal method. if it is just this one function that is screwed up in the database, ie the above query came up with 385, then you can create a file here:

/YOUR_ADMIN/includes/extra_datafiles/admin_mods.php

with the following code:

function cfg_select_option($select_array, $key_value, $key = '') {
    return zen_cfg_select_option($select_array, $key_value, $key);
} 

good luck.

[carlwhat]

ok, 1 last thing. i'm guessing that the problem is not related to only zen_cfg_select_option, but also to any zen_cfg_* function.

you can try the following 2 mysql commands. the first 1 will make a copy of your configuration table, the 2nd one will replace any problem set functions with hopefully the correct one. please note that mysql commands come with no warranty of any kind, and really run the risk of losing data. so ensure you have a good backup.

CREATE TABLE configuration_bkp AS (SELECT * FROM configuration);

UPDATE configuration
SET set_function = REPLACE(set_function, 'cfg', 'zen_cfg')
WHERE `set_function` LIKE 'cfg_%';

i have tested both of these mysql commands, but again, use with caution.

best.