Hello. I am new to this forum and new to the script. I installed everything and in the installer it works fine, but one problem. It keeps saying "Missing SQL schema" and I have uploaded the osticket-rc5.sql and it went in my database just fine. But, when I try and import the v16rc5.sql it gives me the below error:
Error
SQL query:
ALTER TABLE `%TABLE_PREFIX%email` ADD `userid` VARCHAR( 125 ) NOT NULL AFTER `name` , ADD `userpass` VARCHAR( 125 ) NOT NULL AFTER `userid`, ADD `mail_active` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `userpass` , ADD `mail_host` VARCHAR( 125 ) NOT NULL AFTER `mail_active` , ADD `mail_protocol` ENUM( 'POP', 'IMAP' ) NOT NULL AFTER `mail_host` , ADD `mail_encryption` ENUM( 'NONE', 'SSL' ) NOT NULL AFTER `mail_protocol` , ADD `mail_port` INT( 6 ) NULL AFTER `mail_encryption` , ADD `mail_fetchfreq` TINYINT( 3 ) NOT NULL DEFAULT '5' AFTER `mail_port` , ADD `mail_fetchmax` TINYINT( 4 ) NOT NULL DEFAULT '30' AFTER `mail_fetchfreq` , ADD `mail_delete` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `mail_fetchmax` , ADD `mail_errors` TINYINT( 3 ) NOT NULL DEFAULT '0' AFTER `mail_delete` , ADD `mail_lasterror` DATETIME NULL AFTER `mail_errors` , ADD `mail_lastfetch` DATETIME NULL AFTER `mail_lasterror` , ADD `smtp_active` TINYINT( 1 ) NOT NULL AFTER `mail_lastfetch` , ADD `smtp_host` VARCHAR( 125 ) NOT
MySQL said: Documentation
#1060 - Duplicate column name 'userid'
Some1 PLEASE help me. Idk what to do. Thanks.
P.S. I am using hostgator's Phpmyadmin version 5.1.30, Also I am using 1.6 version of this script. Thanks.
