https://interactivetools.com/forum/forum-search.php?k=user%3Awebdude Tue, 21 Apr 2026 00:11:46 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2201064#post2201064
Great! Thanks for listening!
]]> Mon, 11 Jan 2010 19:06:21 -0800 forum-posts.php?postNum=2201064#post2201064 https://interactivetools.com/forum/forum-posts.php?postNum=2201050#post2201050
We hadn't upgraded since 1.28 (where we had patched it ourselves)... but after upgrading to v2.01 the redirects are still not working.

We are running the CMS using SSL on a non-standard port.

We noticed 3 places where the CMS checks if SSL is enabled by checking $_SERVER['https'], instead of checking $_SERVER['HTTPS'] (lowercase vs uppercase). It must be changed to uppercase for it to mean anything (at least on my standard 5.3.0 PHP install) which the PHP documentation page confirms: http://ca.php.net/manual/en/reserved.variables.server.php

in the file lib/common.php on line 391:version 2.01:

$proto = (@$_SERVER["https"] == 'on' || @$_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";

bugfix:

$proto = (@$_SERVER["HTTPS"] == 'on' || @$_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";in the file lib/common.php on line 623:version 2.01:

$isHTTPS = @$_SERVER["https"] == 'on' || @$_SERVER['SERVER_PORT'] == 443;

bugfix:

$isHTTPS = @$_SERVER["HTTPS"] == 'on' || @$_SERVER['SERVER_PORT'] == 443;in the file lib/viewer_functions.php on line 1061:version 2.01:

$isHTTPS = @$_SERVER["https"] == 'on' || @$_SERVER['SERVER_PORT'] == 443;

bugfix:

$isHTTPS = @$_SERVER["HTTPS"] == 'on' || @$_SERVER['SERVER_PORT'] == 443;

The other bug is related (in the thisPageUrl function). It has to do with the fact we are using a non-standard port (eg. 84).

In the file lib/common.php, the code on line 392 extracts the current domain name from $_SERVER['HTTP_HOST'] if possible... the problem is that $_SERVER['HTTP_HOST'] sometimes (depending on the PHP install?) includes the port number if it is non-default...

So the next line 393 adds the port a 2nd time resulting in invalid urls like https://www.example.com:84:84/admin.php instead of https://www.example.com:84/admin.php

My suggested fix would be to first check that the port name was not already included in $domain and only add the port if needed. In the file lib/common.php on line 393:version 2.01:

$port = (@$_SERVER['SERVER_PORT'] && @$_SERVER['SERVER_PORT'] != 80) ? ":{$_SERVER['SERVER_PORT']}" : '';

bugfix:

if(preg_match('|:[0-9]+$|', $domain)) {
$port = '';
} else {
$port = (@$_SERVER['SERVER_PORT'] && @$_SERVER['SERVER_PORT'] != 80) ? ":{$_SERVER['SERVER_PORT']}" : '';
}

I'm sorry if this post is long winded, I just genuinely want to get this fixed. I have patched my installation and it is working great.

Thanks!
]]> Sun, 10 Jan 2010 15:34:44 -0800 forum-posts.php?postNum=2201050#post2201050 https://interactivetools.com/forum/forum-posts.php?postNum=2197081#post2197081
We found a couple buggy redirects after switching our installation to https. Some of the built-in redirects are hard-coded to urls with the regular http prefix which results in redirecting to the wrong url.

On example of such a function is logout. Clicking logout should redirect the user to https://myserver.com/admin.php but instead it is going to http://myserver.com/admin.php

After searching through I found at least 4 files where the http: was hardcoded into the redirect (meaning it wasn't checking to see if the install is running on a SSL connection). Instead of mucking around in all those places I found an easy way to fix it by adding the following line in the redirectBrowserToURL function:$url = preg_replace('|^https?://|i', @$_SERVER['HTTPS'] == 'on' ? 'https://' : 'http://', $url);It would be great if something like this can be included in the next bugfix release.

Thanks!

PS it would not be a good idea to use my fix if the redirectBrowserToURL function is being used by the code to redirect to sites other than the HTTP_HOST on which the install is running, because then the $_SERVER['HTTPS'] would be completely irrelevant.
]]> Fri, 24 Apr 2009 07:57:51 -0700 forum-posts.php?postNum=2197081#post2197081 https://interactivetools.com/forum/forum-posts.php?postNum=2195720#post2195720
Good point. I think a javascript confirm popup presenting the user with the option is a good choice since it offers the flexibility and the added safety measure at the same time.

BTW That a was quick reply!
]]> Mon, 09 Feb 2009 18:19:05 -0800 forum-posts.php?postNum=2195720#post2195720 https://interactivetools.com/forum/forum-posts.php?postNum=2195715#post2195715
We are having problems when using dragSortOrder. Sometimes a header gets clicked in the list view (which results in a new sort order) and then a drag sort is accidentally performed relative to this new sorting which wipes out a pain-stakenly chosen order.

It would be very hand to disable the header-click-to-sort feature for a section (especially when dragSortOrder is being used).

Any thoughts?

Thanks!
]]> Mon, 09 Feb 2009 17:18:53 -0800 forum-posts.php?postNum=2195715#post2195715 https://interactivetools.com/forum/forum-posts.php?postNum=2195116#post2195116
Multiple-file upload would be a great feature addtion to CMS Builder.

I just discovered a really great solution which uses a hidden Flash swf file and the rest is done in Javascript. It is called SWFUpload and is free (demos at http://demo.swfupload.org).

Is there any way this could be integrated into CMS Builder? It would save time for users who have multiple files to upload (because you can shift-select a whole whack in one go!).

Thanks!
]]> Fri, 09 Jan 2009 19:29:22 -0800 forum-posts.php?postNum=2195116#post2195116 https://interactivetools.com/forum/forum-posts.php?postNum=2191574#post2191574
I have emailed you the login info. Please let me know when you get a change to check it out.

