<ul class="menu">
                                     <?php foreach ($training_coursesRecords as $listRecord): ?>
      <?php $isSelected = ($listRecord['num'] == $detailRecord['num']); ?>
      <?php if ($isSelected) { print "<b>"; } ?>
      <li><a href="<?php echo htmlencode($listRecord['_link']) ?>"><?php echo htmlencode($listRecord['name']) ?></a></li>
      <?php if ($isSelected) { print "</b>"; } ?>
    <?php endforeach ?>

    <?php if (!$training_coursesRecords): ?>
      No records were found!<br/><br/>
    <?php endif ?>
                                    </ul>

That did the trick - as always I am indebted.

Cheers,

Benedict

This is a Wine List page that shows the wines from a particular range.

The code that worked fine on the old server, but not this one is:

  // load records
  list($winesRecords, $winesMetaData) = getRecords(array(
    'tableName'   => 'wines',
    'where' => "range = '". intval($rangeRecord['num']) ."'" ,
  ));
  


When I remove this code, the page loads at least, without the wine list. When I include the code, I get this (when trying to load the wine range MWC which is range #11):

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 'range = '11')' at line 3


FInal piece of info - the WInes table pulls the Ranges from the Ranges table using the GET OPTIONS FROM DATABASE option, values=num, labels=title.

Detail pages all present fine as well.

We migrated a lot of cmsBuilder accounts to a new server without issue, but one account is throwing issues on the website, saying:

Warning: Cannot modify header information - headers already sent by (output started at /home/jmcpher/public_html/about-mcpherson-wines.php:32) in /home/jmcpher/public_html/cmsAdmin/lib/database_functions.php on line 634 There was an error creating the list field ''. 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 'range, year DESC LIMIT 0, 999' at line 1

Any ideas what this might be in that file  (/home/jmcpher/public_html/cmsAdmin/lib/database_functions.php) on line 634 that I can fix?

Cheers!

P.S. I had to change the DNS back to the old server in the mean time, so I can not show you a live example.

I'm in the same boat - I've done hundreds of installs of CMSB and getting a 500 error on normal install of 2.61? Did you find the solution for s2media? I've checked that PHP and MySQL versions are compatible, and the bizarre thing is the site I installed it on is still working finr, but I can not get to the /cmsAdmin page.

Cheers,

Benedict

I have a products section where products are assigned one or more categories using a list field (Check boxes).

When I use the code generator, it spits out this:

Category (labels): <?php echo join(', ', $record['category:labels']); ?>

Which outputs the selected categories like this e.g. Home, Business

How do I get rid of the comma that separates the two selected categories? I know it's something to do with the ', ', just after join, but my random noodling has born no fruit.

Cheers,

B

I'm using the same .htaccess code with your permalinks code, and while permalinks works on both, the subsequent 301 redirects do not work on one of the servers. When I remove the permalinks code, the 301 redirects work fine. I presume there is a server setting adjustment I need to make. Any ideas?

# Add this to an .htaccess file in your website root folder
# Your website root folder is usually named: htdocs, httpdocs, www, html, or just / in FTP

# START: CMS Permalink Code
<IfModule mod_rewrite.c>
  RewriteEngine On
  RewriteBase /
  RewriteRule ^permalinks_dispatcher\.php$ - [L]
  RewriteCond %{REQUEST_FILENAME} !-f
  RewriteCond %{REQUEST_FILENAME} !-d
  RewriteRule . /cmsAdmin/plugins/permalinks/permalinks_dispatcher.php [L]
</IfModule>
# END: CMS Permalink Code

RewriteCond %{HTTP_HOST} !^www\.
RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L]

RewriteEngine On

## 301 Redirects
# 301 Redirect 1
RewriteCond %{QUERY_STRING}  ^Samples-4$ [NC]
RewriteRule ^nonslip-products\.php$ /samples? [R=301,NE,NC,L]

Cheers & thanks in advance.

I am having an issue with an events page with a form I am producing. For every event, the client wanted the ability to add up to 10 event dates that a person can choose to attend. Some events have 4 dates, some more. So in CMSB, I just created 10 fields - Event Date 1, Event Date 2, etc...

In my viewer page I have coded the 10 event date fields into a select field, coding it so that it should only show an event date if an entry has been made. In this example event (http://hrlegal.stockstreetserver.com/events-detail.php?Protecting-Your-Business-from-Ex-Employees-5) it correctly shows the first 4 event dates that have been entered, but then shows a default date for the other 6 dates that have not been entered in CMSB.

This is my select field code:

<label for="fieldEmail">Date You Wish To Attend:</label>
        <select name="date" id="date">
<option value="" selected="selected">--Please Select--</option>
            <?php if ($eventsRecord['1st_date_time']): ?>
<option value="<?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['1st_date_time'])) ?>"><?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['1st_date_time'])) ?></option>
          <?php endif ?>
          <?php if ($eventsRecord['2nd_date_time']): ?>
<option value="<?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['2nd_date_time'])) ?>"><?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['2nd_date_time'])) ?></option>
          <?php endif ?>
          <?php if ($eventsRecord['3rd_date_time']): ?>
<option value="<?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['3rd_date_time'])) ?>"><?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['3rd_date_time'])) ?></option>
          <?php endif ?>
          <?php if ($eventsRecord['4th_date_time']): ?>
<option value="<?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['4th_date_time'])) ?>"><?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['4th_date_time'])) ?></option>
          <?php endif ?>
          <?php if ($eventsRecord['5th_date_time']): ?>
