That fixed it. 

Thank you...

Phil

Seems to be an issue with the column name.  These sections were made in a previous version and worked fine.  Is this an issue with the latest version or DB that I need to change on my end?

CMCB Version 3.81 Build 2999

PHP 8.3.28

Thanks

Phil Colvin

I have tried loading SiteLok before and after the CMSB libraries.  The error I am getting is below.

Error: Session already started, only call session_start() after loading CMS libraries so correct session handler is used. in /var/www/vhosts/sctfpa.gov/httpdocs/sctf/contentDetail.php on line 9

I have several pages that are protected by SiteLok with the code snippet in the above example.  If I load it after CMSB, I can get in without the error until I try to load another page that is protected with SiteLok.  Then I get the error above.

It must be something with the server because I am running this exact same setup on other sites hosted at a different host with no problems.  I can check on the PHP settings.  What should the output buffering settings be?

Thanks

Phil

I looked through the SiteLok code there are several places it has a session_start().  I could try to comment out all of them, but that may have an impact on how it functions.

What I find odd is this setup worked for quite a long time until moving to the new server.  We are in the process of rebuilding the entire site and I won't be using some of the unique code that I use now in CMSB which may help. 

What I do in CMSB is with one .php file named contentDetail.php I set the table and other items in the CMSB code so I would not need to have a lot of different actual pages.  See the code below.  Things are set by the menu items selected on the page.  I have found that if I move SiteLok code below the CMSB code on other pages, it works ok, but on this page, if the code is below the CMSB code, I still get session errors.

I will see what the SiteLok developer come back with.  Obviously there is something different in how this server handles sessions that how the old server did.

<?php
  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = ['','../','../../','../../../','../../../../','/var/www/vhosts/sctfpa.gov/httpdocs/']; // add if needed: '/var/www/vhosts/sctfpa.gov/httpdocs/'
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
  
  // load records for the page called. 
  list($myRecords, $myMetaData) = getRecords(array(  
    'tableName'   	  => $_GET['section'],
    // 'tableName'   	  => $_REQUEST['section'],  
    'where'           => "num = '".intval(@$_GET['num'])."'", 
    'loadUploads'     => false, 
    'allowSearch'     => false, 
    'limit'           => '1',  
  ));  
  $myRecord = @$myRecords[0]; // get first record 
   
  //get uploads for the selected record meeting minutes
  list($upload_minutesRecords, $upload_minutesMetaData)=getRecords(array( 
    'tableName'       =>      'uploads', 
    'allowSearch'     =>      false, 
    'where'			  =>	  "tableName='".mysql_escape(@$_GET['section'])."' AND fieldName='meeting_minutes' AND recordNum='".intval($myRecord['num'])."'",
    'orderBy'   	  =>      "STR_TO_DATE(info1,'%M %d,%Y') DESC",
    ));
  
  //get uploads for the selected record other docs
  list($upload_otherRecords, $upload_otherMetaData)=getRecords(array( 
    'tableName'       =>      'uploads', 
    'allowSearch'     =>      false, 
    'where'			  =>	  "tableName='".mysql_escape(@$_GET['section'])."' AND fieldName='other_docs' AND recordNum='".intval($myRecord['num'])."'",
	'orderBy'		  =>	  "`order`",
    ));	
?>

Later on the page is where I loop through all of the menu items that grab the info that is then used by the CMSB code to know what content to display.

		<?php 
		  $categoryTablenames = array('exec_comm', 'ag_sc', 'bii_sc', 'com_it_sc', 'cj_sc', 'exercise_wg', 'frhm_sc', 'health_and_safety', 'hlth_med', 'imt', 'info_intel_wg', 'links', 'logs_eqp', 'mass_evac_wg', 'pol_procd', 'pio', 'tng_sc', 'exercise_wg');
		 
		  $categoryRecordSets = array(); 
		 
		  foreach ($categoryTablenames as $tablename) { 
			list($categoryRecords,) = getCategories(array( 
			  'tableName'   => $tablename, 
			)); 
			$categoryRecordSets[$tablename] = $categoryRecords; 
		  } 
		?> 
		 <ul id="theMenu">
		 <li><a href="index.php">Home</a></li>
		  <?php foreach($categoryRecordSets as $tablename => $categoryRecords): ?>
			  <?php foreach ($categoryRecords as $record): ?>
				<?php echo $record['_listItemStart'] ?>
					<?php if (sl_ismemberofany($record['visible_grp'])){ ?>
					<a href="contentDetail.php?section=<?php echo $tablename ?>&amp;num=<?php echo $record['num'] ?>"><?php echo htmlspecialchars($record['name']) ?></a>
					<?php } ?>
				<?php echo $record['_listItemEnd'] ?>
			 <?php endforeach ?>
		  <?php endforeach ?>

