Forums / Install & configuration / ezimagealiashandler and moving the var directory

ezimagealiashandler and moving the var directory

Author Message

Greg McAvoy-Jensen

Saturday 31 May 2008 9:49:21 am

I've upgraded a site from 3.9.4 to 3.10.0 to 4.0.0. I had a problem getting caches cleared in 4.0, as my main public site had VarDir=var/eznewsletter_site. We're not using the newsletter yet, so I decided to consolidate the var directories into one regular var. I've cleaned the tables so there's no reference to "eznewsletter_site/" in the database. You can see the images in the admin interface now.

However, the site hangs when trying to access a template with a line like:
{content_view_gui view=billboard content_object=$node.object.data_map.billboard.content}
or
<img src={$node.object.data_map.billboard.content.data_map.image.content[billboard].full_path|ezroot} />
or even
{$node.object.data_map.billboard.content.data_map.image|attribute(show,2)} (but not {$node.object.data_map.billboard.content.data_map|attribute(show,2)}).

What might I need to fix?

In case it helps, in settings/override/site.ini.append.php I'm using:
[URLTranslator]
TransformationGroup=urlalias_compat

Does that affect images?

Many thanks!

Granite Horizon, Certified Developer of eZ Publish Web Solutions
Provider of the SaaS Solution Granite Horizon In The Cloud | http://granitehorizon.com/cloud
http://granitehorizon.com | +1 916 647 6350 | California USA | @granitegreg
Blog: http://granitehorizon.com/blog

Greg McAvoy-Jensen

Saturday 31 May 2008 6:29:29 pm

UPDATE

The problem remains after I've reverted to the 3.10.0 working version of the var directory (with var and var/eznewsletter_site) and database (upgraded for 4.0.0). I've got VarDir=var/eznewsletter_site in settings/override/site.ini.append.php.

Suggestions on where to look for a fix?

No errors appear in the logs when it hangs (I've asked WebDeal for server and php logs).

Granite Horizon, Certified Developer of eZ Publish Web Solutions
Provider of the SaaS Solution Granite Horizon In The Cloud | http://granitehorizon.com/cloud
http://granitehorizon.com | +1 916 647 6350 | California USA | @granitegreg
Blog: http://granitehorizon.com/blog

Greg McAvoy-Jensen

Monday 02 June 2008 1:24:32 am

Another update:

I've tried yet again going all the way back to 3.9.4 to 3.10.0 first. It runs fine on 3.10.0. Going to 3.10.0 I did not run bin/php/updateniceurls.php, as it's recommended that we wait until 4.0.0. However, the 3.10.0 upgrade check for the database has concerns:

To synchronize your database with the distribution setup, run the following SQL commands:
ALTER TABLE ezurlalias_ml DROP INDEX ezurlalias_ml_act_org;
ALTER TABLE ezurlalias_ml ADD INDEX ezurlalias_ml_act_org ( action, is_original );
ALTER TABLE ezurlalias_ml DROP INDEX ezurlalias_ml_action;
ALTER TABLE ezurlalias_ml ADD INDEX ezurlalias_ml_action ( action, id, link );
ALTER TABLE ezurlalias_ml DROP INDEX ezurlalias_ml_par_act_id_lnk;
ALTER TABLE ezurlalias_ml ADD INDEX ezurlalias_ml_par_act_id_lnk ( parent, action, id, link );
ALTER TABLE ezurlalias_ml DROP INDEX ezurlalias_ml_par_lnk_txt;
ALTER TABLE ezurlalias_ml ADD INDEX ezurlalias_ml_par_lnk_txt ( parent, link, text );
ALTER TABLE ezurlalias_ml DROP INDEX ezurlalias_ml_par_txt;
ALTER TABLE ezurlalias_ml ADD INDEX ezurlalias_ml_par_txt ( parent, text );
ALTER TABLE ezurlalias_ml DROP INDEX ezurlalias_ml_text;
ALTER TABLE ezurlalias_ml ADD INDEX ezurlalias_ml_text ( text, id, link );
ALTER TABLE ezurlalias_ml DROP INDEX ezurlalias_ml_text_lang;
ALTER TABLE ezurlalias_ml ADD INDEX ezurlalias_ml_text_lang ( text, lang_mask, parent );

I tried leaving this to 4.0.0 to handle.

In 4.0.0, first tried omitting updateniceurls.php; but the site runs with the same problem (, but /user/login works fine):

Fatal error: eZ Publish did not finish its request

The execution of eZ Publish was abruptly ended, the debug output is present below.

I then ran updateniceurls.php, but the problem remains.

I'll next try running the queries 3.10.0 recommended, but I welcome your suggestions. I'm running in circles.

Granite Horizon, Certified Developer of eZ Publish Web Solutions
Provider of the SaaS Solution Granite Horizon In The Cloud | http://granitehorizon.com/cloud
http://granitehorizon.com | +1 916 647 6350 | California USA | @granitegreg
Blog: http://granitehorizon.com/blog

Greg McAvoy-Jensen

Monday 02 June 2008 6:54:19 am

I should have also noted: in moving from 3.9.4 to 3.10.0, the database upgrade script was edited to eliminate the "from 3.9.1" and "3.9.3" snippets. However, It still generated an error--key already exists in this line: ALTER table ezsearch_word ADD KEY ezsearch_word_obj_count(object_count);

I deleted the line from my copy of the script, dropped the tables of the database and restored it was it was before running the script, and ran it again (cleanly this time).

Any idea why I could get that error going from 3.9.4 to 3.10.0? Is it a bug? Could the key have been put there by eznewsletter? Could this be a component of my current problem (see prior posts)?

Granite Horizon, Certified Developer of eZ Publish Web Solutions
Provider of the SaaS Solution Granite Horizon In The Cloud | http://granitehorizon.com/cloud
http://granitehorizon.com | +1 916 647 6350 | California USA | @granitegreg
Blog: http://granitehorizon.com/blog