updateviewcount.php wont work

Thursday 31 January 2008 9:55:44 am

You should probably make some modifications to the script to see if what this query returns, and what '$pathIdentificationString'' is:

"SELECT node_id FROM ezcontentobject_tree \n" .
                                         "WHERE path_identification_string='$pathIdentificationString'";

This will give you a clue on how you should tweak SitePrefix[]!

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Thursday 31 January 2008 1:44:27 pm

Ah.. could you post the path_identification_string on that node ? it's probably different.

This might be because of the new url translation system in 3.10 / 4.0, and the update view count script is not updated for it it seems ( as in a bug ).

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Thursday 31 January 2008 2:14:40 pm

Ok, I have created a issue for it:
http://issues.ez.no/IssueView.php?Id=12484&

It will hopefully be fixed in 3.10.1 and 4.0.1. You can try to downcase the url in the mean time in the script code.

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Thursday 31 January 2008 3:55:57 pm

i've done few changes to updateviewcounter.php and it seems works better now.

This is my hack, i hope it can be useful:

line 133
$url = preg_replace( "/\?.*/", "", $url);
<b>$url = strtolower($url);</b>
foreach ( $prefixes as $prefix )

line 222
foreach ( $pathArray as $path )
{
$pathIdentification = $db->escapeString( $path );
<b>$pathIdentification=preg_replace('/-/','_',$pathIdentification);
$pathIdentification=preg_replace('/\./','_',$pathIdentification);
</b>

dunno if is this solve for every1, for me works.

Have a great day
Fabio

Wednesday 04 June 2008 11:52:34 pm

Hello,

I'm a newcomer to the world of Ez Publish.

I'm having a lot of troubles with the updateviewcount.php script and had to do a little modification in the code to make it work.

I just replaced the next lines:

$url = str_replace( "content/view/full/", "", $url );
                        $url = str_replace( "/", "", $url );
                        $url = preg_replace( "/\?(.*)/", "", $url );
                        $nodeIDArray[] = $url;

With these ones:

$pos_in_url = strrpos($url, "/");
						if ($pos_in_url !== false) {							
							$url = substr($url, $pos_in_url+1, strlen($url)-$pos_in_url);
	                        $nodeIDArray[] = $url;
						}

That's because $url was coming with a string like this one: "index.phpeng87". It should come only with the ID, but was coming with index.php and siteaccess.

The script is working fine now, information is being registered in database (ezview_counter table), but I still have the URL problem, described by Fábio Farnesi.

I have applied the patch André R. recommended, and even after that, the bug persists.

The problem is with Virtual URLS. System URLs are being registered correctly in the database.

I don't know what to do, maybe wait for version 4.0.1...