Luc Chase wrote: (...) > I saw a sql script in the extension and the install txt says it needs to be > added.. do i need that? it is for MySQL but we're running ORACLE. I've > begun to convert the DDL but still can't workout where it is used by the > addmissingobjectattributes.php script.
The sql is only needed if you install the extension, and the extension is not needed for runnning the script. For production I suggest you just use the script. Don't activate the extension, and don't install the sql. The extension doesn't support oracle yet (nor postgres). The script uses only one trivial sql query apart from the API, so it should be fine. It is not tested on oracle though, so take the usual precautions. > One more question please... > Am I supposed to use the normal Admin UI to add the attributes, but > avoid clicking on Save or Apply buttons? That would have added rows to > the class attributes table but not the object tables. Then run the > script? After adding/removing attributes in the admin UI you need to click Apply to save the class attributes. In old versions of eZ Publish there is no Apply button, in that case you can move one attribute up and down again, this will also save the class. Next, close the window. Do not click OK or Cancel. Just close the window. Then you run the script. > OK, I think i got the syntax > php addmissingobjectattributes.php -s xxxxxxx --admin-user=admin > --db-user=... --db-password=... --classid=xxx > --db-database=... > > but the error > "Could not fetch admin user object" > > line 185 seems to be missing [db-host:] ? Hm, you're right, the db options are incomplete. More things are missing as well. (It appears they were never in the original version, which was written by someone else. I never needed those options.) I'll fix that and post the update here shortly. If your db settings are set in settings/override, you can skip the db settings, and just run: php addmissingobjectattributes.php --classid=xxx --admin-user=admin is redundant, since 'admin' is the default. You can skip it. Gunnstein (...) > 2009/11/10 Gunnstein Lye <[email protected]> > >> No, unfortunately not. 4.2 has performance improvements, but does not >> solve all timeout problems. However, we are working on solutions, >> including ways to move long running operations into background processes. >> >> Gunnstein >> >> Luc Chase wrote: >>> Thanks very much Gunnstein. I've also heard that ez 4.2 fixes this >> problem >>> completely. Is this correct? >>> >>> -- >>> Luc. >>> >>> 2009/11/9 Gunnstein Lye <[email protected]> >>> >>>> Luc Chase wrote: >>>>> I believe ez systems has a script to safely add new attributes to a >> class >>>>> which hold a very large number of objects (e.g. to add new attributes >> to >>>> a >>>>> user class holding 15000 users). Does anyone know where I can find that >>>>> script? >>>>> >>>>> I could go into the DB and re-assign the new attributes from another >>>> class >>>>> but would like to have a look at that script, in case it seems a better >>>>> option. >>>> See >>>> http://projects.ez.no/ezscriptmonitor >>>> >>>> This contains the most up to date version of the >>>> addmissingattributes.php script, to my knowledge. You don't have to >>>> install the extension to use the script. >>>> >>>> regards, >>>> -- >>>> Gunnstein Lye >>>> Systems engineer >>>> [email protected] | eZ Systems | http://ez.no >>>> >>> >>> >> >> -- >> Gunnstein Lye >> Systems engineer >> [email protected] | eZ Systems | http://ez.no >> > > > -- Gunnstein Lye Systems engineer [email protected] | eZ Systems | http://ez.no -- Sdk-public mailing list [email protected] http://lists.ez.no/mailman/listinfo/sdk-public
