Bravo List
Register
Go Back   > Bravo List > Source Code > Active Trackers > Torrent Trader
Reply
  #1  
Old 4th October 2021, 23:44
leech24 leech24 is offline
Member
 
Join Date: Feb 2015
Posts: 7
Default 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);
Reply With Quote
  #2  
Old 4th October 2021, 23:53
mogo mogo is offline
Senior Member
 
Join Date: Jun 2020
P2P
Posts: 94
Default
Why you need fix that SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
Reply With Quote
  #3  
Old 5th October 2021, 10:19
DND DND is offline
VIP
 
Join Date: Dec 2008
Posts: 1,241
Default
well..isn't better to actually fix the code then to change mysql settings?
__________________
Need HELP!? I can install:

  1. Server/VPS (Debian,CentOS,Ubuntu,Fedora, FreeBSD) Optimization and ... + Modules
  2. Webserver Windows/Linux (Apache/Lighttpd/Nginx/Mysql/PhpMyAdmin/SSL) Optimization and ... + Modules
  3. Seedbox Windows/Linux (uTorrent,rTorrent,libTorrent,ruTorrent) + Modules
  4. Multiple source code engines
  5. Linux Server Administration (security, cryptography/encryption, proxy, load balancer, custom ddos firewall)
Reply With Quote
  #4  
Old 5th October 2021, 23:44
leech24 leech24 is offline
Member
 
Join Date: Feb 2015
Posts: 7
Default
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
Reply With Quote
  #5  
Old 14th November 2021, 20:41
MicroMonkey's Avatar
MicroMonkey MicroMonkey is offline
Senior Member
 
Join Date: Jun 2016
P2P
Posts: 52
Default
For anyone who may have this problem, new installations of TTv3 have taken care of this issue
__________________
More torrenttrader stuff at https://torrenttrader.uk

Last edited by MicroMonkey; 15th November 2021 at 12:52.
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 01:13. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.