So I can get things working with the index.php page, but if I mess around with the contentDetail.php, which has the code above, it messes things up a bit too much.

Hopefully I won't have these issues with the new site.  I will be using SiteLok and CMSB on it in much the same way.  

Thanks

Phil

SiteLok definitely starts its own session.  I tried to move the code that calls SiteLok below the CMSB code which did help a little, but I still get the session error every now and then.  Below is the code that is at the beginning of most pages on the site.  Of course it varies depending on the content for that page.

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = ['','../','../../','../../../','../../../../']; // add if needed: '/var/www/vhosts/sctfpa.gov/httpdocs/'
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
  
  // load records for News and Events
  list($news_and_eventsRecords, $news_and_eventsMetaData) = getRecords(array(
    'tableName'   => 'news_and_events',
    'loadUploads' => '1',
    'allowSearch' => '0',
  ));
?>
<?php
$groupswithaccess="TFUSER,HC";
require_once("../slpw/sitelokpw.php");
?>

You will see the last 4 lines are what calls Sitelok.  Here it is below the CMSB code.  It if is before, I get a lot more of the session errors.  I am also working with the developer of SiteLok on this.  They just call a normal session which I'm sure CMSB is doing.

I have run this site for years without this issue and no changes until we moved to the new server.  We are on PHP version 8.3.16.  I may try using 8.2.27 and see if that makes any changes.  The old server it was on was running version 8.1

Error: Session already started, only call session_start() after loading CMS libraries so correct session handler is used. in /var/www/vhosts/sctfpa.gov/httpdocs/sctf/index.php on line 10

I'm trying to track down if this is a CMS Builder, SiteLok or server issue.  If anyone could shed some light on this or point me to a possible cause or reason for the error, that would be great.

Thanks

Phil

You replied before I was able to update my post.  I have been able to achieve what I wanted adding a trigger with phpMyAdmin.  The trigger is below.  I still need to test some things in the production enviroment to make sure I don't get any duplicates, but this should work.

BEGIN 

-- Increment the num value and store it in generatedNum 

SET NEW.generatedNum = (SELECT IFNULL(MAX(num), 0) + 1 FROM cmsb_oca_log); 

-- Set the lcwc_num field using the incremented generatedNum 

SET NEW.lcwc_num = CONCAT( YEAR(NEW.createdDate), '-', LPAD(NEW.generatedNum, 4, '0') ); 

END

I'm open to any ideas how to make things better so all suggestions from anyone is welcome.

Phil

Thanks for the reply.  I'll work on making some changes to the function and see how it works.  The array will work fine for multiple sections.

Thanks

Phil

When I have a user that is a Author and Viewer, they can only see their records.

Is there a way to remove the "change" link for the created by for a non admin user?

It would be nice if we could hide the "erase" link for non admin users.

If there is a way to do these things, please point me in that direction.

Thanks

Phil

I need to have a field in a section that contains the year '2024' a dash, then an auto incremented number.  This number could be from the Record Number field and I would set that to start at a certain value using the console.

The field also needs to be editable by an admin in the event the wrong number somehow was saved and the admin can then change it.

I'm just not sure the cleanest way to do this.  I imagine this can be done with a Generated Column field type, but I have not been successful yet.

Thanks

Phil

I know this is a very old post, but I'm looking to do the same thing for old "On Call" records that after the removeDate should be removed.  The difference for me is that I need to have this work on several difference sections, not just one.  Would there be a way to apply this plugin to several sections?

Also, just curious, where is the cron job added for this to run automatically.  I did some testing with it and did not see the cron job anywhere.

Thanks in advance.

Phil Colvin

I have not figured this one out yet.  Any help would be greatly appreciated.

Phil

What I have is a Detail page that has uploads for meeting minutes.  the info2 field has the date of the upload.  

Below is the load records code and then the code to display and sort the uploads.  I'm hoping someone can see what I'm missing.  The uploads display, but are not sorted in descending order.