Webdude
]]> Fri, 16 May 2008 11:43:43 -0700 forum-posts.php?postNum=2191574#post2191574 https://interactivetools.com/forum/forum-posts.php?postNum=2191569#post2191569
Just wondering if anyone else has experienced slowness when viewing larger lists in CMS Builder (say 100 records) due to the dragSortOrder javascript (jquery.tablednd.js) stalling the browser just after page load. Sometimes it can be up to 3 seconds.

It looks like the reordering JS file is consuming some heavy CPU. Can anyone confirm this other than me?
]]> Thu, 15 May 2008 22:30:09 -0700 forum-posts.php?postNum=2191569#post2191569 https://interactivetools.com/forum/forum-posts.php?postNum=2191565#post2191565
Will check it out ASAP!
]]> Thu, 15 May 2008 17:39:12 -0700 forum-posts.php?postNum=2191565#post2191565 https://interactivetools.com/forum/forum-posts.php?postNum=2191563#post2191563
1
10
2
3
4
5
6
7
8
9

... instead of the expected ...

1
2
3
4
5
6
7
8
9
10

Then I have a trick for you to use in your viewer code. Use the MySQL CAST function in your ORDER BY expression... like so:

SELECT * FROM `faq` WHERE `num` > 0 ORDER BY CAST(`myorder` AS UNSIGNED) ASC

I find this much easier than trying to pad numbers with zeros. Unless you have gigantic result sets the CPU hit should be very minimal.
]]> Thu, 15 May 2008 14:47:14 -0700 forum-posts.php?postNum=2191563#post2191563 https://interactivetools.com/forum/forum-posts.php?postNum=2191562#post2191562
Loving CMS Builder. I use it very often and has saved me. I was wondering if we could have an optional field type "order"... This field would allow users to order items in the list view using the friendly dragging and dropping just like in the admin section editor.

Any thoughts? Anyone agree?

Thanks!
]]> Thu, 15 May 2008 14:41:55 -0700 forum-posts.php?postNum=2191562#post2191562 https://interactivetools.com/forum/forum-posts.php?postNum=2190845#post2190845
Well I guess this explains the bug. Here is the output to the code you asked me to run:
This is PHP v5.1.6
date_default_timezone_set: 1
timezone_abbreviations_list:
Your hypothesis seems correct. Either PHP docs are a little screwy or my php is a little screwy (or both?).

Let me know if this helps... I really appreciate your patience in troubleshooting!
]]> Thu, 20 Mar 2008 12:46:02 -0700 forum-posts.php?postNum=2190845#post2190845 https://interactivetools.com/forum/forum-posts.php?postNum=2190837#post2190837
There is a call to PHP function timezone_abbreviations_list() which is only available on PHP versions > 5.10 ish (depending on who you talk to). PHP manual says PHP >= 5.1.0 (http://php.net/timezone_abbreviations_list).

This is causing the Admin:General Settings page to crash with fatal error: Call to undefined function timezone_abbreviations_list() in ... lib/menus/admin/actionHandler.php

We are running official updated CentOS 5 (which is essentially RHEL5) and the function is not available in the PHP version (5.16).

Any thoughts? How can I be the only one noticing this? Maybe I'm the only one running CMS Builder v1.10 who doesn't have bleeding-ish edge PHP and who has tried to view the Admin:General Settings page.
]]> Thu, 20 Mar 2008 04:47:05 -0700 forum-posts.php?postNum=2190837#post2190837 https://interactivetools.com/forum/forum-posts.php?postNum=2190427#post2190427
Tried you suggestion, still gives me the error when images isn't in the search field.

Webdude
]]> Mon, 25 Feb 2008 20:27:12 -0800 forum-posts.php?postNum=2190427#post2190427 https://interactivetools.com/forum/forum-posts.php?postNum=2190421#post2190421
1. Create a "single page" type of custom section
2. remove all fields except the built-in "num" field
3. add a single field type "upload" (screenshot 1.png)
4. after saving go and try to upload a file and save

... results in popup window with Mysql error (screenshot 3.png)

I have uploaded screenshots.


Cheers,

Webdude.]]> Mon, 25 Feb 2008 18:59:45 -0800 forum-posts.php?postNum=2190421#post2190421 https://interactivetools.com/forum/forum-posts.php?postNum=2190399#post2190399 ]]> Fri, 22 Feb 2008 19:06:37 -0800 forum-posts.php?postNum=2190399#post2190399 https://interactivetools.com/forum/forum-posts.php?postNum=2190397#post2190397
I just noticed that when I call getListRows($options) from a different scope (eg within a function) that the table prefix doesn't automatically get prepended producing an error like this: List Viewer (news): MySQL Error: Table 'cmsbuilder.news' doesn't exist It should be looking for the table cmsbuilder.cms_news and not cmsbuilder.news

I traced it back to the CMS Builder source code. It looks like CMS Builder wasn't properly setting $TABLE_PREFIX internally. I found a quick solution...

The original line 91 of lib/init.php:
$TABLE_PREFIX =& $SETTINGS['mysql']['tablePrefix'];

FIX by changing line 91 of lib/init.php to this:
$TABLE_PREFIX = $SETTINGS['mysql']['tablePrefix'];

I was hoping to get an official response from support to confirm that this won't break something else. Perhaps the =& in the code wasn't really intentional.

Thanks for the amazing product BTW!
]]> Fri, 22 Feb 2008 16:57:59 -0800 forum-posts.php?postNum=2190397#post2190397