Re: [Dave] Development Server Issues: Sockets and Permissions

Thu, 22 Nov 2012 11:21:23 -0800

That first one did the trick Dave! On reboot the local server could see the world again and CMSB didn't balk anymore. Many thanks. Still getting some server warnings about the isInstalled issue but bringing a copy of that file from the production server settled that issue too.
J.

Development Server Issues: Sockets and Permissions

Wed, 21 Nov 2012 16:07:24 -0800

Hi there,

Just getting around to setting up a new WAMP-based development box (Win 7). Have had good luck with short-term use of WAMP/MAMP and CMSB in the past. This time however, there's an issue.

The server seems to run well. Using WampDeveloper Pro. Basic sites are playing nicely. The issue is when CMSB is introduced. 2 main issues, probably related:

1- On first run of either a fresh CMSB install (latest stable version) or when copying an existing site to the new box, we get the same problem as:
http://www.interactivetools.com/forum/forum.cgi?do=post_view_printable;post=76704;guest=

Commented out the suggested call but this is not a good solution for dozens of sites.

2 - After trying the comment-out solution above, I was able to complete the intial setup. However, as soon as I then log in as the admin, I get a blank page with the error:

getPage: Error opening socket: An attempt was made to access a socket in a way forbidden by its access permissions. (10013)

This also seems to have been an issue in the past but no solution was published.

I have explored the servers php.ini (thanks Jason) and uncommented the 'extension=php_sockets.dll' line. I know that php.ini file is right as I also manually adjusted the timezone and lat/long info successfully.

Any ideas on how to get CMSB to feel happy in it's new home? It's mental wellbeing is important to me.

J.

Re: [greg] Where Clause in Category List

Fri, 09 Nov 2012 17:00:07 -0800

Thanks Greg. That is the way I wound up doing it. Glad I wan't just missing something obvious (for a change).

Cheers,
J.

Wish List Item: Backend Styling

Fri, 09 Nov 2012 12:37:23 -0800

Not wishing to clutter the 'upcoming features' post, I'll start a new thread:

I'm finding more and more often that I'd like better styling control over the backend. Here is an easy idea that would be welcome from my POV:

- classes assigned to field groups and individual fields:

