posting data to the db publically...?

15 posts by 4 authors in: Forums > CMS Builder
Last Post: March 31, 2009   (RSS)

By Dave - March 30, 2009

If you haven't already done so, try upgrading to the latest CMS Builder. I think that function was added in a recent version. Let me know if the error continues after upgrading or you have any other issues.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] posting data to the db publically...?

By s2smedia - March 31, 2009

ok thanks... is there a way to do this with the older version.. just curious

Ill download new version now and test it out...thanks!

By Dave - March 31, 2009

For an older version you could try copying the mysqlStrictMode function (search for "function mysqlStrictMode") from the latest /lib/database_functions.php to the older one. And then repeat that for any other missing functions.

Here's the code for it. Just copy it to your /lib/database_functions.php

//
function mysqlStrictMode($strictMode) {
$currentVersion = preg_replace("/[^0-9\.]/", "", mysql_get_server_info());
$isMySql5 = version_compare($currentVersion, '5.0.0', '>=');

# only for Mysql 5
if (!$isMySql5) { return; }

# set MySQL strict mode - http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
if ($strictMode) {
$query = "SET SESSION sql_mode = 'STRICT_ALL_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER'";
mysql_query($query) or die("MySQL Error: " .mysql_error(). "\n");
}
else {
$query = "SET SESSION sql_mode = 'NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER'";
mysql_query($query) or die("MySQL Error: " .mysql_error(). "\n");
}
}

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] posting data to the db publically...?

By s2smedia - March 31, 2009

Perfect!! thank you!