I am trying to transfer some websites from on server to other

I am using cpanel Backup Wizard or manual transfer but both of them I have the same error

Error: The system failed to execute the database script with the following errors: ERROR 1101 (42000) at line 125: BLOB, TEXT, GEOMETRY or JSON column 'colValue' can't have a default value

I have notice that the older host account work with 

Database Server MariaDB Server v5.5.5-10.3.36-MariaDB (Max Connections: 151)

and the new one 

MySQL Community Server - GPL v8.0.30 (Max Connections: 151)

I can't sold the problem, could you suggest any solution 

Thank you in advance

Petrogus

what a great update !!!

I have download the latest form generator 1.01 but I can't see this option at the code generator

Hello could you please add a small example of how can we embed Google recaptcha in the form generator 

I would like to ask your help. I am not sure how it start but realize that I have the following error . ( this maybe start after update or php version change)

Warning: Illegal string offset 'image' in /home/xxxx/public_html/products.php on line 154 <img src="Warning: Illegal string offset 'image' in /home/xxxx/public_html/products.php on line 155

I have copy the specific code line. Have anyone idea why this happen

thank you in advance

											<ul class="slides">
											<?php if($catLink == 0) { ?>
												<li>
													<a href="products.php?category=<?php echo htmlencode($rootCat['name_'.$_SESSION['language']]); ?>&cat=<?php echo $rootCat['num']; ?>">
														<?php if(!$rootCat['image']) { ?><img src="images/nocat.jpg" alt="<?php echo htmlencode($rootCat['name_'.$_SESSION['language']]); ?>" />
														<?php } else { ?><img src="inc/timthumb.php?src=<?php echo $rootCat['image'][0]['thumbUrlPath']; ?>&amp;w=215" alt="<?php echo htmlencode($rootCat['name_'.$_SESSION['language']]); ?>" /><?php } ?>
													</a>
												</li>
											<?php } elseif($catLink == 1) { ?>
												<li>
													<a href="products.php?category=<?php echo htmlencode($parentCat['name_'.$_SESSION['language']]); ?>&cat=<?php echo $parentCat['num']; ?>&type=<?php echo htmlencode($rootCat['name_'.$_SESSION['language']]); ?>&id=<?php echo $rootCat['num']; ?>">
														<?php if(!$rootCat['image']) { ?><img src="images/nocat.jpg" alt="<?php echo htmlencode($rootCat['name_'.$_SESSION['language']]); ?>" />
														<?php } else { ?><img src="inc/timthumb.php?src=<?php echo $rootCat['image'][0]['thumbUrlPath']; ?>&amp;w=215" alt="<?php echo htmlencode($rootCat['name_'.$_SESSION['language']]); ?>" /><?php } ?>
													</a>
												</li>
											<?php } ?>
											</ul>

I am looking for solution about a placeholder in an article. I would like to insert dynamic a names or address in a GDPR agreement.
Have anyone idea how can do it. For example see below.

Textfield : #placeholder-name
Textbox : #placeholder-address
Field box : #placeholder-phonenumber

"Lorem ipsum dolor sit amet, #placeholder-name consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation. Duis aute irure dolor in #placeholder-address reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Excepteur sint occaecat cupidatat non proident, #placeholder-phonenumber sunt in culpa qui officia deserunt mollit anim id est laborum."

thank you in advance !

Now all work perfect as always!

I just send to you all information, you want

I looking forward to hear your opinion

I face a very strange issue with CMS Builder. When I edit an article and click save appear the following message 

"This page is asking you to confirm that you want to leave - data you have entered may not be saved"

with two option "Leave or Stay" . In case click to leave all data saved correct but this redirect to white page, where at the top left appear the record num of article

For example I am editing page like /admin.php?menu=about after editing redirect to /admin.php?

I tried to deactivate all plugins I am using but nothing change.

Of course I need to go back and forward to finish my work. Have anyone idea why this happens? Thank you in advance

Operating System Linux 3.10.0-1062.18.1.el7.x86_64 (release)
Web Server Apache
PHP Version PHP v7.3.17 (phpinfo)