<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
  
  // load viewer library
  $libraryPath = 'cmsb/lib/viewer_functions.php';
  $dirsToCheck = ['','../','../../','../../../','../../../../']; // add if needed: '/home3/epfctwot/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."); }

  // load record from 'member_section_meeting_minutes'
  list($member_section_meeting_minutesRecords, $member_section_meeting_minutesMetaData) = getRecords(array(
    'tableName'   => 'member_section_meeting_minutes',
    'where'       => '', // load first record
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $member_section_meeting_minutesRecord = @$member_section_meeting_minutesRecords[0]; // get first record
  if (!$member_section_meeting_minutesRecord) { dieWith404("Record not found!"); } // show error message if no record found

?>

<?php
//get uploads for current record
$uploads = mysql_select('uploads', "tableName='member_section_meeting_minutes' ORDER BY STR_TO_DATE(info2,'%m/%d/%Y') DESC");
?>

<?php foreach ($member_section_meeting_minutesRecord['member_section_meeting_minutes'] as $index => $upload): ?>
<a href="/cmsb/uploads/<?php echo htmlencode($upload['urlPath']) ?>" style="font-family: 'Lato', sans-serif; font-size: 16px; font-weight: 300;"><?php echo htmlencode($upload['info1']) ?></a>            
<br>
<?php endforeach ?>

Thanks

Phil

Thanks for the suggestion.  Based on what you shared, I may try the multi record editor and then use Bootstrap Accordions to group the years for the uploads.

Thanks!

Phil

I know there are things our there, but I would like to keep it integrated with CMS Builder for managing the uploads.

Thanks

Phil

Thanks for the suggestions.

Phil

I just tried deleting the None and that breaks the whole page.  Just get a blank page when loading.

I can give the elseif a try a bit later and see if that works.  I'm not sure it will work since I have to test the first if to see if there are any photos (uploads) for that record.  That is what the None is doing now.

Phil

On one of my pages I am testing to see if there are any photos in the uploads for the section.  If there are, it displays their thumbnails.  If not, it just does not show anything. Below is the code that I'm using.  It works fine on PHP 7.4, but if I switch to 8, it throws an error and nothing on the page after the error will display.

The culprit seems to be the :None in the first If statement.  Works fine in 7.4, but not 8.  I've tried using the empty() or isset() functions, but I'm not doing something right.

                                <div class="photo-gallery">
                                    <div class="row photos" style="padding-bottom: 20px;">
                                        <?php if (!$record['photos']):None ?>
                                        <?php else: ?>
                                            <?php foreach ($record['photos'] as $index => $upload): ?>
                                                <?php if ($index >= 4) { continue; } // limit uploads shown ?>
                                                <div class="col-sm-6 col-md-4 col-lg-3 item">
                                                    <a href="<?php echo htmlencode($upload['urlPath']) ?>" data-lightbox="photos<?php echo htmlencode($record['num']) ?>"><img class="img-fluid" src="<?php echo htmlencode($upload['urlPath']) ?>"/></a>
                                                </div>                                                 
                                            <?php endforeach ?>
                                        <?php endif ?> 
                                    </div>
                                </div>

Thanks in advance for any help...

Phil

error_reporting(E_ALL ^ E_DEPRECATED);

Did not suppress the error, but the error_reporting(0) did.

Phil

Is there any way to hide this message as well? I know the error exists, but since they need to support older versions, they can't change their code. I know we want to have error free code, but sometimes that is not under our control.

Thanks

Phil Colvin

For the viewer, I would like to select each of the records individually to show on the proper place on the page.  The foreach loop won't work as each area the record is to be displayed is laid out differently.

So I want to be able to show all of the records on the page, just individually on the page using a where clause using the title field in the record.

I know there has to be a simple way to do this, but I could not find any example.

Thanks

Phil

Phil

the lightbox on the page is working.  It just allows the user to scroll through all of the images for all records.

I'm not sure I'm tracking with your suggestion.  The code I have works and the lightbox is working fine.  If this were a single record on the page, everything would be fine.  Since I am showing all of the records, the $upload array seems to have all of the uploads and the lightbox is seeing the upload of all records and not just the one the user clicks on.

If there is a way that each record and it's associated upload array values would be kept inside the foreach loop, it would probably work.  I'm not that level of PHP programmer to figure it out.

Phil