mysql Initialization failed

Next topic

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?