Warning: ini_set(): A session is active

Thu, 21 Mar 2013 12:30:55 -0700

I thought I had replied to this but now I don't see it.

ftp & server info is in Support #CTS-262247, opened for another issue.

Try with TLG Content/Newsletters Articles, modify first article, click preview.

The newsletter page can be found at /newsletters/newsletter_detail.php

The includes are in /includes.

Thank you!

Michel

Options Available for $searchOptions Array in Multi-Search

Fri, 15 Mar 2013 07:48:02 -0700

I also only would like an additional where clause "where publish=1", is this possible?

Warning: ini_set(): A session is active

Wed, 06 Mar 2013 11:41:26 -0800

I reviewed every page and removed any session_start() and also made sure that cmsbuilder include is the first thing in the page and the problem still occurs.

if I comment out line 458, I get: You must be logged in to use this feature!

Warning: ini_set(): A session is active

Wed, 06 Mar 2013 08:44:23 -0800

When I click Preview on any of sections, I get an error message that says:

Warning: ini_set(): A session is active. You cannot change the session module's ini settings at this time in /home/linley5/public_html/cms_builder/lib/init.php on line 449 Couldn't start session! 'A session had already been started - ignoring session_start()'!

if I comment out line 449, then it dies on 458

if I comment out line 458, I get:
You must be logged in to use this feature!

here is the url it generated
https://linleygroup.com/newsletters/newsletter_detail.php?preview-9999999999

The Preview Page Url is set to "/newsletters/newsletter_detail.php"
The Filename Fields is set to "title"

I do have a session_start() in my php script

Disabled accounts - Viewers causes SQL error!

Tue, 05 Mar 2013 08:04:26 -0800

When I turn on Disabled Accounts Viewers: Hide records that are "Created By" a user who is: deleted, disabled, or expired on one my my sections I get the following SQL error:

MySQL 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 ') ORDER BY dragSortOrder DESC LIMIT 1' at line 3

Here is the debugSql:

SELECT SQL_CALC_FOUND_ROWS `newsletters`.* FROM `cms_newsletters` as `newsletters` WHERE (num=4828 AND newsletters.createdByUserNum IN (SELECT num FROM `cms_accounts` WHERE disabled != 1 AND (expiresDate > NOW() OR neverExpires = 1))) ORDER BY pub_date DESC, title LIMIT 1

And here is the code:

    list($newsletterRecords, $newsletterMetaData) = getRecords(array(
   'tableName'   => 'newsletters',
   'where'       => 'num='.$num,
   'allowSearch' => false,
   'limit'       => '1',
   'debugSql'=> true,
   ));

I have version 2.5 installed.

Hide some articles in editor

Mon, 04 Mar 2013 15:42:53 -0800

Is a way to hide some articles in a section based on some value in a column. Like being able to specify a where clause in the editor. There are some articles that are auto-generated and I don't want anybody to be able to edit?

Cannot activate a plugin

Thu, 10 Jan 2013 11:36:08 -0800

Never mind I figured it out, path to library was incorrect

Cannot activate a plugin

Thu, 10 Jan 2013 11:18:15 -0800

This plugin worked under the previous version.

Why won't it activate under the new version?

Cannot activate a plugin

Mon, 07 Jan 2013 14:59:47 -0800

I renctly upgraded to the latest version and had to reactivate my plugins, One of my plugin won't activate, after I click activate I get a blank page. The others activated just fine.

The plugin is "SaveTrigger".

Any idea what could cause this?

I have uploaded the plugin code just in case

SELECT MATCH HAVING

Fri, 02 Nov 2012 13:08:17 -0700

I am sing the MYSQL MATCH to search for keywords within the content field. My select (generated through cmsbuilder List()) looks like this:
SELECT SQL_CALC_FOUND_ROWS `listings`.*, MATCH(headline,content) AGAINST('2 bedroom' IN BOOLEAN MODE) AS relevance FROM `cms_listings` as `listings` WHERE (MATCH(headline,content) AGAINST('2 bedroom' IN BOOLEAN MODE) HAVING relevance > 0.2) ORDER BY area, relevance DESC, date_available DESC

MYSQL gives a syntax error at the "HAVING". If I remove the parenthesis after WHERE and before HAVING it works.

CMS Builder is inserting these parentheses. Is there a way to avoid this?

Views

Wed, 08 Jun 2011 11:59:59 -0700

Could you guys support Views?

I want to be able to have a view that selects data from 2 tables with same columns.

I actually managed to do this by first creating a section in CMS with the columns that I wanted, then with phpmyadmin, I dropped the table and created a view to replace the table.

Works great except that CMS complained that my view was not a table, line 213 of lib/database_functions.php, once I removed the die statement, everything worked fine.

mysql_query("ALTER TABLE `".mysql_escape($mysqlTableName)."` $addFieldSQL") or die("Error adding fields to '$mysqlTableName', the error was:\n\n". htmlspecialchars(mysql_error()));

Would be a nice feature for a future release.

Re: [Dave] sessions and timeouts - general overview needed

Mon, 02 May 2011 10:00:12 -0700

hum... been doing php for a lot of years and by changing the timeout in the php.ini it works, don't see why I would have to create a separate folder for it to work. PHP manages those session not the hosting company, especially not on a vps server.

Re: [Jason] sessions and timeouts - general overview needed

Fri, 29 Apr 2011 14:01:08 -0700

session timeout is set to 60*60*24 in init.php, yet the admin times out after 20 min.

