Re: [rconring] admin page not showing all section editors that are in the DB

Sun, 14 Oct 2012 07:38:21 -0700

Thanks for the tip. I will remember that for next time. This is a strange one. I still have access to the old site via ip. When I ftp there and look at the schema file the scrapbooking is missing from that one too. but when i use the IP to log into the admin on that site it shows up and I can access it. So if the Schema file controls access to the editors then I sure don't know what is happening here.

I guess while I have access to the data in the old site I will just create a new scrapbooking under a different name, edit the web page,

Thanks

admin page not showing all section editors that are in the DB

Sat, 13 Oct 2012 05:37:28 -0700

I moved to a new host and updated to v2.17 and have been having some problems with paths etc. that required me to update the web pages. On one of the pages I was trying to fix there was an error about a DB table named scrapbook_retreat that I couldn't fix. I Went to the admin page and discovered that section editor was not listed. I thought that there had been an error in the DB when doing the backup from the old host or the restore to the new host. so I was going to re-create that section editor. I received an error message tellng me that table name is in use to chose another. I went into phpMyAdmin to look at the DB. The Table scrapbook_retreat was there. it looked OK. I did run the Check DB and it checked OK. I ran the fix DB even thought the Check DB said everything was OK. That did not fix the problem. That table did not show up. The is also another table that I noticed in the DB that is not showing up in the admin page. Any ideas on what when wrong and what I can do to fix it?

Re: [greg] update 2.13 to 2.17 moved to new server viewing issues

Fri, 12 Oct 2012 21:08:37 -0700

Yes, I understand that I cannot draw data from the old server. what I was saying is that some of the paths are working and some are not. I just replaced the
require_once "/usr/local/apache/htdocs/shetek.org/cmsAdmin/lib/viewer_functions.php"; with
require_once "/home/shetek/public_html/cmsAdmin/lib/viewer_functions.php";
Some of the pages were still working witht the /usr/local ..... path which I know is the wrong path and should not work which is what got me wondering. .

and now that I have the updated version it appears as though I need to change all the pages to
// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/shetek/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."); }

And that should solve my problems. Is that correct?

update 2.13 to 2.17 moved to new server viewing issues

Thu, 11 Oct 2012 06:39:46 -0700

I moved shetek.org to a new server and updated to 2.17at the same time. Now I am having a strange issue. some of the pages work fine and other just show errors because cant find the files. The paths on the new server are different than the old. plus the code in the code generator is different in 2.17 than in the 2.13 so I have to modify the .php pages to properly access the DB. This issue I am having is that some of the pages still work with the old path and the old code and some pages require the new code. almost like some of the pages are drawing on the old version and some on the new. I have gone in to the admin panel and updated the page and that is shown properly. But If I modity any part of the page in dreamweaver and replace it on the server then I get the errors on that page and it requires the new code. I plan to modify the pages but I am wondering if you know what is happening and short of removing the cms and reinstalling how can I be sure that the 2.17 is in place. the admin panel does say ver 2.17

Re: [Jason] not saving updates

Mon, 19 Dec 2011 21:01:41 -0800

I am working with my client now to determine how many sections are affected. Once I have that information I will let you know.

Re: [gkornbluth] not saving updates

Mon, 19 Dec 2011 08:40:40 -0800

I did not change any settings. When I click on advanced settings nothing happens.
What I did find is that when I click on the HTML icon it opens the html window but there is no code there? This is a mulit-record section and I was able to add another section and save it. For that new recorde I can see the HTML. but I cannot control any of the formatting with the WYSIWYG even though the content is set up that way.

not saving updates

Thu, 15 Dec 2011 21:43:26 -0800

updated from 1.3 to 2.7 and having some issues. There is one page that will not save an update so the page cannot be changed. Other pages seem to work OK so I am not sure where to start looking.

