I want my client to be able to review new issues that are marked with a issue_status field as "setup", so they are only viewable by someone who is logged into the CMS. 

Thinking I may need to activate the membership plugin to do this, but was hoping there is a simpler method to access the global $CURRENT_USER

Notice: MySQL Error: Table 'DBNAME.cmsb__accesslist' doesn't exist - in schema_functions.php on line 37 by getMySqlColsAndType() in C:\SERVERPATH\cmsb\lib\common.php on line 281

Tried a fresh install, confirmed that the accesslist file does exist. still not working.

Start time: 9:00 PM

Warning: session_start(): open(/var/php_sessions/sess_hi98lssup789nop78anrimuosrfnia70, O_RDWR) failed: No such file or directory (2) in /hermes/bosnaweb19a/b1688/ipg.summerfieldfoundatio/cmsb/lib/init.php on line 733 Warning: session_start(): Failed to read session data: files (path: /var/php_sessions) in /hermes/bosnaweb19a/b1688/ipg.summerfieldfoundatio/cmsb/lib/init.php on line 733 Fatal error: Couldn't start session! ''! in /hermes/bosnaweb19a/b1688/ipg.summerfieldfoundatio/cmsb/lib/init.php on line 733

The CMS version is 3.51

With the php.ini, this is the error returned:

500 Internal Server Error

• At what point in the CSV import process do you see this error?

Import CSV = ok

Upload file = ok

Select target table = ok

Analyze Data = error

Do any errors show up in the Developer Log (under Admin Menu in CMSB) when you attempt the import?

Yes...

Error:
E_WARNING: count(): Parameter must be an array or an object that implements Countable

URL: 
/cmsb/admin.php?_plugin=csvImport_v111/csvImport_functions.php&_pluginAction=csvImport_analyseForm_ajax&num=19&offset=0&rowNum=1&menu

Filepath:
/var/www/html/cmsb/plugins/csvImport_v111/csvImport_functions.php

Line num
500

Backtrace
#0 _errorlog_logErrorRecord() called at [/var/www/html/cmsb/lib/errorlog_functions.php:64]
#1 _errorlog_catchRuntimeErrors() called at [/var/www/html/cmsb/plugins/csvImport_v111/csvImport_functions.php:500]
#2 csvImport_analyseForm_ajax() called at [/var/www/html/cmsb/plugins/csvImport_v111/csvImport.php:105]
#3 csvImport_init() called at [/var/www/html/cmsb/lib/plugin_functions.php:312]
#4 doAction() called at [/var/www/html/cmsb/admin.php:32]

• "Status: Error: There was an error sending the request! (200 OK) parsererror - SyntaxError: Unexpected token ( in JSON at position 1"
• CMSB 3.14
• CSV Import 1.11
• It works totally fine on the dev server, but errors out on the live server.

Has anyone done this successfully before?

$related_sessions = implode(',', explode("\t",$page['related_sessions']));

'where' => "num IN ($related_sessions)", 

Got this...

SELECT SQL_CALC_FOUND_ROWS `sessions`.*
FROM `cms_sessions` as `sessions`
 WHERE (num IN (,1048,1047,)) AND `sessions`.hidden = 0 
 ORDER BY date_time DESC,location,type
 LIMIT 2MySQL 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 '1048,1047,)) AND `online_sessions`.hidden = 0 ORDER BY date_time DESC,location' at line 3

$related_sessions = explode("\t",$page['related_sessions']);

and...

'where' => "num IN ($related_sessions)", 

getting this...

Notice: Array to string conversion in 

two tables, DATES and SESSIONS.

DATES includes a list field that allows multiple SESSIONS to be selected - field name is related_sessions.

On the public DATES page, I'm trying to load all of the related_sessions

// load record from 'dates'
list($date, $dateMetaData) = getRecords(array(
'tableName'   => 'dates',
'where'       => whereRecordNumberInUrl(0),
'loadUploads' => true,
'allowSearch' => false,
'limit'       => '1',
));
$date = @$date[0]; // get first record
if (!$date) { header('Location: /'); exit; }

// load records from 'sessions'
list($related_sessions, $related_sessionsMetaData) = getRecords(array(
'tableName'   => 'sessions',
'where' => "num LIKE '%\t". $date['related_sessions'] ."\t%'" , 
'loadUploads' => true,
'allowSearch' => false,
));


with debug on:

SELECT SQL_CALC_FOUND_ROWS `sessions`.*
FROM `cms_sessions` as `sessions`
 WHERE (num LIKE '% 1048 1047 %') AND `sessions`.hidden = 0 
 ORDER BY date_time DESC,location,type

Not record are returned. 

style_formats: [  
   { title: 'Intro', block: 'div', classes: 'intro', wrapper: true, merge_siblings: false },
   { title: 'Divider Line', selector: 'p,h1,h2,h3,h4,h5,h6,div',  classes: 'divider' },
   { title: 'Feature Box', block: 'div', classes: 'feature-box', wrapper: true, merge_siblings: false },
   { title: 'Inset Box', block: 'div', classes: 'inset-box', wrapper: true, merge_siblings: false },
   { title: 'Pullquote', block: 'div', classes: 'pullquote', wrapper: true, merge_siblings: false },
   { title: 'Button', selector: 'a',  classes: 'btn'},
   { title: 'Images', items: [
     { title: 'Float left', block: 'div', classes: 'floatLeft', wrapper: true, merge_siblings: false },
     { title: 'Float right', block: 'div', classes: 'floatRight', wrapper: true, merge_siblings: false }
   ]},
   { title: 'Photo Caption', block: 'div', classes: 'photo-caption', wrapper: true, merge_siblings: false },
   { title: 'Footnote/s', block: 'div', classes: 'footnotes', wrapper: true, merge_siblings: false },
   { title: 'DEV Notes', block: 'div', classes: 'note', wrapper: true, merge_siblings: false }
],


Add this...

   { title: 'Intro', block: 'div', classes: 'intro', wrapper: true, merge_siblings: false },


Now you can select a group of elements, select "Intro" from the style select dropdown, and your html will go from this...

<h1>Heading</h1>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc condimentum tempor sodales. Phasellus eu metus vel urna pulvinar congue in vel tellus. </p>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc condimentum tempor sodales. Phasellus eu metus vel urna pulvinar congue in vel tellus. </p>


to this...

<div class="intro">
   <h1>Heading</h1>
   <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc condimentum tempor sodales. Phasellus eu metus vel urna pulvinar congue in vel tellus. </p>
   <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc condimentum tempor sodales. Phasellus eu metus vel urna pulvinar congue in vel tellus. </p>
</div>

Mind blown! Mine was :)