Is the admin timeout set somewhere else?

Re: [chris] CMS Editor - Sort by multiple columns

Wed, 22 Dec 2010 19:34:58 -0800

How about you implement it like the search, where you can specify multiple fields to sort on

Re: [chris] CMS Editor - add item to a list

Wed, 22 Dec 2010 19:31:52 -0800

This is your reply to everything... We can do it ... custom programing...

Could you please add this to your list of future enhancements?

Re: [chris] CMS Editor - Sort by multiple columns

Wed, 22 Dec 2010 19:23:30 -0800

Could you please add this to your list of future enhancements?

CMS Editor - add item to a list

Wed, 22 Dec 2010 14:46:57 -0800

In the CMS Editor, when I am adding/editing content. I would like to ability to add an item to a pulldown list on the fly if it is not the list without having to bail out of the section and go to the "list" section, add the item and come back to the content I was editing.

CMS Editor - Filter

Wed, 22 Dec 2010 14:44:15 -0800

In the CMS Editor, when I am viewing a section, is there a way to filter information based on one of the fields? For example: where type<>'BLOG'

CMS Editor - Sort by multiple columns

Wed, 22 Dec 2010 14:42:45 -0800

In the CMS Editor, when I am viewing a section I can click on a column to sort by that column, I would like to be able to sort on multiple columns?

Re: [mdegive] Search the whole CMS

Thu, 16 Dec 2010 18:50:33 -0800

Here is what I added in the query section:
if ($where) { $query .= "WHERE $where"; }

//MMD orderBy
if (@$searchOptions['orderBy']!="")
$query .= " ORDER BY ".$searchOptions['orderBy']." ";
//MMD orderBy END

$query .= getMysqlLimit($searchOptions['perPage'], @$_REQUEST['page']);

Works GREAT! Can you add that to your next release?

Re: [mdegive] Search the whole CMS

Thu, 16 Dec 2010 18:36:31 -0800

I can code it myself, but I thought your others users would benefit from that feature. Should be pretty simple to add at the end of the select

Re: [mdegive] Search the whole CMS

Thu, 16 Dec 2010 17:23:46 -0800

By the way, thank you VERY MUCH. That is exactly what I wanted![laugh]

I added an OrderBy option but it is not added to the query:
$searchOptions['orderBy'] = "pub_date DESC, title";

SELECT SQL_CALC_FOUND_ROWS * FROM ( SELECT 'news' as `tablename`, num, `title` as `_title`, `content` as `_summary`, `pub_date` as `field1`, `type` as `field2`, `link_url` as `field3`, '' as `field4`, '' as `field5`, '' as `field6`, '' as `field7`, '' as `field8`, '' as `field9`, '' as `field10`, CONCAT_WS('\t', `title`, `content`) as _content FROM `cms_news` UNION SELECT 'newsletters' as `tablename`, num, `title` as `_title`, `content` as `_summary`, `pub_date` as `field1`, '' as `field2`, '' as `field3`, '' as `field4`, '' as `field5`, '' as `field6`, '' as `field7`, '' as `field8`, '' as `field9`, '' as `field10`, CONCAT_WS('\t', `title`, `content`) as _content FROM `cms_newsletters` UNION SELECT 'press' as `tablename`, num, `title` as `_title`, `content` as `_summary`, `pub_date` as `field1`, '' as `field2`, '' as `field3`, '' as `field4`, '' as `field5`, '' as `field6`, '' as `field7`, '' as `field8`, '' as `field9`, '' as `field10`, CONCAT_WS('\t', `title`, `content`) as _content FROM `cms_press` UNION SELECT 'reports' as `tablename`, num, `title` as `_title`, `content` as `_summary`, `pub_date` as `field1`, '' as `field2`, '' as `field3`, '' as `field4`, '' as `field5`, '' as `field6`, '' as `field7`, '' as `field8`, '' as `field9`, '' as `field10`, CONCAT_WS('\t', `title`, `content`) as _content FROM `cms_reports` UNION SELECT 'white_papers' as `tablename`, num, `title` as `_title`, `content` as `_summary`, `pub_date` as `field1`, '' as `field2`, '' as `field3`, '' as `field4`, '' as `field5`, '' as `field6`, '' as `field7`, '' as `field8`, '' as `field9`, '' as `field10`, CONCAT_WS('\t', `title`, `content`) as _content FROM `cms_white_papers` ) as combinedTable WHERE (`_content` LIKE '%linley%') LIMIT 10 OFFSET 10

non-breaking spaces are stripped from table cell contents

Mon, 13 Dec 2010 17:53:12 -0800

non-breaking spaces are stripped from table cell contents.
for example, " text text"
after save becomes " text text"

Re: [Jason] Search the whole CMS

Wed, 24 Nov 2010 12:10:20 -0800

Well that's really too bad for CMS system it should have this capability, most of them do...

You really did b=not answer my question though!

As I explained I need to search across multiple tables, I understand you had a script called MultiSearch.php, where can I find it?

Search the whole CMS

Tue, 23 Nov 2010 18:11:06 -0800

When I bought CMS Builder, I also bought the Search Engine. I though this search engine would be based on the CMS and let me search in any of the sections I created but instead it is just a search engine that searches through html pages. No good to me.

I can't believe that CMSBuilder does not have a search capability built in or a plugin that would let me specify what sections/field to search on.

I saw that somebody created MultiSearch.php but I am not sure where to find the latest version of this script.

Help!