Thursday 27 November 2003 3:26:00 am

Hmm, you are right, the only database that has all the tables is the plain package one.

I tried executing the blog.sql from the kernel/setup directories and get an error message:

Output from SQL commands in file /..../kernel/setup/packages/blog/sql/mysql/blog.sql ..

ERROR 1065 at line 23: Query was empty

The only table created is the approve one. Line 23 in blog.sql:

/*!40000 ALTER TABLE ezapprove_items DISABLE KEYS */;

Doesn't seem right to me, although I am not a mysql expert. Any comments?

Karsten

Thursday 27 November 2003 3:35:04 am

Karsten you're probably right. We've not tested on that old MySQL. We will fix this. You can just remove these comments from the SQL files and it should run fine.

Thanks for the notice,

-bård

Documentation: http://ez.no/doc

Thursday 27 November 2003 5:22:26 am

Shouldn't MySQL just skip that /*!40000.....*/ line?

I don't know the meaning of /*!40000 in great details, but I thought it meant something along the lines of: "don't execute this, unless the mysql version number >= 4.00.00"

Or am I wrong?

--
Hans

Hans
http://blog.hansmelis.be