top exits and top referrers

[joho]

What would be a reason these two plug-ins would stop collecting data? This is using 0.7.1. I copied one set of tables to the same database, but with a different prefix; and then configured another installation of S9Y to use those tables. But having done that, I get no new entries written to these two tables (in the new installation).. regardless of how I try to force the issue. There are no error messages in any logs.. I can't quite figure out what's going on.

[garvinhicking]

Both tables need their _suppress counterpart to work properly. Did you copy the table structure completely with the right key infrastructure?

Regards,
Garvin

[joho]

I copied everything that I could find. I also "removed" the plug-ins from the new installation and added them back again, assuming I might have missed something I figured I'd let S9Y do it right.

[garvinhicking]

Maybe by copying it some indices or so were copied wrong, or with different/wrong charsets of your MySQL server...

Removing and re-adding the plugins doesn't re-add their tables because those are Core s9y-Tables. Maybe you can make a fresh DB install somehow?

Otherwise I'll try to investigate the issue next week!

Regards,
Garvin

[joho]

I'm now using 0.8-beta2 on that site, and the problem remains.

I have checked every database table against what 0.8 wants/needs, and everything is there; including indices.

You say that both these plugins need their "_suppress"-counterparts.. I'm not sure what that means. I only have one *_suppress table in the S9Y database, this is true both for the one that _does_ work and the one that _doesn't_ work.

[garvinhicking]

I'm honestly sorry and much clueless about this functionality. I never quite got the referer/exit handling routines figured out on my own.

The only clue I've left: Have you checked if maybe the _suppress or exits/referrer table is corrupted on the installation where it doesn't work? Maybe you can try a CHECK TABLES?

Regards,
Garvin

[joho]

The tables are empty (well, the _suppress table is not empty, but the other two are); so I'm not sure what to check

I've removed these plug-ins for now, but a better solution would be to get them working.

[SILU]

I have another question concerning referrers/exits: i want to modify the displayed title of this plugins - but there are no such files in the plugin-directory - where to find them ? Thx.

SILU

[garvinhicking]

The internal plugins are inside include/plugins_internal.inc.php

Regards,
Garvin

[SILU]

I want to modify the titles in this way: .:. ichbinegoist .:. - but i always get sql-errors....how can i to that without errors ?

[garvinhicking]

Hi Silu

If you show me how you modified the plugin, I can tell you what you did wrong

Regards,
Garvin

[SILU]

I just searched in the file for "exits" and changed it like that:

$propbag->add('name', TOP_EXITS); >>before change
$propbag->add('name', .:. TOP EXITS .:.); >> after change

I also tried some other variations, but i always got SQL-Errors.

[garvinhicking]

SILU, you should take a look at PHP Syntax first.

The errors you were getting are not related to SQL but to PHP. Parse Errors always come from PHP.

You'd need to change it to this:

Code: Select all

 $propbag->add('name', '.:. ' . TOP EXITS . ' .:.');

Regards,
Garvin

[SILU]

Ok, thx i solved it...but between TOP and EXITS you have to write an "_" then i got no error...but the signs ".:." are not displayed....i entered in the file this code:

$propbag->add('name', '.:. ' . TOP_EXITS . ' .:.');

How to modify that the ".:." will be displayed ?Thx

[garvinhicking]

Oh, you're right. I just copy+pasted your code!

Regards,
Garvin