3.2 database fix

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

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

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?

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.

Wednesday 17 September 2003 7:58:28 am

The demodata.sql is no longer part of the distribution and is depracated. All demo data has been split into 8 eight separate packages which are found in the kernel/setup/packages directory. To install this the setup must be used or install the sql under the sql directory in the package directory (eg. kernel/setup/packages/bookshop/sql/mysql/bookshop.sql)

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq