• Resolved Brandon Dove

    (@brandondove)


    Hi,

    I’m receiving the following errors in the response to the post to the tracker located at wp-content/plugins/matomo/app/matomo.php. I found the seemingly related post on the Matomo forums (https://forum.matomo.org/t/upgrading-from-3-to-4-call-to-undefined-method-piwik-tracker-request-getdayssincelastvisit/39892) that recommended doing a fresh install. I deleted all of the plugin files and reinstalled them from www.remarpro.com. This did not seem to make any difference.

    Do you have any further advice or is this an actual bug?

    ——-

    An error occurred
    Call to undefined method Piwik\Tracker\Request::getDaysSinceLastVisit()

    Go Back | Go to Matomo
    Stack trace

    #0 /nas/content/live/sitename/wp-content/plugins/matomo/app/core/Tracker/Visit.php(499): Piwik\Plugins\VisitorInterest\Columns\VisitsByDaysSinceLastVisit->onNewVisit(Object(Piwik\Tracker\Request), Object(Piwik\Tracker\Visitor), Object(Piwik\Tracker\ActionPageview))
    #1 /nas/content/live/sitename//wp-content/plugins/matomo/app/core/Tracker/Visit.php(302): Piwik\Tracker\Visit->triggerHookOnDimensions(Array, ‘onNewVisit’)
    #2 /nas/content/live/sitename//wp-content/plugins/matomo/app/core/Tracker/Visit.php(209): Piwik\Tracker\Visit->handleNewVisit(NULL)
    #3 /nas/content/live/sitename//wp-content/plugins/matomo/app/core/Tracker.php(160): Piwik\Tracker\Visit->handle()
    #4 /nas/content/live/sitename//wp-content/plugins/matomo/app/core/Tracker/Handler.php(55): Piwik\Tracker->trackRequest(Object(Piwik\Tracker\Request))
    #5 /nas/content/live/sitename//wp-content/plugins/matomo/app/core/Tracker.php(140): Piwik\Tracker\Handler->process(Object(Piwik\Tracker), Object(Piwik\Tracker\RequestSet))
    #6 /nas/content/live/sitename//wp-content/plugins/matomo/app/core/Tracker.php(115): Piwik\Tracker->track(Object(Piwik\Tracker\Handler), Object(Piwik\Tracker\RequestSet))
    #7 /nas/content/live/sitename//wp-content/plugins/matomo/app/piwik.php(73): Piwik\Tracker->main(Object(Piwik\Tracker\Handler), Object(Piwik\Tracker\RequestSet))
    #8 /nas/content/live/sitename//wp-content/plugins/matomo/app/matomo.php(13): include(‘/nas/content/li…’)
    #9 {main}

    ——-

    Below you will find the system report exported from the plugin.

    
    # Matomo
    
    * Matomo Plugin Version: 4.1.2
    * Config exists and is writable.: Yes ("$ABSPATH/wp-content/uploads/matomo/config/config.ini.php" )
    * JS Tracker exists and is writable.: Yes ("$ABSPATH/wp-content/uploads/matomo/matomo.js" )
    * Plugin directories: Yes ([{"pluginsPathAbsolute":"$ABSPATH\/wp-content\/plugins\/matomo\/plugins","webrootDirRelativeToMatomo":"..\/"}])
    * Tmp directory writable: Yes ($ABSPATH/wp-content/cache/matomo)
    * Matomo Version: 4.1.1
    * Matomo Blog idSite: 1
    * Matomo Install Version: 1.3.1 (Install date: 2020-10-21 18:35:32)
    * Upgrades outstanding: No
    * Upgrade in progress: No
    
    ## Endpoints
    
    * Matomo JavaScript Tracker URL:  ($site_url/wp-content/uploads/matomo/matomo.js)
    * Matomo JavaScript Tracker - WP Rest API:  ($site_url/wp-json/matomo/v1/hit/)
    * Matomo HTTP Tracking API:  ($site_url/wp-content/plugins/matomo/app/matomo.php)
    * Matomo HTTP Tracking API - WP Rest API:  ($site_url/wp-json/matomo/v1/hit/)
    
    ## Crons
    
    * Server time: 2021-01-20 21:24:46
    * Blog time: 2021-01-20 17:24:46 (Below dates are shown in blog timezone)
    * Sync users & sites: Next run: 2021-01-21 16:56:37 (23 hours 31 min) ( Last started: 2021-01-20 16:56:38 (-28 min 8s). Last ended: 2021-01-20 16:56:38 (-28 min 8s). Interval: daily)
    * Archive: Next run: 2021-01-20 17:56:37 (31 min 51s) ( Last started: 2021-01-20 16:56:38 (-28 min 8s). Last ended: 2021-01-20 16:56:53 (-27 min 53s). Interval: hourly)
    * Update GeoIP DB: Next run: 2021-02-19 16:56:37 (29 days 23 hours) ( Last started: 2021-01-20 16:56:53 (-27 min 53s). Last ended: 2021-01-20 16:56:54 (-27 min 52s). Interval: matomo_monthly)
    
    ## Mandatory checks
    
    * PHP version >= : ok 
    * PDO extension: ok 
    * PDO\MYSQL extension: ok 
    * MYSQLI extension: ok 
    * Other required extensions: ok 
    * Required functions: ok 
    * Required PHP configuration (php.ini): ok 
    * Directories with write access: ok 
    * Directories with write access for Tag Manager: ok 
    
    ## Optional checks
    
    * Tracker status: ok 
    * Memory limit: ok 
    * Time zone: ok 
    * Open URL: ok 
    * PageSpeed disabled: ok 
    * GD > 2.x + Freetype (graphics): ok 
    * Other extensions: ok 
    * Warning Other functions: warning  (shell_exec You need to enable this built-in function. set_time_limit mail parse_ini_file glob gzopen md5_file )
    * Filesystem: ok 
    * Last Successful Archiving Completion: ok 
    * Database abilities: ok 
    * Warning Max Packet Size: warning  (It is recommended to configure a 'max_allowed_packet' size in your MySQL database of at least 64MB. Configured is currently 16MB. )
    * Geolocation: ok 
    * Update over HTTPS: ok 
    * Writable JavaScript Tracker ("/matomo.js"): ok 
    * Supports Async Archiving: No
    * Location provider ID: geoip2php
    * Location provider available: Yes
    * Location provider working: Yes
    * Warning Proxy header: HTTP_CF_CONNECTING_IP (A proxy header is set which means you maybe need to configure a proxy header in the Advanced settings to make location reporting work. If the location in your reports is detected correctly, you can ignore this warning. Learn more: https://matomo.org/faq/wordpress/how-do-i-fix-the-proxy-header-warning-in-the-matomo-for-wordpress-system-report/)
    
    ## Matomo Settings
    
    * Track mode: default
    * Track codeposition: footer
    * Track api endpoint: default
    * Track js endpoint: default
    * Version history: 4.1.2, 4.1.1, 1.3.1
    * Core version: 4.1.1
    * Last tracking settings update: 1611176557
    * Last settings update: 1611176557
    * Track noscript: Yes
    * Track ecommerce: No
    * Track search: Yes
    * Track 404: Yes
    * Track user id: email
    * Track datacfasync: Yes
    
    ## Logs
    
    * None: 
    
    # WordPress
    
    * Home URL: $site_url
    * Site URL: $site_url
    * WordPress Version: 5.6
    * Number of blogs: 1
    * Multisite Enabled: No
    * Network Enabled: No
    * WP_DEBUG: No
    * WP_DEBUG_DISPLAY: Yes
    * WP_DEBUG_LOG: No
    * DISABLE_WP_CRON: No
    * FORCE_SSL_ADMIN: Yes
    * WP_CACHE: Yes
    * CONCATENATE_SCRIPTS: -
    * COMPRESS_SCRIPTS: -
    * COMPRESS_CSS: -
    * ENFORCE_GZIP: -
    * WP_LOCAL_DEV: -
    * DIEONDBERROR: -
    * WPLANG: 
    * ALTERNATE_WP_CRON: -
    * WP_CRON_LOCK_TIMEOUT: 60
    * WP_DISABLE_FATAL_ERROR_HANDLER: -
    * MATOMO_SUPPORT_ASYNC_ARCHIVING: -
    * MATOMO_TRIGGER_BROWSER_ARCHIVING: -
    * MATOMO_ENABLE_TAG_MANAGER: -
    * MATOMO_SUPPRESS_DB_ERRORS: -
    * MATOMO_ENABLE_AUTO_UPGRADE: -
    * MATOMO_DEBUG: -
    * MATOMO_SAFE_MODE: -
    * MATOMO_GLOBAL_UPLOAD_DIR: -
    * MATOMO_LOGIN_REDIRECT: -
    * Permalink Structure: /%postname%/
    * Possibly uses symlink: No
    * Compatible content directory: Yes
    
    # WordPress Plugins
    
    ## MU Plugins
    
    * Force Strong Passwords - WPE Edition: 1.6.4
    * WP Engine Seamless Login Plugin: 1.5.5
    * WP Engine Security Auditor: 1.0.9
    * WP Engine System: 4.1.0
    
    ## Plugins
    
    * Admin Menu Editor: 1.9.8
    * Advanced Custom Fields PRO: 5.9.4
    * Avada Builder: 3.2.1
    * Avada Core: 5.2.1
    * CM Tooltip Glossary Pro+: 3.9.12
    * Contact Form 7: 5.3.2
    * Elegant Elements for Fusion Builder: 3.3.2.3
    * Lorem Ipsum Block: 2.1.0
    * MailPoet 3 (New): 3.58.0
    * Matomo Analytics - Ethical Stats. Powerful Insights.: 4.1.2
    * Pexels: Free Stock Photos: 1.2.2
    * Quick Page/Post Redirect Plugin: 5.2.2
    * Relevanssi: 4.10.2
    * Slider Revolution: 6.3.3
    * Sticky Buttons: 2.0.1
    * Trending/Popular Post Slider and Widget: 1.4
    * WordPress Importer: 0.7
    * Yoast Duplicate Post: 4.0.2
    * Active Plugins: 18 (TooltipProPlus admin-menu-editor advanced-custom-fields-pro contact-form-7 duplicate-post elegant-elements-fusion-builder fusion-builder fusion-core lorem-ipsum-block mailpoet matomo quick-pagepost-redirect-plugin relevanssi revslider sticky-buttons wordpress-importer wp-pexels-free-stock-photos wp-trending-post-slider-and-widget)
    * Theme: Avada (Avada)
    
    # Server
    
    * Server Info: Apache
    * PHP OS: Linux
    * PHP Version: 7.3.24-3+ubuntu18.04.1+deb.sury.org+1
    * PHP SAPI: apache2handler
    * Timezone: UTC
    * WP timezone: -04:00
    * Locale: en_US
    * User Locale: en_US
    * Memory Limit: 1G (At least 128MB recommended. Depending on your traffic 256MB or more may be needed.)
    * WP Memory Limit: 1G
    * WP Max Memory Limit: 512M
    * Timezone version: 0.system
    * Time: 1611177887
    * Max Execution Time: 3600
    * Max Post Size: 100M
    * Max Upload Size: 52428800
    * Max Input Vars: 10000
    * Disabled PHP functions: Yes (apache_child_terminate,apache_get_modules,apache_get_version,apache_getenv,apache_note,apache_setenv,disk_free_space,disk_total_space,diskfreespace,dl,exec,fastcgi_finish_request,link,opcache_compile_file,opcache_get_configuration,opcache_invalidate,opcache_is_script_cached,opcache_reset,passthru,pclose,pcntl_exec,popen,posix_getpid,posix_getppid,posix_getpwuid,posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid,posix_setpgid,posix_setsid,posix_setuid,posix_uname,proc_close,proc_get_status,proc_nice,proc_open,proc_terminate,shell_exec,show_source,symlink,system)
    * zlib.output_compression is off: Yes
    * Curl Version: 7.58.0, OpenSSL/1.1.1g
    * Suhosin installed: No
    
    # Database
    
    * MySQL Version: 5.7.31
    * Mysqli Connect: Yes
    * Force MySQL over Mysqli: No
    * DB Prefix: wp_
    * DB CHARSET: utf8
    * DB COLLATE: utf8_unicode_ci
    * SHOW ERRORS: No
    * SUPPRESS ERRORS: No
    * Uses Socket: No
    * Uses IPv6: No
    * Matomo tables found: 126
    * Matomo users found: 9
    * Matomo sites found: 1
    * Required permissions: OK
    
    # Browser
    
    * Browser:  (Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:84.0) Gecko/20100101 Firefox/84.0)
    * Language: en-us,en
    
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Thomas

    (@tsteur)

    Hi @brandondove

    Sorry about the trouble. It seems when updating the plugin, some old files weren’t removed that should have been removed. Are you updating the plugin manually or are you using the WordPress plugin updater in the WordPress Admin UI?

    Basically, this can be likely fixed eg by removing the following file:

    wp-content/plugins/matomo/app/plugins/VisitorInterest/Columns/VisitsByDaysSinceLastVisit.php

    You might also want to check if other ones need to be removed like

    
    wp-content/plugins/matomo/app/plugins/DevicePlugins/Columns/PluginDirector.php
    wp-content/plugins/matomo/app/plugins/DevicePlugins/Columns/PluginGears.php
    

    Do those files exist in your installation? And if so, can you try to remove them?

    The information might be still cached and you might need to go to “WP Admin -> Matomo Analytics -> Diagnostics -> Troubleshooting” and click on the “clear cache” button but I think it might not be needed.

    Thread Starter Brandon Dove

    (@brandondove)

    @tsteur, thanks for the fast feedback, it’s truly appreciated. All three of those files were present in the folder in the production environment, but not in my local dev environment.

    We’re hosted on WP Engine and use git deployments there. Because I had a similar problem with files not clearing previously, I deleted the entire Matomo plugin folder in my local dev environment and committed that change. I then added a fresh plugin folder from www.remarpro.com locally and committed that change. I then deployed the site to our production environment. I can’t explain why the files still existed in production.

    I have removed the three files you indicated and then cleared the cache.

    I’m now getting a different error in the POST matomo.php.

    ——-
    An error occurred

    [1054] Unknown column ‘interaction_position’ in ‘field list’
    Backtrace:

    #0 /nas/content/live/sitename/wp-content/plugins/matomo/classes/WpMatomo/Db/WordPressTracker.php(176): Piwik\Tracker\Db\WordPress->after_execute_query(Object(wpdb))
    #1 /nas/content/live/sitename/wp-content/plugins/matomo/app/core/Tracker/Model.php(31): Piwik\Tracker\Db\WordPress->query(‘INSERT INTO wp_…’, Array)
    #2 /nas/content/live/sitename/wp-content/plugins/matomo/app/core/Tracker/Action.php(426): Piwik\Tracker\Model->createAction(Array)
    #3 /nas/content/live/sitename/wp-content/plugins/matomo/app/plugins/Actions/Tracker/ActionsRequestProcessor.php(91): Piwik\Tracker\Action->record(Object(Piwik\Tracker\Visitor), ’22’, ’21’)
    #4 /nas/content/live/sitename/wp-content/plugins/matomo/app/core/Tracker/Visit.php(218): Piwik\Plugins\Actions\Tracker\ActionsRequestProcessor->recordLogs(Object(Piwik\Tracker\Visit\VisitProperties), Object(Piwik\Tracker\Request))
    #5 /nas/content/live/sitename/wp-content/plugins/matomo/app/core/Tracker.php(160): Piwik\Tracker\Visit->handle()
    #6 /nas/content/live/sitename/wp-content/plugins/matomo/app/core/Tracker/Handler.php(55): Piwik\Tracker->trackRequest(Object(Piwik\Tracker\Request))
    #7 /nas/content/live/sitename/wp-content/plugins/matomo/app/core/Tracker.php(140): Piwik\Tracker\Handler->process(Object(Piwik\Tracker), Object(Piwik\Tracker\RequestSet))
    #8 /nas/content/live/sitename/wp-content/plugins/matomo/app/core/Tracker.php(115): Piwik\Tracker->track(Object(Piwik\Tracker\Handler), Object(Piwik\Tracker\RequestSet))
    #9 /nas/content/live/sitename/wp-content/plugins/matomo/app/piwik.php(73): Piwik\Tracker->main(Object(Piwik\Tracker\Handler), Object(Piwik\Tracker\RequestSet))
    #10 /nas/content/live/sitename/wp-content/plugins/matomo/app/matomo.php(13): include(‘/nas/content/li…’)
    #11 {main}
    ——-

    Plugin Author Thomas

    (@tsteur)

    Hi @brandondove

    sorry there seems to be another file that needs to be removed in

    
    wp-content/plugins/matomo/app/plugins/Actions/Columns/InteractionPosition.php
    

    I’m hoping this is the last file that needs to be removed. I looked through the code and couldn’t find any other ones but it’s no guarantee. Be great to remove the file and test it again. Thanks ??

    Thread Starter Brandon Dove

    (@brandondove)

    @tsteur I removed that file and cleared the cache again (just for good measure). That seems to have fixed the issue! Thanks for your wonderful and prompt support, you saved the day!

    Plugin Author Thomas

    (@tsteur)

    Glad it works now @brandondove ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘> 4.1.1 PHP Error in tracking script’ is closed to new replies.