If you enable debugOutput it might give some clues.

Modified on Tuesday 26 August 2008 11:28:14 pm by André R

TRUNCATE: command not found

What's the mysql version you're using ?

X+

Thanks for quick response:

Attn. André:
I have enabled the debug output. Its only visible in the admin interface.
http://nuna0000.no.ezpublish10.ezdeal.no/siteadmin

There where a lot of errors like:

eZContentObjectTreeNode::pathWithNames() failed to fetch path of node 15, falling back to generated url entries. Run updateniceurls.php to fix the problem.

The second time I tried to click on a link in the admin interface most of those error where gone. There are still some as you can see. Cache clearing in admin doesent seems to work?
Tried cache clearing with terminal and it didnt work:

ezpublish10:~/www/bin/shell$ clearcache.sh
-bash_nuna0000noezpublish10ezdealno: clearcache.sh: command not found

I tried to run the nice url update again:

ezpublish10:~/www$ php bin/php/updateniceurls.php --fetch-limit=100
Note: any errors encountered will be logged to urlalias_error.log
Using fetch limit: 100
Starting updates for Home, 119 nodes
........................................................ 46.22% 2s 55/119
........................................................ 93.28% 0s 111/119
.......
Updated 0/119 for Home

Starting updates for Users, 12 nodes
............
Updated 0/12 for Users

Starting updates for Media, 21 nodes
.....................
Updated 0/21 for Media

Starting updates for Setup, 1 nodes
.
Updated 0/1 for Setup

Starting updates for Design, 1 nodes
.
Updated 0/1 for Design


Total update 5/159
Node time taken: 3s
Total time taken: 3s
ezpublish10:~/www$ 

Attn. Xavier: Its MySQL client version: 5.0.26
and PHP extensions: mysqli

I will look more in to this in the afternoon.

I have turned on ( DebugOutput=enabled ) the display of errormessages in the file site.ini in the folder settings.

This gives error messages in admin siteaccess, but non in the websiteinterface. One message is:

Query error: Unknown column 'e0.alias_redirects' in 'field list'. Query: SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e0.alias_redirects AS e0_alias_redirects, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.is_alias AS e1_is_alias, e1.action AS e1_action, e1.alias_redirects AS e1_alias_redirects
FROM ezurlalias_ml e0, ezurlalias_ml e1
WHERE e0.parent = 0 AND (e0.lang_mask & 7 > 0) AND e0.text_md5 =  MD5( 'user' ) 
AND e1.parent = e0.link AND (e1.lang_mask & 7 > 0) AND e1.text_md5 =  MD5( 'login' ) 
LIMIT 0, 1

I tried to run the clearcache.sh to be able to se more errors. Also unsucessfull:

ezpublish10:~/www/bin/shell$ clearcache.sh
-bash_nuna0000noezpublish10ezdealno: clearcache.sh: command not found
ezpublish10:~/www/bin/shell$ 

I cant do anything in the admin interface. Cant run clear cache...
Any suggestions what to try?

Looks like your url_alais table is broken, might be faster to just set up the content again on a clean 4.0.1 install then figuring out where you went wrong in the 4.0.0 -> 4.0.1 update.

As for:
> I tried to run the clearcache.sh to be able to se more errors. Also unsucessfull:

clearcace.sh where removed a couple a versions ago, here is how to clear cache:
http://ez.no/doc/ez_publish/techn...eference/scripts/generic/ezcache_php

Also mentioned explicit in the last couple of upgrade docs:
http://ez.no/doc/ez_publish/upgra...4_0/from_4_0_x_to_4_0_y#eztoc98307_5

OK I am also thinking about ding just that. I am unpacking the new 4.01 on my mac. Then updating the distribution files as described. Then I will use FTP and move the 4.01 and replacing the files on the webserver.

Before I start on any thing related to the databse I will use phpmyadmin and use the "import" thing to get the old database back to the mysql databaseserver.

Is this is the right way to do it? Time will show..

Question. Will a copy of EZ from my mac have the right permissions to run on a remote webserver?

> Question. Will a copy of EZ from my mac have the right permissions to run on a remote webserver?

No, permissions are normally not included when transferring over ftp. So take a look at chmod and chown, probably also mentioned somewhere in the docs as well.

OK I am also thinking about ding just that. I am unpacking the new 4.01 on my mac. Then updating the distribution files as described. Then I will use FTP and move the 4.01 and replacing the files on the webserver.

Before I start on any thing related to the databse I will use phpmyadmin and use the "import" thing to get the old database back to the mysql databaseserver.

Is this is the right way to do it? Time will show..

Question. Will a copy of EZ from my mac have the right permissions to run on a remote webserver?

Hi Erland,

3 years after this thread was created I'm trying to update some old ezp 3.10 installation and I'm facing exactly same issue as you did. 

Did you succeed with your upgrade? If yes, do you remember any hints that could help me?

br,

Michal

EDIT:

issue resolved while migrating I didn't update location of database in siteaccess configuration and site was still pointing to the old database

Modified on Wednesday 28 September 2011 10:06:05 pm by Michal Slocinski