|
Tony Wood
|
Wednesday 20 August 2003 12:20:50 pm
The kernelclean sql nis missing two fields in ezcontentobject_tree
I needed to add the following two lines.
crc32_path varchar(255) default '',
md5_path varchar(255) default '', I would have preferred NOT NULL but the first line 771 in demo data contains NULL data. 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
|
Wednesday 20 August 2003 12:33:15 pm
Wow.. spot on.. it was accelerator cache.. ignore next post too... it works now..
The insert in Demo data contains
INSERT INTO ezcontentobject_tree (node_id, parent_node_id, contentobject_id, contentobject_version, contentobject_is_published, crc32_path, depth, path_string, sort_field, sort_order, priority, path_identification_string, main_node_id, md5_path) VALUES (1,1,0,1,1,NULL,0,'/1/',1,1,0,NULL,1,NULL);
so it balked if i didn't have it
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
|
Wednesday 20 August 2003 12:38:49 pm
I've not looked at 3.2 before now, we have been too busy. I must say, it looks lovely. Nice work :)
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
|
|
Don MacLeod
|
Wednesday 17 September 2003 6:33:03 am
I've just tried to load the demo data (demodata.sql) for 3.2. I also get the same problem as above ...... ERROR 1054 at line 771: Unknown column 'crc32_path' in 'field list'. This is on a db server without PHP installed so is not related to the above mentioned PHP Accelerator issue. Also, the install doc differs from the files included in the distribution in that it mentions "demokernel.sql". This is NOT included - instead it is "demodata.sql". Any ideas?
|
|
Don MacLeod
|
Wednesday 17 September 2003 7:39:42 am
Tony OK thanks, but I already have apache, php, mysql, ImageMagick setup and working well so wanted to avoid the installer. In any case it was the unstable version I was trying to install (Beta 2) and so have gone for the main 3.2 (stable). In that version there is no demodata.sql available anyway! Just really wanted to get demo stuff in there to play around with. Don.
|
|
Tony Wood
|
Wednesday 17 September 2003 7:54:23 am
sorry, I meant using the eZ HTML installer for the demo.
[SiteAccessSettings]
CheckValidity=true This will take you thru the installer for a project. I agree, if you have your system setup they way you want it don't use the binary installer, it could make a mess. 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
|