<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title></title>
        <link>https://interactivetools.com/forum/forum-search.php?k=user%3Aeduran582</link>
        <description></description>
        <pubDate>Wed, 20 May 2026 06:31:12 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-search.php?k=user%3Aeduran582&amp;rss=1" rel="self" type="application/rss+xml" />

                <item>
          <title>Error Log will not display</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2237806#post2237806</link>
          <description><![CDATA[<p>Hey Dave and DreamSync,</p>
<p>I tried what you suggested Dave (admin.php?menu=_error_log&amp;perPage=10) and the page came up.  The last error reported was: E_ERROR: Allowed memory size of 134217728 bytes exhausted (tried to allocate 6537037 bytes) so it appears it's as you said (more data is loaded on the error log page then PHP can hold in memory).  Once I cleared the log, I was able to access it again.</p>
<p>Thanks!</p>
<p>Eric</p>]]></description>
          <pubDate>Fri, 04 Dec 2015 14:16:12 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2237806#post2237806</guid>
        </item>
                <item>
          <title>Error Log will not display</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2237659#post2237659</link>
          <description><![CDATA[<p>Hi Damon,</p>
<p>Thanks for the reply.  I can see it listed at the bottom in the left navigation it's just when I click on it to see the errors, a blank page displays.  It's been working fine but recently (a few days ago), I suddenly cannot see the errors and each time I try and go 'back', it increments by one.</p>
<p>Eric</p>
<p>Forgot to include the last errors that were emailed to me in case this helps:</p>

<p>Latest errors:</p>
<p>Oct 31st, 2015 - 03:34:47 PM<br /> E_NOTICE: Undefined index: menuName<br /> /home/content/.../cmsAdmin/lib/menus/_error_log/actionHandler.php (line 19)<br /><a href="https://www.cmpdsites.com/cmsAdmin/admin_265-1122.php?menu=_error_log" rel="nofollow">https://www.cmpdsites.com/cmsAdmin/admin_265-1122.php?menu=_error_log</a><br /><br /> Oct 31st, 2015 - 03:34:47 PM<br /> E_NOTICE: Undefined index: listPageOrder<br /> /home/content/.../cmsAdmin/lib/menus/default/list_functions.php (line 57)<br /><a href="https://www.cmpdsites.com/cmsAdmin/admin_265-1122.php?menu=_error_log" rel="nofollow">https://www.cmpdsites.com/cmsAdmin/admin_265-1122.php?menu=_error_log</a><br /><br /> Oct 31st, 2015 - 03:24:16 PM<br /> E_ERROR: Allowed memory size of 134217728 bytes exhausted (tried to allocate 6377140 bytes)<br /> /home/content/.../cmsAdmin/lib/viewer_functions.php (line 433)<br /><a href="https://www.cmpdsites.com/cmsAdmin/admin_265-1122.php?menu=_error_log" rel="nofollow">https://www.cmpdsites.com/cmsAdmin/admin_265-1122.php?menu=_error_log</a></p>]]></description>
          <pubDate>Mon, 02 Nov 2015 11:04:02 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2237659#post2237659</guid>
        </item>
                <item>
          <title>Error Log will not display</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2237655#post2237655</link>
          <description><![CDATA[<p>I cannot get the error log to open.  I've looked for a table to check but cannot find one.  I get notification in my email of errors.  Where are the errors stored?  All the other functions work great; just can't see the contents of the error log.</p>
<p>Eric</p>]]></description>
          <pubDate>Sat, 31 Oct 2015 15:33:59 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2237655#post2237655</guid>
        </item>
                <item>
          <title>Problem passing variable with mysql SELECT</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2235950#post2235950</link>
          <description><![CDATA[<p>Support ticket submitted...</p>
<p>Thanks again!</p>]]></description>
          <pubDate>Mon, 02 Feb 2015 11:43:14 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2235950#post2235950</guid>
        </item>
                <item>
          <title>Problem passing variable with mysql SELECT</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2235945#post2235945</link>
          <description><![CDATA[<p>Hi again Claire,</p>
<p>I was using the htmlencode because it's what is generated when I use the "Code Generator" in CMSB.  I subsequently have taken out that reference but alas, still no luck. BTW, the 'test' var subjects all have email and phone numbers...</p>
<p>I've attached the test file for you to look at that I've been using to try to narrow down what's happening.  Maybe another set of eyes (yours) can see what I'm sure I've been missing.</p>
<p>I forgot to mention in my info that I'm using version 2.63 (Build 1092) of CMSB; not sure that matters.</p>
<p>Again, thanks for your time!</p>
<p>Eric</p>]]></description>
          <pubDate>Mon, 02 Feb 2015 11:03:05 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2235945#post2235945</guid>
        </item>
                <item>
          <title>Problem passing variable with mysql SELECT</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2235939#post2235939</link>
          <description><![CDATA[<p>Hi Claire,</p>
<p>Thanks for replying!  I added both var-dumps (separately) and both displayed the same data (the variable $readr name).  However, I did notice the length of each string was one more than the actual string; e.g., string(10) "Bill Hull" showed a length of 10 even though it is only 9 characters in length.  Using the trim, ltrim or rtrim made no difference.  Is there a 'hidden' character when using htmlencode($record['reader']) -- specifically the htmlencode -- when retrieving the field from the table using  foreach($scheduledRecords as $record); specifically at the beginning?  I'm guessing not because when I just used $record['reader'] it still made no difference.</p>
<p>I've even tried looping through the 'readers' table and when the variable is used it still does not 'see' the contents.  BUT when I hardcode the name instead of using the variable, it works every time.  Funny thing is, the mysql code is used in other modules and it works fine!  If I ONLY use the mysql statement and assign a variable ($readr = 'Bill Hull'), it works so I'm thinking it has something to do with the foreach process when extracting the record from the table using the foreach clause.</p>
<p>Server Info:<br />PHP Version: PHP v5.3.24<br />Database Server:  MySQL v5.0.96</p>
<p>I appreciate your time and thank you in advance for ANY suggestions.</p>
<p>Eric</p>]]></description>
          <pubDate>Mon, 02 Feb 2015 10:24:36 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2235939#post2235939</guid>
        </item>
                <item>
          <title>Problem passing variable with mysql SELECT</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2235933#post2235933</link>
          <description><![CDATA[<p>Hi all,</p>
<p>I'm having a problem with the mysql SELECT not passing the variable I'm using.  Here's the code:</p>
<p><code>foreach ($scheduledRecords as $record){<br />    $readr = htmlencode($record['reader']);      <br />    $check = mysql_query("SELECT email, phone FROM cms_readers WHERE full_name = '" . mysql_real_escape_string($readr) . "'") or die(mysql_error());<br />      $check2 = mysql_num_rows($check);<br />      // if reader exists get email address<br />      if($check2 &gt; 0){<br />          while($ifo = mysql_fetch_array( $check )){<br />          $r_em = $ifo['email'];<br />          $r_ph = $ifo['phone'];<br />        }<br />       }else{<br />            $r_em = '';<br />            $r_ph = '';<br />      }<br />}<br /></code></p>
<p>$readr is the variable that is not accepted and is taken from another table.  If I put the actual reader name in, it finds the record ($check2 is &gt; 0).  This same code works in other files but no matter how I try to duplicate it, it still will not pass the $readr variable.</p>
<p>Any ideas?</p>
<p>Please help to preserve my sanity!</p>
<p>Thanks in advance,</p>
<p>Eric</p>]]></description>
          <pubDate>Sun, 01 Feb 2015 11:30:05 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2235933#post2235933</guid>
        </item>
                <item>
          <title>Error with CMSB in WordPress</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2217417#post2217417</link>
          <description><![CDATA[Hi all,<br /><br />I have CMSB installed with the latest WordPress version (with the &quot;Exec-PHP&quot; plugin.)  When ever I put just the generated &quot;top&quot; code on a page:<br /><br /><code>$libraryPath = 'cmsAdmin/lib/viewer_functions.php';<br />$dirsToCheck = array('&lt;abs path&gt;','','../','../../','../../../');<br />foreach ($dirsToCheck as $dir) { if (@include_once(&quot;$dir$libraryPath&quot;)) { break; }}<br />if (!function_exists('getRecords')) { die(&quot;Couldn't load viewer library, check filepath in sourcecode.&quot;); }</code><br /><br />I get the following 'notice' at the bottom of the WordPress page:<br /><br />&quot;Notice: Undefined index: none in /home/.../wp-content/themes/itheme2/footer.php on line 16 Warning: Invalid argument supplied for foreach() in /home/.../html/wp-content/themes/itheme2/footer.php on line 16&quot;<br /><br />I've tracked it down to the third line, &quot;foreach ($dirsToCheck...&quot;, and when I comment out that line, the error does not appear (and of course, the program halts.)  Knowing where the cmsAdmin dir is located, I also tried replacing the code using:<br /><br /><code>require_once &quot;/home/.../html/cmsAdmin/lib/viewer_functions.php&quot;;</code><br /><br />but that didn't make any difference and the error still appeared.<br /><br />FYI, when the code is executed, it displays fine (list pages, detail pages, etc.) but still shows the 'Notice' at the bottom.<br /><br />The area the 'Notice' refers to in the 'footer.php' page is:<br /><code>&lt;?php foreach($columns[$footer_widget_option] as $col): ?&gt;<br />	&lt;?php<br />		 $x++;<br />		 if($x == 1){<br />			  $class = &quot;first&quot;;<br />		 } else {<br />			  $class = &quot;&quot;;<br />		 }<br />	?&gt;<br />	&lt;div class=&quot;&lt;?php echo $col;?&gt; &lt;?php echo $class; ?&gt;&quot;&gt;<br />		 &lt;?php if (@!function_exists('dynamic_sidebar') || !dynamic_sidebar('Footer_Widget_'.$x) ) ?&gt;<br />	&lt;/div&gt;<br />&lt;?php endforeach; ?&gt;</code><br />(with 'line 16 being the first line.)<br /><br />Any suggestions to try to get rid of that notice?<br /><br />TIA,<br /><br />Eric<br />]]></description>
          <pubDate>Sat, 11 Aug 2012 12:11:14 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2217417#post2217417</guid>
        </item>
                <item>
          <title>Re: [eduran582] WordPress and spambotEmailProtector</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2215998#post2215998</link>
          <description><![CDATA[Hi Jason,<br /><br />FOLLOW-UP:<br />Your suggestion didn't make any difference but I did find a WordPress plugin that seems to use a simple encode process to prevent webbots from harvesting email addresses.  I'm sure there are others but this one works for me.<br /><br />In their words:  &quot;Found email addresses are replaced with the return value of eae_encode_str() (changeable), which obfuscates the email addresses to protect it from being read by email-harvesting robots.&quot;<br /><br />Maybe that will be helpful to others looking for some sort of email security when using WordPress and CMSB together on the same page.<br /><br />Thanks again for your quick reply.<br /><br />Eric<br />]]></description>
          <pubDate>Mon, 30 Apr 2012 14:27:27 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2215998#post2215998</guid>
        </item>
                <item>
          <title>Re: [Jason] WordPress and spambotEmailProtector</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2215994#post2215994</link>
          <description><![CDATA[Thanks, Jason.  I'll give it a try and report back.<br />]]></description>
          <pubDate>Mon, 30 Apr 2012 13:05:18 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2215994#post2215994</guid>
        </item>
                <item>
          <title>WordPress and spambotEmailProtector</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2215991#post2215991</link>
          <description><![CDATA[Hi all,<br /><br />I have spambotEmailProtector activated but when I hover over the email address in a WordPress page, it does not show the usual &quot;encrypted&quot; address like when using a 'regular' php page (not in WordPress.)  The WordPress page has php in it (using the &quot;exec-php&quot; plugin) and the page contains a simple 'list' table that contains the usual code at the top including the required:<br /><br /><code>$libraryPath = 'cmsAdmin/lib/viewer_functions.php';</code><br /><br />Is there something I have to do to enable this feature when using it with WordPress?<br /><br />TIA,<br /><br />Eric<br />]]></description>
          <pubDate>Mon, 30 Apr 2012 12:47:08 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2215991#post2215991</guid>
        </item>
                <item>
          <title>Re: [Dave] CMSB Security</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2215785#post2215785</link>
          <description><![CDATA[Hey Dave,<br /><br />Thanks for the help.  I think I found the cause of all those &quot;errors&quot; and was actually me closing mySQL before I should have.  <br /><br />A series of checks was done to verify logon credentials that when correct, redirected the user to another page (header(&quot;Location: xxxx.php&quot;)) where additional mysql_query's continued.  Commenting out the mysql_close() eliminated that error from showing up.<br /><br />Please let me know if you still want me to send the viewer_functions.php file.<br /><br />Again, thanks for the great support!!<br /><br />Eric<br />]]></description>
          <pubDate>Tue, 10 Apr 2012 01:11:45 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2215785#post2215785</guid>
        </item>
                <item>
          <title>Re: [Jason] CMSB Security</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2215781#post2215781</link>
          <description><![CDATA[Hi Jason,<br /><br />Thanks for the reply!  The server is a vds and to my knowledge has not gone down is some time.  Nevertheless, I ran the &quot;optimize tables&quot; in the mySQL Admin and no errors showed up.  I'll keep an eye on the logs to see if anything else occurs.<br /><br />Thanks again for the insight!<br /><br />Eric<br />]]></description>
          <pubDate>Mon, 09 Apr 2012 17:26:35 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2215781#post2215781</guid>
        </item>
                <item>
          <title>CMSB Security</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2215769#post2215769</link>
          <description><![CDATA[Hello all,<br /><br />Question regarding the security of CMSB and mySQL.  Lately I've been receiving a LOT of the following errors from various IP addresses in my log and would like to know if any of you think this might be an attempt to access the mySQL table for my particular program (gets about 500 hits a day)?  Even though it looks like all have been unsuccessful, any solutions to prevent this or should I not even worry about it and rely on CMSB's security?:<br /><br /><code>[Sun Apr 08 18:08:11 2012] [error] [client xxx.xxx.xxx.xxx]   PHP Warning:  mysql_query(): Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/vhosts/xxxxx.com/httpdocs/cmsAdmin/lib/viewer_functions.php on line 419, referer: https://xxxxx.com/index.php<br />[Sun Apr 08 18:08:11 2012] [error] [client xxx.xxx.xxx.xxx]  PHP Warning:  mysql_query(): A link to the server could not be established in /var/www/vhosts/xxxxx.com/httpdocs/cmsAdmin/lib/viewer_functions.php on line 419, referer: https://xxxxx.com/index.php</code><br /><br />TIA.<br /><br />Eric<br />]]></description>
          <pubDate>Sun, 08 Apr 2012 20:24:38 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2215769#post2215769</guid>
        </item>
                <item>
          <title>Warning: fwrite() expects parameter 1 to be resource, boolean given</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2215668#post2215668</link>
          <description><![CDATA[Hi all,<br /><br />I have two identical sites (one is a backup to the other) and when I run the identical script (with related db changes), I get the following error on one of the sites:<br /><blockquote>Warning: fwrite() expects parameter 1 to be resource, boolean given</blockquote><br /><br />The site it runs on is a &quot;shared hosting&quot; and the one it does not run on is a virtual dedicated server (both through GoDaddy).<br /><br />Site 1: (the shared hosting one that works) is running: MySQL v5.0.92 (Max Connections: 200) with PHP v5.2.17<br /><br />Site 2: (virtual dedicated server) is running:  MySQL v5.0.95 (Max Connections: 100) PHP v5.3.3<br /><br />Both sites run the latest version of CMSB.  I've looked high and low for a solution on the web but nothing seems to work.  I'm guessing, from what I've read, it might be the v5.3.3 of PHP that is causing the problem.<br /><br />Any help would be appreciated as site #2 is the &quot;production&quot; site and the script is going to be run every day.<br /><br />TIA,<br /><br />Eric<br />]]></description>
          <pubDate>Tue, 27 Mar 2012 16:07:52 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2215668#post2215668</guid>
        </item>
                <item>
          <title>Re: [Jason] mySQL logs</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2213939#post2213939</link>
          <description><![CDATA[Hi Jason,<br /><br />Thanks for the quick reply!  I tried running the command you gave but ended up with the error: &quot;MySQL Error: Variable 'log' is a read only variable&quot;.  The MySQL version running is: v5.0.77<br /><br />Just before I posted this request for help, I became rather insistent with the &quot;server group&quot; support and asked them if they could check the other accounts sharing the same virtual server I was on.  Even thought I haven't heard back from them (yet), to my amazement when I went to check the code you gave me, the site is now coming up within 1-2 seconds! [shocked]<br /><br />In reply to your question about testing a smaller table for access, it seems it didn't matter how big or small the table was; it was still taking a ton of time to access it.  However, maybe the problem is solved.<br /><br />Thanks again for your quick response!  I'll follow-up when I hear back from the ISP (if I do).  [;)]<br />Eric<br />]]></description>
          <pubDate>Thu, 17 Nov 2011 13:28:12 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2213939#post2213939</guid>
        </item>
                <item>
          <title>mySQL logs</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2213934#post2213934</link>
          <description><![CDATA[Hi all, mySQL question here.<br /><br />I have several tables (over 20) in a database with some that have over 20,000 records.  Those are used primarily for archiving records from other similar tables and are not accessed on a regular basis.  Those that are accessed, 4 or 5 normally, for the most part contain less than 2,000 records.  All run in a virtual dedicated server.<br /><br />Just recently (within the last couple of days) the time it takes to access the website has increased by at least 10 times what it normally would take (from 1-2 seconds to 10-15 seconds and as much as 30 seconds) even though the increase in records has not been unusually high.  I was told by my ISP to &quot;optimize&quot; my tables, which I did via the admin for mySQL, which didn't help (all came out &quot;ok&quot;).  I was further told by my by ISP: &quot;Regarding the database on your site; one additional thing that you can look into is the query logging for MySQL.  Sometimes this can be set to log every query to the database and this can also decrease performance.  Basically if every query has to also log it's actions, even with several small optimized queries it can cause latency issues for the website.&quot;  The link they provided for further information, http://dev.mysql.com/doc/refman/5.1/en/query-log.html, explained a lot but was rather confusing.<br /><br />I researched this issue and found a possible command to run: &quot;mysql&gt; SET GLOBAL general_log=OFF;&quot;) to see if that helps.  I tried doing that from the plugin &quot;MySQL Console&quot; and received the following error: MySQL Error: Unknown system variable 'general_log'<br /><br />Question: is there a way to shut off the 'general' log from working while running a specific file? Or another way to limit all this writing that seemingly is causing the increase in latency?<br /><br />TIA,<br /><br />Eric<br />]]></description>
          <pubDate>Thu, 17 Nov 2011 12:48:40 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2213934#post2213934</guid>
        </item>
                <item>
          <title>Re: [Jason] Warning in cmsAdmin init.php showing up on pages</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2209705#post2209705</link>
          <description><![CDATA[Thanks again, Jason.  I'll contact them.<br /><br />Eric<br />]]></description>
          <pubDate>Thu, 17 Feb 2011 15:46:13 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2209705#post2209705</guid>
        </item>
                <item>
          <title>Re: [Jason] Warning in cmsAdmin init.php showing up on pages</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2209701#post2209701</link>
          <description><![CDATA[Hi Jason,<br />Thanks for responding!  The @ in front of the is_dir (on line 178 in the latest init.php file) did the trick!<br /><br />However, when I log into the admin page of cms, it gives me the following instruction at the top:<br /><br />Please set 'Website Root Directory' under: Admin &gt; General Settings<br /><br />The website root directory has not changed and is correct.  One of the things I noticed that has changed in my php.ini server file is now under the php core settings where &quot;open_basedir&quot; is located, in the &quot;local&quot; column it now has the string &quot;/var/www/vhosts/acsovisiting.com/httpdocs/:/tmp/&quot; where before it had: &quot;/var/www/vhosts/acsovisiting.com/httpdocs:/tmp/&quot;.  Note the trailing slash after httpdocs now.  My other installations of cmsAdmin have &quot;no value&quot; in the local column and in both cases the &quot;master&quot; column has &quot;no value&quot;.  I SSH'd into the server and modified the php.ini file (/etc/php.ini) but it still shows up.  Do you think this is what's causing the admin page instruction to appear (add root directory)?  If so, I'll contact the hosting company and see if they can remove it (set to &quot;no value&quot;).<br /><br />Thanks again.<br /><br />Eric<br />]]></description>
          <pubDate>Thu, 17 Feb 2011 15:20:47 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2209701#post2209701</guid>
        </item>
                <item>
          <title>Warning in cmsAdmin init.php showing up on pages</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2209682#post2209682</link>
          <description><![CDATA[In every case where the cmsAdmin library is being referenced I'm getting the following Warning:<br /><br /><br />Warning: is_dir(): open_basedir restriction in effect. File(/var/www/vhosts/acsovisiting.com/httpdocs) is not within the allowed path(s): (/var/www/vhosts/acsovisiting.com/httpdocs/:/tmp/) in /var/www/vhosts/acsovisiting.com/httpdocs/cmsAdmin/lib/init.php on line 169<br /><br />Help please?<br /><br />TIA,<br /><br />Eric<br />]]></description>
          <pubDate>Thu, 17 Feb 2011 10:57:31 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2209682#post2209682</guid>
        </item>
                <item>
          <title>mySQL compare dates</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2208425#post2208425</link>
          <description><![CDATA[DISREGARD THIS QUESTION *** Problem wasn't with the code; it was with another related issue.<br /><br />Sorry for the waste of electrons  [blush]<br /><br />Hello all,<br /><br />I'm having a problem extracting a date range from a table with a 'date' field (mySQL format: Y-m-d 00:00:00).  I load the table and use the where statement to list the dates equal to or greater than today's date which is defined as:<br /><code>$tuday = date('Y-m-d 00:00:00',time());</code><br /><br />When I run the following, I only get about 1/3 of the dates in the table that are greater or equal to $tuday:<br /><code>// filter by visiting date  <br />  list($visiting_currentRecords, $visiting_currentMetaData) = getRecords(array(<br />    'tableName'   =&gt; 'visiting_current',<br />    'orderBy'      =&gt; 'visit_date',<br />    'where'       =&gt; &quot;visit_date &gt;= '$tuday'&quot;,<br />    'loadUploads' =&gt; '0',<br />    'limit'       =&gt; '0',<br />  ));<br />  $visiting_currentRecord = @$visiting_currentRecords[0]; // get first record</code><br /><br />I'm really at a loss.  I've even tried counting the records using a mySQL statement:<br /><code>$query = &quot;SELECT count(*) FROM cms_visiting_current WHERE visit_date &gt;= '$tuday'&quot;;<br />$gCount= mysql_result (mysql_query ($query), 0);</code><br /><br />It too yields the incorrect count.  I even tried using the Epoch date comparison:<br /><code>$query = &quot;SELECT count(*) FROM cms_visiting_current WHERE UNIX_TIMESTAMP(visit_date) &gt;= '$tdayepoch'&quot;;<br />$gCount= mysql_result (mysql_query ($query), 0);</code><br /><br />But the same (incorrect) count came up.  I'm not talkin' about just a few records; for this particular instance, it will list 138 records instead of the 914 that are matching (went to the table and counted).<br /><br />I've been at this so long now, I'm sure I'll make more mistakes than I may have already made and decided to ask those that know a heck of a lot more about this than me.  [crazy]<br /><br />ANY help will be appreciated.  [:/]<br /><br />TIA.<br /><br />Eric<br />]]></description>
          <pubDate>Sun, 05 Dec 2010 15:14:32 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2208425#post2208425</guid>
        </item>
                <item>
          <title>Re: [Jason] Error when &quot;POSTing&quot; to another page</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2206719#post2206719</link>
          <description><![CDATA[Hi Jason,<br /><br />That did the trick!  In this case, I actually had to do that (enter some default values) for all those fields in the table where we cannot enter a value (createdDate, createdByUserNum, updatedDate, updatedByUserNum, dragSortOrder).  When I 'call' this page from other areas of the program, I don't get that error.  I'm guessing it must have something to do with the &quot;refresh&quot; or renewing of the information on that page.<br /><br />Either way, it works now.  Thanks for the, as usual, fine support!<br /><br />Eric<br />]]></description>
          <pubDate>Fri, 10 Sep 2010 11:40:05 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2206719#post2206719</guid>
        </item>
                <item>
          <title>Re: [chris] Error when &quot;POSTing&quot; to another page</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2206700#post2206700</link>
          <description><![CDATA[Hi Chris,<br /><br />Thanks for responding.  My mistake; I wasn't &quot;POSTing&quot; (got it mixed up with another).  It was being &quot;called&quot;:<br /><code>include 'add_Current.php';</code><br />The &quot;add_Current.php&quot; takes (several) lines of text from a file and accesses the database, 'truncates' a defined table, loops through and loads each line of text as a record (putting each comma delimited field into a defined field) into the table, then closes the mySQL instance.<br /><br />The first time the 'include' is called, it works fine.  The second time it's called is IF the user hits the &quot;refresh&quot; button of the browser.  Other code checks a couple of fields to see if they exist and if so, tells the user they have already added their &quot;reservation&quot;.  It's the second time, if called, when I get that error.<br /><br />I have the same program running on a different host and the only difference is the 'backup' site is running mySQL 4.x and the production site is running mySQL 5.x<br /><br />I tried to find a way to disable the 'refresh' on a web browser but haven't been successful so I tried using this method.  Any suggestions are certainly welcome.  I just don't want the user to be able to 'refresh' the page which will subsequently add yet another line of text and an additional duplicate 'reservation'.<br /><br />If you'd still like to see the code, I can email it to you.<br /><br />Eric<br />]]></description>
          <pubDate>Thu, 09 Sep 2010 23:32:51 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2206700#post2206700</guid>
        </item>
                <item>
          <title>Error when &quot;POSTing&quot; to another page</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2206688#post2206688</link>
          <description><![CDATA[Hi all,<br /><br />I'm getting the following error when I &quot;POST&quot; to another page:<br /><br />Error: Field 'createdDate' doesn't have a default value<br /><br />I'm not quite sure what this is but it does not show up when using mySQL v4.x but does when using mySQL v5.x<br /><br />Any idea what causes this?  I've tried narrowing it down but it's kind of hard when that's the only thing that shows up on the page.<br /><br />TIA!<br /><br />Eric<br />]]></description>
          <pubDate>Thu, 09 Sep 2010 20:11:46 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2206688#post2206688</guid>
        </item>
                <item>
          <title>Re: [Jason] Add new line to end of text file</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2204879#post2204879</link>
          <description><![CDATA[Hi Jason, <br /><br />Thanks for responding.  Because of the confidential information included in the file the written to, how about I email both to you.  Would your email be <a target="_blank" href="mailto:jason@interactivetools.com">jason@interactivetools.com</a>?  [cool] <br /><br />Eric<br />]]></description>
          <pubDate>Mon, 14 Jun 2010 20:36:35 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2204879#post2204879</guid>
        </item>
              </channel>
    </rss>
  