See Drupal and MySQL 5.0.15 configuration problems for a little more information. Basically, Drupal won't install cleanly on MySQL 5.0.15.

These only seem to be minor issues - but causing major problems, so I'll post a patch soon.

CommentFileSizeAuthor
#4 database.mysql_8.patch559 bytesThox

Comments

sepeck’s picture

sepeck commented

Thox, I posted a followup there with some links. It may be related to people using the mysql extensions instead of the mysqli extensions with MySQL4.1.3 or higher. I ran into this issue with Windows/IIS systems, switched and never thought twice about it.

Not an area I am an expert in, but it may be worth looking at as the actual cause.

cerberos’s picture

cerberos commented

I tried a new and clear install of drupal 4.6.3 (new user :-D) in a server running Apache 2, php 5 and mysql 5. The sql query to create tables give an error on lines near 803 (no default value)... Adding a default value '' the cms seems work but gives many error later... Probably it's related with the use of php_mysql.dll instead php_mysqli.dll... I will try.

cerberos’s picture

cerberos commented

Using mysqli.dll cms doesn't work...probably it can't connect.

Thox’s picture

Thox commented
StatusFileSize
new database.mysql_8.patch559 bytes

The attached patch allows Drupal to install on MySQL 5.0.15. However, there are still one or more areas that do not work correctly.

Fatal error: Incorrect integer value: '' for column 'required' at row 1 query: INSERT INTO vocabulary (name, description, help, multiple, required, hierarchy, relations, tags, weight, module, vid) VALUES ('Test', '', '', 0, '', '0', 0, 0, 0, 'taxonomy', 1) in C:\www\drupal\includes\database.mysql.inc on line 108

The problem is that taxonomy_save_vocabulary tries to save the "required" (also the "multiple" field and maybe others) as a string when the value in those fields is empty - i.e. when they're not ticked.

geeklight’s picture

geeklight commented

Hopefully helpful, from a drupal newbie: I noticed the source of the errors I was getting while loading the db (clean install) were related to the fact that the REPLACE statements for the 'blocks' table were running against an empty table, making them inserts (as assumption here that if inserts were intended they would have been written that way?) So, I commented those out, and the script can run successfully.

However, I try to create my first post in the new install, and get this:

Location /index.php?q=node/add/blog
Message Field 'revisions' doesn't have a default value query: INSERT INTO drup_node (status, moderate, promote, sticky, comment, title, body, format, uid, created, type, teaser, changed, nid) VALUES('1', '0', '1', '0', '2', 'Drupal Installed!', 'Check it out.', '1', '1', '1131138418', 'blog', 'Check it out.', '1131138436', '2') in C:\Inetpub\wwwroot\includes\database.mysql.inc on line 66.

One interesting thing to note - MySQL documentation indicates that TEXT datatypes cannot have DEFAULT VALUES. (the columns I'm seeing these messages for).

Good luck!

jholt’s picture

jholt commented

The problem seems to be related to the "strict" setting in MySQL 5. I had the same problem, and reconfiguring with this setting turned off seems to have solved the problem. I just ran the database creation script for now, and it finished OK. It gave errors previously.

See also: http://db4free.blogspot.com/2005/10/web-apps-ready-for-mysql-5.html

dries’s picture

dries commented
Status: Active » Fixed

Committed to HEAD. Thanks.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
drewish’s picture

drewish commented
Version: » 4.7.2

I've created a patch to address some of the other issues. See #76743: Incompatibilities with MySQL 5.0