I wasn't clear enough with my previews post. At the first time script send mails in the way that email template was structured
but the placeholders was empty. Finally we find the correct sequence to work.

I copy the way it work to me below (partial copy)

.
.
.
.

    ### INSERT NEW RECORD
    if (!$errorsAndAlerts) {
      $colsToValues = array(
        'createdDate='     => "NOW()",
        'createdByUserNum' => (int) @$CURRENT_USER['num'],
        'updatedDate='     => "NOW()",
        'updatedByUserNum' => (int) @$CURRENT_USER['num'],
        'dragSortOrder'    => time(),
        'name'             => @$_REQUEST['name'],
        'surname'          => @$_REQUEST['surname'],
        'phone'            => @$_REQUEST['phone'],
        'email'            => @$_REQUEST['email'],
        'message'          => @$_REQUEST['message'],
        'agree'            => @$_REQUEST['agree'],
      );

      // insert or update record (and adopt uploads [for future use])
      $recordNum = fg_util_insertOrUpdateRecord($FORM_TABLE, $FORM_RECORD_NUM, $colsToValues);
      adoptUploads($FORM_TABLE, $FORM_PRESAVETEMPID, $recordNum);
      removeExpiredUploads(); // erase old expired uploads
	  
		$email    = isset( $_REQUEST['email'] ) ? $_REQUEST['email'] : '';
		$fullname = isset( $_REQUEST['name'] ) ? $_REQUEST['name']." ".$_REQUEST['surname'] : '';
		$phone    = isset( $_REQUEST['phone'] ) ? $_REQUEST['phone'] : '';
		$message  = isset( $_REQUEST['message'] ) ? $_REQUEST['message'] : '';
		if(@$_POST['agree'] == "1") { $agree = "Yes!"; } else { $agree = "No?"; }


	  $emailHeaders = emailTemplate_loadFromDB(array(
		'template_id'        => 'TEST-MAIL-ME',
		'addHeaderAndFooter' => false,
		'placeholders'       => array(
		  'visitor.name'      => $fullname,
		  'visitor.email'     => $email,
		  'visitor.phone'     => $phone,
		  'visitor.message'   => $message,
		  'visitor.agree'     => $agree,
		),
	  ));

    //Get the subject to use in the title tag.
    $htmlTitle  = htmlencode($emailHeaders['subject']);
    //Custom Header
    $header = <<<__HTML__
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>$htmlTitle</title>
</head>

<body>

<style type="text/css">p { margin-bottom: 1em; color:#000; }</style>

__HTML__;
// ***NOTE*** style tag is for Yahoo Mail which otherwise drops paragraph spacing - http://www.email-standards.org/blog/entry/yahoo-drops-paragraph-spacing/
// ... having a defined <title></title> helps get by spam filters

  //Generate the footer
  $footer = <<<__HTML__
</body>
</html>
__HTML__;
  
  //Add teh footer and header to the email headers.
  $emailHeaders['html'] = $header . $emailHeaders['html'] . $footer;

  //Send the email
  $mailErrors = sendMessage($emailHeaders);
  if ($mailErrors) { die("Mail Error: $mailErrors"); }

      // on success
      $_REQUEST        = []; // clear form fields
      $errorsAndAlerts = "Thank you! The form has been submitted successfully.<br />\n";
      $success         = true;		  
    }
  }
 

.
.
.
.

Thank you for your support !!!

Could you help me in case I would like to send email with values from checkboxes (multi value)

I have created a form with Form Generator with the following fields, which work perfect (all Records are stored to CMS Builder)
'name', 'surname', 'phone', 'email', 'message' and 'agree' (checkbox)

but I want to send these information to administrator with email as well.

While I search to forum I understand that I need to use email template with custom placeholder (as look bellow)

Visitor Name : #visitor.name#
Visitor Email: #visitor.email#
Visitor Phone : #visitor.phone#
Visitor Message : #visitor.message#
Visitor Accept Terms : #visitor.agree#

