Custom label in list selection box

Mon, 23 Nov 2015 13:34:13 -0800

Daryl,

You're my new hero. Thanks so much. This worked perfectly.

Jim

Custom label in list selection box

Sun, 22 Nov 2015 17:22:53 -0800

I have a table called 'workshops' that includes the following fields: num, date, location, title

Next I have another table called 'newsletters' where the client will create newsletters. This is where the client will fill out all the particulars to create the newsletter. As part of this process, it will display a multi-select dropdown list where the client can select which workshops they want to promote in that month's newsletter. Sometimes though, the workshops are exactly the same with the exception of the date. I created the list field using the "Get options from database (advanced)" selection using the following options:

Tablename: workshops
Option Values: num
Option Labels: title

A problem immediately rears its head. For many of the workshops the title is exactly the same. There's no way for the client to tell one from the other when selecting them in the list box. It would be great if I could add more than one label to each selection item. For example, if I have three workshops all called "Investing in Turbulent Times", instead of seeing that indistinguishable label repeated three times i the list box, it would be nice to be able to preface it with the date field so that the selection items read more like:

Nov 12th, 2015: Investing in Turbulent Times
Dec 2nd, 2015: Investing in Turbulent Times
Dec 10th, 2015: Investing in Turbulent Times

This way the client would know which particular workshops they are selecting.

Is there any way to do that besides forcing the client to edit the title of each workshop to include the date?

Thanks in advance.

Jim

Thumbnails not showing up in CMS if PREFIX_URL is set

Sat, 17 Aug 2013 07:15:21 -0700

Thanks for the follow-up, Greg. That explanation makes sense. All seems to be working pretty well now.

Jim

Thumbnails not showing up in CMS if PREFIX_URL is set

Wed, 14 Aug 2013 10:48:09 -0700

Thanks Greg. I thought there was something wrong. Actually, I always keep my upload folder OUT of the cmsAdmin directory. I'll make the changes you suggest adjusted for my own settings and see if it helps. I think I already tried those settings you suggest, but I'll try again. Maybe I missed something.

Jim

[Note: -- I forgot that I had created a little JavaScript that was massaging my website image URLs. I removed it and made the changes you suggested. Looks like it's working fine now. Thanks for your help.]

Thumbnails not showing up in CMS if PREFIX_URL is set

Tue, 13 Aug 2013 12:37:57 -0700

I'm building a site for a client and incorporating a few slideshows. Each slideshow has its own image directory; the images being uploaded through the CMS. The client has a site already, but we're going to be switching servers when the new site is done. So I'm working on a server by accessing it using the IP address / ~client format: ex: http://111.222.333.44/~client

In CMS builder, under General Settings, I set a Website Prefix URL of /~client.

When I set up the slideshow table I created an upload field called 'slides' and set a custom upload directory. I also set the List Page Fields to: title, slides -- so that I can see the thumbnail of the image in the listing within the CMS. The problem is that the thumbnails are not showing up. It looks like the PREFIX_URL is not being added to the img src, so I'm getting a broken URL. The slideshow, however, works perfectly in the website.

I've tried a lot of different settings combinations and nothing seems to work. For example, I can get the thumbnails to show in the CMS, but then the slideshow breaks in the website.

By the way, I do not have this problem when the site is installed on a server without a PREFIX_URL. Everything works fine then.

Either I'm doing something wrong, or else one of the CMS files needs to be edited to add a missing PREFIX_URL constant. Could use your help.

Hope I was somewhat clear about the problem. If not, let me know and I'll give you a call.

Thanks.

Jim

Re: [Jason] Uploaded images being rotated

Sat, 23 Jun 2012 18:45:53 -0700

Jason,

I've sent in the support request along with links to a couple of images you can use to test the problem.

Jim

Uploaded images being rotated

Fri, 22 Jun 2012 16:06:58 -0700

I don't recall seeing this happen in previous versions of CMSB...

Images that are taller than they are wide (vertical images) are being rotated horizontally as they are being uploaded and recreated by CMSB in order to maintain the proportions that I've set: width 480, height 360.

It's doing this for both the main image as well as the thumbnails that are created.

The weird thing is that it doesn't happen every time. But it happens more often than not.

I don't want this to happen. I'd prefer that it maintain the orientation of the original image and simply reduce the image, proportionately, so that the entire image fit in the assigned space, even if it doesn't FILL the entire space because of scaling.

Suggestions, or reasons as to why this might be happening, would be appreciated.

Thanks.

Jim

Re: [Jason] 2.15 Error when saving configuration file

Fri, 11 May 2012 14:40:17 -0700

Jason,

No need. I fixed it. It had to do with the configuration file. I had left out the [wysiwyg] section. That caused the errors.

Jim

2.15 Error when saving configuration file

Fri, 11 May 2012 08:53:11 -0700

I just upgraded a client from 2.02 to the latest version of CMS Builder, 2.15. When I click SAVE from the General Settings screen, I get the following error:

Should be an array in /home/xxxxxx/public_html/cmsAdmin/lib/menus/admin/actionHandler.php on line 214 Warning: Invalid argument supplied for foreach() in /home/xxxxxx/public_html/cmsAdmin/lib/menus/admin/actionHandler.php on line 214 Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/cmsAdmin/lib/menus/admin/actionHandler.php:214) in /home/xxxxxx/public_html/cmsAdmin/lib/menus/header.php on line 2