Example for a textfield with pre- and post-text elements. This styling would let us control some aspects of a single field or a whole field-group. This could easily be connected to style class for a 'requied' field also.

  
    Aside
    
    Optional:

      <br /><br />   <span class="field_desc">Used to highlight or feature items from this article such as pull quotes, adding supporting documents, or making extra comments.</span><br />    </td><br />   </tr></code><br /><br />This would let us easily create a backend style sheet which would allow us to apply styles to:<br /> - whole field groups/table row (borders, colours, font style, margins, etc.), <br /> - a single field group based on the name (highlight the required field's table row),  <br /> - all labels, prefixes or descriptions (make all prefixes dark, all descrptions indented, italics and monospaced),<br /> - a single field (.field_aside .field_desc {color: red;}<br /> - a required field (if a required token is set in the field schema) .required {background: yellow, url('alert_icon.gif') no-repeat;}<br /><br /><br /><br />If you like this idea, I could mock up a list view version as well. It would probably follow similar rules but may need row and column indexing.<br /><br />My $0.02... again. ;-)<br /><br />J.<br />
</article>
<article>
<h1>Re: [Dave] *** Upcoming Features & Development Plan (Updated Oct 2012)</h1>
<p>Fri, 09 Nov 2012 12:09:01 -0800</p>
Nice to see an ambitious list, Dave!<br /><br />Fingers crossed to see this coming down the pipe in 2013.<br />
</article>
<article>
<h1>Where Clause in Category List</h1>
<p>Fri, 09 Nov 2012 11:59:29 -0800</p>
How do we limit which records to select in a Category query?<br /><br />Would like to use a single Category list but with checkbox conditions so that a given record can be set to "show in main nav" and/or "show in footer" for menu use. Having two manual Category lists for this seems excessive.<br /><br />Cheers,<br />J.<br />
</article>
<article>
<h1>Re: [greg] Is it possible to share data across two URLs</h1>
<p>Mon, 22 Oct 2012 16:19:48 -0700</p>
FWIW, it may also depend a bit on your server config. We have one site that has two projects hosted on the same account. The hosting firm calls this an add-on slot but in practice the second site is a another directory under the root. All the site layout files are in there, but the CMS folder remains in it's original (and single) location.<br /><br />Apart from that, the process was seamless and easy. The client now manages both "sites" from within a single instance of CMSB.<br /><br />And yes, I checked with the good people at Interactive Tools before I did this to make sure they didn't object. They didn't. They're cool. ;-)<br /><br />J.<br />
</article>
<article>
<h1>Re: [pothompson] SEO capabilities</h1>
<p>Mon, 22 Oct 2012 14:19:03 -0700</p>
Not to belabour the point, but I honestly find that CMSB is a great tool if you as the developer understand the basics of SEO. We're able to create specific code in our pages to make sure that the content (the true engine of organic SEO) can be well understood by search engines. <br /><br />CMSB allows us to make certain that pages have a unquie title tag, customize the layout using modern "white hat" HTML methods to clearly separate the article and navigation from the rest of the page, and encourage proper client management of that content.<br /><br />WordPress, often using SEO plug-ins, is actually quite inflexible and limited - but it does put the user on rails so that they can not deviate from a course of action. It does the bare minimum very well. With CMSB you can do really clever things like scrub your title tags for misspellings or content-free words. Or set it up so that your title uses a special text field for content _only_ if the user provides it, falling back to using the article headline if not. Thereby giving your client two chances to insert good, and different, keywords.<br /><br />With CMSB the onus is on the developer to know the material and make the best use of it that they know how.<br /><br />J.<br />
</article>
<article>
<h1>Re: [greg] Upload Feature Error</h1>
<p>Mon, 22 Oct 2012 11:33:19 -0700</p>
Just a note, but we saw the same issue but not with a. SWF file. It was with a PNG that I think was saved in the CMYK colour-space.<br />This fix removed the error message and allowed us to save the record.<br />Thanks to Greg and Jason for this.<br />J.<br />
</article>
<article>
<h1>Re: [Jason] Using MetaData Recordset</h1>
<p>Wed, 03 Oct 2012 15:07:30 -0700</p>
Thanks Jason. That puts the right array element into $currentCat and $category but now the next & prev links get the original array dumped to them. For those keeping score at home, the full solution is below:<br /><br /><code>							$categories = array_pluck($categoriesArray, 'collection');  <br />							$currentCat = @$_REQUEST['collections']; <br />							$nextLink   = ""; <br />							$prevLink   = ""; <br />  foreach ($categories as $index => $category) { <br />     <br />    if ($category == $currentCat) { <br />       <br />      if ($index == count($categories) - 1) { <br />	$nextLink = "?collections=".$categories[0]; <br />      } <br />      else { <br />	$nextLink = "?collections=".$categories[$index + 1]; <br />      } <br />       <br />      if ($index == 0) { <br />	$prevLink = "?collections=".$categories[count($categories) - 1]; <br />      } <br />      else { <br />	$prevLink = "?collections=".$categories[$index - 1]; <br />      } <br />       <br />      break; <br />    } <br />     <br />  }</code><br /><br />Works as billed. Thank you Jason. You're the bestest.<br /><br />J.<br />
</article>
<article>
<h1>Re: [Jason] Using MetaData Recordset</h1>
<p>Wed, 03 Oct 2012 12:55:17 -0700</p>
Hi Jason,<br /><br />Almost there! The only issue with the above is that the array index is not being inremented or decremented in the nextLink and prevLink variables.<br /><br />A few tests show the current content of $category is a complete 'array' rather than the current position in the category list.<br /><br />It's probably a misunderstanding at my end once I brought the dynamic list in from the database. <br /><br />Sample: <br /><br /><code><?php<br />  list($categoriesArray, $categoriesArrayMetaData) = getRecords(array(<br />    'tableName'   => 'collections',<br />    'loadUploads' => '0',<br />    'allowSearch' => '0',<br />    'where' => '`active` != 0',<br />  ));<br /><br />$currentCat = @$_REQUEST['collections']; <br />$nextLink   = ""; <br />$prevLink   = ""; <br /><br />  foreach ($categoriesArray as $index => $category) { <br />     <br />    if ($category == $currentCat) { <br />       <br />      if ($index == count($categoriesArray) - 1) { <br />	$nextLink = "?cat=".$categoriesArray[0]; <br />      } <br />      else { <br />	$nextLink = "?cat=".$categoriesArray[$index + 1]; <br />      } <br />       <br />      if ($index == 0) { <br />	$prevLink = "?cat=".$categoriesArray[count($categoriesArray) - 1]; <br />      } <br />      else { <br />	$prevLink = "?cat=".$categoriesArray[$index - 1]; <br />      } <br />       <br />      break; <br />    } <br />     <br />  }  <br />	echo "Current Cat: ".$currentCat.'<br />'; // Echos: Barcelona (correct)<br />	echo "Category: ". $category . '<br />';     // Echos: array<br />              ?><br />              <br />              <br /><br />        <a href="<?php echo $prevLink; ?>">Prev</a> | <a href="<?php echo $nextLink; ?>">Next</a> <br /></code><br />
</article>
<article>
<h1>Re: [GB39CA] CMS Builder ( Blog )</h1>
<p>Wed, 03 Oct 2012 12:09:31 -0700</p>
Bear in mind that how any blog "looks" has more to do with the site design and client requirements than the underlying software. CMSB is very flexible and can be made to look a great many ways.<br /><br />Also, any collection of articles uses the blog tech of CMSB. So technically, we use blogging systems to list things like products, services, news, tips & tricks, testimonials, download resources, etc. The difference again in the design appearance of function of the site.<br /><br />J.<br />
</article>
<article>
<h1>Re: [greg] PDF Upload Field Issue</h1>
<p>Fri, 21 Sep 2012 14:22:19 -0700</p>
I do have the original file Greg and will happily send it to you. <br /><br />The possiblity that it's a server issue has crossed my mind - it's just an unusual situation as PDF uploads are not normally a challenge beyond a size & upload connection timeout issue. Will test and report.<br /><br />J.<br />
</article>
<article>
<h1>PDF Upload Field Issue</h1>
<p>Fri, 21 Sep 2012 11:45:18 -0700</p>
UPDATED:<br />Okay, so it turns out that I posted an issue like this before but had forgotten. My apologies. <hangs head in geek shame><br /><br />The issue appears to be in the PDF creation process. There are hidden elements and un-downsampled mask layers in the construction process. Running the PDF through the Advanced -> Optimize PDF function Acrobat Pro fixes the issue so that the PDF can be uploaded.<br /><br />However, this is a problem as the client does not own that software and has never had an issue with PDFs on their site before. Any thoughts on how this can be addressed would be welcome!<br /><br />--- Original Post ---<br /><br />Hi there,<br /><br />We have a site in development on a staging server. It has previously allowed us to upload <5Mb .PDF files to an upload field without issue. This is not within the TinyMCE WYSIWYG editor but a distinct field.<br /><br />As of today, the upload process begins but is fairly quickly stalled. An error message appears in the lightbox of the upload which reads:<br /><br /><code>Not Acceptable<br /><br />An appropriate representation of the requested resource /westhaven/cmsAdmin/admin.php could not be found on this server.<br /><br />Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.</code><br /><br />Any idea where we should begin to find a solution for this?<br /><br />Many thanks,<br />J.<br />
</article>
<article>
<h1>Re: [greg] Encrypted Password Question</h1>
<p>Wed, 12 Sep 2012 09:18:38 -0700</p>
Great. Thanks for that confirmation!<br />J.<br />
</article>
<article>
<h1>Re: [greg] Searching Related Records from List View Advanced Search</h1>
<p>Wed, 12 Sep 2012 09:18:04 -0700</p>
Thanks Greg. I'll take it up through the usual channels if needed. <br />Cheers,<br />J.<br />
</article>
<article>
<h1>Searching Related Records from List View Advanced Search</h1>
<p>Tue, 11 Sep 2012 16:32:00 -0700</p>
Hi,<br /><br />A client is needing to search a long List View of a table which contains a Related Records field. A few tries with the Advanced Search editor have either caused MySQL errors or return 100% of all records in the table.<br /><br />I'd like to do something like this in the Advanced Search area:<br />Purchases:|relatedRecords001:productName|query<br /><br />Where 'relatedRecords001' is the joined table and productName is the field to search on.<br /><br />Any idea on how I might do this successfully?<br /><br />Thanks,<br />J.<br />
</article>
<article>
<h1>Encrypted Password Question</h1>
<p>Tue, 11 Sep 2012 16:20:45 -0700</p>
Now that we have encrypted passwords for the Membership Plug-in, what happens if a client goes into the Membership Accounts area and types in a password into that field? <br /><br />1 - Does that become encrypted?<br />2 - Can the client then contact the account user and give them the password they just typed into the backend?<br /><br />Many thanks,<br /><br />J.<br />
</article>
<article>
<h1>Re: [Jason] Using MetaData Recordset</h1>
<p>Tue, 28 Aug 2012 11:21:35 -0700</p>
Many thanks Jason! I'll take a poke at this later today and report back on how I get on.<br />Cheers,<br />J.<br />
</article>
<article>
<h1>Using MetaData Recordset</h1>
<p>Mon, 27 Aug 2012 16:05:44 -0700</p>
Hi,<br /><br />We have a list view on a page which relies upon the URL parameters to show a single record on page load. We'd also like to have Next & Prev buttons to allow users to click through the list or related page categories.<br /><br />We need to find a way to make these Next & Prev buttons use the record title field in the URL paramater rather than the normal '....php&page=2' format. So we'd like to use a table of categories such as:<br /><br />RED<br />BLUE<br />GREEN<br /><br />... so that when on "mypage.php?cat=BLUE", then the Prev button would link to "mypage.php?cat=RED" and the Next button to  "mypage.php?cat=GREEN". I think this is just an adjustment to the normal use of the MetaData recordset but I'm not familiar enough with it to know what to do.<br /><br />Many thanks,<br />J.<br />
</article>
<article>
<h1>Re: [Jason] URL parameter filters with where clauses</h1>
<p>Mon, 27 Aug 2012 09:50:39 -0700</p>
Many thanks Jason. That would seem to explain the change in behaviour. The solution you offer will work nicely I'm sure.<br /><br />J.<br />
</article>
<article>
<h1>URL parameter filters with where clauses</h1>
<p>Thu, 23 Aug 2012 15:35:20 -0700</p>
Hi,<br /><br />Until recently I had a page which showed all the records for a given table. It also displayed a set of links which reloaded the same page but with parameters appented to the URL. i.e.:<br /><br /><code>mypage.php?type=blue</code><br /><br />Then these links were fired the page would reload and display only the records where the type was 'blue'.<br /><br />But now I have to put a where clause on the page at all times. It's working to limit the display of the original records but it also seems to stop the in-url filtering from working.<br /><br />Any ideas of why that is, and how I can work around it?<br /><br />Cheers,<br />J.<br />
</article>
<article>
<h1>Re: [Jason] .fullname Options in List field</h1>
<p>Tue, 24 Jul 2012 23:03:16 -0700</p>
Many thanks Jason. That does clarify a number of items for me.<br /><br />I have to wonder at the odd instance where this worked on a simple-cart orders table. Most of the time, the .fullname column showed '0' as you'd expect. But in one case at least, a single row held the correct full user name. If you're interested, it was the GSG project.<br /><br />Best wishes,<br />J.<br />
</article>
<article>
<h1>.fullname Options in List field</h1>
<p>Tue, 24 Jul 2012 16:30:21 -0700</p>
I'm trying to understand the rules related to the use of .fullname in the list of columsn to display in an editors List View. <br /><br />Can anyone clarify when this will work and when it wont? Which fields will it work with? I keep seeing the use of 'createdBy.fullname' but createdBy is not a field that appears in tables.  Applying the .fullname to createdByUserNum seems to mostly generate a value of '0' except for sometimes it will actually work - all in the same column. Weird!<br /><br />I'd really love it always work with any instance of 'createdByUserNum'.  [;)]<br /><br />I'm also interested in whether it will work with the Membership Plugin if you have two tables of users. The first being the admin user table, and the second being the members table.<br /><br />Cheers,<br />J.<br />
</article>
<article>
<h1>Re: [cmsb] Fancybox not working</h1>
<p>Tue, 24 Jul 2012 16:24:16 -0700</p>
Just having a quick peek in here and it doesn't look like the Fancybox directory (from which the js and css are being called) are on your server. You should be able to view the CSS file for example, by browsing to:<br />http://www.mtgrovecemetery.org/fancybox/source/jquery.fancybox.css <br />same applies to the javascript libraries (.js files)<br /><br />Also, you don't need to call both the packed and unpacked .js libs. One is enough. They are both the same thing, just that the packed one has had all the unused characters removed to make it smaller.<br />Lastly, you're actually calling the Fancybox .css file twice also. <br /><br />Although none of these duplications will stop the script from working, they may lead to confusion and extra page load weight.<br /><br />The lack of the libraraies and CSS files on the server will be a showstopper though. It looks that way currently. The larger image is being displayed, but not using the Fancybox javascript.<br /><br />Hope this helps,<br />J.<br />
</article>
</main></body></html>