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

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!
Dave,

Just an unrelated word of thanks for posting the user signup form code earlier in this post. That form, along with reading over the assistance you gave here really helped me in setting up this member area that I've been working on for a client. I was pretty hesitant to agree to do this for them, but your assistance, even indirectly, really saved the day for me. :-)

Thanks again!

Jeremy
---------------------------

Dwelling Productions

www.dwellingproductions.com