Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   TBDev (http://www.bvlist.com/forumdisplay.php?f=20)
-   -   Black Torrents - signup problems (http://www.bvlist.com/showthread.php?t=8854)

Tones 7th February 2013 00:34
Black Torrents - signup problems
 
2 Attachment(s)
Attachment 4056

Attachment 4057

These two files are in BT...... my problem is similar to this BORKED http://www.bvlist.com/tbdev/1040-problem-source.html

joeroberts 7th February 2013 00:42
replace
PHP Code:
$ret = mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."')"); 
with

PHP Code:
mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."')")or die(mysql_error());
                die('test Now tell joe what it said'); 
and let me know what it said

Tones 7th February 2013 00:47
Field 'title' doesn't have a default value

joeroberts 7th February 2013 00:55
Now try this
PHP Code:
                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added, title) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title')")or die(mysql_error());
                die('test Now tell joe what it said'); 

Tones 7th February 2013 00:57
I get this error.... Field 'modcomment' doesn't have a default value

joeroberts 7th February 2013 01:00
wow pick data base try this one
PHP Code:
                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added, title, modcomment) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title', 'signed up')")or die(mysql_error());
                die('test Now tell joe what it said'); 

Tones 7th February 2013 01:03
Field 'disable_reason' doesn't have a default value

Bump: These errors stop somewhere in country field ....

joeroberts 7th February 2013 01:05
try this one now
PHP Code:
                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added, title, modcomment, disable_reason) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title', 'signed up', 'none')")or die(mysql_error());
                die('test Now tell joe what it said'); 

Tones 7th February 2013 01:07
Field 'supportfor' doesn't have a default value

joeroberts 7th February 2013 01:09
try this
PHP Code:
                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added, title, modcomment, disable_reason, supportfor) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title', 'signed up', 'none', 'nothen')")or die(mysql_error());
                die('test Now tell joe what it said'); 

Tones 7th February 2013 01:11
Field 'passhint' doesn't have a default value

joeroberts 7th February 2013 01:15
wow Who the hell made this dam table?
try this one now
PHP Code:
                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added, title, modcomment, disable_reason, supportfor, passhint) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title', 'signed up', 'none', 'nothen', 'pass')")or die(mysql_error());
                die('test Now tell joe what it said'); 
Also can you post the user table so I can see if I can fix that

Tones 7th February 2013 01:19
1 Attachment(s)
Incorrect integer value: '' for column 'country' at row 1

and here is the users table
Attachment 4058

joeroberts 7th February 2013 01:30
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 ;

Tones 7th February 2013 01:31
#1101 - BLOB/TEXT column 'bonuscomment' can't have a default value

joeroberts 7th February 2013 01:35
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 ;

Tones 7th February 2013 01:36
Incorrect integer value: '' for column 'country' at row 1

joeroberts 7th February 2013 01:39
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 ;

Tones 7th February 2013 01:41
same error Incorrect integer value: '' for column 'country' at row 1

joeroberts 7th February 2013 01:46
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 ;

Tones 7th February 2013 01:48
same error Incorrect integer value: '' for column 'country' at row 1

joeroberts 7th February 2013 02:01
PHP Code:
                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, email, status, ". (!$arr[0]?"class, ":"") ."added, title, modcomment, disable_reason, supportfor, passhint) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret,  $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title', 'signed up', 'none', 'nothen', 'pass')")or die(mysql_error());
                die('test Now tell joe what it said'); 

Tones 7th February 2013 02:03
Incorrect integer value: 'pass' for column 'passhint' at row 1

joeroberts 7th February 2013 02:05
PHP Code:
                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, email, status, ". (!$arr[0]?"class, ":"") ."added, title, modcomment, disable_reason, supportfor) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret,  $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title', 'signed up', 'none', 'nothen')")or die(mysql_error());
                die('test Now tell joe what it said'); 

Tones 7th February 2013 02:06
Field 'passhint' doesn't have a default value

Bump: i set the value to Null .. and now I see this test Now tell joe what it said

joeroberts 7th February 2013 02:11
PHP 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` text default 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 ; 

Tones 7th February 2013 02:12
EVRIKAAAAAA
 
Thank you so much joe goes super ok now !!!! :war:

joeroberts 7th February 2013 02:15
ok so make your code
PHP Code:
$ret = mysql_query("INSERT INTO users (username, passhash, secret, editsecret, email, status, ". (!$arr[0]?"class, ":"") ."added, title, modcomment, disable_reason, supportfor) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret,  $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title', 'signed up', 'none', 'nothen')"); 
and remove the
PHP Code:
                die('test Now tell joe what it said'); 
and that should do it


All times are GMT +2. The time now is 05:31.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.