From Email Templates, I tried to send these data using "Export Templates as PHP or SendMessage() PHP with no luck.

Below I have attach the code which I am using. Could you help me ?

All relevant Code is under

/********** Send Message **********/

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  // load viewer library
  $libraryPath = 'xxxxxx/lib/viewer_functions.php';
  $dirsToCheck = ['','../','../../','../../../','../../../../']; 
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
  
  // FORM SETTINGS
  $FORM_TABLE          = "contact_form";
  $FORM_ALLOW_ADD      = true;  // allow creating new records
  $FORM_ALLOW_EDIT     = false; // allow editing existing records,  link to page with ?num=123 to specify record num
  $FORM_REQUIRE_LOGIN  = false; // require users to be logged in to use form
  $FORM_RECORD_NUM     = intval(@$_REQUEST['num']);   // specify record number to edit in url like this: ?num=123
  $FORM_UPLOAD_FIELDS  = []; 
  $FORM_PRESAVETEMPID  = @$_REQUEST['preSaveTempId'] ? $_REQUEST['preSaveTempId'] : uniqid('x'); // for future use - uploads
  $_IS_ADD_FORM        = !$FORM_RECORD_NUM;
  $_IS_EDIT_FORM       = $FORM_RECORD_NUM;

  // ERROR/SECURITY CHECK
  $formRecord     = $FORM_RECORD_NUM ? mysql_get($FORM_TABLE, $FORM_RECORD_NUM) : [];
  $userOwnsRecord = @$formRecord['createdByUserNum'] && $formRecord['createdByUserNum'] == @$CURRENT_USER['num'];
  if      (!function_exists('fg_util_isPluginEnabled')) { die("You must activate the Form Generator plugin before you can access this page."); }
  else if ($FORM_REQUIRE_LOGIN && !@$CURRENT_USER)      { die("You must login to use this form!"); }
  else if ($_IS_ADD_FORM && !$FORM_ALLOW_ADD)           { die("Add record - access not permitted!"); }
  else if ($_IS_EDIT_FORM) {
    if      (!$FORM_ALLOW_EDIT)                         { die("Modify record - access not permitted!"); }  
    else if (!$formRecord)                              { die("Modify record - record doesn't exist!"); }  
    else if ($FORM_REQUIRE_LOGIN && !$userOwnsRecord)   { die("Modify record - you can only edit records you've created!"); }
  }
  
  // PROCESS FORM - Update this PHP code block if you need to change the error checking or error/alert messages
  $errorsAndAlerts = '';
  if (@$_REQUEST['_save']) {

    ### CREATE DATE-FIELDS
    
    
    ### ERROR CHECKING
    list($table, $num) = [$FORM_TABLE, $FORM_RECORD_NUM]; // assign shorter convenience variables
    if (@$_REQUEST['name'] == '')   { $errorsAndAlerts .= "'Name' is required.<br />\n"; }
    if (@$_REQUEST['email'] == '')  { $errorsAndAlerts .= "'email' is required.<br />\n"; }
    if (!@$_REQUEST['agree'])     { $errorsAndAlerts .= "'Agree' is required.<br />\n"; } // uncomment to make checkbox required


    ### INSERT NEW RECORD
    if (!$errorsAndAlerts) {
      $colsToValues = array(
        'createdDate='     => "NOW()",
        'createdByUserNum' => (int) @$CURRENT_USER['num'],
        'updatedDate='     => "NOW()",
        'updatedByUserNum' => (int) @$CURRENT_USER['num'],
        'dragSortOrder'    => time(),
        'name'             => @$_REQUEST['name'],
        'surname'          => @$_REQUEST['surname'],
        'phone'            => @$_REQUEST['phone'],
        'email'            => @$_REQUEST['email'],
        'message'          => @$_REQUEST['message'],
        'agree'            => @$_REQUEST['agree'],
      );

      // insert or update record (and adopt uploads [for future use])
      $recordNum = fg_util_insertOrUpdateRecord($FORM_TABLE, $FORM_RECORD_NUM, $colsToValues);
      adoptUploads($FORM_TABLE, $FORM_PRESAVETEMPID, $recordNum);
      removeExpiredUploads(); // erase old expired uploads


      // on success
      $_REQUEST        = []; // clear form fields
      $errorsAndAlerts = "Thank you! The form has been submitted successfully.<br />\n";
      $success         = true;		  
    }
  }
  
 
  // Load Record (for edit forms)
  if ($_IS_EDIT_FORM) {
    $FORM_RECORD = mysql_get($FORM_TABLE, (int) $FORM_RECORD_NUM);
    $_REQUEST     = fg_util_prePopulateRequest($FORM_RECORD);
  }

  // set page title
  $formTitle = "Contact Form";
	
  if ($FORM_ALLOW_ADD && $FORM_ALLOW_EDIT) { // if form supports add and edit, show which action is taking place
    if ($_IS_ADD_FORM)   { $formTitle .= " - Add record"; } 
    if ($_IS_EDIT_FORM)  { $formTitle .= " - Modify record"; } 
  }


