Title: Database Error
Last modified: August 27, 2025

---

# Database Error

 *  Resolved [abulu](https://wordpress.org/support/users/abulu/)
 * (@abulu)
 * [9 months, 1 week ago](https://wordpress.org/support/topic/database-error-423/)
 * [22-Aug-2025 14:45:41 UTC] WordPress database error Column ‘bounce’ in field 
   list is ambiguous for query SELECT COUNT(DISTINCT CASE WHEN bounce = 0 THEN statistics.
   uid END) as visitors, COALESCE( SUM( CASE WHEN bounce = 0 THEN 1 ELSE 0 END ),
   0) as pageviews, COUNT( DISTINCT CASE WHEN bounce = 0 THEN statistics.session_id
   END ) as sessions, COALESCE( COUNT(DISTINCT CASE WHEN bounce = 0 AND statistics.
   first_time_visit = 1 THEN statistics.uid END),0) as first_time_visitors, COALESCE(
   AVG( CASE WHEN bounce = 0 THEN statistics.time_on_page END ), 0 ) as avg_time_on_page,
   ROUND(SUM(session_bounces.bounce) / COUNT(DISTINCT statistics.session_id) * 100,
   2) as bounce_rate FROM wpaa_burst_statistics AS statistics LEFT JOIN (
 *     ```wp-block-code
                                             SELECT                                         session_id,                                        CASE WHEN COUNT(*) = 1 THEN 1 ELSE 0 END AS bounce                                      FROM wpaa_burst_statistics                                      WHERE time > 1755723601 AND time < 1755810000                                      GROUP BY session_id                                    ) AS session_bounces ON statistics.session_id = session_bounces.session_id  WHERE statistics.time > 1755723601 AND statistics.time < 1755810000      made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Burst\Admin\App\App->get_data, Burst\Admin\Statistics\Statistics->get_compare_data, Burst\Admin\Statistics\Statistics->get_base_data, Burst\Admin\Statistics\Statistics->execute_data_query, Burst\Admin\Statistics\Statistics->get_data 
       ```
   

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

 *  Plugin Author [Rogier Lankhorst](https://wordpress.org/support/users/rogierlankhorst/)
 * (@rogierlankhorst)
 * [9 months, 1 week ago](https://wordpress.org/support/topic/database-error-423/#post-18615133)
 * Hi [@abulu](https://wordpress.org/support/users/abulu/),
 * Thanks for reporting the issue. Which version of Burst are you using?
 *  Plugin Author [Rogier Lankhorst](https://wordpress.org/support/users/rogierlankhorst/)
 * (@rogierlankhorst)
 * [9 months, 1 week ago](https://wordpress.org/support/topic/database-error-423/#post-18615611)
 * Assuming you are on the current version, I have a fix for that ready. It will
   be shipped with version 2.2.5, as it can’t make 2.2.4 anymore.
 * Thanks for reporting the issue.

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

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

 * ![](https://ps.w.org/burst-statistics/assets/icon-256x256.png?rev=2672964)
 * [Burst Statistics – Simple WordPress Analytics (Google Analytics Alternative)](https://wordpress.org/plugins/burst-statistics/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/burst-statistics/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/burst-statistics/)
 * [Active Topics](https://wordpress.org/support/plugin/burst-statistics/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/burst-statistics/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/burst-statistics/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Rogier Lankhorst](https://wordpress.org/support/users/rogierlankhorst/)
 * Last activity: [9 months, 1 week ago](https://wordpress.org/support/topic/database-error-423/#post-18615611)
 * Status: resolved