Title: Database Error: Unknown table fields Last modified: March 29, 2022 --- # Database Error: Unknown table fields * Resolved [wabetainfo](https://wordpress.org/support/users/wabetainfo/) * (@wabetainfo) * [4 years, 2 months ago](https://wordpress.org/support/topic/database-error-unknown-table-fields-2/) * 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/](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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-error-unknown-table-fields-2%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 6 replies - 1 through 6 (of 6 total) * Plugin Support [WPQuads Support](https://wordpress.org/support/users/wpquadssupport/) * (@wpquadssupport) * [4 years, 2 months ago](https://wordpress.org/support/topic/database-error-unknown-table-fields-2/#post-15513358) * Can you please share the URL of your website once? * Thread Starter [wabetainfo](https://wordpress.org/support/users/wabetainfo/) * (@wabetainfo) * [4 years, 2 months ago](https://wordpress.org/support/topic/database-error-unknown-table-fields-2/#post-15514208) * Hi, the URL was already in the first message: [https://wabetainfo.com](https://wabetainfo.com). Thanks for your answer! * Plugin Support [WPQuads Support](https://wordpress.org/support/users/wpquadssupport/) * (@wpquadssupport) * [4 years, 2 months ago](https://wordpress.org/support/topic/database-error-unknown-table-fields-2/#post-15522932) * Thanks for providing the URL, we will get back to you shortly. * Plugin Support [WPQuads Support](https://wordpress.org/support/users/wpquadssupport/) * (@wpquadssupport) * [4 years, 1 month ago](https://wordpress.org/support/topic/database-error-unknown-table-fields-2/#post-15546949) * 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](https://github.com/wpquads/quick-adsense-reloaded/issues/517) * Thread Starter [wabetainfo](https://wordpress.org/support/users/wabetainfo/) * (@wabetainfo) * [4 years, 1 month ago](https://wordpress.org/support/topic/database-error-unknown-table-fields-2/#post-15563512) * 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](https://wordpress.org/support/users/wabetainfo/). * Plugin Support [WPQuads Support](https://wordpress.org/support/users/wpquadssupport/) * (@wpquadssupport) * [4 years, 1 month ago](https://wordpress.org/support/topic/database-error-unknown-table-fields-2/#post-15564043) * 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. * ![](https://ps.w.org/quick-adsense-reloaded/assets/icon-256x256.png?rev=2369641) * [Quads Ads Manager for Google AdSense](https://wordpress.org/plugins/quick-adsense-reloaded/) * [Frequently Asked Questions](https://wordpress.org/plugins/quick-adsense-reloaded/#faq) * [Support Threads](https://wordpress.org/support/plugin/quick-adsense-reloaded/) * [Active Topics](https://wordpress.org/support/plugin/quick-adsense-reloaded/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/quick-adsense-reloaded/unresolved/) * [Reviews](https://wordpress.org/support/plugin/quick-adsense-reloaded/reviews/) * 6 replies * 2 participants * Last reply from: [WPQuads Support](https://wordpress.org/support/users/wpquadssupport/) * Last activity: [4 years, 1 month ago](https://wordpress.org/support/topic/database-error-unknown-table-fields-2/#post-15564043) * Status: resolved