I have attempted to install the program twice now and each time I get the same results:
CREATE TABLE IF NOT EXISTS `smp_members` ( `id` int(11) NOT NULL AUTO_INCREMENT, `firstname` varchar(255), `lastname` varchar(255), `referred_by` varchar(255) NOT NULL DEFAULT 'admin', `email` varchar(255), `username` varchar(255), `password` varchar(32), `paypal_email` varchar(255), `postal` varchar(255), `city` varchar(255), `state` varchar(255), `zip` varchar(255), `country` varchar(255), `phone` varchar(255), `ssn` varchar(255), `ip` varchar(255) , `date_joined` date NOT NULL DEFAULT '0000-00-00' , `status` NOT NULL int(11), `show_oto` int(11) NOT NULL DEFAULT '1', `bought_oto` int(11) NOT NULL DEFAULT '0', `last_login` int(11), `mailing` int(11), `jv_status` char(4) NOT NULL DEFAULT '0', `randomstring` varchar(100), `activate` int(11) NOT NULL DEFAULT '1', `comments` LONGTEXT NOT NULL default '', `total_points` int(11) NOT NULL, `photo` varchar(255) NOT NULL, `sell_dd` int(11) NOT NULL, PRIMARY KEY (`id`) ) 1064 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 'NOT NULL int(11), `show_oto` int(11) NOT NULL DEFAULT '1', `bought_oto` in' at line 19
The installation is completed, but basically when I access the system, everything is incomplete.
Please assist.