Also, when I go to MODIFY an existing data entry through the CMS, the following error is thrown:

Notice: Uninitialized string offset: 0 in /home/xxxxxx/public_html/cmsAdmin/lib/wysiwyg.php on line 20

Thoughts?

Jim

Re: [Jason] Bug! Link to Code Generator Page

Tue, 29 Nov 2011 14:57:56 -0800

Thanks. Guess I should have searched first.

Jim

Bug! Link to Code Generator Page

Tue, 29 Nov 2011 10:16:46 -0800

Using version 2.13.

It appears that when you are editing a record, if you use the Advanced Commands drop down menu at the bottom of the page to select Admin: Code Generator, you are directed to the Administrator General Settings page instead. I don't recall this happening in earlier versions.

Jim

Re: [Dave] Custom Upload Directory not recognized

Fri, 19 Aug 2011 22:20:22 -0700

Hi Dave,

Yes, the /gallery/ subdir exists under the /uploads/ folder on both servers.

As for what I mean by "not recognized," I mean that when I try to create a record I get an error message in the space where the file upload link normally would be. It simply says that the /gallery/ directory does not exist. If, instead, I go back to the custom upload field area and prefix the custom upload directory with the full upload dir path URL, then everything works fine.

I've got it working now using the full upload dir path method, so I'm not in trouble with this site. In fact, I'm done with the project. However, I was just curious as to what caused this since it wasted an hour or so of my time trying to figure it out and I would like to know how to fix it should I run into it again on my next CMS project.

Jim

Custom Upload Directory not recognized

Fri, 19 Aug 2011 11:34:59 -0700

I'm working on 2 separate CMS Builder site on 2 separate servers from 2 separate hosting providers.

On one of them I have no problem at all setting custom upload directories simply by typing the new upload directory into the appropriate fields. For example, if my normal upload directory has been set to be '/home/####/public_html/images/uploads/' , then the custom upload directory is simply set to something like 'gallery/' when, in fact, it is a subdirectory to the 'uploads' directory mentioned earlier.

On the other server, I have to put in the entire custom upload path of '/home/####/public_html/images/uploads/gallery' in order for it to be recognized by the CMS.

BOTH CMS's are version 2.11, the latest as of the date of this post.

I'm going to assume that there's some apache or PHP configuration that's causing this behavior on the 2nd server, i.e., requiring the full path for the custom directory.

Any ideas from you guys?

Jim

Re: [Jason] Problem with upgrade to 2.11

Fri, 22 Jul 2011 20:48:54 -0700

Jason,

You made me laugh. If you look at all the things you wanted me to move into the 2.10 folder, it was pretty much everything except the 'data' folder. So I reversed it and simply copied the 2.10 data folder into the 2.11 folder, after which the upgrade worked fine.

Thanks.

Jim

Problem with upgrade to 2.11

Thu, 21 Jul 2011 08:32:09 -0700

