• Resolved wabetainfo

    (@wabetainfo)


    Hi!

    My host had to put my website in “forced cache” mode because your plugin experiences an issue. There are unknown table fields.

    Error: WordPress database error Unknown column ‘referrer’ in ‘where clause’
    Reason for error: Missing filed

    You can read here some further details here:

    [Tue Mar 29 00:59:59.993754 2022] [fcgid:warn] [pid 7727] [client 197.229.132.55:0] mod_fcgid: stderr: WordPress database error Unknown column ‘referrer’ in ‘where clause’ for query SELECT id FROM avwp_quads_stats WHERE ad_id = 20 AND ad_device_name = 0 AND ad_thetime = 1648512000 AND referrer = 0 AND ip_address = 197 AND URL = 0 AND browser = 0 made by do_action(‘wp_ajax_nopriv_quads_insert_ad_impression’), WP_Hook->do_action, WP_Hook->apply_filters, quads_admin_analytics->quads_insert_ad_impression, quads_admin_analytics->quads_insert_impression, referer: https://wabetainfo.com/whatsapp-is-enabling-the-global-voice-note-player-on-android/

    +—————-+——————–+——+—–+———+—————-+
    | Field | Type | Null | Key | Default | Extra |
    +—————-+——————–+——+—–+———+—————-+
    | id | bigint(9) unsigned | NO | PRI | NULL | auto_increment |
    | ad_id | int(50) unsigned | NO | MUL | 0 | |
    | ad_thetime | int(15) unsigned | NO | MUL | 0 | |
    | ad_clicks | int(15) unsigned | NO | | 0 | |
    | ad_impressions | int(15) unsigned | NO | | 0 | |
    | ad_device_name | varchar(20) | NO | | | |
    +—————-+——————–+——+—–+———+—————-+
    Can you please let me know if you will work on a fix for a future update of the plugin? Thanks!

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support WPQuads Support

    (@wpquadssupport)

    Can you please share the URL of your website once?

    Thread Starter wabetainfo

    (@wabetainfo)

    Hi, the URL was already in the first message: https://wabetainfo.com. Thanks for your answer!

    Plugin Support WPQuads Support

    (@wpquadssupport)

    Thanks for providing the URL, we will get back to you shortly.

    Plugin Support WPQuads Support

    (@wpquadssupport)

    Sorry for the delay in getting back. For this, We have raised a GitHub ticket in our repository. We will work on it and fix it in our update and get back to you soon!

    Please follow this, For reference: https://github.com/wpquads/quick-adsense-reloaded/issues/517

    Thread Starter wabetainfo

    (@wabetainfo)

    Hi,

    I managed to address the issue by adding missing fields. I’ve used these queries:

    ALTER TABLE avwp_quads_stats ADD ip_address varchar(20) NOT NULL default ”;
    ALTER TABLE avwp_quads_stats ADD URL varchar(255) NOT NULL default ”;
    ALTER TABLE avwp_quads_stats ADD browser varchar(20) NOT NULL default ”;

    ALTER TABLE avwp_quads_stats ADD referrer varchar(255) NOT NULL default ”;

    Finally, the issue is fixed. Thanks for your availability!

    • This reply was modified 4 years, 1 month ago by wabetainfo.
    Plugin Support WPQuads Support

    (@wpquadssupport)

    Glad to hearing it. If you have any other queries or issues, Please create a new topic.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Database Error: Unknown table fields’ is closed to new replies.