Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > TBDev
Reply
  #11  
Old 9th May 2020, 21:58
stargate stargate is offline
Member
 
Join Date: May 2018
Posts: 4
Default
Quote:
Originally Posted by Asterix View Post
Hi.
Go to signup page and signup with your credentials. First user will become automatically sysop.
Thanks for the reply.

I tried to add a user and the word account confirmed appears to me, however in reality it does not create any account for me. In fact, looking at the users table in mysql it is empty!

am I wrong?

Last edited by stargate; 10th May 2020 at 12:47.
Reply With Quote
  #12  
Old 10th May 2020, 16:03
Asterix Asterix is offline
Senior Member
 
Join Date: Mar 2011
P2P
Posts: 20
Default
some errors in database structure.
Reply With Quote
  #13  
Old 11th May 2020, 07:38
Napon Napon is offline
Banned
 
Join Date: Feb 2016
P2P
Posts: 522
Thumbs up
nothing wrong with database hes not installed it wtite at all drop db resign up and add user
Reply With Quote
  #14  
Old 11th May 2020, 15:07
stargate stargate is offline
Member
 
Join Date: May 2018
Posts: 4
Default
Quote:
Originally Posted by Napon View Post
nothing wrong with database hes not installed it wtite at all drop db resign up and add user
hi napon,

sorry but I did not understand ... am I wrong? why can't I add users?

Thanks
Reply With Quote
  #15  
Old 11th May 2020, 17:46
Asterix Asterix is offline
Senior Member
 
Join Date: Mar 2011
P2P
Posts: 20
Default
Error Number: 1292
Error: Incorrect date value: '0000-00-00' for column 'birthday' at row 1

Error Number: 1364
Error: Field 'title' doesn't have a default value

@ stargate add this table to your database and try to signup after.
Attached Files
File Type: sql users.sql (6.4 KB, 27 views)
Reply With Quote
  #16  
Old 11th May 2020, 20:59
iseeyoucopy iseeyoucopy is offline
VIP
 
Join Date: Jan 2011
P2P
Posts: 28
Default
According to MySql we should use values between '1000-01-01' to '9999-12-31'

Don't use 0000-00-00 it will still give some errors in php, your birthday column should similar

PHP Code:
ALTER TABLE `usersALTER COLUMN `birthdaySET DEFAULT '1920-01-01'
Reply With Quote
  #17  
Old 11th May 2020, 21:34
Asterix Asterix is offline
Senior Member
 
Join Date: Mar 2011
P2P
Posts: 20
Default
True.

but on tbdev database on table users column

`birthday` date DEFAULT '0000-00-00',

when insert the database it gives a column with null=yes default 000-00-00.

i suposse corect will be

`birthday` date NOT NULL DEFAULT '1920-01-01',
Reply With Quote
  #18  
Old 11th May 2020, 21:56
iseeyoucopy iseeyoucopy is offline
VIP
 
Join Date: Jan 2011
P2P
Posts: 28
Default
Quote:
Originally Posted by Asterix View Post
True.

but on tbdev database on table users column

`birthday` date DEFAULT '0000-00-00',

when insert the database it gives a column with null=yes default 000-00-00.

i suposse corect will be

`birthday` date NOT NULL DEFAULT '1920-01-01',

sorry forgot to mention but in my case and in that database it was already set to not null, and i just change default value, it doesn't have to touch NOT NULL because already was set

and yes you have right , the line in sql need to be changed with that
PHP Code:
`birthdaydate NOT NULL DEFAULT '1920-01-01'
Reply With Quote
  #19  
Old 11th May 2020, 22:21
Asterix Asterix is offline
Senior Member
 
Join Date: Mar 2011
P2P
Posts: 20
Default
For that i said some errors on database structure.
This is one from many.
Columns not null without default value and colums set to null with default value different from null.

Reply With Quote
  #20  
Old 15th May 2020, 12:38
Dehas's Avatar
Dehas Dehas is offline
Member
 
Join Date: Feb 2008
France
Posts: 13
Default
hello
I registered and i can't donwload !!
Thx
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 13:48. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.