Hi there, Getting some warnings after upgrading to php 8:

Issue #1 - related to membership plugin

E_WARNING: Trying to access array offset on value of type bool (line 12)

The code:
if ($CURRENT_USER['member_approved'] == 1 && $CURRENT_USER['private_yacht_access'] == 1 ) {

Issue #2 - general php warning

#19595 - E_WARNING: Trying to access array offset on value of type null

In this block of code (see comments for where errors occuring)

<?php foreach ($yachtsRecords as $record): ?>

  <?php if ($record['yachtfolio_link_new']) {

    $yachtfolio_num = $record['yachtfolio_link_new'];
    list($link_redirectsRecords, $link_redirectsMetaData) = getRecords(array(
      'tableName'   => 'link_redirects',
      'where'       => "`num` = '". mysql_escape($yachtfolio_num) ."'",
      'loadUploads' => false,
      'allowSearch' => false,
      'limit'       => '1',
    ));
    $link_redirectsRecord = @$link_redirectsRecords[0];

      if ($link_redirectsRecord['link_destination']) {
        $linky = $link_redirectsRecord['link_destination']; // ERROR ON THIS LINE
      } else {
        $linky = $link_redirectsRecord['yachtfolio_link_destination'] . $settingsRecord['yachtfolio_id']; // ERROR ON THIS LINE
      }

    $linky_target = "_blank";

  } elseif ($record['yachtfolio_link']) {
    $linky = $record['yachtfolio_link'] . $settingsRecord['yachtfolio_id'];
    $linky_target = "_blank";
  
  } else {

    if ($yacht_typeRecord['num']==8) {
      $link = $record['_link'];
      $linky = strtolower(str_replace("yacht.php", "for-sale.php", $link));
      $linky_target = "_self";
    } else {
      $linky = strtolower($record['_link']);
      $linky_target = "_self";
    }

  }  
?>

Thanks for that, fixed the error from showing in the admin but still getting the following errors in the log (see attached also)

E_NOTICE: Undefined index: listType
/cms/lib/menus/default/edit_functions.php (line 767)
/cms/admin.php?menu=blog&action=edit&num=79

E_NOTICE: Undefined index: listType
/cms/lib/menus/default/edit_functions.php (line 762)
/cms/admin.php?menu=blog&action=edit&num=79

BTW, forgot to mention this is v3.54 (Build 2280)

<?

// list fields w/ advanced filters - add onchange event handler to local filter field
  if (@$fieldSchema['filterField']) {
    $targetListField = $fieldSchema['name'];
    $filterSchema    = $GLOBALS['schema'][$fieldSchema['filterField']];
    // $sourceField     = ($filterSchema['listType'] == 'checkboxes' || $filterSchema['listType'] == 'pulldownMulti')? $filterSchema['name']."[]" : $filterSchema['name'] ;
    $sourceField = (!empty($filterSchema['listType']) && ($filterSchema['listType'] == 'checkboxes' || $filterSchema['listType'] == 'pulldownMulti'))? $filterSchema['name']."[]" : $filterSchema['name'] ;

    ?>
    <script type="text/javascript"><!--
      $("[name='<?php echo $sourceField; ?>']").change(function () {
        <?php if($filterSchema['listType'] == 'pulldownMulti'): ?>
          newFilterValue = "\t";
          $.each($("[name='<?php echo $sourceField ?>']").select2('data'), function( key, selectedOption ) {
            newFilterValue = newFilterValue + selectedOption.id + "\t" ;
          });
        <?php elseif($filterSchema['listType'] == 'checkboxes') : ?>
          newFilterValue = "\t";
          $("[name='<?php echo $sourceField ?>']:checked").map(function(){
            newFilterValue = newFilterValue + $(this).val()+ "\t" ;
          });
        <?php else: ?>
          var newFilterValue  = this.value;
        <?php endif; ?>

        var targetListField = '<?php echo $targetListField ?>';
        updateListFieldOptions(targetListField, newFilterValue);
      });
    // --></script>

Getting Undefined index: listType errors on a list field that's using the mySQL advanced option to join two fields together:

SELECT num, CONCAT(name, ' - ',size)
FROM `<?php echo $TABLE_PREFIX ?>products`

The list gets output fine in the cms, but has errors at the end:

E_NOTICE: Undefined index: listType
/cms/lib/menus/default/edit_functions.php (line 766)
/cms/admin.php?menu=blog&action=edit&num=79

E_NOTICE: Undefined index: listType
/cms/lib/menus/default/edit_functions.php (line 761)
/cms/admin.php?menu=blog&action=edit&num=79

E_NOTICE: Undefined index: listType
/cms/lib/menus/default/edit_functions.php (line 757)
/cms/admin.php?menu=blog&action=edit&num=79

Size can sometimes be blank in case that helps.

Any tips to fix this? Thanks :)

$geoid = "AU";

// load record from 'banners'
list($bannersRecords, $bannersMetaData) = getRecords(array(
'tableName' => 'banners',
'where' => "`country_code` LIKE '". mysql_escape($geoid) ."'",
'loadUploads' => false,
'allowSearch' => false,
'limit' => '1',
));
$bannersRecord = @$bannersRecords[0]; // get first record

country_code has a list of id's in it separated by comma's like this:

AU,NZ,US

What should I use for 'where' => 

Many thanks :)

