Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - prevmedone

Pages: [1]
1
Simple Member Pro / Incomplete Installation of Version 2.11 (fixed)
« on: February 22, 2009, 09:28:14 PM »
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.

Pages: [1]