search

Alexandre-io / wordpress_exporter

Prometheus exporter for WordPress / WooCommerce
MIT License
10 stars 3 forks source link

Table 'bedrocksample.wp_woocommerce_sessions' doesn't exist #6

Open runningman84 opened 2 years ago

runningman84 commented 2 years ago

The exporter doesn't work with a vanilla wordpress install.

time="2022-04-28T12:32:03Z" level=fatal msg="Error 1146: Table 'bedrocksample.wp_woocommerce_sessions' doesn't exist"

These tables are available by default:

MySQL [bedrocksample]> show tables;
+-----------------------------------+
| Tables_in_bedrocksample           |
+-----------------------------------+
| wp_as3cf_items                    |
| wp_check_email_log                |
| wp_commentmeta                    |
| wp_comments                       |
| wp_ewwwio_images                  |
| wp_ewwwio_queue                   |
| wp_ilj_linkindex                  |
| wp_links                          |
| wp_options                        |
| wp_oses_attachments               |
| wp_oses_clicks                    |
| wp_oses_email_attachments         |
| wp_oses_emails                    |
| wp_oses_failures                  |
| wp_oses_jobs                      |
| wp_postmeta                       |
| wp_posts                          |
| wp_term_relationships             |
| wp_term_taxonomy                  |
| wp_termmeta                       |
| wp_terms                          |
| wp_usermeta                       |
| wp_users                          |
| wp_wsal_metadata                  |
| wp_wsal_occurrences               |
| wp_wsal_options                   |
+-----------------------------------+
37 rows in set (0.002 sec)
runningman84 commented 2 years ago

This is my fix https://github.com/arvatoaws-labs/wordpress_exporter/commit/fedecde1b4a0393325feae656165714f2eff2d16

usmangt commented 8 months ago

I also got hit by same error message while installing a clean install without using any plugins/addons.

@Alexandre-io can you please fix this.