Forums / Install & configuration / mysql Initialization failed

mysql Initialization failed

Author Message

zackwlg zackwlg

Thursday 19 June 2003 6:23:17 am

hi,
when i try to Initialize the Database i get this error message:

Initialization failed
The database could not be properly initialized.
Column 'contentobject_id' is used with UNIQUE or INDEX but is not defined as NOT NULL
MySQL Error #1121

my db contains data and i checkedĀ“"Continue but leave the data as it is.
" who can help me?

bye zack

Tony Wood

Thursday 19 June 2003 7:32:48 am

Zack,

did you do the initialisation by hand or via the install tool?

I am guessing you don't want any of the data in the db so if you can go to the DB drop the tables. Then run

mysql -uxxx -pxxx mydb < kernel/sql/mysql/kernel_clean.sql

This will create a clean db for you.

I hope this helps

Tony

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

zackwlg zackwlg

Thursday 19 June 2003 10:15:37 pm

i install by the install tool. no, i need the other tables in the db. i can`t drop them.

zack

zackwlg zackwlg

Sunday 22 June 2003 10:48:02 pm

is there no way to install the tables manually perhaps with a sql file?

zack

Tony Wood

Monday 23 June 2003 3:32:11 am

Hi,

This is what this does. It installs the tables manually

mysql -uxxx -pxxx mydb < kernel/sql/mysql/kernel_clean.sql

Give it a try, but remember to drop the tables beforehand to clear out data.

phpMyAdmin is good for this if you are not happy doing it from the command line.

tony

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

zackwlg zackwlg

Monday 23 June 2003 4:30:34 am

thanks but now i get this error message:

Error

SQL-Command :

INSERT INTO ezcontentclass( id, version, name, identifier, contentobject_name, creator_id, modifier_id, created, modified )
VALUES ( 1, 0, 'Folder', 'folder', '<name>' , - 1, 14, 1024392098, 1048494694 )

MySQL announces:

Table 'DB18384.ezcontentclass' doesn't exist

but my DB is called DB18384. i do not know where the error is.

zack

Paul Forsyth

Monday 23 June 2003 4:52:19 am

Try creating a new empty db and issuing the mysql command again. Sounds like there is content within the db already.

If you are getting errors when going through the setup try and skip that phase.

zackwlg zackwlg

Monday 23 June 2003 5:29:52 am

i can`t create an new empty db. i have only this db and it contains other tables, which i can`t drop. other applications use this db too. does ezp need a empty db?