Cannot create Table

[keith]

I received the following error log while attempting to create table. Please see below. I am currently using WordPress 2.0.11 and it was working fine until the database seems to get corrupted.

Can you please suggest how to rectify the issue. If not, is there a way to completely remove Firestats from the SQL Database, e.g. which are field names to remove, and from where.

Hide Error installing tables: Database error: Can't create table './extraris_secr/wp_firestats_hits.frm' (errno: -1)

MySQL Version: 5.0.45-community-log
SQL Query:
CREATE TABLE IF NOT EXISTS wp_firestats_hits ( `id` INTEGER PRIMARY KEY AUTO_INCREMENT COMMENT 'Primary key', `ip_int1` BIGINT UNSIGNED NULL COMMENT 'IP Address left 64bit', `ip_int2` BIGINT UNSIGNED NULL COMMENT 'IP Address right 64bit', `ip` VARCHAR(40) NOT NULL DEFAULT 'unknown' COMMENT 'IP Address of hit source', `timestamp` DATETIME NOT NULL COMMENT 'Hit timestamp', `url_id` INTEGER COMMENT 'Hit URL ID', `referer_id` INTEGER COMMENT 'Referer URL id', `useragent_id` INTEGER COMMENT 'UserAgent ID', `session_id` VARCHAR(30) COMMENT 'Client session ID', `user_id` INTEGER default NULL COMMENT 'User ID in the enclosing system, NULL for unknown user', `country_code` INT(4) default NULL COMMENT 'Country code of IP address or NULL if unknown', `excluded_by_user` TINYINT(1) DEFAULT 0 COMMENT '1 if user explicitly excluded record, 0 otherwise', `excluded_ip` TINYINT(1) DEFAULT 0 COMMENT '1 if the ip is in the excluded ips table, 0 otherwise', `excluded_user` TINYINT(1) DEFAULT 0 COMMENT '1 if the user id is in the excluded users table, 0 otherwise' ) COMMENT 'Hits table' ENGINE=InnoDB

[omry]

Hi Keith,

This is a problem with your mysql server, which have an unspecified problem creating the table.

I am not sure what the actual error is, the error code is not very helpful. it could be a permissions issue, out of space issue, bad hard drive or anything else.

in any case - contact your system administrator about this. I don't think it's a FireStats problem.

let me know how it goes.

[Keith]

Hi omry,

I've submitted a ticket to Bluehost, which will take some time to look into the matter. It sis definitely not an out-of-space issue. I am suspecting if there is anything got to do with plugins conflict.

[omry]

I don't think it's caused by a plugin conflict. just wait for a response from bluehost and lets see what they say.

[Keith]

Hi omry, below is the reply that I received from Bluehost. It suggests a re-installation procedure. Can you advice how to complete remove any related tables from the Database?

Thank you for contacting Bluehost support regarding your MySQL table creation problem. I have checked your database and there are no tables for firestats. Although the files are there, I suspect that you may need to reinstall it in order for it to add the required tables to the database.

[omry]

if the files are there, but does not appear inside the database, it's a database consistency problem.

since the database does not have the tables, you can't uninstall them using any standard SQL tools, and since the files are there, you can't create the tables again.

so, no - you can't reinstall FireStats until this issue is resolved.

Ask bluehost to do whatever it takes to make sure you can create the firestats tables (wp_firestats_hits for example).

this will probably require deleting the firetats frm files, but I am not a mysql expert.

[omry]

Not a FireStats bug.