Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   Torrent Trader (http://www.bvlist.com/forumdisplay.php?f=29)
-   -   error in date line,,, how to fix it (http://www.bvlist.com/showthread.php?t=12427)

leech24 4th October 2021 23:44

error in date line,,, how to fix it
 
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);

mogo 4th October 2021 23:53

Why you need fix that SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

DND 5th October 2021 10:19

well..isn't better to actually fix the code then to change mysql settings?

leech24 5th October 2021 23:44

Can you explain how to solve with pictures? English is not the original language * You are not a programmer

Bump: When registering, an error appears in the database

MicroMonkey 14th November 2021 20:41

For anyone who may have this problem, new installations of TTv3 have taken care of this issue


All times are GMT +2. The time now is 01:36.

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