This is the setup of the page that I cannot edit Admin > [url "http://shetek.org/cmsAdmin/admin.php?menu=database&action=listTables"]Section Editors[/#0066cc][/url] > [url "http://shetek.org/cmsAdmin/admin.php?menu=database&action=editTable&tableName=summer_employment"]summer employment[/#800080][/url] General Viewer Urls Searching Sorting Advanced
Section Name Indent on menubar Table Name cms_ Database table name used by PHP and MySQL Section Type Multi Record
ListPage Fields
These fields are displayed on the [url "http://shetek.org/cmsAdmin/admin.php?menu=summer_employment"]editor list page[/#800080][/url] (beside modify and erase)

example: field1, field2 List Page Url example: /news/newsList.php Detail Page Url example: /news/newsDetail.php Preview Page Url leave blank to use Detail Page Url These urls are used when creating links to viewers for this section.
Update the urls and filenames to match the viewers you create.

Filename Fields
example: field1, field2
These fields are added to viewer links to create more descriptive urls for users
and search engines. The first field value that isn't blank is used.
Example Url: viewer.php?record_title_goes_here-123
Search Fields title, content

This section lets you control what search options are available on the [url "http://shetek.org/cmsAdmin/admin.php?menu=summer_employment"]editor list page[/#800080][/url]. Disabling Search If you don't want any search options displayed just leave the box above blank.

Simple Search For basic search functionality enter a list of comma separated fieldnames on the first line only. The editor list will display a single keyword search field that allows your users to search on those fields. Example: title, content

Advanced Search For each search field you want to appear enter the following: Label|FieldList|searchType

label - This is displayed before the search field, such as: Category, Hidden, etc
fieldlist - This is the fieldname or fieldnames (comma separated) to be searched. If there are multiple fieldnames a text field will be displayed. If there is only one fieldname and it is a list or checkbox field a dropdown list of options will be displayed. (Tip: enter _all_ for all fields).
searchType - This can be one of: match, keyword, prefix, query, min, max, year, month or day. See the docs for more details on search types. Example:

Keyword|title,content|query
Status|product_status|match
Hidden|hidden|match
Full Name|createdBy.fullname (special case for searching by record owner)

This example search might look something like this:

Keyword Status Checked Unchecked

Tip: Use your own fieldnames instead of the examples. Order By
These sorting settings are used for both the [url "http://shetek.org/cmsAdmin/admin.php?menu=summer_employment"]editor[/#800080][/url] and the viewers (although viewers can override them). Here are some common sorting values that can be used here and in the viewers. Use your own fieldnames instead of the examples.
title, author sort by title, then author

date DESC, title sort by date in descending order (newest first), then by title

price+0, date sort by price numerically, then by date (oldest first)

featured DESC, date DESC sort featured (checkbox field) records first, then order by date (newest first)

RAND( ) sort in random order (for viewers only)

Tip: The "Order By" field is actually just the standard MySQL ORDER BY clause of a SELECT statement. So if you're familiar with MySQL you can enter any ORDER BY clause you want here. Otherwise, congratulations! You just learned some MySQL! Max Records Max records for this section (leave blank for unlimited) Max records per user (leave blank for unlimited) Disable Add Don't allow adding records Disable View Don't allow viewing of records through "view" menu Disable Modify Don't allow modifying records Disable Erase Don't allow removing records Disable Preview Don't allow previewing records Disabled Accounts Viewers: Hide records that are "Created By" a user who is: deleted, disabled, or expired Hide Menu Don't show this section on the menu bar Required Plugins Example: plugin1.php, plugin2.php Drag Field Label Field Type Field Name Action
none text field text box wysiwyg date/time list checkbox upload separator [img]http://shetek.org/cmsAdmin/lib/images/drag.gif[/img]
Record Number none
num
system field [img]http://shetek.org/cmsAdmin/lib/images/drag.gif[/img]
Created none
createdDate
system field [img]http://shetek.org/cmsAdmin/lib/images/drag.gif[/img]
Created By none
createdByUserNum
system field [img]http://shetek.org/cmsAdmin/lib/images/drag.gif[/img]
Last Updated none
updatedDate
system field [img]http://shetek.org/cmsAdmin/lib/images/drag.gif[/img]
Last Updated By none
updatedByUserNum
system field [img]http://shetek.org/cmsAdmin/lib/images/drag.gif[/img]
Order none
dragSortOrder
modify erase [img]http://shetek.org/cmsAdmin/lib/images/drag.gif[/img]
Title textfield
title
modify erase [img]http://shetek.org/cmsAdmin/lib/images/drag.gif[/img]
Content wysiwyg
content
[url "http://shetek.org/cmsAdmin/admin.php?menu=database&action=editTable&tableName=summer_employment#"]modify[/#0066cc][/url] [url "http://shetek.org/cmsAdmin/admin.php?menu=database&action=editTable&tableName=summer_employment#"]erase[/#0066cc][/url] Any ideas ?

wysiwyg editor in ver 2.3

Thu, 15 Dec 2011 18:36:49 -0800

I just upgraded a client site to 2.3 and it seems that the sysiwyg editor is having some issues. He stated

[font "Calibri"]"another thing I’ve noticed is when I create a link now on the website, I used to be able to change the color of the font for the link. Now I can select a different color for the text but when I make it a link it seems to go to the default black or whatever it is, and I can’t change it back unless I don’t make it a link."[/#000000]
I am able to go into the html and edit that so the link is the color he wants but it no longer seems to let him make the changes through the editor.
Did something change with the editor or is this a new issue.

browser settings

Sun, 13 Nov 2011 08:24:17 -0800

I have a client who has been using CMS builder for a few years. Shetek.org One of his staff got a new laptop. Now she cannot update.She can log in just fine but changes that she makes are not saved to the database. I Determined that it is not her user credentials. She can log in from other computers and update successfully. Other users that can also update successfully from their own computers are unable to update when they use the new laptop. so it would appear to be a security issue with IE. I am wondering what settings in IE would not allow the update. Thanks Jerry

Re: [chris] how to filter fields

Thu, 11 Feb 2010 06:37:44 -0800

Hi Chris,

The problem was somewhere in the viewer code. I couldn't see anything that looked out of place but I did delete all the code on my page and recopied the viewer code. Now it works fine. So the filter portion of the code was good. just something with the view code but that was easy enought to copy and replace.

Thanks.

Re: [vyskocil] how to filter fields

Mon, 08 Feb 2010 21:23:54 -0800

That didn't fix the problem like I thought. The links now show. They look identical to the links on the documents page but they don't point to the pdf files when I filter out by category

???

suggestions.

Re: [Dave] how to filter fields

Mon, 08 Feb 2010 20:39:54 -0800

Hi Dave,

Thanks, I had two problems. I had renamed the table column and forgot to change the script. The second part is the like syntax was wrong.

this is what didn't work
'where' => " catagories LIKE '%\temployment forms\t%' ", )); ?>[/#000000]

This is what did work
'where' => "catagory LIKE 'employment forms' ", )); ?>

Thanks for all your help.

how to filter fields

Sat, 06 Feb 2010 16:28:48 -0800

I have set up a document managemt system using a multi record. I have separate tables for each type of form. catagory. For example there is a table named employment forms. in that table there is an upload field and a text field named catagory. catagory is labeled Employment Forms so that will be echo'd to the page. So in that one table I have the documents for employment. Then there is another table set up the same named registrations for registration documents. On the website there is a documents page that shows all documents for download and are listed by catagory. What I want to do is on a separate page to list just one catagory from that multi record. So on a page that references registrations that I could pull just the documents having to do with registrations. I tried add the like statement

list($docsRecords, $docsMetaData) = getRecords(array(
'tableName' => 'docs',
'where' => " catagories LIKE '%\temployment forms\t%' ", ));

When I use that I get no records found and the page shows nothing.

What code do I use to sort on the field catagories

Thanks

Re: [gkornbluth] pdf download

Wed, 03 Feb 2010 22:58:59 -0800

Thanks Jerry,

I did get your book. Lots of great information. Just didn't put two and two together. I was using the variable names and not the field names. There is sure lots of help in this forum. Thanks everyone.

Re: [vyskocil] pdf download

Wed, 03 Feb 2010 22:36:01 -0800

[:)]Thanks Dave,

It works well when using the correct names.

pdf download

Wed, 03 Feb 2010 22:21:29 -0800

I created a multi record editor for the purpose of document management type system using categories. everything seems to work fine with one exception. the file name is the link to download the pdf file. There are the extra custom info fields. Default names = title and caption. I would like to be able to use one or the other of those as the link in place of the file name. I just tried using the generated code and turned off the echo for the file name and tried to add in the field name title / caption. I get error msg. I have search the forum, lots on using images for links but can't find what I need to do to use one of the custom info fields.

Thanks

.

Re: [Dave] two or more editable regions

Thu, 14 Jan 2010 06:40:11 -0800

Thanks Dave,

That did the trick. I changed the DB names and all is well

Re: [Dave] two or more editable regions

Sun, 10 Jan 2010 08:22:25 -0800

Thanks Dave

attached are the two files. the 2-4grade.php has the viewers in the right hand column that are working. the 2-4-2grade.php is the same file but with an additional viewer added in the body section. both files are currently uploaded to the webiste.

Jerry

two or more editable regions

Sun, 10 Jan 2010 08:22:25 -0800

N/A

two or more editable regions

Sat, 09 Jan 2010 20:00:35 -0800

I have a page that I have two editable regions in the right hand column. When I try to add a third in the body the entire page will not come up. I am sure something to do with the php in the code but just cannot figure out what it is. I guess I am not sure why it works in the right hand column but not the main body. Any ideas?

to look at the page I am talking about http://shetek.org/2-4grade.php this will show the two right column CMS regions and I just put the text in the body where I tried to add another.

Re: [Dave] Image on listing page

Tue, 27 Jan 2009 22:48:39 -0800

HI Dave,

That is one of the suggestions that I found in the forum and tried. I did try that again in case I had it in the wrong place. And you are correct that it stops the loop after one image. Then I get NO image for the second, third, etc. listings. I get only the one image on the first listing only. The rest of the listings list all the info but no images. When I remove the that I just added then I am back to showing all the images for all the listings. What I would like is this. If I have 5 listings and each has 5 pictures I want the 5 listings to show on the listings page but I want only the first image of each listing to show. I only need to show all the images on the listingDetail page. Your answer seems to indicate that the loop for the images is nested inside the loop for the listing. That is not the way it appears the code is generated. It has a step2 display records which has an endforeach and then a step2a display uploads. Both seem to be independent loops and not nested. So can you help me out a little more. My code is displayed below:

Listings - List Page Viewer

Record Number:

Featured Property:

Property Type:

Price:

MLS #:

Address:

City:

State / Province:

Summary:

Description:

View Listing :

No records were found!

" width="" height="" alt="" />

" width="" height="" alt="" />

Download

Image on listing page

Tue, 27 Jan 2009 08:45:59 -0800

On this listings page all the images are showing. I read through the posts and tried several of the suggestions. Then I end up getting only one image, but the one image is for the entire listings page. So the first listing will now have one image and the listings following have no images.

How can I get the listings page to show only one image for each of the listings?

Thanks

Re: [Damon] format question

Tue, 02 Dec 2008 22:17:59 -0800

Yes that was causing the problem. I will look at some of the solutions to removing the p tag that I have seen in the forum. Thanks

format question

Tue, 02 Dec 2008 11:08:40 -0800

I built an FAQ page. When viewing the page it shows

Question: The question would be here on the same line
Answer:
But the answer would be on the line below.

I checked the code and I do not see an extra break in between the "Answer" the and php code that would cause the answer output to be placed on the line below.
Question:

Answer:

Any suggestion ??

Re: [Dave] formating issue

Wed, 05 Nov 2008 15:52:30 -0800

Thanks Dave ! That did the trick. [cool]