Geeklog Forums

I receive this when i try to install geeklog 1121: Column 'date' is used with UNIQUE or INDEX but is not defined as NOT NULL

This is explained in the installation instructions (well, part of it at least): Your version of MySQL is too old. You need to upgrade MySQL (or ask your hosting service to do it for you).

Otherwise, you would need to remove some lines from sql/mysqltableandata.php, but I'm afraid the list in the installation instructions (which tells you to remove lines 176 and 375) is not up to date (and the line numbers are wrong now). Sorry, we need to come up with an updated list ...

Besides, there were some security issues with MySQL recently, so upgrading to MySQL 3.23.54 is recommended anyway.

bye, Dirk

Perhaps not directly related to first post, but... I just installed (on Win2k/Apache/MySQL 3.23.44) and when I get to the last stage of the install script I get this error: 1146: Table 'ego.geeklog_blocks' doesn't exist However if I look at my db it has already created a table 'geeklog_access' so it obviously has the ability to create tables okay. Is there something I should be doing or is this a bug?

Hi, i am having the same problem, Just wondering would version 3.22.32 be too old?? if not, what files do i delete,,?? please help... cheers ben

Hi folks, just tried to install the latest German version of geeklog (1.3.7 sr1) and running into the very same problem. Even the workaround with deleting two lines in the mysql_tableanddata.php file did not help (well, I deleted the line by content, not by row number!). Any ideas?? Roman

As I already said above: The documentation is not up to date here - you would have to remove more than two lines. But even if you find all the lines, you will probably run into other SQL problems later. In other words: You should really upgrade your MySQL installation. We've made a couple of optimizations in the MySQL code over the last Geeklog updates, resulting in a better performance. The downside is that Geeklog now requires a reasonably up-to-date MySQL install. I'd say don't even bother to try if your MySQL version is 3.22.something - you should have at least 3.23.something. I know that some hosters are not very responsive (Since you're German, let me take a guess: Strato? Last I heard, they were still on MySQL 3.22.32) and refuse to upgrade their MySQL install. In that case, I recommend to point out to them that security issues have been found in MySQL last December and that the makers of MySQL recommend to upgrade to MySQL 3.23.54 as soon as possible. bye, Dirk

I have an interested problem exactly on these lines. I copied just the SQL code to CREATE the comments table. I can execute the SQL code and create the table on one web hosting service running MySQL 3.23.39. However, when I cut and paste the same SQL code into another server running MySQL 3.23.49 (newer version) I get the same darn error [Column \'date\' is used with UNIQUE or INDEX but is not defined as NOT NULL]. Obviously, this is preventing me from running the install pack. I went through mysql_tableanddata.php and changed all of the column definitions for the INDEX declaration columns to NOT NULL (and of course then had to make changes to the DEFAULT from NULL to some reasonable value). But then of course this all blew up when the rest of the install script tried to write NULL to one of the index columns. Is it possible that the same problem with MySQL versions less than 3.22 will appear in a later version?

Are you talking about 1.3.7 or 1.3.8? In 1.3.8, there\'s no index on the date field in the comments table (not at first, at least - it\'s added later in the install, after the install script made sure it\'s running on MySQL 3.23.2 or newer). The MySQL manual makes no mention that this problem exists in newer versions as well. I only have access to installs running 3.23.52 and .57 at the moment and everything\'s fine there ... bye, Dirk