Error creating the list field

Hi Perch,

Are there any steps that I can take to recreate this error?

What version of CMS Builder are you using?

Can you post the link to the previous link with Dave so I can read up on the history? I searched for it but was unable to locate it.

Thanks!

Hi, Damon -

I have a number of sites running CMSB 2.65 and they all generate the error a few times every week. 

The weirdest thing is I can never replicate the error myself! I am used to receiving instant notifications from CMSB when there's a problem. This usually happens when a page is viewed which has some bad code. However, with this problem, my own activity never triggers the error. When an email notification comes in I immediately head off to the page in question to see if I can do "something" to make the error fire again - but it never happens!

I don't think this is an admin related issue. That seems to suggest it is being caused by (a) user activity or (b) some kind of bot activity.

Below are some error messages from various sites. The first one is interesting in that the page in question repeatedly generates the error. This is the only time this problem has ever created a "pattern".

E_USER_ERROR: There was an error creating the list field ''.
Query:
MySQL Error: Query was empty
$fieldSchema =
debug_backtrace: =

...etc/cmsb/lib/database_functions.php (line 592)
http://www.missiontogether.org.uk/little-way-week%20?num=41



E_USER_ERROR: There was an error creating the list field ''.
Query:
MySQL Error: Query was empty
$fieldSchema =
debug_backtrace: =


..etc/cmsb/lib/database_functions.php (line 592)
http://www.ashridgecommunications.com/



E_USER_ERROR: There was an error creating the list field ''.
Query:
MySQL Error: Query was empty
$fieldSchema =
debug_backtrace: =


..etc/cmsb/lib/database_functions.php (line 592)
http://www.theassaultgroup-shop.co.uk/index.php?blog=296



E_USER_ERROR: There was an error creating the list field ''.
Query:
MySQL Error: Query was empty
$fieldSchema =
debug_backtrace: =


..etc/cmsb/lib/database_functions.php (line 592)
http://theassaultgroup-shop.co.uk

Any thoughts?

:0/

Perch

Hi Perch, 

We added some error checking code to v3.00 and later for this in /lib/error_functions.php

  // detect servers with broken print_r (Seen July 2015 on 1&1 UK Shared Hosting Package occurs on HEAD request after any content sent, and causes our error logs to be blank!
  $brokenFunctions = array();
  ob_start(); echo '1'; $ob_get_clean_response = ob_get_clean();
  if (print_r(1, true) != '1')       { $brokenFunctions[] = "print_r"; }
  if ($ob_get_clean_response != '1') { $brokenFunctions[] = "ob_get_clean"; }
  if ($brokenFunctions) {
    $errorMessage = "WARNING: Server has broken PHP functions: " .implode(', ', $brokenFunctions). ". "
                  . "PHP software may not function correctly!  Please contact support for assistance.\n\n"
                  . "Original error: $errorMessage";
  }

If you upgrade to the latest version of CMSB those should appear.  It's just some kind of glitch with your web host.  If it's not causing any problems you could try just ignoring it.

Hope that helps!