I am moving a site to a new server. When I try to do a restore from a backup on the new server I get the following error message

MySQL Error: BLOB, TEXT, GEOMETRY or JSON column 'template_id' can't have a default value

Can you advise

Thanks

I have enough trouble getting the client to use their CMS, so I think FTP might be a step too far for them :-)

Paul

Is it possible to upload a file to the Media Library and overwrite the existing file if they are both the same name? This would be convenient when the file is used across a number of pages.

Thanks

I have it almost working now. However the background image isn't changing it only ever shows the image of the first record.

I am using the following code in my css

// load record from 'guided_tours'
  list($guided_toursRecords, $guided_toursMetaData) = getRecords(array(
    'tableName'   => 'guided_tours',
    'where'       => whereRecordNumberInUrl(1),
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $guided_toursRecord = @$guided_toursRecords[0]; // get first record

--------

<?php foreach ($guided_toursRecord['images'] as $index => $upload): ?>
url("<?php echo htmlencode($upload['urlPath']) ?>")
<?php endforeach; ?>

--------------

I have tried a few variations of this but I cannot get it to change the image. Can you see what my problem might be?Thanks

Did all that, but when I copy the files over to the server all styles are lost. So the page display completely wrong.

Paul

How do I link to this new file style.php

The original link to the css is <link rel="stylesheet" href="css/style.css">
What should it be now?

Thanks

I have a background image that is defined in the css file. After I upload an image in CMSB what code do I use to update the css file?

Thanks

I'm trying to use an anchor link with a page that uses permalinks.

The link goes to a url structure like this, but it doesn't work:

case-studies/case-study-1/#example

Is it possible to using anchor links when using the permalink plugin?

Thanks

I have the following code that allows users to subscribe to a mailing list:

<label>
yes <input name="mailing_list" value="1" <?php checkedIf(@$_REQUEST['mailing_list'], '1') ?> type="radio" />
no  <input name="mailing_list" value="0" <?php checkedIf(@$_REQUEST['mailing_list'], '0') ?> type="radio" />
</label>

It works okay in IE and Chrome, but not in FF. When a user clicks "No" in FF the "Yes" button is highlighted.

Any ideas on what the problem could be?

Thanks

I wanted to add the google recaptcha code to an enquiry form I have.

The code for the form in headers I have is:

<?php header('Content-type: text/html; charset=utf-8'); ?>

<?php

  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */

  // load viewer library

  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';

  $dirsToCheck = array('/home/domain/public_html/domain.com/','','../','../../','../../../');

  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}

  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

   list($officeRecords, $officeMetaData) = getRecords(array(

    'tableName'   => 'office',

  ));

  // load records

// process form

  if (@$_REQUEST['submitForm']) {

    // error checking

    $errorsAndAlerts = "";

    if (!@$_REQUEST['fullname'])                { $errorsAndAlerts .= "You must enter your full name!<br/>\n"; }

    if (!@$_REQUEST['email'])                   { $errorsAndAlerts .= "You must enter your email!<br/>\n"; }

    else if(!isValidEmail(@$_REQUEST['email'])) { $errorsAndAlerts .= "Please enter a valid email (example: user@example.com)<br/>\n"; }

               if (!@$_REQUEST['country'])                 { $errorsAndAlerts .= "You must enter a value for country!<br/>\n"; }

               if (!@$_REQUEST['message'])                { $errorsAndAlerts .= "You must enter a message!<br/>\n"; }

    // send email user

    if (!$errorsAndAlerts) {

      $from    = $_REQUEST['email'];

      $to      = "info@domain.com";

      $subject = "Email form submitted";

      $message = <<<__TEXT__

You've received an email enquiry

Full name: {$_REQUEST['fullname']}

Country: {$_REQUEST['country']}

Phone: {$_REQUEST['telephone']}

Email:     {$_REQUEST['email']}

Message:   {$_REQUEST['message']}

The user who sent this message had the IP address {$_SERVER['REMOTE_ADDR']}.

__TEXT__;

      // Note: The above line must be flush left or you'll get an error

      // This is a PHP heredoc.  See: http://ca2.php.net/manual/en/language.types.string.php#language.types.string.syntax.heredoc

      // send message

      $mailResult = @mail($to, $subject, $message, "From: $from");

      if (!$mailResult) { die("Mail Error: $php_errormsg"); }

      //

       redirectBrowserToURL('/confirm.php?success='.urlencode('Thank you for your enquiry. '));

    $_REQUEST = array(); // clear form values

    exit;

    }

  }

?>

The first line on the form is:

<form method="post" action="?">

The instructions on recaptcha are to change this to:

<form method="post" action="verify.php">

The code for verify.php is:

<?php

  require_once('recaptchalib.php');

  $privatekey = "your_private_key";

  $resp = recaptcha_check_answer ($privatekey,

                                $_SERVER["REMOTE_ADDR"],

                                $_POST["recaptcha_challenge_field"],

                                $_POST["recaptcha_response_field"]);

  if (!$resp->is_valid) {

    // What happens when the CAPTCHA was entered incorrectly

    die ("The reCAPTCHA wasn't entered correctly. Go back and try it again." .

         "(reCAPTCHA said: " . $resp->error . ")");

  } else {

    // Your code here to handle a successful verification

  }

  ?>

At the point where is says // Your code here to handle a successful verification do I need to copy some of the code I have in my header over to verify.php? If so what should I copy over?

Thanks

We have an enquiry form on our site. When a form is completed and sent, a message appears on the page to confirm this.

The code is:

$errorsAndAlerts = "Thanks for your enquiry. A representative fwill deal with your enquiry.";
$_REQUEST = array(); // clear form values

Rather than displaying the message I would like the users to be redirected to a different page and then have the message displayed there.

Can someone help me with this.

Thanks

I have a site hosted with godaddy and to enable gzip compression they recommended I place the folloiwng code at the top of every page in my site.

<?php if (substr_count($_SERVER['HTTP_ACCEPT_ENCODING'], 'gzip')) ob_start("ob_gzhandler"); else ob_start(); ?>

I'm not a php programmer so I just have a couple of queries about using it:

1. Will there be any conflict with the CMSB code I have on my site?

2. Would there be any security issues with using this code?

Thanks for any advice