Database Error: Unknown table fields
-
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 filedYou 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]
-
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!
- The topic ‘Database Error: Unknown table fields’ is closed to new replies.
