Re: [Tom P] Firefox Problem

Wed, 21 Mar 2012 15:48:11 -0700

Tom,

I installed the new version of TinyMCE and that fixed the problem. Thanks for looking into this and providing the fix.

Phil C

Re: [Tom P] Firefox Problem

Wed, 21 Mar 2012 10:50:21 -0700

Thanks for checking into it. I have verified that FF 10.x works fine.

I only have one site that uses multiple WYSIWYG fields so the other browser will the answer for now.

For what it is worth, I did do some testing on TinyMCE's fiddle site and did have multiple editors on one page and it seemed to work ok.

Re: [pcolvin] Firefox Problem

Wed, 21 Mar 2012 09:49:34 -0700

Just a quick update. I was able to try this on a Windows 7 machine and have the same problem.

It worked fine in Firefox version 10.x but after upgrading to Firefox 11.x it exhibits the same problem when there are two WYSIWYG fields in a section editor.

Firefox 11 Problem

Tue, 20 Mar 2012 22:19:49 -0700

I have run into a problem with Firefox 11.x and was wondering if anyone else may be having the same issue.

If I have more than one WYSIWYG field in a section, I cannot access any of the content in the first WYSIWYG field. I can see what was entered in the filed if it hit the HTML button to see the raw HTML code, but the editor just is blank. If I hover over the first field, I get a tool tip that says "Rich Text Area. Press Alt F10 for toolbar. Press Alt 0 for Help".

The second WYSIWYG field works fine and you can enter and edit text.

I have tested this in Safari and Google Chrome and both fields work fine in those browsers.

I'm using a MacBook Pro with OS X Lion. I have not had the chance to see if the behavior is the same on a Windows machine. This happens with both version 2.08 and 2.10 of CMSB. I have not had the chance to try this with 2.14.

I believe this problem started after upgrading to Firefox 11. If anyone else is having a similar problem, please let me know. I will do some research with TinyMCE as well.

Thanks in advance.

Re: [pcolvin] Sort Uploads by createdTime

Tue, 21 Feb 2012 09:32:50 -0800

Jason,

Thanks. It works perfectly!

Phil

Sort Uploads by createdTime

Sat, 18 Feb 2012 13:32:56 -0800

I have a page that displays a gallery of photos that are grouped by a category. I need to sort the photos in each category by the createdTime system field in the uploads table so that the most recently uploaded photo appears at the top of the table inside each category header.

I have attached the page that I'm working on. I'm sure this is a rather simple task to do, but I'm missing something here.

I've tried to get the records from the uploads table and sort them as needed, but I cannot seem to display on the page. They need to be displayed inside the category foreach loop.

Any help will be appreciated.

Re: [Jason] Upload Paths & URL not working since upgrade to 2.09

Mon, 04 Jul 2011 13:49:24 -0700

Jason,

This make sense now. The site that I had the problem with generates the URLs on the menu system a bit differently. I will add that variable to the site's menu code. I'm sure that will fix it.

Thanks

Phil

Re: [pcolvin] Error with Preview

Mon, 04 Jul 2011 13:47:28 -0700

Quick update.

The problem with the record not found was from another set of code for another viewer on the same page. It only has one record and I did not have the code in to select the first record. That is fixed and the page now displays correctly.

I did find one thing that was causing a problem at least with this hosting provider. If I kept in the this line from the Code Generator . I was able to correct this with a setting in my text editor. It was saving the file as a UTF-8 BOM. I changed that to just UTF-8 and that cleared up that problem.

All in all thing are working correctly now. The Preview works now that I have used the new code from the code generator and also made sure the file was being saved correctly.

Thanks for the help.

Phil

Re: [robin] Error with Preview

Mon, 04 Jul 2011 13:05:08 -0700

Robin,

I have run into that before as well and I did just verify there were no lines or spaces.

I did make me think of one thing and that was to update the viewer code at the top of the document with the new version. After doing this I now get a No Record Found error when I try to Preview it or view the Detail Record from the List Viewer.

However, if I open just the Detail Viewer Page, I do get the last record as expected and the page loads fine. Now I just cannot open Detail by loading from the record number at the end of the URL.

Phil

Re: [Dave] 500 Internal Server Error after Upgrade to 2.10

Sun, 03 Jul 2011 15:06:12 -0700

Great. I'll comment them out for now. I will check with my hosting provider. I have upgraded other sites with no problem.

Phil

500 Internal Server Error after Upgrade to 2.10

Sat, 02 Jul 2011 06:40:55 -0700

I just upgraded to 2.10 and when trying to access the CMSB admin.php page I received the 500 error. I was able to fix this by renaming the new .htaccess file and copying the old .htaccess file from 2.09.

It appears that the only difference between the new and old file are these lines.

