View Single Post
  #3  
Old 4th October 2021, 23:05
leech24 leech24 is offline
Member
 
Join Date: Feb 2015
Posts: 7
Default
thanks micro

CREATE TABLE `blackjack`( `userid` INT(11) NOT NULL DEFAULT '0', `points` INT(11) NOT NULL DEFAULT '0', `status` ENUM('playing', 'waiting') NOT NULL DEFAULT 'playing', `cards` TEXT NOT NULL, `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY(`userid`)) ENGINE = MyISAM;


i use mysql 5.7

Bump: i found some error
in my web


Quote:
Database Error in account-signup.php on line 126: Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_login' at row 1. Query was: INSERT INTO users (username, password, secret, email, status, added, last_access, age, country, gender, client, stylesheet, language, class, ip, seedbonus) VALUES ('adminl24','a8e9600c3c5d0e4edc767c2b39608996c2eb0 347','pPfm5HsVdpr72OIzzduu','A@AA.com','pending',' 2021-10-04 21:27:06','2021-10-04 21:27:06',25,84,'Male','',1,1,1,'142.247.196.199', 0).

in account signup ,line126
Quote:
SQL_Query_exec("INSERT INTO users (username, password, secret, email, status, added, last_access, age, country, gender, client, stylesheet, language, class, ip, seedbonus) VALUES (" .
implode(",", array_map("sqlesc", array($wantusername, $wantpassword, $secret, $email, $status, get_date_time(), get_date_time(), $age, $country, $gender, $client, $site_config["default_theme"], $site_config["default_language"], $signupclass, getip(), 0.0))).")");

$id = mysqli_insert_id($GLOBALS["DBconnector"]);

$psecret = md5($secret);
$thishost = $_SERVER["HTTP_HOST"];
$thisdomain = preg_replace('/^www\./is', "", $thishost);
Bump: i found some error
in my web


Quote:
Database Error in account-signup.php on line 126: Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_login' at row 1. Query was: INSERT INTO users (username, password, secret, email, status, added, last_access, age, country, gender, client, stylesheet, language, class, ip, seedbonus) VALUES ('adminl24','a8e9600c3c5d0e4edc767c2b39608996c2eb0 347','pPfm5HsVdpr72OIzzduu','A@AA.com','pending',' 2021-10-04 21:27:06','2021-10-04 21:27:06',25,84,'Male','',1,1,1,'142.247.196.199', 0).

in account signup ,line126
Quote:
SQL_Query_exec("INSERT INTO users (username, password, secret, email, status, added, last_access, age, country, gender, client, stylesheet, language, class, ip, seedbonus) VALUES (" .
implode(",", array_map("sqlesc", array($wantusername, $wantpassword, $secret, $email, $status, get_date_time(), get_date_time(), $age, $country, $gender, $client, $site_config["default_theme"], $site_config["default_language"], $signupclass, getip(), 0.0))).")");

$id = mysqli_insert_id($GLOBALS["DBconnector"]);

$psecret = md5($secret);
$thishost = $_SERVER["HTTP_HOST"];
$thisdomain = preg_replace('/^www\./is', "", $thishost);
Bump: i found some error
in my web


Quote:
Database Error in account-signup.php on line 126: Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_login' at row 1. Query was: INSERT INTO users (username, password, secret, email, status, added, last_access, age, country, gender, client, stylesheet, language, class, ip, seedbonus) VALUES ('adminl24','a8e9600c3c5d0e4edc767c2b39608996c2eb0 347','pPfm5HsVdpr72OIzzduu','A@AA.com','pending',' 2021-10-04 21:27:06','2021-10-04 21:27:06',25,84,'Male','',1,1,1,'142.247.196.199', 0).

in account signup ,line126
Quote:
SQL_Query_exec("INSERT INTO users (username, password, secret, email, status, added, last_access, age, country, gender, client, stylesheet, language, class, ip, seedbonus) VALUES (" .
implode(",", array_map("sqlesc", array($wantusername, $wantpassword, $secret, $email, $status, get_date_time(), get_date_time(), $age, $country, $gender, $client, $site_config["default_theme"], $site_config["default_language"], $signupclass, getip(), 0.0))).")");

$id = mysqli_insert_id($GLOBALS["DBconnector"]);

$psecret = md5($secret);
$thishost = $_SERVER["HTTP_HOST"];
$thisdomain = preg_replace('/^www\./is', "", $thishost);
Bump: i found some error
in my web


Quote:
Database Error in account-signup.php on line 126: Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_login' at row 1. Query was: INSERT INTO users (username, password, secret, email, status, added, last_access, age, country, gender, client, stylesheet, language, class, ip, seedbonus) VALUES ('adminl24','a8e9600c3c5d0e4edc767c2b39608996c2eb0 347','pPfm5HsVdpr72OIzzduu','A@AA.com','pending',' 2021-10-04 21:27:06','2021-10-04 21:27:06',25,84,'Male','',1,1,1,'142.247.196.199', 0).

in account signup ,line126
Quote:
SQL_Query_exec("INSERT INTO users (username, password, secret, email, status, added, last_access, age, country, gender, client, stylesheet, language, class, ip, seedbonus) VALUES (" .
implode(",", array_map("sqlesc", array($wantusername, $wantpassword, $secret, $email, $status, get_date_time(), get_date_time(), $age, $country, $gender, $client, $site_config["default_theme"], $site_config["default_language"], $signupclass, getip(), 0.0))).")");

$id = mysqli_insert_id($GLOBALS["DBconnector"]);

$psecret = md5($secret);
$thishost = $_SERVER["HTTP_HOST"];
$thisdomain = preg_replace('/^www\./is', "", $thishost);
Reply With Quote