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?

eZ debug

Timing:	Jan 18 2025 16:08:36
Script start
Timing:	Jan 18 2025 16:08:36
Module start 'layout'
Timing:	Jan 18 2025 16:08:36
Module start 'content'
Timing:	Jan 18 2025 16:08:36
Module end 'content'
Timing:	Jan 18 2025 16:08:36
Script end

Main resources:

Total runtime	0.5767 sec
Peak memory usage	4,096.0000 KB
Database Queries	74

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0174	589.1641	152.6406
Module start 'layout'	0.0174	0.0038	741.8047	39.4766
Module start 'content'	0.0212	0.5543	781.2813	625.8281
Module end 'content'	0.5755	0.0011	1,407.1094	16.1484
Script end	0.5766		1,423.2578

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.5873	16	0.0002
Check MTime	0.0014	0.2509	16	0.0001
Mysql Total
Database connection	0.0008	0.1448	1	0.0008
Mysqli_queries	0.5050	87.5647	74	0.0068
Looping result	0.0006	0.1010	72	0.0000
Template Total	0.5339	92.6	2	0.2670
Template load	0.0020	0.3508	2	0.0010
Template processing	0.5319	92.2251	2	0.2659
Template load and register function	0.0002	0.0288	1	0.0002
states
state_id_array	0.0014	0.2416	1	0.0014
state_identifier_array	0.0012	0.2039	2	0.0006
Override
Cache load	0.0018	0.3144	50	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0004	0.0692	3	0.0001
Fetch class attribute name	0.0009	0.1642	9	0.0001
XML
Image XML parsing	0.0007	0.1200	3	0.0002
class_abstraction
Instantiating content class attribute	0.0000	0.0029	10	0.0000
General
dbfile	0.0007	0.1256	16	0.0000
String conversion	0.0000	0.0021	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
8	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
11	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 27 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs