|
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
|
|
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
|