CMSB v3.75 Released (Dec 10) - DB Performance & Debug Footers

Wed, 12 Mar 2025 03:42:07 -0700

Hey Dave -

I upgraded to 3.75 but it is stuck on "software update to 3.65" and it doesn't go any further and I can't get into the admin panel at all. Any ideas on how I can get access back?

Thanks!

craig

QRC Generator

Fri, 19 Apr 2024 13:48:20 -0700

Thanks, I had the same problem! Really appreciate you figuring this out and sharing!

counts not working properly

Tue, 31 Oct 2023 11:55:10 -0700

You are genius Steve - thank you! I just couldn't see what was right in front of me!

counts not working properly

Fri, 27 Oct 2023 07:48:29 -0700

Hi All -

I am sure this is staring me in the face but I don't know why it isn't working. I have a blog on this new site and when it counts the archive articles per month on the main page the article numbers are incorrect (it attributes 4 articles to each month) it counts all articles rather than just the articles for that month. However, when you click on a month to see those articles the counts are correct (2 articles each month) and it is the same code on the same page driving it.

You can see the in process site here: https://craigh103.sg-host.com/blog.php

I attached the page as well as images of the numbers when it initially loads vs when you select one of the archive months.

Any assitance is appreciated.

Craig

displayed records not matching total records

Tue, 29 Mar 2022 06:24:52 -0700

Hey Daniel -

Nevermind - I am too clever for my own good apparently. I found the issue. The menu system goes out to check and see if there are records to be displayed before it makes the menu option a choice.

Thanks for your wilingness to jump in with me!

Regards,

Craig

displayed records not matching total records

Mon, 28 Mar 2022 17:19:06 -0700

you are right! see below - still not sure why the #5 records show up in the foreach loop

SELECT SQL_CALC_FOUND_ROWS `x_news`.*
FROM `cms_x_news` as `x_news`
WHERE (blog_category = '1')
ORDER BY `post_date` DESC
SELECT * FROM `cms_uploads` WHERE tableName = 'x_news' AND
fieldName IN ('photo') AND
recordNum IN (64,63,59,58,47,40,38,39,33,31,21,20,14)
ORDER BY `order`, num
SELECT SQL_CALC_FOUND_ROWS `accounts`.*
FROM `cms_accounts` as `accounts`
WHERE (`num` IN (29,26,1,18))
ORDER BY fullname, username
SELECT SQL_CALC_FOUND_ROWS `members`.*
FROM `cms_members` as `members`
WHERE (`num` IN (29,26,1,18))
ORDER BY user_fname ASC
SELECT * FROM `cms_uploads` WHERE tableName = 'members' AND
fieldName IN ('photo') AND
recordNum IN (1)
ORDER BY `order`, num
# records 13

displayed records not matching total records

Mon, 28 Mar 2022 16:57:45 -0700

Hey Daniel -

Thanks for the help - well I don't know how to explain this but here are the debug results and i posted the whole page code below. Also I took a screenshot of the x_news table in the database and you can see there are records with blog_category = 1

Please let me know if you need anything else.

thanks!

craig

SELECT SQL_CALC_FOUND_ROWS `x_news`.*
FROM `cms_x_news` as `x_news`
WHERE ('blog_category' = 1)
ORDER BY `post_date` DESC
# records 0

++++++++++++++++++++++++++++++++++

// $blog_where = "";
// $blog_where = "1";
$blog_rec = "";

