Title: database table sam_errors is running full – plugin simple-ad-manager
Last modified: August 21, 2016

---

# database table sam_errors is running full – plugin simple-ad-manager

 *  Resolved [wombelt](https://wordpress.org/support/users/wombelt/)
 * (@wombelt)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-table-sam_errors-is-running-full-plugin-simple-ad-manager/)
 * Hoi!
 * My Database Table has actually a Size of 31 GB !!!
    There are 9,811,208 Entrys!
   I recognized that a little bit late – Hope not to late.
 * What is stored in this Table?
    Are they only Error Messages? Can I easily delete
   all entrys?
 * In the Database Cells are Select Statements like this:
 *     ```
       SELECT
                         gz_sam_places.id,
                         gz_sam_places.name,
                         gz_sam_places.description,
                         gz_sam_places.code_before,
                         gz_sam_places.code_after,
                         gz_sam_places.place_size,
                         gz_sam_places.place_custom_width,
                         gz_sam_places.place_custom_height,
                         gz_sam_places.patch_img,
                         gz_sam_places.patch_link,
                         gz_sam_places.patch_code,
                         gz_sam_places.patch_adserver,
                         gz_sam_places.patch_dfp,
                         gz_sam_places.patch_source,
                         gz_sam_places.trash,
                         (SELECT COUNT(*) FROM gz_sam_ads WHERE gz_sam_ads.pid = gz_sam_places.id AND gz_sam_ads.trash IS FALSE) AS ad_count,
                         (SELECT COUNT(*) FROM gz_sam_ads WHERE gz_sam_ads.pid = gz_sam_places.id AND gz_sam_ads.trash IS FALSE AND (IF(gz_sam_ads.ad_users = 0, TRUE, (gz_sam_ads.ad_users_unreg = 1))) AND ((gz_sam_ads.view_type = 1) OR (gz_sam_ads.view_type = 0 AND (gz_sam_ads.view_pages+0 & 11)) OR (gz_sam_ads.view_type = 2 AND FIND_IN_SET(9165, gz_sam_ads.view_id))) AND (gz_sam_ads.ad_cats = 0)  AND (gz_sam_ads.ad_authors = 0)   AND IF(gz_sam_ads.x_id, NOT FIND_IN_SET(9165, gz_sam_ads.x_view_id), TRUE)     AND IF(gz_sam_ads.ad_schedule, CURDATE() BETWEEN gz_sam_ads.ad_start_date AND gz_sam_ads.ad_end_date, TRUE) AND IF(gz_sam_ads.limit_hits, gz_sam_ads.hits_limit > gz_sam_ads.ad_hits, TRUE) AND IF(gz_sam_ads.limit_clicks, gz_sam_ads.clicks_limit > gz_sam_ads.ad_clicks, TRUE) AND (gz_sam_ads.ad_weight > 0)) AS ad_logic_count,
                         (SELECT COUNT(*) FROM gz_sam_ads WHERE gz_sam_ads.pid = gz_sam_places.id AND gz_sam_ads.trash IS FALSE AND (IF(gz_sam_ads.ad_users = 0, TRUE, (gz_sam_ads.ad_users_unreg = 1))) AND ((gz_sam_ads.view_type = 1) OR (gz_sam_ads.view_type = 0 AND (gz_sam_ads.view_pages+0 & 11)) OR (gz_sam_ads.view_type = 2 AND FIND_IN_SET(9165, gz_sam_ads.view_id))) AND (gz_sam_ads.ad_cats = 0)  AND (gz_sam_ads.ad_authors = 0)   AND IF(gz_sam_ads.x_id, NOT FIND_IN_SET(9165, gz_sam_ads.x_view_id), TRUE)     AND IF(gz_sam_ads.ad_schedule, CURDATE() BETWEEN gz_sam_ads.ad_start_date AND gz_sam_ads.ad_end_date, TRUE) AND IF(gz_sam_ads.limit_hits, gz_sam_ads.hits_limit > gz_sam_ads.ad_hits, TRUE) AND IF(gz_sam_ads.limit_clicks, gz_sam_ads.clicks_limit > gz_sam_ads.ad_clicks, TRUE)  AND IF(gz_sam_ads.ad_weight > 0, (gz_sam_ads.ad_weight_hits*10/(gz_sam_ads.ad_weight*1000)) < 1, FALSE)) AS ad_full_count
                       FROM gz_sam_places
                       WHERE gz_sam_places.id = 5 AND gz_sam_places.trash IS FALSE;
       ```
   
 * .
 * [http://wordpress.org/plugins/simple-ads-manager/](http://wordpress.org/plugins/simple-ads-manager/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [minimus](https://wordpress.org/support/users/minimus/)
 * (@minimus)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/database-table-sam_errors-is-running-full-plugin-simple-ad-manager/#post-4288895)
 * Only error messages. You can clear table…

Viewing 1 replies (of 1 total)

The topic ‘database table sam_errors is running full – plugin simple-ad-manager’
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/)

 * 1 reply
 * 2 participants
 * Last reply from: [minimus](https://wordpress.org/support/users/minimus/)
 * Last activity: [12 years, 6 months ago](https://wordpress.org/support/topic/database-table-sam_errors-is-running-full-plugin-simple-ad-manager/#post-4288895)
 * Status: resolved