I've had some problem with my db, so I did a fresh D6-10 multisite install on a shared hosting server. I've just installed some contributed modules (pathauto, nodework, page title, global redirect, webform, etc.), then I just did a db export and import again just to see if the db error was introduced by me or not, to my surprise I got the following error:
Error
SQL query:
--
-- Dumping data for table actions
INSERT INTO actions ( aid , type , callback , parameters , description )
VALUES (
'comment_unpublish_action', 'comment', 'comment_unpublish_action', '', 'Unpublish comment'
), (
'node_publish_action', 'node', 'node_publish_action', '', 'Publish post'
), (
'node_unpublish_action', 'node', 'node_unpublish_action', '', 'Unpublish post'
), (
'node_make_sticky_action', 'node', 'node_make_sticky_action', '', 'Make post sticky'
), (
'node_make_unsticky_action', 'node', 'node_make_unsticky_action', '', 'Make post unsticky'
), (
'node_promote_action', 'node', 'node_promote_action', '', 'Promote post to front page'
), (
'node_unpromote_action', 'node', 'node_unpromote_action', '', 'Remove post from front page'
), (
'node_save_action', 'node', 'node_save_action', '', 'Save post'
), (
'user_block_user_action', 'user', 'user_block_user_action', '', 'Block current user'
), (
'user_block_ip_action', 'user', 'user_block_ip_action', '', 'Ban IP address of current user'
);
MySQL said: Documentation
1062 - Duplicate entry 'comment_unpublish_action' for key 1
I'm new to Drupal and not that familar with MySQL, has anyone ever seen this kind of error before? If so how did you solve this? Please remember, it's just a fresh install and I did not add any node or page.
Thanks in advance for your suggestion/comment
Michael
Comments
same problem here
I have the exact same problem, though I am not installing Drupal in a multisite configuration. (It is on a shared server, however, on Hostpapa.
Mine's Drupal 6-9, though, I think - "Fantastico" automatically installs Drupal on Hostpapa.)
Actually I had this problem
Actually I had this problem when I tried to export my db from local to shared hosting (I was using D6-9), then I got this problem, I thought it was something I did, so when I upgraded my core to 6.10, I did not create anything, just core + contributed modules and exported again, and I got the same error, and I'm at lost what to do or how this happened, and I don't know how to solve this, one solution I thought is to export every table except actions, but I don't know if this will work, I'll give it try later.
Thanks in advance for your suggestion/comment
Michael
Thanks in advance for your suggestion/comment
Michael