# Enable error checking
php_flag display_errors On
php_flag display_startup_errors On
php_flag log_errors On
php_value error_log "_php_error.log"

I'm thinking this is an issue with my hosting provider. The question is, will not having these line in here cause any problems down the road. I don't think so, but would like to be sure.

Thanks

pcolvin

Upload Paths & URL not working since upgrade to 2.09

Fri, 01 Jul 2011 20:37:00 -0700

I recently upgraded a site to 2.09 from 2.06. After the upgrade, all of the paths and/or URLs for the uploads are not correct. I have checked the General Settings and the correct path and URL are there. Even when adding a new upload, the path in the URL on the viewer is not correct.

I looked in the cms_uploads table and in the filePath and urlPath fields just the file name is listed.

I have checked the permission of all files including the setting.dat.php and everything is as it should be.

I'm in a bit of problem spot with this site since the majority of the content is documents.

I'm going to roll back the site to a backup prior to the upgrade to get things working again. If anyone else has had this problem, or know how to fix it, that would be great.

pcolvin

Error with Preview

Thu, 30 Jun 2011 13:23:24 -0700

Has anyone received a similar error when trying to preview a detail viewer?

Couldn't start session! 'session_start(): Cannot send session cache limiter - headers already sent (output started at /home/fdmjweb/public_html/apparatus.php:2)'!

Preview works fine on other sites, gust this one is giving me a problem. I have tried a few different things and could not find anything else similar in the formums..

Thanks

P Colvin

Re: [Jason] Sorting Uploads

Wed, 12 Jan 2011 15:23:59 -0800

Jason,

I got the second query working perfectly with the date. Thank you.

I'll fill out a second level request for the other one.

Thanks

Phil

Re: [Jason] Sorting Uploads

Wed, 12 Jan 2011 14:20:50 -0800

Jason,

I do want to sort on the dragSortOrder field for the one upload field. I have tried putting the order in single quotes, the page displays but no sorting takes place. See below for the code I'm using.

  //get uploads for the selected record other docs
  list($upload_otherRecords, $upload_otherMetaData)=getRecords(array( 
    'tableName'       =>      'uploads', 
    'allowSearch'     =>      false, 
    'where'			  =>	  "tableName='".mysql_escape(@$_REQUEST['section'])."' AND fieldName='other_docs' AND recordNum='".intval($myRecord['num'])."'",
	'orderBy'		  =>	  "'order'",
	'debugSql' => true,
    ));

Here is the output from the debugSql

SELECT SQL_CALC_FOUND_ROWS `uploads`.* FROM `cms_uploads` as `uploads` WHERE (tableName='exec_comm' AND fieldName='other_docs' AND recordNum='1') ORDER BY 'order'

Now for another question which is probably also a syntax problem.

In the other upload field which is for meeting minutes, I would like to sort them by the info1 field which contains and English date such as November 1, 2010. Is it possible to take the English date and use the strtotime() function to covert it to a number and then sort by the number? See the code below and the SQL ouput:

  //get uploads for the selected record meeting minutes
  list($upload_minutesRecords, $upload_minutesMetaData)=getRecords(array( 
    'tableName'       =>      'uploads', 
    'allowSearch'     =>      false, 
    'where'			  =>	  "tableName='".mysql_escape(@$_REQUEST['section'])."' AND fieldName='meeting_minutes' AND recordNum='".intval($myRecord['num'])."'",
    'orderBy'         =>      "\" strtotime('info1')\"",
	'debugSql' => true,	
    ));

I know what I have in the orderBy will not work since it sees the function inside the quotes. I just don't have my head around the proper PHP syntax just yet to get it right.

SQL output:

SELECT SQL_CALC_FOUND_ROWS `uploads`.* FROM `cms_uploads` as `uploads` WHERE (tableName='exec_comm' AND fieldName='meeting_minutes' AND recordNum='1') ORDER BY " strtotime('info1')"

Sorry to be such a pain with this. Hopefully I'm close enough and will soon have this working.

Thanks

Phil

Re: [pcolvin] Sorting Uploads

Wed, 12 Jan 2011 11:50:23 -0800

Jason,

I have pretty much everything working they way I need it to except one small thing. I have two upload fields in the section. One for meeting minutes and one for other documents. The other documents field I would like to sort ascending by the "order" field, or the drag sort order, but when I try to use that field in the orderBy line, I get the following 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' at line 4

If I put the field name "order" inside single quotes ("'order'") the error goes away, but the uploads are not sorted. They appear in the order they are in the table.

If I take out the orderBy line all together, I then get the following error appear on the page:

Notice: Undefined index: listPageOrder in /path/to/htdocs/cmsAdmin/lib/viewer_functions.php on line 67