<option value="<?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['5th_date_time'])) ?>"><?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['5th_date_time'])) ?></option>
          <?php endif ?>
          <?php if ($eventsRecord['6th_date_time']): ?>
<option value="<?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['6th_date_time'])) ?>"><?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['6th_date_time'])) ?></option>
          <?php endif ?>
          <?php if ($eventsRecord['7th_date_time']): ?>
<option value="<?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['7th_date_time'])) ?>"><?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['7th_date_time'])) ?></option>
          <?php endif ?>
          <?php if ($eventsRecord['8th_date_time']): ?>
<option value="<?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['8th_date_time'])) ?>"><?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['8th_date_time'])) ?></option>
          <?php endif ?>
          <?php if ($eventsRecord['9th_date_time']): ?>
<option value="<?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['9th_date_time'])) ?>"><?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['9th_date_time'])) ?></option>
          <?php endif ?>
          <?php if ($eventsRecord['10th_date_time']): ?>
<option value="<?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['10th_date_time'])) ?>"><?php echo date("D, M jS, Y g:i a", strtotime($eventsRecord['10th_date_time'])) ?></option>
          <?php endif ?>
                  </select>

How do I make fields with no date entry not appear in this list?

Thanks in advance.

Now, I the customer wants the wines sorted by variety - these are not sorted alphabetically, rather by the strength of the grape from white through to red wines. So I'm using DragSortOrder in the varieties table - on the wines list viewer page  how do I get the wines to order by the variety order from the variety table, i.e. not alphabetically.  ?

http://www.interactivetools.com/forum/forum-posts.php?postNum=2218577#post2218577

It works with my multirecord Gallery section which has 4 records in it with an upload field holding approx. 25 images per  record/gallery - Weddings/Corporate/NYE/Private Charters

When I say it works, it gathers up the images and presents them in random order... almost.

What it does is it randomises only the presentation of the first 4 images - it is still the same 4 first images everytime (the first in each record of Weddings/Corporate/NYE/Private Charters). I want those images to be completely shuffled every time the page loads.

You can see it working down the bottom of the page in the carousel at http://vicstar.stockstreetserver.com/index.html - note when you refresh, it is showing the same 1st image each time, not randomising the whole array.

My modified code of yours is:

<div class="carousel">
            <div class="carousel-center">
                <div class="gmask-center">
                    <div class="gmask">
                        <ul>
                        <?php
  
// load records from 'galleries'
list($gallery, $galleriesMetaData) = getRecords(array(
'tableName' => 'galleries',
'orderBy' => 'RAND()',
'loadUploads' => true,
'allowSearch' => false,
));

//shuffle all of the images for each record
foreach($gallery as $images){
shuffle($images['images']);
}

//counter
$n = 0;
//max number of images you want to pull from each section;
$max = 7;
while($n <= $max): ?>
                        <?php foreach($gallery as $key => $images): ?>
                            <li>
                                <div class="photo">
                                    <?php //If there is a picture in the image array with a key of $n, assign it to the $image varible, else return false
if($image = @$images['images'][$n]): ?>
<?php shuffle($images['images']); ?>
                                <img title="<?php echo $image['info1']; ?>" alt="<?php echo $image['info1']; ?>" src="<?php echo $image['thumbUrlPath3']; ?>" width="309" height="206"/>
                                    <?php endif; ?>
                                </div>
                            </li>
                            <?php endforeach; ?>
<?php $n++; ?>
<?php endwhile; ?>
                        </ul>
                    </div>
                </div>
                <a href="#" class="btn-prev">prev</a>
                <a href="#" class="btn-next">next</a>
            </div>
        </div>

We're launching another permalink site that has an issue. When we go to the page we created, we get this issue:

The requested URL /cmsAdmin/plugins/permalinks/permalinks_dispatcher.php was not found on this server.

When I go to that path in my browser to find it, I get this:

Fatal error: Call to undefined function addAction() in /usr/home/shabaka/public_html/xn--wgb.xn----1mcbc7cp0fnu.xn--mgbaam7a8h/cmsAdmin/plugins/permalinks/permalinks.php on line 19

The file is definitely there along with all the other files in the Permalink folder, so I'm stumped. The URL permalink is just /test:

http://xn----1mcbc7cp0fnu.xn--mgbaam7a8h/test

(It converts to arabic).

P.S. I have reuploaded the plugin, ensured it is in a folder named permalinks and all permissions are set.

But every press release is in both English and Arabic - I am using the Permalink field for the arabic URL, but want to use another for English. Possible? Or will I have to create two sections - one for English, one for Arabic?

Bad News - Everything set up, uploaded .htacccess file, tested it on a non-working url, and it is working fine. I created a 'permalink' field and did my first test on www.mysite.com.au/test.php in my "Footer Links section whose original url would have been footer-links.php?test-4. It did redirect, but to the fourth record in a completely different section ("Design Guidelines"). I did another test straight away on footer-links.php?jabba-5 permalinked to www.mysite.com.au/jabba.php. Same issue - it went to the 5th record in a different section.

I checked the head code in both sections and updated it as I had done the upgrade to 2.53, and also checked the fields in the body - all function fine without the permalink , still no luck when it is added. Any ideas?

I'm trying to install the permalinksplugin for the first time, but when I go to the Code generator for Permalinks, and click ".htaccess code for redirecting requests", I get a 406 error:

Not Acceptable

An appropriate representation of the requested resource /cmsAdmin/admin.php could not be found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

The link it is trying to reach is:

http://www.mysite.com.au/cmsAdmin/admin.php?filename=.htaccess&menu=_codeGenerator&_generator=permalink_codeGenerator

Any ideas?