I have made an updated version, fixing the problem with siteaccess and db settings. It can be downloaded directly from SVN, here: http://svn.projects.ez.no/ezscriptmonitor/trunk/extension/ezscriptmonitor/bin/addmissingobjectattributes.php
I have also updated the scriptmonitor extension, which contains this script: http://projects.ez.no/ezscriptmonitor Also the issue is updated: http://issues.ez.no/10203 Gunnstein Gunnstein Lye wrote: > 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
