Login | Sign up | Toll-Free: 1-800-752-0455



5 posts by 3 authors in: Forums > CMS Builder
Last Post: December 1, 2007

Hi -
Having just downloaded CMS builder I was disappointed to see it requires MySQL 5.0.24 to run (missed that on the specs).

Is that an absolute necessity or a recommendation? (ie is there any point in me trying to install it with MySql 4.1.22? 5.x seems quite a high requirement (my hosting company doesn't have any servers on that version yet) and though they're happy to upgrade me I'm a bit worried it will break other stuff.

Regards, Steve.

Re: [steve_e] MySql 5

No, it does need MySQL 5.0.24 or better.

The MySQL company recommends version 5 and has version 6 in alpha. And there is a real push on to get everybody up to MySQL 5 and PHP 5 lately so we decided to start with the more recent versions rather than have to convert 6 months in.

The biggest thing is that MySQL 5 has more strict error reporting. So if you get new errors with your old scripts you need to add "SET SESSION sql_mode=''" to their code to turn off the new errors. Most big hosts will do this automatically for you anyways.

If you get stuck anywhere in the process feel free to post. We had a few hickups in our server upgrade and may be able to help.
Dave Edis - Senior Developer

Re: [osluk] MySql 5

I know how frustrating it can be trying to upgrade things on your server. I've gone through it many times on my own development server and with many web hosts.

If you're upgraded to MySQL 5.0.15 now then you should probably be fine with that one. I'd give it a try. Here's how to bypass the version check:

- Edit the file /cmsAdmin/lib/database_functions.php
- Search for "$requiredVersionAsString" (around line 123)
- Change the version from '5.0.24' to '5.0.15'
- Run the program again.

Let me know how that works out.
Dave Edis - Senior Developer

Re: [Dave] MySql 5

Thanks Dave.
Ok, well the requirement pushed me into it and my hosts have now very quickly and with the minimum of fuss upgraded me to the necessary MySQL and PHP versions.

I'm happy to say it didn't cause any problems at all, only one default setting needed to be changed in the php.ini file if anyone has a problem:

allow_url_include off changed to allow_url_include on if you have problems with include file error messages.

One other thing that might be useful is that when installing cmsbuilder might ask you to disable magic quotes. You can do this via a .htaccess file, but although some help pages tell you to do this with the following line:

php_value magic_quotes_gpc off

I found this didn't work and had to use the following:

php_flag magic_quotes_gpc off

Other than that it's working fine at the moment and looks very impressive!

Regards, Steve