SELECT SQL_CALC_FOUND_ROWS `yachts`.*
FROM `cms_yachts` as `yachts`
 WHERE (type IN ('motor','sailing','catamaran','power-catamaran','gulet','motorsail','mega-yacht') AND active ='1' AND hide ='0' AND private ='1' ) 

but Im still not getting back any results. Is it because the type field in the yacht table is holding multiple text values separated by tabs? e.g.

"	gulet	"
"	sailing	gulet	motorsail	"
"	gulet	motorsail	"

Here's my code:

if ($CURRENT_USER['preferred_yacht_types']) {
  $preferred_yacht_types = explode("\t", trim($CURRENT_USER['preferred_yacht_types']));
  $user_yacht_type = mysql_escapeCSV($preferred_yacht_types);
} else {
  $user_yacht_type = "";
}

list($yachtsRecords, $yachtsMetaData) = getRecords(array(
  'tableName'   => 'yachts',
  'where'     => "type IN (" . $user_yacht_type . ") AND active ='1' AND hide ='0' AND private ='1' ",
  'loadUploads' => true,
  'allowSearch' => true,
  'useSeoUrls'  => true,
  'limit'       => 3,
  'debugSql'    => true,
));

I have a user who has been tagged with multiple yacht types that they are interested in:

$CURRENT_USER['preferred_yacht_types']

So the value in here might be something like this:

 2 3 4 

How do I setup the select statement to bring back all yachts that match any one of these values? This is what I have so far:

<?php // load records from 'yachts'
if ($CURRENT_USER['preferred_yacht_types']) {
$user_yacht_type = $CURRENT_USER['preferred_yacht_types'];
} else {
$user_yacht_type = "";
}
list($yachtsRecords, $yachtsMetaData) = getRecords(array(
'tableName'   => 'yachts',
'where'     => "type LIKE '". mysql_escape($user_yacht_type) ."'" . ' AND active ="1"' . ' AND hide ="0"' . ' AND private ="1"', 
'loadUploads' => true,
'allowSearch' => false,
'useSeoUrls'    => true,
'limit' => 3,
'debugSql' => true,
)); ?>

Thanks in advance for your help

https://www.sailconnections.com/destinations/south-pacific/new-caledonia/?gclid=EAIaIQobChMInfeJ6oKI4gIVExWPCh0RnQ0XEAAYASAAEgKpkfD_BwE

but if I strip off some of the code it works:

https://www.sailconnections.com/destinations/south-pacific/new-caledonia/?gclid=EAIaIQobChMInfeJ6oKI4gIVExWPCh0RnQ0XE

Any Idea why that might be the case?

MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE name IS NOT NULL AND name != ''' at line 4

For the following:

SELECT num, name
FROM `<?php echo $TABLE_PREFIX ?>itineraries`
ORDER BY name ASC
WHERE name IS NOT NULL AND name != ''

None of these WHERE options work:

WHERE name IS NOT NULL AND name != ''

WHERE name IS NOT NULL

WHERE name != ''

Could it be related to still using an older version of php?

SELECT num, name
FROM `itineraries`
ORDER BY name ASC
WHERE name IS NOT NULL
WHERE name != ''

For this I assume I need to use the "get options from MYSQL query" ? Just looking for some guidance on how to use this feature. 

See attached admin screen 

Many thanks!

For example:

This query only returns 3 yachts:

https://www.sailconnections.com/yachts.php?yacht_type=2&charter_type=1&yacht_name_query%2Cmeta_description_query%2Cintro_query%2Cdescription_query=Lagoon

If I search in the admin I get 10 results (see attached)

If I remove the keyword and just search for yacht_type and charter_type I can see there are 10 yachts with the name Lagoon:

https://www.sailconnections.com/yachts.php?yacht_type=2&charter_type=1

If I remove the other fields from the keyword search it does work:

https://www.sailconnections.com/yachts.php?yacht_type=2&charter_type=1&yacht_name_query=Lagoon

e.g. yacht_name_query%2Cmeta_description_query%2Cintro_query%2Cdescription_query=Lagoon >> yacht_name_query=Lagoon

so maybe Im doing something wrong with that, can you only have one query field?

Any suggestions?

A Geocoder plugin for a client stopped working so we have upgraded and added an API key. Now we are getting the following error message:

Bad response from Google geocoder API: REQUEST_DENIED
plugins/geocoder/geocoder.php (line 145)

Application restrictions: None  
API restrictions: None

Any suggestions? 

#3686 - E_USER_NOTICE: DEBUG - Record Number: num = '274'
/home/luxurychartergroup/luxurychartergroup.com/fr/post.php (line 17)
https://www.luxurychartergroup.com/fr/post.php/yacht-rapide-274/

I suspect its related to the php files with a similar name as well, but not sure what to do next, any suggestion?

• 404: luxurychartergroup.com/fr/post.php/yacht-rapide-274/
• 200: luxurychartergroup.com/fr/post.php/rapide-274/

OR

• 404: luxurychartergroup.com/post.php/destinations-eloigne-249/
• 200: luxurychartergroup.com/post.php/destination-eloigne-249/

See attached page code. I also checked the htaccess file and no weird rules in there. 

Any idea what might be causing this?

CMS Builder v3.14 + plugins (see attached)

Many thanks