|
#11
|
|||
|
|||
Quote:
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. |
#12
|
|||
|
|||
some errors in database structure.
|
#13
|
|||
|
|||
nothing wrong with database hes not installed it wtite at all drop db resign up and add user
|
#14
|
|||
|
|||
Quote:
sorry but I did not understand ... am I wrong? why can't I add users? Thanks |
#15
|
|||
|
|||
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. |
#16
|
|||
|
|||
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:
|
#17
|
|||
|
|||
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', |
#18
|
|||
|
|||
Quote:
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:
|
#19
|
|||
|
|||
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. |
#20
|
||||
|
||||
hello
I registered and i can't donwload !! Thx |
|
|