I'm hoping there is an easy fix to this and I'm just not seeing it. Below is the code that I'm using to load the upload records and sort them:

  //get uploads for the selected record other docs
  list($upload_otherRecords, $upload_otherMetaData)=getRecords(array( 
    'tableName'       =>      'uploads', 
    'allowSearch'     =>      false, 
    'where'			  =>	  "tableName='".mysql_escape(@$_REQUEST['section'])."' AND fieldName='other_docs' AND recordNum='".intval($myRecord['num'])."'",
	'orderBy'		  =>	  "order",
    ));

Thanks

Phil

Re: [Jason] Sorting Uploads

Tue, 11 Jan 2011 14:46:04 -0800

Jason,

I think I may be getting closer but I'm still having some problems. If I use the example code to load the records, I get the following error.

loadSchema: tableName ''exec_comm'' contains invalid characters!

If I change the line

'tableName' => "'".mysql_escape($_REQUEST['section'])."'",

back to

'tableName' => $_REQUEST['section'],

the error goes away and the page is displayed. However, when I do get the page to display, the upload fields, which I should have mentioned I have more than one, but only need to sort one of those fields, errors as an Undefined Index. I have tried replacing the fieldName with the actual name of the upload field, but that did not seem to correct that problem.

Thanks

Phil

Re: [pcolvin] Sorting Uploads

Tue, 11 Jan 2011 13:44:33 -0800

One other thing that I forgot to include in the last post. The field name that I'm using is meeting_minutes. In your example it was images.

Instead of sorting on the createdTime, I was hoping I could use the info1 field which I then enter a date such as November 1, 2010. This way if the files are not loaded in the proper sequence, they can be sorted correctly. I'm sure I would have to use the strtotime() function to change the data in the field to something that can be sorted.

Thanks

Phil

Re: [Jason] Sorting Uploads

Tue, 11 Jan 2011 13:37:06 -0800

Jason,

I should have been more clear. I'm trying to get the record and also the uploads so they can be sorted.

I have attached the .php page.

Thanks

Phil

Re: [Jason] Sorting Uploads

Tue, 11 Jan 2011 12:54:44 -0800

Jason,

I may need some guidance getting this solution to work on the site I'm currently building.

I select the records for the page dynamically depending with the code below:

  // load records for the page called.
  list($myRecords, $myMetaData) = getRecords(array( 
    'tableName'   => $_REQUEST['section'], 
    'where'       => mysql_escapef('num = ?', $_REQUEST['num']), 
    'limit'       => '1', 
  )); 
  $myRecord = @$myRecords[0]; // get first record

I have tried a couple of variants to get the code working to load the records, but can't quite figure it out. Any ideas?

Thanks

Phil

Need Help with Error

Mon, 10 Jan 2011 16:13:51 -0800

I need some help tracking down an error. I've looked but can't put my finger on what is causing it.

I keep getting the following error at the top of the page.

Notice: Undefined index: listPageOrder in /var/www/sctf/htdocs/cmsAdmin/lib/viewer_functions.php on line 67

I have attached the code for the page to see if someone might be able to find what is generating the error. The page renders fine and the menu works. I just get this error at the top. I have tried to change items in the Sort Order and even removed everything.

Thanks in advance for any help.

P Colvin

Re: [Jason] Sorting Uploads

Mon, 10 Jan 2011 13:00:25 -0800

Jason,

Thank you, I'm sure I can get this to work for me.

Phil

Sorting Uploads

Fri, 07 Jan 2011 23:55:24 -0800

I have seen a couple of threads that touches on this and I'm sure it can be done. I have several sections on a site that uses the uploads to post dated documents. I need to list the most recently uploaded document at top of the list of upload that is displayed on the page.

I'm guessing the best way to do this is to use one of the Info fields to do the sorting. Would it be possible to use the PHP Date function to insert the date the document was uploaded into one of the Info fields. If so, what would be a good way to sort the uploaded documents using this field.

If I'm off track with the Info field direction, are there any other solutions to sorting the uploads by the date of upload.

Thanks

P Colvin

Re: [chris] Help with Site Layout

Wed, 22 Dec 2010 09:16:10 -0800

That was it. Work perfectly...

Thanks

Re: [chris] Help with Site Layout

Tue, 21 Dec 2010 16:10:06 -0800

Chris,

It's been a while since I could work on this, but now I'm back. The code your provided works great for looping through all the tables to build the menu. However, when I try to build and UL with the code below, I get extra blank list items.

It looks like this: (Note: the sub menu items (o) are indented as they should be.

*
*Menu Item
o
o Sub Menu Item
o
o Sub Menu Item

*
* Menu Item
o
o Sub Menu Item
o
o Sub Menu Item

*
* Menu
o
o Sub Menu

I can't figure out where the blank list item is coming from. I've tried moving the

	
   $categoryRecords): ?>