Title: Database Error
Last modified: August 30, 2016

---

# Database Error

 *  [rebiscoco](https://wordpress.org/support/users/rebiscoco/)
 * (@rebiscoco)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/database-error-193/)
 * Hi,
 * I’ve been experiencing this error:
 * PHP message: WordPress database error Unknown column ‘sa.ad_swf_fallback’ in ‘
   field list’ for query
    (SELECT [@pid](https://wordpress.org/support/users/pid/):
   = sp.id AS pid, 0 AS aid, sp.name, sp.patch_source AS code_mode, @code_before:
   = sp.code_before AS code_before, @code_after := sp.code_after AS code_after, 
   @ad_size := IF(sp.place_size = “custom”, CONCAT(CAST(sp.place_custom_width AS
   CHAR), “x”, CAST(sp.place_custom_height AS CHAR)), sp.place_size) AS ad_size,
   sp.patch_code AS ad_code, sp.patch_img AS ad_img, “” AS ad_alt, 0 AS ad_no, sp.
   patch_link AS ad_target, 0 AS ad_swf, “” AS ad_swf_flashvars, “” AS ad_swf_params,“”
   AS ad_swf_attributes, “” AS ad_swf_fallback, sp.patch_adserver AS ad_adserver,
   sp.patch_dfp AS ad_dfp, 0 AS count_clicks, 0 AS code_type, IF((sp.patch_source
   = 1 AND sp.patch_adserver) OR sp.patch_source = 2, -1, 1) AS ad_cycle, [@aca](https://wordpress.org/support/users/aca/):
   = IFNULL((SELECT AVG(sa.ad_weight_hits*10/(sa.ad_weight*1000)) FROM wp_9_sam_ads
   sa WHERE sa.pid = [@pid](https://wordpress.org/support/users/pid/) AND sa.trash
   IS NOT TRUE AND (IF(sa.ad_user… PHP message: WordPress database error Unknown
   column ‘sa.ad_swf_fallback’ in ‘field list’ for query
 * Any idea how I can fix this? Or is anyone having the same error. You can only
   see the error inside logs though.
 * Thanks
 * [https://wordpress.org/plugins/simple-ads-manager/](https://wordpress.org/plugins/simple-ads-manager/)

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

 *  Plugin Author [minimus](https://wordpress.org/support/users/minimus/)
 * (@minimus)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/database-error-193/#post-6476912)
 * What version you use?
 *  Thread Starter [rebiscoco](https://wordpress.org/support/users/rebiscoco/)
 * (@rebiscoco)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/database-error-193/#post-6476924)
 * Hi minimus,
 * 1. WordPress 4.3
    2. SAM 2.9.6.121
 * Please help me fix this please.
 * Thanks,
 *  Plugin Author [minimus](https://wordpress.org/support/users/minimus/)
 * (@minimus)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/database-error-193/#post-6476930)
 * Deactivate and activate SAM plugin… The plugin tries to update the database table
   only when you install or activate it.

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

The topic ‘Database Error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/simple-ads-manager_73687f.svg)
 * [Simple Ads Manager](https://wordpress.org/plugins/simple-ads-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/simple-ads-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/simple-ads-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/simple-ads-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/simple-ads-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/simple-ads-manager/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 3 replies
 * 2 participants
 * Last reply from: [minimus](https://wordpress.org/support/users/minimus/)
 * Last activity: [10 years, 8 months ago](https://wordpress.org/support/topic/database-error-193/#post-6476930)
 * Status: not resolved