Category Name and Categories Description now show on backend?

[holawill]

my site works well online, but when i move to localhost, the Category Name and Categories Description now show on backend,

on frontend i can see Category Name and Categories Description without any problems.

besides, for product name and description are the same situation.

my zencart version: v1.5.1
wampserver3.0.6_x86_apache2.4.23_mysql5.7.14_php5.6.25-7.0.10

i checked logs error:
[11-Nov-2016 07:46:46 UTC] PHP Warning: Invalid argument supplied for foreach() in D:\wamp\www\pinbadge\adminn\includes\ckeditor.php on line 15
[11-Nov-2016 07:46:46 UTC] PHP Stack trace:
[11-Nov-2016 07:46:46 UTC] PHP 1. {main}() D:\wamp\www\pinbadge\adminn\categories.php:0
[11-Nov-2016 07:46:46 UTC] PHP 2. include() D:\wamp\www\pinbadge\adminn\categories.php:559


how to solve my problem? thanks in advance.

[mc12345678]

My response relates to the PHP version/ZC version aspect that may play a factor as relates to the posted server requirements: http://www.zen-cart.com/content.php?...o-run-zen-cart

Otherwise things such as an incomplete database transfer/restoration may be involved, method of transfer, database problems, etc.

[carlwhat]

just a guess; i would think your languages table has no data...

prior to clicking on the edit category, you could also change the editor to plain text.

good luck.

[holawill]

i can make sure database complete transfer. The same database i tested on live server it works well.

So Zen Cart v1.5.1 is not compatible with PHP 5.6.25? this is the problem?

[holawill]

just a guess; i would think your languages table has no data...

prior to clicking on the edit category, you could also change the editor to plain text.

good luck.

Thanks. languages table has data, see below pic:


I also tested plain text editor before clicking on the edit category, still the same

[carlwhat]

#1 - i don't think this is a compatibility issue.
#2 - have you posted the complete debug log? i don't think the script should stop on a warning. please post the complete contents of the debug log.
#3 - post the contents on the ckeditor.php file.

[holawill]

#1 - i don't think this is a compatibility issue.
#2 - have you posted the complete debug log? i don't think the script should stop on a warning. please post the complete contents of the debug log.
#3 - post the contents on the ckeditor.php file.

#2, yes, i have posted the completed debug log, i checked again. by the way, when i select plain text, there's no error log, once i selected CKEditor, the error caused.
#3

<?php
/**
 * @package admin
 * @copyright Copyright 2010 Kuroi Web Design
 * @copyright Portions Copyright 2009 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: ckeditor.php 277 2010-05-22 14:09:32Z kuroi $
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}

$var = zen_get_languages();
$jsLanguageLookupArray = "var lang = new Array;\n";
foreach ($var as $key)
{
  $jsLanguageLookupArray .= "  lang[" . $key['id'] . "] = '" . $key['code'] . "';\n";
}
?>
<script type="text/javascript" src="<?php echo (strstr(HTTP_SERVER, 'ttps:') ? 'https' : 'http'); ?>://www.google.com/jsapi"></script>
<script type="text/javascript">if (typeof jQuery == 'undefined') google.load("jquery", "1");</script>
<script type="text/javascript" src="../<?php echo DIR_WS_EDITORS ?>ckeditor/ckeditor.js"></script>
<script type="text/javascript"><!--
$(document).ready(function() {
  <?php echo $jsLanguageLookupArray ?>
  $('textarea').each(function()    {
    if ($(this).attr('name') != 'message' && $(this).attr('class') != 'noEditor')
    {
      index = $(this).attr('name').match(/\d+/);
      if (index == null) index = <?php echo $_SESSION['languages_id'] ?>;
      CKEDITOR.replace($(this).attr('name'),
        {
          coreStyles_underline : { element : 'u' },
          width : 760,
          language: lang[index]
        });
    }
  });
});
//--></script>

[carlwhat]

the error message is complaining about line 15:

foreach ($var as $key)

in general, this problem is because $var is not an array.

$var gets established 2 lines above, in zen_get_languages. which is why i would think there is nothing in the languages table.

we can add the following line just above the foreach line to see what is in $var and post the results:

print_r($var);

[holawill]

the error message is complaining about line 15:

foreach ($var as $key)

in general, this problem is because $var is not an array.

$var gets established 2 lines above, in zen_get_languages. which is why i would think there is nothing in the languages table.

we can add the following line just above the foreach line to see what is in $var and post the results:

print_r($var);

>> I have added this line above the foreach line, but error logs are the same as before, no other errors.

<?php
/**
 * @package admin
 * @copyright Copyright 2010 Kuroi Web Design
 * @copyright Portions Copyright 2009 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: ckeditor.php 277 2010-05-22 14:09:32Z kuroi $
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}

$var = zen_get_languages();
$jsLanguageLookupArray = "var lang = new Array;\n";
print_r($var);
foreach ($var as $key)
{
  $jsLanguageLookupArray .= "  lang[" . $key['id'] . "] = '" . $key['code'] . "';\n";
}
?>
<script type="text/javascript" src="<?php echo (strstr(HTTP_SERVER, 'ttps:') ? 'https' : 'http'); ?>://www.google.com/jsapi"></script>
<script type="text/javascript">if (typeof jQuery == 'undefined') google.load("jquery", "1");</script>
<script type="text/javascript" src="../<?php echo DIR_WS_EDITORS ?>ckeditor/ckeditor.js"></script>
<script type="text/javascript"><!--
$(document).ready(function() {
  <?php echo $jsLanguageLookupArray ?>
  $('textarea').each(function()    {
    if ($(this).attr('name') != 'message' && $(this).attr('class') != 'noEditor')
    {
      index = $(this).attr('name').match(/\d+/);
      if (index == null) index = <?php echo $_SESSION['languages_id'] ?>;
      CKEDITOR.replace($(this).attr('name'),
        {
          coreStyles_underline : { element : 'u' },
          width : 760,
          language: lang[index]
        });
    }
  });
});
//--></script>

can can i do now?

[holawill]

the error message is complaining about line 15:
foreach ($var as $key)
in general, this problem is because $var is not an array.
$var gets established 2 lines above, in zen_get_languages. which is why i would think there is nothing in the languages table.
we can add the following line just above the foreach line to see what is in $var and post the results:
print_r($var);

-------------------------------------------------------------------
>> Thanks, I have added this line above the foreach line, but error logs are the same as before, no other errors.

<?php
/**
 * @package admin
 * @copyright Copyright 2010 Kuroi Web Design
 * @copyright Portions Copyright 2009 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: ckeditor.php 277 2010-05-22 14:09:32Z kuroi $
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}

$var = zen_get_languages();
$jsLanguageLookupArray = "var lang = new Array;\n";
print_r($var);
foreach ($var as $key)
{
  $jsLanguageLookupArray .= "  lang[" . $key['id'] . "] = '" . $key['code'] . "';\n";
}
?>
<script type="text/javascript" src="<?php echo (strstr(HTTP_SERVER, 'ttps:') ? 'https' : 'http'); ?>://www.google.com/jsapi"></script>
<script type="text/javascript">if (typeof jQuery == 'undefined') google.load("jquery", "1");</script>
<script type="text/javascript" src="../<?php echo DIR_WS_EDITORS ?>ckeditor/ckeditor.js"></script>
<script type="text/javascript"><!--
$(document).ready(function() {
  <?php echo $jsLanguageLookupArray ?>
  $('textarea').each(function()    {
    if ($(this).attr('name') != 'message' && $(this).attr('class') != 'noEditor')
    {
      index = $(this).attr('name').match(/\d+/);
      if (index == null) index = <?php echo $_SESSION['languages_id'] ?>;
      CKEDITOR.replace($(this).attr('name'),
        {
          coreStyles_underline : { element : 'u' },
          width : 760,
          language: lang[index]
        });
    }
  });
});
//--></script>

Can you please tell me what can i do now?