Posted by Axel_V on July 29, 2006 at 4:40pm
Jump to:
| Project: | G2 Glossary |
| Version: | 4.7.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Axel_V |
| Status: | closed (fixed) |
Issue Summary
I'm working with MySql 4.0 on Drupal 4.7.2.
When I try to install g2 gallery through Drupal, the tables will not set up. I can install the g2_node table handish but the g2_referer table install is rejected with the following error: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 COMMENT='G2 referer stats for link exchang
Comments
#1
What is happening is the you are actually using g2 glossary (not g2 gallery) on the basic drupal nodes, without the extensions brought in by G2, which causes all the errors you see: you're missing tables g2_node and g2_referer.
What is happening is the fact that install failed, because your version of MySQL is too old: version 4.0 did not understand some clauses like "ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='G2 referer stats for link exchange'" so you can just remove them.
The simplest fix if you want to keep on using this MySQL version is to manually install the g2.mysql file, for instance from PHPMyAdmin, possibly editing it to remove MySQL 4.1 specific information.
If you have more time, could you roll up a patch to g2.install so that it takes into account 4.0 ?
In the meantime, I'm adding a "requirements" section in the docs, because the need for 4.1 was not yet documented.
#2
MySQL 4.1 requirement is now documented, so I'm marking the problem as fixed, but if you want to create a 4.0 compatible .install, by all means submit it and mark the issue as "code needs review". Thanks.
#3
#4
Version 1.15.2.7 has an improved installer, which might prevent such issues.
#5