New Affiliate Plugin not displaying stats or tracking clicks

I've just swapped over from using the wordpress affiliate plugin in /mu-plugins to a network activate in /plugins.

All my previous stats are gone and clicks aren't being tracked anymore.

Is the new plugin using different tables or are there new tables to add for multi-db?

  • georgef
    • The Incredible Code Injector

    hmm, pretty messy. Here is some of it:

    [Sat Jan 29 21:57:36 2011] [error] [client 66.249.71.36] PHP Fatal error: Allowed memory size of 402653184 bytes exhausted (tried to allocate 75846 bytes) in /home/thatmlmb/public_html/wp-includes/functions.php on line 235
    [Sat Jan 29 21:56:58 2011] [error] [client 67.195.115.58] PHP Fatal error: Allowed memory size of 402653184 bytes exhausted (tried to allocate 75846 bytes) in /home/thatmlmb/public_html/wp-includes/functions.php on line 235, referer: http://www.homebusinessblogs.com/page/2/
    [Sat Jan 29 21:54:56 2011] [error] [client 67.195.115.58] PHP Fatal error: Allowed memory size of 402653184 bytes exhausted (tried to allocate 104 bytes) in /home/thatmlmb/public_html/wp-includes/plugin.php on line 160
    [Sat Jan 29 21:51:57 2011] [error] [client 67.195.115.58] PHP Fatal error: Cannot use object of type stdClass as array in /home/thatmlmb/public_html/wp-content/plugins/MyRP/myrp-auxtions.php on line 25
    [Sat Jan 29 21:45:06 2011] [error] [client 77.88.29.247] PHP Parse error: syntax error, unexpected '|' in /home/thatmlmb/public_html/wp-content/themes/light-10/archive.php on line 14
    [Sat Jan 29 21:43:15 2011] [error] [client 74.110.103.86] PHP Fatal error: Call to a member function get() on a non-object in /home/thatmlmb/public_html/wp-includes/cache.php on line 93, referer: http://just-ask-kim.com/fan-page-fbml-tabs-easy/
    [Sat Jan 29 21:39:50 2011] [error] [client 66.249.71.36] PHP Fatal error: Allowed memory size of 402653184 bytes exhausted (tried to allocate 75846 bytes) in /home/thatmlmb/public_html/wp-includes/functions.php on line 235
    [Sat Jan 29 21:39:45 2011] [error] [client 188.92.75.82] PHP Warning: Invalid argument supplied for foreach() in /home/thatmlmb/public_html/wp-content/plugins/wpmu-dev-seo/wds-files/wds-autolinks/wds-autolinks.php on line 287
    [Sat Jan 29 21:38:44 2011] [error] [client 67.195.115.58] PHP Fatal error: Cannot use object of type stdClass as array in /home/thatmlmb/public_html/wp-content/plugins/MyRP/myrp-auxtions.php on line 25
    [Sat Jan 29 21:38:00 2011] [error] [client 67.195.115.58] PHP Fatal error: Cannot use object of type stdClass as array in /home/thatmlmb/public_html/wp-content/plugins/MyRP/myrp-auxtions.php on line 25
    [Sat Jan 29 21:28:41 2011] [error] [client 77.88.29.247] PHP Parse error: syntax error, unexpected '|' in /home/thatmlmb/public_html/wp-content/themes/light-10/archive.php on line 14
    [Sat Jan 29 21:26:27 2011] [error] [client 67.195.115.58] PHP Fatal error: Cannot use object of type stdClass as array in /home/thatmlmb/public_html/wp-content/plugins/MyRP/myrp-auxtions.php on line 25
    [Sat Jan 29 21:22:42 2011] [error] [client 98.245.7.32] PHP Fatal error: Call to a member function get() on a non-object in /home/thatmlmb/public_html/wp-includes/cache.php on line 93, referer: http://www.meetbethallen.com/the-importance-of-balance-for-truly-radiant-health/
    [Sat Jan 29 21:20:54 2011] [error] [client 67.195.115.58] PHP Fatal error: Cannot use object of type stdClass as array in /home/thatmlmb/public_html/wp-content/plugins/MyRP/myrp-auxtions.php on line 25
    [Sat Jan 29 21:19:38 2011] [error] [client 209.85.224.90] PHP Fatal error: Allowed memory size of 402653184 bytes exhausted (tried to allocate 75846 bytes) in /home/thatmlmb/public_html/wp-includes/functions.php on line 235
    [Sat Jan 29 21:12:13 2011] [error] [client 77.88.29.247] PHP Parse error: syntax error, unexpected '|' in /home/thatmlmb/public_html/wp-content/themes/light-10/archive.php on line 14

  • drmike
    • DEV MAN’s Mascot

    Dang, you;re using a lot of memory in php. What do you have the memory limit set to? That's like 400megs. That's very high. :slight_frown:

    You have to set memory limits in a couple of different places now with php. Please give this thread a read:

    https://premium.wpmudev.org/forums/topic/antisplog-out-of-memory-allocated-27000832-tried-to-allocate-197540-bytes-in-homepublic_htmlwp-includesfunctionsphp-on-line-251

    Please see if that helps,
    -drmike

  • Barry
    • DEV MAN’s Mascot

    Hmm - for some reason it's stopped using those, or created some new ones and carried on - that is most strange. You've got a multi-db set up haven't you? So hunting for any new tables isn't simple?

    Can you look in the information_schema database of your mysql install and look in the tables table (note this could be huge - so might be worth writing a quick query rather than trying to view).
    Look for a table_name like '%affiliate%' and see how many it turns up - the database they are in will be shown in the table_schema field.

  • georgef
    • The Incredible Code Injector

    Yes I have multidb setup.

    All my databases are on a different server now and it has caused some other weird problems.

    Well there's new data in there so they must still be working. the latest entry now is 2011-01-31 18:58:36

    Now this is weird and I hope this hasnt got something to do with my host moving db's to a new server, but the tables table is empty.

    Here's a screenshot.

  • Barry
    • DEV MAN’s Mascot

    It may be a permissions thing rather than an empty table - I think you system would stop pretty sharply if that table was actually empty.

    I there is new data going into the table, then the plugin is using that one - how much historic is there? Anything pre-the update?

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.