Support

Home Forums Event Espresso Premium Database Error during Check in

Database Error during Check in

Posted: November 8, 2016 at 1:07 am


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

  • Support Staff

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.

The support post ‘Database Error during Check in’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  Tony 3 years ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!