I am trying to install the latest release of Drupal+Drigg.
My PHP version is 5.2.5
My MySQL version is 5.0.67-community (I have also tried it with 4.1.22)
What I did:
--Downloaded drigg-distr.tgz fromhttp://www.drigg-code.org/pages/download_and_install
--Unpacked & FTPed it to the root directory of my site (http://www.quaerens.net)
--Created a MySQL database
--Opened the home page of my site in IE and entered the database details. Drupal looked to have installed OK.
--Opened PhpMyAdmin
--Tried to execute the SQL in drigg_distr_sql.mysql
--Got this error:
===
Error
SQL query:
INSERT INTO `cache_menu` VALUES ('1:en','a:4:{s:10:\"path index\";a:178:{s:17:\"admin/build/block\";s:2:\"14\";s:22:\"admin/build/block/list\";i:-2;s:27:\"admin/build/block/configure\";i:-3;s:24:\"admin/build/block/delete\";i:-4;s:21:\"admin/build/block/add\";i:-5;s:29:\"admin/build/block/list/marvin\";i:-6;s:33:\"admin/build/block/list/pushbutton\";i:-7;s:34:\"admin/build/block/list/drigg_theme\";i:-8;s:30:\"admin/build/block/list/garland\";i:-9;s:32:\"admin/build/block/list/chameleon\";i:-10;s:33:\"admin/build/block/list/bluemarine\";i:-11;s:31:\"admin/build/block/list/minnelli\";i:-12;s:21:\"admin/content/comment\";s:2:\"15\";s:26:\"admin/content/comment/list\";i:-14;s:30:\"admin/content/comment/list/new\";i:-15;s:35:\"admin/content/comment/list/approval\";i:-16;s:30:\"admin/content/comment/settings\";i:-17;s:14:\"comment/delete\";i:-18;s:12:\"comment/edit\";i:-19;s:22:\"admin/settings/filters\";s:2:\"16\";s:27:\"admin/settings/filters/list\";i:-21;s:26:\"admin/settings/filters/ad[...]
MySQL said:
#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 '0',
`created` int(11) NOT NULL default '0',
`headers` text,
PRIMARY KEY' at line 1
===
This is most frustrating. I have tried it on two different hosts with 2 different versions of MySQL and get the same error each time.
Can you check it out ASAP please as I'm unable to get going with Drigg because of this.
Thanks,
Lex Edmonds
Comments
Comment #1
mercmobily commentedHi,
I really don't know what could be going wrong.
Does anybody else have any ideas?
In the meantime, you can always install Drigg the manual way!
Bye,
Merc.
Comment #2
mercmobily commentedHi,
I just tested this on MySql 5.0.58 and it works fine.
I am going to assume this was a one-off weirdness, since I had never heard it before.
If it still affects you, please reopen pasting exactly what you are trying to feed mysql.
Bye,
Merc.