Topic: Error message....HELP!

[Steen Løcke]

Hi Friends.

When I boot up my SME 5.6 Update4 I got this error message in my boot.log:

May  8 22:21:02 moornook mysql: ERROR 1061 at line 74: Duplicate key name 'category_category_name_idx'
May  8 22:21:02 moornook mysql.init: Loading 30mysql.create.horde.sql into mysql failed

My server is running..it seems that it works, but I don't like such a message. Somebody knows what 's wrong and have a solution.

Best regards
Steen

[Simon Vetterli]

I get also some errors after updating from SME 5.1.2 to SME 5.5:

May 10 15:52:28 africagate migrate-imp-to-turba: /etc/rc.d/init.d/mysql.init: /etc/e-smith/sql/init/30mysql.create.horde.sql: No such file or directory
May 10 15:52:28 africagate mysql.init: Loading data into mysql failed
May 10 15:52:28 africagate migrate-imp-to-turba: ^[[60G
May 10 15:52:28 africagate migrate-imp-to-turba:
May 10 15:52:28 africagate migrate-imp-to-turba: Creating Turba objects table
May 10 15:52:28 africagate migrate-imp-to-turba: DBI->connect(horde:localhost:3306) failed: Access denied for user: 'horde@localhost' (Using password: YES) at /etc/rc.d/init.d/migrate-imp-to-turba line 120
May 10 15:52:28 africagate migrate-imp-to-turba: Converting book entries
May 10 15:52:28 africagate rc: Starting migrate-imp-to-turba:  failed
May 10 15:52:29 africagate mysql.init: loading /etc/e-smith/sql/init/30mysql.create.horde.sql into mysql
May 10 15:52:29 africagate mysql.init: Loading data into mysql
May 10 15:52:29 africagate mysql.init: /etc/rc.d/init.d/mysql.init: /etc/e-smith/sql/init/30mysql.create.horde.sql: No such file or directory
May 10 15:52:29 africagate mysql.init: Loading data into mysql failed
May 10 15:52:29 africagate mysql.init: ^[[60G
May 10 15:52:30 africagate mysql.init:
May 10 15:52:30 africagate rc: Starting mysql.init:  succeeded

I need some Help!

Regards

Simon

[Steen Løcke]

Hi!

I have solved this problem/error! How did I do it? Okay, "30mysql..." looks like a kind of a template...bingo! It was a template!
This template tried to make af db: horde.sql
But my server has allready a horde.sql! I deleted this db and run a reboot...now my SME make a clean boot! A new horde.sql was created and it looks fine.

Best regards
Steen

[Dave]

Well I have the same error.

Now I attempt to find the horde.sql file to delete by cannot find it.

Can someone help please.

Cheers

Dave