|
#11
|
|||
|
|||
Field 'passhint' doesn't have a default value
|
#12
|
||||
|
||||
wow Who the hell made this dam table?
try this one now PHP Code:
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#13
|
|||
|
|||
Incorrect integer value: '' for column 'country' at row 1
and here is the users table users_table.php |
#14
|
||||
|
||||
drop your user table and try this one
Code:
CREATE TABLE IF NOT EXISTS `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `old_password` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `passhash` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `secret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', `email` varchar(80) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `status` enum('pending','confirmed') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'pending', `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_catchup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `editsecret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', `privacy` enum('normal','strong') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'normal', `stylesheet` int(10) DEFAULT '1', `info` text CHARACTER SET latin1 COLLATE latin1_general_ci, `acceptpms` enum('yes','friends','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `ip` varchar(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `class` tinyint(2) unsigned NOT NULL DEFAULT '1', `avatar` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0', `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0', `title` varchar(60) CHARACTER SET latin1 COLLATE latin1_general_ci default NULL, `country` int(10) NOT NULL DEFAULT '0', `notifs` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `modcomment` text CHARACTER SET latin1 COLLATE latin1_general_ci default NULL, `enabled` enum('yes','no') NOT NULL DEFAULT 'yes', `disable_reason` text default NULL, `imunity` enum('yes','no') NOT NULL DEFAULT 'no', `avatars` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `donor` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `warned` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `warneduntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `torrentsperpage` int(3) unsigned NOT NULL DEFAULT '0', `topicsperpage` int(3) unsigned NOT NULL DEFAULT '0', `postsperpage` int(3) unsigned NOT NULL DEFAULT '0', `deletepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `savepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `parked` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `announce` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `passkey` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `last_browse` int(11) NOT NULL DEFAULT '0', `last_browsex` int(11) NOT NULL DEFAULT '0', `last_browsem` int(11) NOT NULL DEFAULT '0', `fader` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `fadecolor` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'FF0000', `support` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `supportfor` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `supportlang` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `invited_by` int(10) NOT NULL DEFAULT '0', `invitees` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `invites` int(1) NOT NULL DEFAULT '0', `gender` enum('Male','Female','N/A') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N/A', `invitedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `view_adult` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_music` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_adult_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_music_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musiclo_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musicvi_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musicpks_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `advertisename` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `signatures` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `signature` varchar(225) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `uploadpos` enum('yes','no') NOT NULL DEFAULT 'no', `downloadpos` enum('yes','no') NOT NULL DEFAULT 'yes', `forumpost` enum('yes','no') NOT NULL DEFAULT 'yes', `chatpost` enum('yes','no') NOT NULL DEFAULT 'no', `chatdisable` enum('yes','no') NOT NULL DEFAULT 'no', `donated` decimal(8,2) NOT NULL DEFAULT '0.00', `last_pm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_comment` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_post` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `forum_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_staffmsg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `timezone` smallint(3) NOT NULL DEFAULT '120', `dst` tinyint(2) NOT NULL DEFAULT '0', `commentpm` enum('yes','no') NOT NULL DEFAULT 'yes', `staff_chat_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `groups` int(10) unsigned NOT NULL DEFAULT '0', `rangclass` int(10) unsigned NOT NULL DEFAULT '0', `zodiac` int(10) unsigned NOT NULL DEFAULT '0', `donoruntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `total_donated` decimal(8,2) NOT NULL DEFAULT '0.00', `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `leechwarn` enum('yes','no') NOT NULL DEFAULT 'no', `timeswarned` int(10) NOT NULL DEFAULT '0', `seedbonus` decimal(5,1) NOT NULL DEFAULT '0.0', `bonuscomment` text NOT NULL DEFAULT '', `vip_added` enum('yes','no') NOT NULL DEFAULT 'no', `vip_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `smile_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `parola` varchar(40) NOT NULL DEFAULT '', `passhint` int(10) unsigned NOT NULL, `hintanswer` varchar(40) NOT NULL DEFAULT '', `upped` enum('yes','no') NOT NULL DEFAULT 'no', `lastup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `upwarn` enum('yes','no') NOT NULL DEFAULT 'no', `hit_run_total` int(9) DEFAULT '0', `sendmailnotif` enum('yes','no') NOT NULL DEFAULT 'no', `mod_added` enum('yes','no') NOT NULL DEFAULT 'no', `mod_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `trial` enum('yes','no') NOT NULL DEFAULT 'no', `bjwins` int(10) NOT NULL DEFAULT '0', `bjlosses` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), KEY `status_added` (`status`,`added`), KEY `ip` (`ip`), KEY `uploaded` (`uploaded`), KEY `downloaded` (`downloaded`), KEY `country` (`country`), KEY `last_access` (`last_access`), KEY `warned` (`warned`), KEY `passkey` (`passkey`), KEY `id` (`id`,`username`,`old_password`,`passhash`,`secret`), KEY `stylesheet` (`stylesheet`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=453 ;
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#15
|
|||
|
|||
#1101 - BLOB/TEXT column 'bonuscomment' can't have a default value
|
#16
|
||||
|
||||
Code:
CREATE TABLE IF NOT EXISTS `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `old_password` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `passhash` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `secret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', `email` varchar(80) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `status` enum('pending','confirmed') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'pending', `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_catchup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `editsecret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', `privacy` enum('normal','strong') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'normal', `stylesheet` int(10) DEFAULT '1', `info` text CHARACTER SET latin1 COLLATE latin1_general_ci, `acceptpms` enum('yes','friends','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `ip` varchar(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `class` tinyint(2) unsigned NOT NULL DEFAULT '1', `avatar` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0', `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0', `title` varchar(60) CHARACTER SET latin1 COLLATE latin1_general_ci default NULL, `country` int(10) NOT NULL DEFAULT '0', `notifs` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `modcomment` text CHARACTER SET latin1 COLLATE latin1_general_ci default NULL, `enabled` enum('yes','no') NOT NULL DEFAULT 'yes', `disable_reason` text default NULL, `imunity` enum('yes','no') NOT NULL DEFAULT 'no', `avatars` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `donor` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `warned` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `warneduntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `torrentsperpage` int(3) unsigned NOT NULL DEFAULT '0', `topicsperpage` int(3) unsigned NOT NULL DEFAULT '0', `postsperpage` int(3) unsigned NOT NULL DEFAULT '0', `deletepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `savepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `parked` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `announce` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `passkey` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `last_browse` int(11) NOT NULL DEFAULT '0', `last_browsex` int(11) NOT NULL DEFAULT '0', `last_browsem` int(11) NOT NULL DEFAULT '0', `fader` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `fadecolor` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'FF0000', `support` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `supportfor` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `supportlang` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `invited_by` int(10) NOT NULL DEFAULT '0', `invitees` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `invites` int(1) NOT NULL DEFAULT '0', `gender` enum('Male','Female','N/A') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N/A', `invitedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `view_adult` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_music` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_adult_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_music_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musiclo_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musicvi_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musicpks_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `advertisename` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `signatures` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `signature` varchar(225) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `uploadpos` enum('yes','no') NOT NULL DEFAULT 'no', `downloadpos` enum('yes','no') NOT NULL DEFAULT 'yes', `forumpost` enum('yes','no') NOT NULL DEFAULT 'yes', `chatpost` enum('yes','no') NOT NULL DEFAULT 'no', `chatdisable` enum('yes','no') NOT NULL DEFAULT 'no', `donated` decimal(8,2) NOT NULL DEFAULT '0.00', `last_pm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_comment` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_post` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `forum_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_staffmsg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `timezone` smallint(3) NOT NULL DEFAULT '120', `dst` tinyint(2) NOT NULL DEFAULT '0', `commentpm` enum('yes','no') NOT NULL DEFAULT 'yes', `staff_chat_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `groups` int(10) unsigned NOT NULL DEFAULT '0', `rangclass` int(10) unsigned NOT NULL DEFAULT '0', `zodiac` int(10) unsigned NOT NULL DEFAULT '0', `donoruntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `total_donated` decimal(8,2) NOT NULL DEFAULT '0.00', `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `leechwarn` enum('yes','no') NOT NULL DEFAULT 'no', `timeswarned` int(10) NOT NULL DEFAULT '0', `seedbonus` decimal(5,1) NOT NULL DEFAULT '0.0', `bonuscomment` longtext character set utf8 collate utf8_bin NULL, `vip_added` enum('yes','no') NOT NULL DEFAULT 'no', `vip_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `smile_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `parola` varchar(40) NOT NULL DEFAULT '', `passhint` int(10) unsigned NOT NULL, `hintanswer` varchar(40) NOT NULL DEFAULT '', `upped` enum('yes','no') NOT NULL DEFAULT 'no', `lastup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `upwarn` enum('yes','no') NOT NULL DEFAULT 'no', `hit_run_total` int(9) DEFAULT '0', `sendmailnotif` enum('yes','no') NOT NULL DEFAULT 'no', `mod_added` enum('yes','no') NOT NULL DEFAULT 'no', `mod_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `trial` enum('yes','no') NOT NULL DEFAULT 'no', `bjwins` int(10) NOT NULL DEFAULT '0', `bjlosses` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), KEY `status_added` (`status`,`added`), KEY `ip` (`ip`), KEY `uploaded` (`uploaded`), KEY `downloaded` (`downloaded`), KEY `country` (`country`), KEY `last_access` (`last_access`), KEY `warned` (`warned`), KEY `passkey` (`passkey`), KEY `id` (`id`,`username`,`old_password`,`passhash`,`secret`), KEY `stylesheet` (`stylesheet`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=453 ;
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#17
|
|||
|
|||
Incorrect integer value: '' for column 'country' at row 1
|
#18
|
||||
|
||||
Code:
CREATE TABLE IF NOT EXISTS `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `old_password` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `passhash` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `secret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', `email` varchar(80) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `status` enum('pending','confirmed') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'pending', `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_catchup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `editsecret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', `privacy` enum('normal','strong') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'normal', `stylesheet` int(10) DEFAULT '1', `info` text CHARACTER SET latin1 COLLATE latin1_general_ci, `acceptpms` enum('yes','friends','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `ip` varchar(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `class` tinyint(2) unsigned NOT NULL DEFAULT '1', `avatar` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0', `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0', `title` varchar(60) CHARACTER SET latin1 COLLATE latin1_general_ci default NULL, `country` int(10) unsigned NOT NULL DEFAULT '0', `notifs` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `modcomment` text CHARACTER SET latin1 COLLATE latin1_general_ci default NULL, `enabled` enum('yes','no') NOT NULL DEFAULT 'yes', `disable_reason` text default NULL, `imunity` enum('yes','no') NOT NULL DEFAULT 'no', `avatars` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `donor` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `warned` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `warneduntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `torrentsperpage` int(3) unsigned NOT NULL DEFAULT '0', `topicsperpage` int(3) unsigned NOT NULL DEFAULT '0', `postsperpage` int(3) unsigned NOT NULL DEFAULT '0', `deletepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `savepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `parked` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `announce` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `passkey` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `last_browse` int(11) NOT NULL DEFAULT '0', `last_browsex` int(11) NOT NULL DEFAULT '0', `last_browsem` int(11) NOT NULL DEFAULT '0', `fader` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `fadecolor` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'FF0000', `support` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `supportfor` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `supportlang` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `invited_by` int(10) NOT NULL DEFAULT '0', `invitees` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `invites` int(1) NOT NULL DEFAULT '0', `gender` enum('Male','Female','N/A') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N/A', `invitedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `view_adult` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_music` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_adult_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_music_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musiclo_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musicvi_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musicpks_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `advertisename` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `signatures` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `signature` varchar(225) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `uploadpos` enum('yes','no') NOT NULL DEFAULT 'no', `downloadpos` enum('yes','no') NOT NULL DEFAULT 'yes', `forumpost` enum('yes','no') NOT NULL DEFAULT 'yes', `chatpost` enum('yes','no') NOT NULL DEFAULT 'no', `chatdisable` enum('yes','no') NOT NULL DEFAULT 'no', `donated` decimal(8,2) NOT NULL DEFAULT '0.00', `last_pm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_comment` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_post` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `forum_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_staffmsg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `timezone` smallint(3) NOT NULL DEFAULT '120', `dst` tinyint(2) NOT NULL DEFAULT '0', `commentpm` enum('yes','no') NOT NULL DEFAULT 'yes', `staff_chat_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `groups` int(10) unsigned NOT NULL DEFAULT '0', `rangclass` int(10) unsigned NOT NULL DEFAULT '0', `zodiac` int(10) unsigned NOT NULL DEFAULT '0', `donoruntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `total_donated` decimal(8,2) NOT NULL DEFAULT '0.00', `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `leechwarn` enum('yes','no') NOT NULL DEFAULT 'no', `timeswarned` int(10) NOT NULL DEFAULT '0', `seedbonus` decimal(5,1) NOT NULL DEFAULT '0.0', `bonuscomment` longtext character set utf8 collate utf8_bin NULL, `vip_added` enum('yes','no') NOT NULL DEFAULT 'no', `vip_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `smile_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `parola` varchar(40) NOT NULL DEFAULT '', `passhint` int(10) unsigned NOT NULL, `hintanswer` varchar(40) NOT NULL DEFAULT '', `upped` enum('yes','no') NOT NULL DEFAULT 'no', `lastup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `upwarn` enum('yes','no') NOT NULL DEFAULT 'no', `hit_run_total` int(9) DEFAULT '0', `sendmailnotif` enum('yes','no') NOT NULL DEFAULT 'no', `mod_added` enum('yes','no') NOT NULL DEFAULT 'no', `mod_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `trial` enum('yes','no') NOT NULL DEFAULT 'no', `bjwins` int(10) NOT NULL DEFAULT '0', `bjlosses` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), KEY `status_added` (`status`,`added`), KEY `ip` (`ip`), KEY `uploaded` (`uploaded`), KEY `downloaded` (`downloaded`), KEY `country` (`country`), KEY `last_access` (`last_access`), KEY `warned` (`warned`), KEY `passkey` (`passkey`), KEY `id` (`id`,`username`,`old_password`,`passhash`,`secret`), KEY `stylesheet` (`stylesheet`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=453 ;
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
#19
|
|||
|
|||
same error Incorrect integer value: '' for column 'country' at row 1
|
#20
|
||||
|
||||
Code:
CREATE TABLE IF NOT EXISTS `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `old_password` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `passhash` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `secret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', `email` varchar(80) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `status` enum('pending','confirmed') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'pending', `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_catchup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `editsecret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', `privacy` enum('normal','strong') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'normal', `stylesheet` int(10) DEFAULT '1', `info` text CHARACTER SET latin1 COLLATE latin1_general_ci, `acceptpms` enum('yes','friends','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `ip` varchar(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `class` tinyint(2) unsigned NOT NULL DEFAULT '1', `avatar` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0', `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0', `title` varchar(60) CHARACTER SET latin1 COLLATE latin1_general_ci default NULL, `country` bigint(20) unsigned NOT NULL DEFAULT '0', `notifs` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `modcomment` text CHARACTER SET latin1 COLLATE latin1_general_ci default NULL, `enabled` enum('yes','no') NOT NULL DEFAULT 'yes', `disable_reason` text default NULL, `imunity` enum('yes','no') NOT NULL DEFAULT 'no', `avatars` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `donor` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `warned` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `warneduntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `torrentsperpage` int(3) unsigned NOT NULL DEFAULT '0', `topicsperpage` int(3) unsigned NOT NULL DEFAULT '0', `postsperpage` int(3) unsigned NOT NULL DEFAULT '0', `deletepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `savepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `parked` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `announce` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `passkey` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `last_browse` int(11) NOT NULL DEFAULT '0', `last_browsex` int(11) NOT NULL DEFAULT '0', `last_browsem` int(11) NOT NULL DEFAULT '0', `fader` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `fadecolor` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'FF0000', `support` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `supportfor` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `supportlang` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `invited_by` int(10) NOT NULL DEFAULT '0', `invitees` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `invites` int(1) NOT NULL DEFAULT '0', `gender` enum('Male','Female','N/A') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N/A', `invitedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `view_adult` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_music` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_adult_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_music_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musiclo_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musicvi_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `view_musicpks_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `advertisename` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no', `signatures` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes', `signature` varchar(225) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `uploadpos` enum('yes','no') NOT NULL DEFAULT 'no', `downloadpos` enum('yes','no') NOT NULL DEFAULT 'yes', `forumpost` enum('yes','no') NOT NULL DEFAULT 'yes', `chatpost` enum('yes','no') NOT NULL DEFAULT 'no', `chatdisable` enum('yes','no') NOT NULL DEFAULT 'no', `donated` decimal(8,2) NOT NULL DEFAULT '0.00', `last_pm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_comment` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_post` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `forum_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_staffmsg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `timezone` smallint(3) NOT NULL DEFAULT '120', `dst` tinyint(2) NOT NULL DEFAULT '0', `commentpm` enum('yes','no') NOT NULL DEFAULT 'yes', `staff_chat_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `groups` int(10) unsigned NOT NULL DEFAULT '0', `rangclass` int(10) unsigned NOT NULL DEFAULT '0', `zodiac` int(10) unsigned NOT NULL DEFAULT '0', `donoruntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `total_donated` decimal(8,2) NOT NULL DEFAULT '0.00', `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `leechwarn` enum('yes','no') NOT NULL DEFAULT 'no', `timeswarned` int(10) NOT NULL DEFAULT '0', `seedbonus` decimal(5,1) NOT NULL DEFAULT '0.0', `bonuscomment` longtext character set utf8 collate utf8_bin NULL, `vip_added` enum('yes','no') NOT NULL DEFAULT 'no', `vip_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `smile_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `parola` varchar(40) NOT NULL DEFAULT '', `passhint` int(10) unsigned NOT NULL, `hintanswer` varchar(40) NOT NULL DEFAULT '', `upped` enum('yes','no') NOT NULL DEFAULT 'no', `lastup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `upwarn` enum('yes','no') NOT NULL DEFAULT 'no', `hit_run_total` int(9) DEFAULT '0', `sendmailnotif` enum('yes','no') NOT NULL DEFAULT 'no', `mod_added` enum('yes','no') NOT NULL DEFAULT 'no', `mod_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `trial` enum('yes','no') NOT NULL DEFAULT 'no', `bjwins` int(10) NOT NULL DEFAULT '0', `bjlosses` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), KEY `status_added` (`status`,`added`), KEY `ip` (`ip`), KEY `uploaded` (`uploaded`), KEY `downloaded` (`downloaded`), KEY `country` (`country`), KEY `last_access` (`last_access`), KEY `warned` (`warned`), KEY `passkey` (`passkey`), KEY `id` (`id`,`username`,`old_password`,`passhash`,`secret`), KEY `stylesheet` (`stylesheet`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=453 ;
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent Do not ask me to make a mod for any other source Do not Ask me to setup your site. I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum My Current Demo is here http://demo.btmanager.org/ |
Tags |
black , problems , signup , torrents |
|
|