search

eventespresso / eea-recurring-events-manager

EE4 Recurring Events Manager add-on for Event Espresso 4
GNU General Public License v3.0
0 stars 1 forks source link

"WPDB Error: "Unknown column 'Datetime.RCR_ID' in 'field list'"" #32

Closed nicolad closed 4 years ago

nicolad commented 4 years ago

After I've pulled latest changes from REM and core and upgraded the DB, I've got few errors, even if I've reinstalled the plugin few times:

Peek 2020-10-09 13-49

An EE_Error exception was thrown!   code: EEM_Base - _do_wpdb_query - 2321
"WPDB Error: "Unknown column 'Datetime.RCR_ID' in 'field list'""
click to view backtrace and class/method details
/home/vadim/Public/EE/event-espresso-core/core/db_models/EEM_Base.model.php   ( line no: 2321 )

image

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''RCR_ID' INT UNSIGNED NULL DEFAULT NULL AFTER 'DTT_deleted', ' at line 2]

ALTER TABLE wp_esp_datetime ADD 'RCR_ID' INT UNSIGNED NULL DEFAULT NULL AFTER 'DTT_deleted', ADD INDEX 'RCR_ID' ('RCR_ID');

image