<html><head><style type='text/css'>body { font-family: 'Arial'; font-size: 10pt; color: #000000}</style></head><body>It was suggested that I run this script as the mysql root user, but received the same error. ERROR 1064 (42000) at line 3866: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'increment KEY, logdate TIMESTAMP, logtext TEXT ) DEFAULT CHARACTER S' at line 1 Here are the contents of the create_tables.sql script. -- AvantFAX 2.2.6 MySQL structure DROP DATABASE IF EXISTS avantfax; -- CREATE DATABASE avantfax; CREATE DATABASE avantfax DEFAULT CHARACTER SET utf8; GRANT ALL PRIVILEGES ON avantfax.* TO 'avantfax'@'localhost' IDENTIFIED BY 'd58fe49';^@ FLUSH PRIVILEGES; USE avantfax; -- Distribution Lists CREATE TABLE IF NOT EXISTS DistroList ( dl_id INT auto_increment KEY, listname VARCHAR(255) NOT NULL, listdata TEXT, lastmod_date TIMESTAMP, lastmod_user INT ) DEFAULT CHARACTER SET utf8; -- MODEMS CREATE TABLE IF NOT EXISTS Modems ( devid INT auto_increment KEY, device VARCHAR(10) NOT NULL, alias VARCHAR(40), contact VARCHAR(100) ) DEFAULT CHARACTER SET utf8; -- USER INFORMATION -- password is md5 hash and always 32 chars CREATE TABLE IF NOT EXISTS UserAccount ( uid INT auto_increment KEY, name VARCHAR(40), username VARCHAR(40) NOT NULL, password VARCHAR(32) NOT NULL, email VARCHAR(99) NOT NULL, email_sig TEXT, from_company VARCHAR(150), from_location VARCHAR(150), from_voicenumber VARCHAR(150), from_faxnumber VARCHAR(150), superuser BOOL DEFAULT FALSE, can_del BOOL DEFAULT FALSE, last_mod TIMESTAMP, last_login TIMESTAMP, last_ip VARCHAR(15), language VARCHAR(2), modemdevs VARCHAR(99), didrouting VARCHAR(255), faxcats VARCHAR(99), pwdexpire DATE, pwdcycle INT DEFAULT 0, pwd_reuse BOOL DEFAULT FALSE, wasreset BOOL DEFAULT FALSE, acc_enabled BOOL DEFAULT TRUE, deleted BOOL DEFAULT FALSE ) DEFAULT CHARACTER SET utf8; CREATE TABLE IF NOT EXISTS AdminAccount ( aid INT auto_increment KEY, name VARCHAR(40), username VARCHAR(15) NOT NULL, password VARCHAR(32) NOT NULL, email VARCHAR(99) NOT NULL, last_mod TIMESTAMP, last_login TIMESTAMP, last_ip VARCHAR(15), language VARCHAR(2), wasreset BOOL DEFAULT FALSE, pwdexpire DATE, pwdcycle INT DEFAULT 0 ) DEFAULT CHARACTER SET utf8; -- store hashes of passwords already used for a user CREATE TABLE IF NOT EXISTS UserPasswords ( upid INT auto_increment KEY, uid INT NOT NULL, pwdhash VARCHAR (32) NOT NULL, adminpwd BOOL DEFAULT FALSE ) DEFAULT CHARACTER SET utf8; CREATE TABLE IF NOT EXISTS UserRubrica ( urid INT auto_increment KEY, userid INT NOT NULL, name VARCHAR(100), email VARCHAR(100) NOT NULL ) DEFAULT CHARACTER SET utf8; -- RUBRICA CREATE TABLE IF NOT EXISTS Rubrica ( cid INT auto_increment KEY, company VARCHAR(255) NOT NULL, email VARCHAR(100) ) DEFAULT CHARACTER SET utf8; CREATE TABLE IF NOT EXISTS FaxNum ( faxnumid INT auto_increment KEY, companyid INT NOT NULL, faxnum VARCHAR(20) NOT NULL, email VARCHAR(100), description VARCHAR(30), to_person VARCHAR(150), to_location VARCHAR(150), to_voicenumber VARCHAR(150), faxcatid INT, faxfrom INT DEFAULT 0, faxto INT DEFAULT 0 ) DEFAULT CHARACTER SET utf8; -- DID Routing CREATE TABLE IF NOT EXISTS DIDRoute ( didr_id INT auto_increment KEY, routecode VARCHAR(10) NOT NULL, alias VARCHAR(40), contact VARCHAR(100) ) DEFAULT CHARACTER SET utf8; -- ARCHIVE -- companyid for outgoing faxes CREATE TABLE IF NOT EXISTS FaxArchive ( fid INT auto_increment KEY, faxnumid INT NOT NULL, companyid INT, faxpath VARCHAR(255) NOT NULL, pages INT, faxcatid INT, didr_id INT, description BLOB, lastoperation TIMESTAMP, lastmoduser INT(10), lastmoddate TIMESTAMP, archstamp TIMESTAMP, modemdev VARCHAR(10), userid INT, origfaxnum VARCHAR(20), inbox BOOL DEFAULT TRUE ) DEFAULT CHARACTER SET utf8; CREATE TABLE IF NOT EXISTS FaxCategory ( catid INT auto_increment KEY, name VARCHAR(30) ) DEFAULT CHARACTER SET utf8; -- AvantFAX System Log CREATE TABLE IF NOT EXISTS SysLog ( syslogid INT auto_increment KEY, logdate TIMESTAMP, logtext TEXT ) DEFAULT CHARACTER SET utf8; INSERT INTO AdminAccount (name, username, password, wasreset, email) VALUES ('AvantFax Admin', 'afadmin', '5f4dcc3b5aa765d61d8327deb882cf99', TRUE, 'YOUR_EMAIL_ADDRESS'); INSERT INTO UserPasswords (uid, pwdhash, adminpwd) VALUES ('0', '5f4dcc3b5aa765d61d8327deb882cf99', TRUE); INSERT INTO Rubrica SET company = 'XXXXXXX'; INSERT INTO FaxNum SET companyid = 1, faxnum = 'XXXXXXX'; SHOW TABLES; </body></html>