MySQL problem with module
thomherfs - March 10, 2006 - 01:45
| Project: | Zeitgeist |
| Version: | HEAD |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | thomherfs |
| Status: | closed |
Jump to:
Description
Just a quick note -- interesting module.
When checking it out, the zeitgeist.mysql file brought up a syntax error. In looking at it, you have:
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Log table for zeitgeist.module';
as the last line in the command. The error goes away if you substitute:
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
Type and Engine are interchangeable, of course, I simply wrote it the way I am used to doing. Rather than making this into a patch, I thought I'd just bring it to your attention and let you decide how you wanted to rewrite it.
Again, thanks for a very interesting module.

#1
Thanks for your comments. I've included an alternate mysql file for version 4.0.x, and instructions in the INSTALL.TXT file. The version committed today should now be usable on both mysql versions.
#2