Sunday 15 August 2004 5:09:31 am
Well, I've worked out that it all seems to be to do with the ezcontentobject_attribute table. For the objects that work, the datatype_string field says ezxmltext, ezurl, ezstring, etc..., but the ones that don't work have a blank field. I have found where the problem (for me lies), and that is in the dbupdate-3.2-4-to-3.3-1 sql update script. In fact it is in this section: create table ezcontent_attribute_tmp as select ezcontentobject_attribute.*, ezcontentclass_attribute.data_type_string from ezcontentobject_attribute, ezcontentclass_attribute where ezcontentobject_attribute.contentclassattribute_id=ezcontentclass_attribute.id and ezcontentclass_attribute.version=0; delete from ezcontentobject_attribute; alter table ezcontentobject_attribute add data_type_string varchar(50) not null;
insert into ezcontentobject_attribute select * from ezcontent_attribute_tmp; drop table ezcontent_attribute_tmp;
Only problem is, I can'r get it to work, it keeps giving errors?? Any ideas? Thanks, Tim
http://www.AdBalance.com - Ad network news and reviews
http://www.DevPublisher.com - Website publisher guides, tools and news
http://www.AudioMelody.com - Make better music
|