Hay Jaxel. Got an error during import of the product. First error I forgot to copy, but it said something about one of the tables not able to be created.
Second import I got this Database Error.
Code:
Database error in vBulletin 3.8.2:
Invalid SQL:
CREATE TABLE addonchat_settings
(
account_id INT UNSIGNED NOT NULL DEFAULT 0,
login_md5pass VARCHAR(32) NOT NULL DEFAULT '',
language VARCHAR(8) NOT NULL DEFAULT 'en',
settings_retrieved TINYINT(1) NOT NULL DEFAULT 0,
login_email VARCHAR(64) NOT NULL DEFAULT '',
edition INT UNSIGNED NOT NULL DEFAULT 0,
modules VARCHAR(128) NOT NULL DEFAULT '',
ras_capable TINYINT(1) NOT NULL DEFAULT 0,
edition_name VARCHAR(128) NOT NULL DEFAULT 'Unknown',
expire_date DATE NOT NULL DEFAULT 0,
ras_enabled TINYINT(1) NOT NULL DEFAULT 0,
ras_url VARCHAR(128) NOT NULL DEFAULT 'http://',
server_name VARCHAR(64) NOT NULL DEFAULT 'client0.addonchat.com',
server_port INT UNSIGNED NOT NULL DEFAULT 8000,
cpanel_login VARCHAR(255) NOT NULL DEFAULT 'http://',
title VARCHAR(48) NOT NULL DEFAULT 'My Chat Room',
account_id_fq VARCHAR(32) NOT NULL DEFAULT 'SC-0',
customer_id_fq VARCHAR(32) NOT NULL DEFAULT 'RC-0',
enable_auto_login TINYINT(1) NOT NULL DEFAULT 1,
allow_unregistered_guests TINYINT(1) NOT NULL DEFAULT 0,
url_exit VARCHAR(128) NOT NULL DEFAULT 'http://',
width INT UNSIGNED DEFAULT 585,
height INT UNSIGNED DEFAULT 400,
width_float INT UNSIGNED DEFAULT 620,
height_float INT UNSIGNED DEFAULT 420,
forum_url VARCHAR(255) NOT NULL DEFAULT 'http://',
ef_profile TINYINT(1) NOT NULL DEFAULT 1,
ef_find_posts TINYINT(1) NOT NULL DEFAULT 1,
ef_email TINYINT(1) NOT NULL DEFAULT 1,
ef_pm TINYINT(1) NOT NULL DEFAULT 1,
ef_add_buddy TINYINT(1) NOT NULL DEFAULT 1,
ef_forum_ignore TINYINT(1) NOT NULL DEFAULT 0,
vb_enable_menu TINYINT(1) NOT NULL DEFAULT 1,
vb_enable_embed TINYINT(1) NOT NULL DEFAULT 1,
vb_enable_popup TINYINT(1) NOT NULL DEFAULT 1,
vb_enable_whos_chatting TINYINT(1) NOT NULL DEFAULT 1,
vb_enable_whos_chatting_main TINYINT(1) NOT NULL DEFAULT 0
)
ENGINE=MyISAM CHARACTER SET utf8;
MySQL Error : Table 'addonchat_settings' already exists
Error Number : 1050
Request Date : Monday, June 1st 2009 @ 02:56:22 AM
Error Date : Monday, June 1st 2009 @ 02:56:22 AM
Script : http://www.cogonline.net/forums/admincp/plugin.php?do=productimport
Referrer : http://www.cogonline.net/forums/admincp/plugin.php?do=productadd
IP Address : XXXXXXXXX
Username : Digital Jedi
Classname : vB_Database
MySQL Version : 5.0.77-community-log
Is it safe to just drop the tables and try importing again?