/********** Send Message **********/

	$email    = isset( $_REQUEST['email'] ) ? $_REQUEST['email'] : '';
	$fullname = isset( $_REQUEST['name'] ) ? $_REQUEST['name']." ".$_REQUEST['surname'] : '';
	$phone    = isset( $_REQUEST['phone'] ) ? $_REQUEST['phone'] : '';
	$message  = isset( $_REQUEST['message'] ) ? $_REQUEST['message'] : '';
	if(@$_POST['agree'] == "1") { $agree = "Yes!"; } else { $agree = "No?"; }
	
	

if (!$errorsAndAlerts) {
  $emailHeaders = emailTemplate_loadFromDB(array(
    'template_id'        => 'TEST-MAIL-ME',
    'addHeaderAndFooter' => false,
    'placeholders'       => array(
      'visitor.name'      => $fullname,
      'visitor.email'     => $email,
      'visitor.phone'     => $phone,
      'visitor.message'   => $message,
      'visitor.agree'     => $agree,
    ),
  ));

    //Get the subject to use in the title tag.
    $htmlTitle  = htmlencode($emailHeaders['subject']);
    //Custom Header
    $header = <<<__HTML__
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>$htmlTitle</title>
</head>

<body>

__HTML__;

  //Generate the footer
  $footer = <<<__HTML__
</body>
</html>
__HTML__;
  
  //Add teh footer and header to the email headers.
  $emailHeaders['html'] = $header . $emailHeaders['html'] . $footer;

  //Send the email
  $mailErrors = sendMessage($emailHeaders);
  if ($mailErrors) { die("Mail Error: $mailErrors"); }
 
  }
  /******** End of Sent Message *******/
  
?> 

I would to filter 'myrecords' base on articleTypesRecords between tabs. I have two types of records and i want to filter at each tab - type.

At the moment 'myrecords' load at both tabs, could you help me please ?!

<?php
  list($articleRecords, $articleMetaData) = getRecords(array( 'tableName'   => 'myrecords',  
  'loadUploads' => true, 'allowSearch' => false, ));  
  
  list($articleTypesRecords, $articleTypesMetaData) = getRecords(array( 'tableName'   => 'rec_type', 'loadUploads' => true, 'allowSearch' => false, ));  

?>

<div class="tabs">
	<?php foreach($articleTypesRecords as $articleType) { ?>
        <div class="tab-item <?php if ($articleType['num'] == 1) { echo "tab-active"; } ?>">
          	<a class="tab-label <?php if ($articleType['num'] == 1) { echo "active-btn"; } ?>" data-url="<?php echo $articleType['num']; ?>"><?php echo htmlencode($articleType['title_'.$_SESSION['lang']]); ?></a>
			<div class="tab-content">
				<?php foreach($articleRecords as $articleItem) { $articleType = mysql_select("rec_type", "num = '".$articleItem['rec_type']."'"); $articleType = @$articleType[0]; ?>
				<article>
					<h3><a href="sample.php"><?php echo $articleItem['title']; ?></a></h3>
					<a href="blog.php&article=<?php echo $articleItem['num']; ?>">Read more</a>  
				</article>
				<?php } ?>
			</div>  
		</div>
	<?php } ?>	
