big database error, out of the blue

  • Resolved anonymized-14293447

    (@anonymized-14293447)


    7 years, 2 months ago

    this plugin doesn’t seem to be supported at all, however I suddenly have this error:

    Errore sul database di WordPress: [Unknown column 's.view_count' in 'field list']
SELECT <code>s</code>.<code>s_id</code> AS <code>stats_id</code> , <code>s</code>.<code>view_count</code> AS <code>view_count</code> FROM <code>wp_sw_statistics</code> AS <code>s</code> INNER JOIN <code>wp_posts</code> AS <code>p</code> ON <code>p</code>.<code>ID</code> = <code>s</code>.<code>post_id</code> WHERE <code>p</code>.<code>post_status</code> IN ('publish', 'private') AND <code>p</code>.<code>post_type</code> IN ("job","deals","portfolio","events","blog") AND <code>s</code>.<code>post_id</code> = 23598 AND <code>s</code>.<code>statistic_date</code> = '2017-09-26';

Errore sul database di WordPress: [Unknown column 'post_id' in 'field list']
INSERT INTO <code>wp_sw_statistics</code>(<code>post_id</code>,<code>view_count</code>,<code>statistic_date</code>) VALUES (23598,1,'2017-09-26')

Errore sul database di WordPress: [Unknown column 'ip' in 'field list']
INSERT INTO <code>wp_sw_ips</code> (<code>s_id</code>, <code>ip</code>) VALUES ((SELECT MAX(<code>s_id</code>) FROM <code>wp_sw_statistics</code>), '95.252.44.218')

    Am I gonna get any help?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor gVectors Team

    (@gvectors-team)

    Hi arsenalemusica,
    This is an updating issue. We see problems in table structure. If these tables are empty, please drop them using Hosting Service cPanel > phpMyAdmin database manager:

    • wp_sw_statistics
    • wp_sw_ips

    Then deactivate the plugin then activate it.

    If they are not empty please register at gVectors Team support forum for deeper support: https://gvectors.com/forum/

    Thread Starter anonymized-14293447

    (@anonymized-14293447)

    yep, tables where empty. Problems is solved following your instructions, and new tables are filled again. Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘big database error, out of the blue’ is closed to new replies.