I have a new site that I'm working on. It's using version 2.10 of CMS Builder. I grabbed a version of 2.11 and went through the normal upgrade steps. What I do is simply drop the newer version in the same directory as the old version and then copy over the Schema files, the setup file (with appropriate version modifications and/or any new fields you may have added), set the file permissions, folder permissions, etc.

This has always worked flawlessly.

However, after this latest upgrade, it does not seem to be recognizing the settings.php file and, instead, it wants me to re-register the program and re-edit all the general setting information. As soon as I saw this, I simply flipped back to the 2.10 version and left 2.11 sitting on the server until after I get a response back from you as to what might be happening.

Thanks.

Jim

Re: [Jason] PDF creator plug-in throwing terminate error

Fri, 28 Jan 2011 14:06:09 -0800

OK. I'll see if I can figure it out first, but if I can't, then I'll do as you ask.

Jim

Re: [Jason] PDF creator plug-in throwing terminate error

Fri, 28 Jan 2011 12:56:38 -0800

Jason,

They all pass perfectly except the last one, "Visually View PDF Output." That shows my custom Error 404 page, but unstyled and not in PDF format.

Jim

PDF creator plug-in throwing terminate error

Thu, 27 Jan 2011 15:07:21 -0800

I was trying to use the PDF plug-in on a site today. It worked fine, but then started crashing with this error. Any ideas?

terminate called after throwing an instance of 'std::bad_alloc' what(): St9bad_alloc

Jim

Re: [chris] Pulling select fields from records

Thu, 16 Dec 2010 23:29:27 -0800

Thanks, Chris. That worked like a charm.

Jim

Re: [Jason] Pulling select fields from records

Thu, 16 Dec 2010 14:11:24 -0800

I am creating a website for a property management company. Each property has a LOT of fields. Using the CMS, I have a script that creates the main navigation on the fly by reading the entries to my main navigation table. At one point, I want it to jump into the properties table and just grab the 'title' and record number fields of each of the properties so that I can construct a link to each of them in a drop down menu off the main menu. In this example, it doesn't make sense to have to read in the entire properties table just to grab two fields.

As you said, I'll probably just go ahead and write this using regular sql.

Pulling select fields from records

Thu, 16 Dec 2010 12:32:24 -0800

Without resorting to straight SQL, how can you pull only specified fields from tables?

Normally, it would be something like:
SELECT title FROM ....

I can't see anyway to limit the fields that are selected using the commands that are accepted by CMS Builder.

Help?

Re: [prinsins] createPDF example

Sat, 23 Oct 2010 14:22:05 -0700

I was just playing around with it. Go to my website at:

http://www.webcampone.com/about.php

At the bottom of the page there is a link that says "Download This Page as PDF"

It does exactly what it says.

Jim

Re: [Dave] Create PDF tests OK, but throws an error on real page

Thu, 21 Oct 2010 10:02:13 -0700

Dave,

I found the problem. It seems that Create PDF crashes with the following error if the modernizr.js is loaded into the file. Modernizr.js is used to determine at run time which CSS3 and HTML5 features are supported by various browsers and to use that info when displaying the page to the user.

Modernizr.js is somewhat important to use when designing cross-browser HTML5 pages. You can find it here: http://www.modernizr.com/. Maybe someone there can take a peek and find out what's causing the problem.

Jim

Create PDF tests OK, but throws an error on real page

Fri, 08 Oct 2010 19:38:47 -0700

I installed Create PDF on a shared server tonight. All the tests work just fine. I create, display, and download PDFs just fine.

However, when I try to use it on a real website page, I get the following error:

..... plugins/createPDF/wkhtmltopdf/wkhtmltopdf-i386: symbol lookup error: .... plugins/createPDF/wkhtmltopdf/wkhtmltopdf-i386: undefined symbol: FcFreeTypeQueryFace

Any idea what might be causing that? Like I said, the tests from the plugins screen work just fine.

Jim

Re: [chris] Leading space in text field types

Thu, 23 Sep 2010 07:04:02 -0700

Chris,

Seems to be an issue with webkit enabled browsers. Not much I can do about that. Will try to figure another way around it.

Thanks.

Jim