</div>

i use this one
<?php $modelCount = mysql_count('products', 'type'); ?>
 <?php if ($modelCount == 1) { ?>
  section A
<?php } elseif($modelCount > 1) { ?>
 section B
<?php } ?>

example
model AA have type A --> view in section 1
and
model B and type B
model 2B and type B  --> View in section 2

Could you help me please !
petrogus

it works but the problem is that I have different results on search page.

For example <?php echo $record['_link'] ?> show me links like products.php?7 or news.php?2 or article.php?4

I need to create links like products.php?article=7 or news.php?article=2 or article.php?article=4.
Different php page for each results.

thank you for your help

I create a search page with the results,

                  <?php foreach ($searchRows as $record): ?>
                     <a href="<?php echo $record['_link'] ?>"><strong><?php echo $record['_title'] ?></strong></a><br/>
                     <?php if ($record['_summary']): ?>
                       <?php echo $record['_summary'] ?><br/>
                      <?php else: ?>
                        No description available for page.<br/>
                      <?php endif ?>
                     <a href="<?php echo $record['_link'] ?>" style="color: #999;" ><?php echo $record['_link'] ?></a><br/><br/>
                  <?php endforeach ?>

and the link of the results look like as /news.php?6

but I would like to appear as /news.php?article=6

Could you help ! thank you in advance

P.

it works fine thank you for your help

for example I have this code

<?php $maxCols = 4; $columnCount = 0; ?> 
<?php if (($columnCount % $maxCols) == 0) { echo "<div class=".chr(34)."row".chr(34).">";}?>
<?php foreach ($productsRecords as $record): ?>

<div class="col-md-3 >
.....
</div>

<?php endforeach ?>
<?php if (($columnCount % $maxCols) == 0) { echo "</div>";}?>

and I would like to appear on page the following

<div class="row">
<div class="col-md-3 >.....</div>
<div class="col-md-3 >.....</div>
<div class="col-md-3 >.....</div>
<div class="col-md-3 >.....</div>
</div>

<div class="row">
<div class="col-md-3 >.....</div>
<div class="col-md-3 >.....</div>
<div class="col-md-3 >.....</div>
<div class="col-md-3 >.....</div>
</div>

Thank you in advance

I'm trying to print a long table (2 or more pages long, landscape) to PDF but i cannot create page break in my document.

I tried my table to print in grid as well (i'm working with bootstrap 3). I have header and footer for every page as well.

My script for output until now:

  $GLOBALS['CREATEPDF_CUSTOM_SWITCHES'] = '--page-size A4 --encoding UTF-8 --orientation landscape --margin-top 0 --margin-bottom 25 --margin-right 0 --margin-left 0 --header-html printthis-header.html --footer-html printthis-footer.html';
  createPDF_fromOutput('inline', 'example.pdf');

Have you any sample code to create automatic page breaks?
I'm using the add-on version 1.04.
Please advise,
Kostas

I start a research about the backup to external server with no luck until, now.

I there any live solution i can embed?

Keeping backup files on the same server is not the best solution and send over email everyday for over 30 client is lot of work with archiving afterwards.

How and where can i mount an externmal drive in the autoBackup.php like:

sshfs user@remotesystem:/remote/dir /some/local/dir

Regarded to the post Future CMSB Requirements: PHP v5.4 and MySQL v5.5 (http://www.interactivetools.com/forum/forum-posts.php?Future-CMSB-Requirements-PHP-v5.4-and-MySQL-v5.5-79943)
Is this for the next big update (maybe version 3) of the cmsb or even for the next immediate releases as well?

Please advise,
Kostas

Thank you for the update!

Kostas

Related to the post:

http://www.interactivetools.com/forum/forum-posts.php?postNum=2233052#post2233052

is there any news on new version of the autoBackup add-on?

I search for solution to create backup to an external server, (ip/folder).

Thank you,
Kostas