Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Getting Error in database capabilities #12577

Closed
xopez opened this issue Feb 22, 2018 · 8 comments
Closed

Getting Error in database capabilities #12577

xopez opened this issue Feb 22, 2018 · 8 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@xopez
Copy link

xopez commented Feb 22, 2018

I have a fresh installation of matomo cause I am new to it.
My tracking seems to be working fine, but i got following error in database capabilities section:

LOAD DATA INFILE
Die Benutzung von LOAD DATA INFILE erhöht die Geschwindigkeit des Piwik Archivierungsprozesses erheblich. Um dies für Matomo verfügbar zu machen, setzen Sie bitte eine neuere PHP & MySQL Software ein und stellen Sie sicher, dass der gewählte Datenbankbenutzer das FILE Recht besitzt.
Falls Ihr Matomo Server Websites mit erhöhtem Verkehrsaufkommen (z.B.: > 100.000 Seiten pro Monat) verarbeiten muss empfehlen wir dieses Problem zu beheben.
Fehler: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'option
(option_name,option_value)
VALUES (?,?)' at line 1
Troubleshooting: FAQ on matomo.org

Of cource i searched forums and the given FAQ and did all there. So PHP Safemode is disabled and I don't use open_basedir. I also added local-infile in mysql and mysqld and allowed.
Also allowed access to apparmor with following line:
/var/www/vhosts/mightful-noobs.de/stats.mightful-noobs.de/tmp/assets/** rw,

PHP 7.2.2
Matomo 3.3.0
and MySQL over Plesk with Version 5.7.21-0ubuntu0.16.04.1

and it's all up2date

@fdellwing
Copy link
Contributor

Can you try PHP 7.1? As far as I'm aware of, PHP 7.2 is still not fully supported.

@xopez
Copy link
Author

xopez commented Feb 22, 2018

Same error with PHP 7.1.14 and PHP 7.0.25

@tsteur
Copy link
Member

tsteur commented Feb 22, 2018

Is there any chance you could find out what the full query is that causes the error? (option (option_name,option_value) VALUES (?,?)) ? Are you using any custom or 3rd party plugins?

@tsteur
Copy link
Member

tsteur commented Feb 22, 2018

Actually browsing through the code do you see this in the system check?

@xopez
Copy link
Author

xopez commented Feb 22, 2018

Is there any chance you could find out what the full query is that causes the error? (option (option_name,option_value) VALUES (?,?)) ? Are you using any custom or 3rd party plugins?

Having only Standard Addons, disabled all with "example" in name and Ecommerce.

I had this both addons, too. But disabling them together doesn't change anything

ForceSSL
LoginFailLog

Complete Plugin List

CorePluginsAdmin, CoreAdminHome, CoreHome, WebsiteMeasurable, Diagnostics, CoreVisualizations, Proxy, API, Widgetize, Transitions, LanguagesManager, Actions, Dashboard, MultiSites, Referrers, UserLanguage, DevicesDetection, Goals, SEO, Events, UserCountry, VisitsSummary, VisitFrequency, VisitTime, VisitorInterest, RssWidget, Feedback, Monolog, Login, UsersManager, SitesManager, Installation, CoreUpdater, CoreConsole, ScheduledReports, UserCountryMap, Live, CustomVariables, PrivacyManager, ImageGraph, Annotations, MobileMessaging, Overlay, SegmentEditor, Insights, Morpheus, Contents, BulkTracking, Resolution, DevicePlugins, Heartbeat, Intl, Marketplace, ProfessionalServices, UserId, CustomPiwikJs, DBStats, Provider, ForceSSL, LoginFailLog

@xopez
Copy link
Author

xopez commented Mar 28, 2018

With Matomo 3.4.0 it's still there for me. Same error message and no PHP errors.
PHP-Version: 7.2.3

@xopez
Copy link
Author

xopez commented Mar 28, 2018

Guess I found the file where it stands.
plugins/Diagnostics/Diagnostic/LoadDataInfileCheck.php

At line 40 there stands following:

        $optionTable = Common::prefixTable('option');
        $testOptionNames = array('test_system_check1', 'test_system_check2');

        $loadDataInfile = false;
        $errorMessage = null;
        try {
            $loadDataInfile = Db\BatchInsert::tableInsertBatch(
                $optionTable,
                array('option_name', 'option_value'),
                array(
                    array($testOptionNames[0], '1'),
                    array($testOptionNames[1], '2'),
                ),
                $throwException = true,
                $charset = 'latin1'
            );
        } catch (\Exception $ex) {
            $errorMessage = str_replace("\n", "<br/>", $ex->getMessage());
        }

@mattab
Copy link
Member

mattab commented Feb 13, 2020

Thanks for contributing to this issue. As it has been a few months since the last activity and we believe this is likely not an issue anymore, we will now close this. If that's not the case, please do feel free to either reopen this issue or open a new one. We will gladly take a look again!

@mattab mattab closed this as completed Feb 13, 2020
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Feb 13, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

4 participants