Unknown coulm ‘1’ in the ‘field list’

  • Resolved matheusferreira

    (@matheusferreira)


    7 months, 2 weeks ago

    HI. I discovered this plugin and I just installed it and loved everything from the design to the funcionalities. But since i’ve installed the plugin I’m not able to see post listing in any report page.

    Looked into my error log and found that it seems to have a problem with the column 1.

    I’m right about to have the PRO Version, but would be nice to solve it first. Thank you.

    PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘1’ in ‘field list’ in /var/www/***/html/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php:319
    Stack trace: 0 /var/www/***/html/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(319): PDO->prepare() 1 /var/www/***/html/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(587): IAWPSCOPED\Illuminate\Database\Connection->IAWPSCOPED\Illuminate\Database{closure}() 2 /var/www/***/html/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(561): IAWPSCOPED\Illuminate\Database\Connection->runQueryCallback() 3 /var/www/***/html/wp-content/plugins/independent-analytics/vendor/illuminate/database/Connection.php(323): IAWPSCOPED\Illuminate\Database\Connection->run() 4 /var/ww” while reading response header from upstream, client: 162.158.63.89, server: ***, request: “POST /wp-admin/admin-ajax.php HTTP/1.1”, upstream: “fastcgi://unix:/run/php/php7.4-fpm.sock:”, host: “***”, referrer: “https://***/wp-admin/admin.php?page=independent-analytics”

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Ben Sibley

    (@bensibley)

    Thanks for using Independent Analytics!

    I’m sorry to hear about this error. It sounds like something could have gone wrong with the initial installation. Could you try visiting the Analytics > Settings menu and using the Reset Analytics option there? This will rebuild the tables from scratch.

    Please let me know if this resolves the error, and if not, we can try something else.

    Thread Starter matheusferreira

    (@matheusferreira)

    Hi, Ben, thank for your quick answer.

    I tried to reset the analytics and also tried to deactivate the plugin removing all data, without success. The same error is still occurring for me. I even disabled my Web App Firewal from Wordfence and it still happening.

    I’m using WordPress 6.5.2, Ubuntu 22 .04 Nginx 1.18.0 and PHP 7.4

    Don’t know if there’s anything else that I can share with you to help.

    Thank you.

    Plugin Author Ben Sibley

    (@bensibley)

    Got it, thanks for trying that out.

    Could you reach out to us at [email protected]? To debug further, we may have to discuss some sensitive site details that shouldn’t be posted here.

    Thread Starter matheusferreira

    (@matheusferreira)

    Hi, Ben, I appreciate your availability to help me with this case, but I found a solution. I don’t know if it could be useful for you to improve the plugin, but I’ll share it in a case of any other user could have the same issues I had.

    The problem was with the “ANSI_QUOTES” SQL Mode that was active as default in my managed DB. I’m not a expert in MySQL to know if there’s a huge problem removing it, but I searched here and it’s not a default for MySQL 8, just in my server, so I disabled it.

    Plugin Author Ben Sibley

    (@bensibley)

    Thanks so much for sharing the solution here! That’s helpful to know for future cases.

    Let me know if anything else comes up and I’ll be happy to help.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Unknown coulm ‘1’ in the ‘field list’’ is closed to new replies.