$libraryPath = 'cmsb/lib/viewer_functions.php';
$dirsToCheck = array('/home/xanitoshqadmin/public_html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

list($x_sec_introRecords, $x_sec_introMetaData) = getRecords(array(
'tableName' => 'x_sec_intro',
'where' => "`sn` = 'bed'",
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$x_sec_introRecord = @$x_sec_introRecords[0]; // get first record
if (!$x_sec_introRecord) { dieWith404("Record not found!"); } // show error message if no record found

list($x_newsRecords, $x_newsMetaData) = getRecords(array(
'tableName' => 'x_news',
'loadUploads' => true,
'allowSearch' => false,
'where' => "'blog_category' = 1",
'orderBy' => "`post_date` DESC",
'debugSql' => true,
));
?>

<?php echo htmlencode($x_sec_introRecord['title']) ?><?php include("core-title-tag.php"); ?>
">

$blog_rec = $x_newsMetaData['totalRecords'];
echo ' # records '. $blog_rec;?>

$upload): ?>

" alt=" | www.xanitos.com">

Record Number:

Title:

Blog Category (value):

Blog Category (label):

author:

$upload): ?>
Upload Url:

displayed records not matching total records

Mon, 28 Mar 2022 14:03:54 -0700

Hi All -

I have a section that breaks up articles into different catagories then I display those catagories of articles on different pages. I have done this a lot on websites but it is not working here and for the life of me I cannot see what is going on.

Below I have identified the components This is where it pulls the records for the page - if I do a record count for that subset of records (see below) the total records lists 15 (which is accurate) but when I do a foreach loop to loop through those records 6 records show up and they are all for category 5 (see attachment for results example). This code is from a test page which I built to see if I could figure out the issue which is why there are some variables in there that are not normally there.

I am out of idea's it makes no sense to me. Any help is appreciated.

Thanks!

This is where it pulls records from the cms on page:

$blog_where = "2";

$libraryPath = 'cmsb/lib/viewer_functions.php';
$dirsToCheck = array('/home/xanitoshqadmin/public_html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

list($x_newsRecords, $x_newsMetaData) = getRecords(array(
'tableName' => 'x_news',
'loadUploads' => true,
'allowSearch' => false,
'where' => "blog_category = '$blog_where'",
'orderBy' => "`post_date` DESC",
));

This displays the record count just as a check:

$blog_rec = $x_newsMetaData['totalRecords'];
echo ' # records '. $blog_rec;?>

This is the foreach loop on the page:

Record Number:

Title:

Blog Category (value):

Blog Category (label):

author:

$upload): ?>
Upload Url:

As an FYI - the list field categories are setup like this in the table:

write data from a form to the CMS database including uploads creating two entries

Wed, 06 Oct 2021 06:26:19 -0700

Hi -

We are using CMS builder to record covid vaccination information for pre-hire employees and I am using the uploadForm3_add code to upload vaccination card images. Ultimately I want to send an email to the HR department that includes the vaccination information as well as the uploads but I am running into an issue. When you click the upload button in the iframe it does upload to the database but then when you submit the form it creates a second record rather than writing it to the same record even though they have same tempid. I am guessing the issue is once it uploads the images to the CMS the temp id ceases to exist and but I don't know how to counteract this.

Any help is appreciated.

Thanks!

Craig

Website Comments 1.05 Error - Trying to access array offset on value of type bool

Thu, 17 Jun 2021 14:41:00 -0700

Steve!

You are genius! I changed the PHP version to 7.3 and the error magically disappeared! I'll look to upgrade to 3.54.

Thanks!

Craig

Website Comments 1.05 Error - Trying to access array offset on value of type bool

Thu, 17 Jun 2021 12:35:04 -0700

Hi -

I started getting this error with website comments 1.05 just out of the clear blue sky (I am sure something happened I just don't know what)

On the website it shows up like this:

Notice: Trying to access array offset on value of type bool in /home/customer/www/delanceyplace.com/public_html/cmsAdmin/plugins/websiteComments/websiteComments.php on line 279

In the error log it shows up like this:

E_NOTICE: Trying to access array offset on value of type bool
/home/customer/www/delanceyplace.com/public_html/cmsAdmin/plugins/websiteComments/websiteComments.php (line 279)
https://delanceyplace.com/view-search-results.php?2509

It looks like the error is in the plugin itself.

We are running:

CMS Builder v3.53 (Build 2265)
Website comments 1.05
PHP v7.4.18

Can you guys help?

Thanks!

Craig

can't clear error log

Wed, 29 Jul 2020 17:34:15 -0700

Ok Greg -

After mucking around a bit I was able to resolve the issue - I think the log just got enormous like gigs enormous. i was able to find it and clean it out at the sql level. I guess the last question I have is can I remove all of the cmsb_ prefixed tables since it looks like those tables were all copied to cms_

thanks for the help - I really appreciate the support you guys provide.

Regards,

Craig

can't clear error log

Wed, 29 Jul 2020 14:40:27 -0700

Hi Greg -

Thanks - in the database they are all cmsb (see attached). They were upgraded on the same server - I made a copy of the directory with the website in it and upgraded it so that I could move it to the new version of php and of cmsb.

Regards,

craig

can't clear error log

Tue, 28 Jul 2020 17:57:30 -0700

Hi Guys -

I keep getting a 504 timeout when I try and look at the error log so I tried a work around to limit the entries per page to 5 via the url but that did not work. I looked in the database so see if I could get at the errors that way but there were no database entries for the error log. seemed a little weird since the count is coming from somewhere.

I also looked at the server info in admin > general settings and it indicates the table prefix is cms_ but when I look at the database it looks like the table prefix is cmsb_ not cms_.

I attached images of all of these things. This was a cms update from 2.65 to 3.53. I moved the whole thing to a new directory, updated it and pointed the domain to the new version so it could be a side effect of that but the error log seems to grow. I just can't figure out where the numbers are coming from.

Any help would be appreciated!

thanks!

Craig

Facebook started adding query param for tracking - Remove with mod_rewrite so as not to interfere with whereRecordNumberInUrl

Tue, 14 May 2019 11:21:52 -0700

me too! this worked great!

hiding records from multi-search

Thu, 09 May 2019 08:45:24 -0700

Well...now I feel dumb....

After reading some more entries in the forum about "hidden" records and how they behave I discovered the interactive tools (not surprisingly) guys already thought of this. if you use the "hidden" field as the checkbox in your section editor to hide fields you don't have to do anything in the search array to exclude these hidden records, it happens automatically.

By setting this:'ignoreHidden' => true, I was actually doing what I did not want to do which was to ignore that hidden field and show the record...some days...

If others have this issue, as long as you use the "hidden" field in your section editor then all will be well.

hiding records from multi-search

Thu, 09 May 2019 07:17:29 -0700

Hi Deborah -

I had the same thought this am - the section editor does indeed indicate that "hidden" is a special field type but the 'ignoreHidden' => true, statement still causes a 500 error on the page. I feel like we are close but there is some (critical) piece of information I am missing.

Thanks

Craig

hiding records from multi-search

Thu, 09 May 2019 06:03:09 -0700

Hi Deborah -

Thank you again, but unfortunately it did not work - when i put that in I get a 500 series error (see attached).

Thanks again.

Craig

hiding records from multi-search

Wed, 08 May 2019 14:53:23 -0700

Hi Deborah -

Funny enough, that is the post I was referencing in my initial posting that I did not understand (pasted below) - Damon makes reference to "the hidden checkbox on the record" which I could not find at all (unless it is staring me in the face) and "adding the following to the view options" and I was just unclear if it is the view options on the page (like below) or somehow in the CMS section. I wasn't sure if I was just supposed to create a "hidden" checkbox field and magically it would adopt those properties but since my "do_not_display" field was essentially the same thing with a different name. I included a screenshot of the current fieldlist in the leadership_sales section.

The alternative method he proposes is essentially the method you proposed and it has the same impact on the total count as your proposed method and i wanted to avoid writing record count code etc since the built in method does it so elegantly.

In any case, that is my current conundrum.

thanks again for looking around.

$searchTables['x_leadership_sales'] = array(
'viewerUrl' => 'about-leadership.php',
'titleField' => 'title',
'summaryField' => 'content',
'searchFields' => array('title','content'),
'ignoreHidden' => true,
);

One way you can exclude records from the multiSearch would be to use the "hidden" checkbox on the record. The record would then not appear in the search results.

To be able to link to the record directly and it have it display (even when marked as hidden) would require that you add the following to the View Options:

'ignoreHidden' => true, // don't hide records with hidden flag set

Hope this helps. If you need any additional details about the steps or have questions, just let me know.

hiding records from multi-search

Wed, 08 May 2019 10:27:20 -0700

Hi Deborah -

Thank you, it works functionally but there is one caveat, the numeric result lists then don't function correctly. Say for example I type in a name that I know is in do not display, it tells me there is 1 record in my result but of course because of the code, the record does not display (this is the good part).

I was hoping to exclude it farther up in the process so the results numbers are accurate.

Thanks again!

hiding records from multi-search

Wed, 08 May 2019 08:21:47 -0700

Hi -

I have a checkbox field in my section (do_not_display) and I want to exclude any record that is checked from the search results. I already found (unsuccessfully) you cannot use a where clause and I found another archived entry which frankly I just didn't understand (perhaps I need more coffee today).

Below is the search code for that table, I can attach the page code if you think that would help but I can't figure out how to exclude these records marked as do_not_display.

$searchTables['x_leadership_sales'] = array(
'viewerUrl' => 'about-leadership.php',
'titleField' => 'title',
'summaryField' => 'content',
'searchFields' => array('title','content'),
);

Thanks!

Craig

Is there going to be an update to

Fri, 28 Dec 2018 11:22:36 -0800

Hey Daniel -

I changed the php setting on my website to 7.2 in anticipation of upgrading to the latest cms release (we are currently running 3.10) when i did that, the upload option as well as the forms that write back to the data to the CMS system stopped working correctly.

That is what prompted my post.

thanks!

Craig

Is there going to be an update to

Fri, 21 Dec 2018 15:12:01 -0800

the updateform3 file up-loader or will the forms plugin be updated to facilitate attaching files to records loaded in the database under mysqli and the 3.15 version of CMSB. Alternatively if anyone has any ideas I am open to it. I want to move to 3.15 and php 7.x but can't because we use that process to have people upload resumes for open positions and then they all get loaded into CMSB for easy access.

Thanks!

Craig

Getting a Fatal Error: Call to undefined function _permalink_getRedirectUrl()

Wed, 05 Jul 2017 13:39:31 -0700

Hey Dave -

Thanks for getting back to me, I did not have permalinks in the subsite but in the parent site and once I removed that it was fine. However, it is still not giving me the preview and I suspect it is because it is not picking up the correct path. In this case the primary site is xanitoshq.com but the subsite is xanitos.com it works totally fine in the code so it is finding (I presume) the relative path correctly but when I update the subsite content in the primary site where the cms is installed I get the broken link issue - i can see the pathing is not correct when I rollover the broken link, it should be xanitoshq.com/x/assets/images/cmsb but it is showing up as xanitoshq.com/assets/images/cmsb but the website totally finds the photo correctly (which ultimately is xanitos.com/assets/images/cmsb). I have included screen shots of the xanitoshq.com (where the cms is installed - cms_uploads_dir.png) and the section of the site that has the subsite content where I am having the issue (cms_leadership_custom_uploads_dir.png)

thanks!

Craig

Getting a Fatal Error: Call to undefined function _permalink_getRedirectUrl()

Wed, 05 Jul 2017 07:46:44 -0700

i am getting this fatal error message when I try and view photo that was an upload field in the CMS (see cms_photo_upload.png attached). You can see the sort of broken link Not sure why it is a permalinks error since permalinks (while there) is not installed (see attached cms_plugins.png attached).

Fatal error: Call to undefined function _permalink_getRedirectUrl() in /home/xanitoshqadmin/public_html/cmsb/plugins/permalinks/permalinks_dispatcher.php on line 12

I am running cms 3.02, build 2060.

Thanks!