How can I create a new attribute through a script?

Next topic

Author	Message
K259	Monday 11 September 2006 4:13:42 am I have a class called article. If I add an attribute to this article in the admin-interface, I get a timeout and only some articles stored in the database get this attribute. The solution is to add this attribute to the class, and to the existing objects of this class in the database by using a script, but how? Are there any script for this available today for ez? I've seen many postings about this, but haven't found any links to scripts, only text that says: you have to create this in the db through a script if your database already contains too many objects of this class..then it will not work adding this in the ez admin interface. Hope someone can help.
Kristof Coomans	Monday 11 September 2006 4:28:22 am Hi K I think you can use this one: http://ez.no/community/contribs/hacks/update_class_from_command_line Enable the apply button in the class edit interface, that will make storing your temporary class version easier. In content.ini.append.php: [ClassSettings] ApplyButton=enabled independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Atle Pedersen	Thursday 14 September 2006 1:04:28 am What is the reason for this problem? PHP execution timeout? Would it solve the problem just (temporarily) increasing the timeout value?
K259	Thursday 14 September 2006 4:26:41 am No, it will not help us so much. With too many objects, there "will be" a timeout. We already got the limit too high.
K259	Thursday 14 September 2006 4:28:05 am Btw. Is it possible to fix this through mysql? I prefer fixing these things with sql rather than messing around with scripts and versions of classes ;)
Kristof Coomans	Thursday 14 September 2006 7:22:05 am Hi K I think running plain SQL queries to do this could mess up your eZ publish database more than using CLI scripts and some kernel functions. independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Claudia Kosny	Thursday 14 September 2006 2:34:46 pm Hello K259 Did you try the script mentioned by Kristof? I might need something like this later on and would be interested in the results you got with it. Claudia
K259	Friday 15 September 2006 12:03:37 am Hi Claudia! No, I'm thinking about another solution. There have to be a better and easier way to do this. K259

eZ debug

Timing:	Jan 18 2025 14:55:06
Script start
Timing:	Jan 18 2025 14:55:06
Module start 'layout'
Timing:	Jan 18 2025 14:55:06
Module start 'content'
Timing:	Jan 18 2025 14:55:07
Module end 'content'
Timing:	Jan 18 2025 14:55:07
Script end

Main resources:

Total runtime	0.8382 sec
Peak memory usage	4,096.0000 KB
Database Queries	76

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0064	588.0469	152.6406
Module start 'layout'	0.0064	0.0036	740.6875	39.4922
Module start 'content'	0.0099	0.8267	780.1797	659.9531
Module end 'content'	0.8366	0.0015	1,440.1328	16.1250
Script end	0.8381		1,456.2578

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.4160	16	0.0002
Check MTime	0.0015	0.1785	16	0.0001
Mysql Total
Database connection	0.0008	0.1011	1	0.0008
Mysqli_queries	0.7719	92.1000	76	0.0102
Looping result	0.0008	0.0956	74	0.0000
Template Total	0.8019	95.7	2	0.4009
Template load	0.0021	0.2517	2	0.0011
Template processing	0.7997	95.4172	2	0.3999
Template load and register function	0.0002	0.0223	1	0.0002
states
state_id_array	0.0015	0.1833	1	0.0015
state_identifier_array	0.0015	0.1755	2	0.0007
Override
Cache load	0.0018	0.2106	32	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0011	0.1262	4	0.0003
Fetch class attribute name	0.0012	0.1431	10	0.0001
XML
Image XML parsing	0.0014	0.1611	4	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0024	11	0.0000
General
dbfile	0.0030	0.3535	22	0.0001
String conversion	0.0000	0.0010	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
8	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 22 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs