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
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!
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
Hope that helps!
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
interactivetools.com
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
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
Dwelling Productions
www.dwellingproductions.com