3.2 database fix

Author Message

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

Bård Farstad

Wednesday 20 August 2003 12:24:27 pm

You should not need these fields. They are deprecated.

Make sure you've cleared PHP Accelerator cache before installation.

--bård

Documentation: http://ez.no/doc

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?

Tony Wood

Wednesday 17 September 2003 7:04:23 am

Don, try using the installer, that works fine for Demo setups.

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

Jan Borsodi

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.