Help ... Please ...

[Nev]

Since upgrading to MySQL 3.23.49 my Zones have stop displaying. There in the table, but the admin applicaiton does not display any of the zones.

 

This is causing me a big problem as new users who sign up to the store are unable to vaildate their county, thus they cannot register and not order any products. Sob Sob.

 

I have looked every where and cannot seem to find the problem.

 

Any pointers would be extremly appreciated.

 

Thanks

Nev :(

[Nev]

This is the code in the zones.php file.

 

<?php

 $zones_query_raw = "select z.zone_id, c.countries_id, c.countries_name, z.zone_name, z.zone_code, z.zone_country_id from " . TABLE_ZONES . " z, " . TABLE_COUNTRIES . " c where

z.zone_country_id = c.countries_id order by c.countries_name, z.zone_name";

 $zones_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $zones_query_raw, $zones_query_numrows);

 $zones_query = tep_db_query($zones_query_raw);

 while ($zones = tep_db_fetch_array($zones_query)) {

   if (((!$HTTP_GET_VARS['cID']) || (@$HTTP_GET_VARS['cID'] == $zones['zone_id'])) && (!$cInfo) && (substr($HTTP_GET_VARS['action'], 0, 3) != 'new')) {

     $cInfo = new objectInfo($zones);

   }



   if ( (is_object($cInfo)) && ($zones['zone_id'] == $cInfo->zone_id) ) {

     echo '              <tr class="dataTableRowSelected" onmouseover="this.style.cursor='hand'" onclick="document.location.href='' . tep_href_link(FILENAME_ZONES, 'page=' .

$HTTP_GET_VARS['page'] . '&cID=' . $cInfo->zone_id . '&action=edit') . ''">' . "n";

   } else {

     echo '              <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" oncli

ck="document.location.href='' . tep_href_link(FILENAME_ZONES, 'page=' . $HTTP_GET_VARS['page'] . '&cID=' . $zones['zone_id']) . ''">' . "n";

   }

?>

               <td class="dataTableContent"><?php echo $zones['countries_name']; ?></td>

               <td class="dataTableContent"><?php echo $zones['zone_name']; ?></td>

               <td class="dataTableContent" align="center"><?php echo $zones['zone_code']; ?></td>

               <td class="dataTableContent" align="right"><?php if ( (is_object($cInfo)) && ($zones['zone_id'] == $cInfo->zone_id) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow

_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ZONES, 'page=' . $HTTP_GET_VARS['page'] . '&cID=' . $zones['zone_id']) . '">' . tep_image(DIR_WS_IMAGES . 'ic

on_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>

             </tr>

<?php

[Nev]

Sorted. The Countries_id did not match any in the table...

 

Not sure how that happened?

 

Nev

 

Panic Over.... :P