Cannot change values in admin

[amayernx]

Howdy, set up osCommerce 2.2 MS 2 on a Windows 2K3 Enterprise server, running IIS 6.0, PHP 5.2.1, MySQL 5.0.27, all latest and greatest and patched (sometimes it's good to be the king). I've turned on register_globals, long arrays, set the "read only" properties on the configure.php values to turn off that admin warning, and a few other handhacks because of the PHP 5 issues that present themselves, along with turning off MySQL 5's "strict" mode. Everything is hunky dory except for two things:

 

1. My newly minted Windows Vista Home Premium machine seems to get stuck when submitting forms, it just blanks the form out. Just me or is there a known issue I need to be looking at? My development box running XP Pro doesn't have this problem, and neither does anyone else in the shop (sometimes it's not good to be the king).

 

2. I cannot ADD/CHANGE values through the administration panel. I can go into the database and add/edit the values, but I'd like to give the other people in my shop the power to use the GUI that osCommerce provides. I can turn modules on and off, but I can't change options through the panel. Is there a PHP5/MySQL5/IIS6/Win2K3 conflict I'm unaware of? Is there some piece of code that doesn't play well with MySQL 5 databases?

 

As an aside, I can properly order things through the customer side, and the MySQL connection information is the same for both, plus my standard database connection tests come back clean.

 

I'm reasonably savvy, so even a push in the right direction woul be a huge help, as opposed to the current solution of wading through the codebase. I've searched for variations on being unable to edit values in the admin panel, but the results are useless/not related, so I humbly ask for your assistance.

[bkellum]

Anthony,

I hope you do not find this as useless. The following will fix the bug in osC 060817 modules not refreshing:

 

1. Open the catalog/admin/includes/functions/compatibility.php.

2. At the end of the “do_magic_quotes_gpc” routine, add the following code

 

reset($ar);

 

It will end up looking like this:

 

 

function do_magic_quotes_gpc(&$ar) {
if (!is_array($ar)) return false;
while (list($key, $value) = each($ar)) {
if (is_array($ar[$key])) {
do_magic_quotes_gpc($ar[$key]);
} else {
$ar[$key] = addslashes($value);
}
}
reset($ar);
}

3. Do the same for the compatibility.php file located in catalog/includes/functions/compatibility.php.

[amayernx]

Thanks! Worked like a charm! I hope this wasn't stickied somewhere and I've now cast myself into the "too stupid to search" category. Looks like it fixed both issues, which excites me a great deal. Now to show this off to the boss so we can get away from...whatever they're calling the existing shopping cart (I won't name names, but it's ASP-based and sucks).

 

Anthony,

I hope you do not find this as useless. The following will fix the bug in osC 060817 modules not refreshing:

 

1. Open the catalog/admin/includes/functions/compatibility.php.

2. At the end of the “do_magic_quotes_gpc” routine, add the following code

 

reset($ar);

 

It will end up looking like this:

 

 

function do_magic_quotes_gpc(&$ar) {
if (!is_array($ar)) return false;
while (list($key, $value) = each($ar)) {
if (is_array($ar[$key])) {
do_magic_quotes_gpc($ar[$key]);
} else {
$ar[$key] = addslashes($value);
}
}
reset($ar);
}

3. Do the same for the compatibility.php file located in catalog/includes/functions/compatibility.php.

[mindy]

Thanks bkellum,

I've spent few hours yesterday fiddling with OSC installation, Windows permissions, IIS settings etc till I found this post.

It works

Your help very appreciated

:rolleyes:

 

Anthony,

I hope you do not find this as useless. The following will fix the bug in osC 060817 modules not refreshing:

 

1. Open the catalog/admin/includes/functions/compatibility.php.

2. At the end of the “do_magic_quotes_gpc” routine, add the following code

 

reset($ar);

 

It will end up looking like this:

 

 

function do_magic_quotes_gpc(&$ar) {
if (!is_array($ar)) return false;
while (list($key, $value) = each($ar)) {
if (is_array($ar[$key])) {
do_magic_quotes_gpc($ar[$key]);
} else {
$ar[$key] = addslashes($value);
}
}
reset($ar);
}

3. Do the same for the compatibility.php file located in catalog/includes/functions/compatibility.php.