|
icasby
|
November 8, 2016 at 1:07 am
Hi guys,
I have some error whenever I went to EVENT-CHECK In from registrations admin page.
Error says :
An EE_Error exception was thrown! code: EEM_Base – _do_wpdb_query – 1952
“WPDB Error: “Can’t create/write to file ‘/tmp/#sql_82b_0.MYI’ (Errcode: 28)””
click to view backtrace and class/method details
/nfs/c08/h06/mnt/153150/domains/icasby.com/html/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php ( line no: 1952 )
Help!!!
I don’t want to lose the data 🙁
|
|
icasby
|
November 8, 2016 at 1:25 am
I added some numbers and I got some errors :
WordPress database error: [Can’t create/write to file ‘/tmp/#sql_82b_0.MYI’ (Errcode: 28)]
SHOW FULL COLUMNS FROM wp_options
WordPress database error: [Table ‘wp_esp_question_group’ already exists]
CREATE TABLE wp_esp_question_group ( QSG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, QSG_name varchar(255) NOT NULL, QSG_identifier varchar(100) NOT NULL, QSG_desc text NULL, QSG_order tinyint(2) unsigned NOT NULL DEFAULT 0, QSG_show_group_name tinyint(1) NOT NULL, QSG_show_group_desc tinyint(1) NOT NULL, QSG_system tinyint(2) NULL, QSG_deleted tinyint(1) unsigned NOT NULL DEFAULT 0, QSG_wp_user bigint(20) unsigned NULL, PRIMARY KEY (QSG_ID), UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier), KEY QSG_order (QSG_order) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
🙁
|
|
Tony
|
November 8, 2016 at 9:10 am
Hi there,
Its an issue with your host, either the /tmp directory is full or mysql does not have access to it.
I’d recommend contacting your host and asking them to fix this error:
“WPDB Error: “Can’t create/write to file ‘/tmp/#sql_82b_0.MYI’ (Errcode: 28)””
The additional details shown is the SQL command that is attempting to be ran, the above is the problem.
I don’t want to lose the data
Do you have a database backup? If not create one before moving further just to be safe.
|
