Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   TBDev (http://www.bvlist.com/forumdisplay.php?f=20)
-   -   TBDev09 (2020) (http://www.bvlist.com/showthread.php?t=12262)

stargate 9th May 2020 21:58

Quote:

Originally Posted by Asterix (Post 54819)
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?

Asterix 10th May 2020 16:03

some errors in database structure.

Napon 11th May 2020 07:38

nothing wrong with database hes not installed it wtite at all drop db resign up and add user:cool:

stargate 11th May 2020 15:07

Quote:

Originally Posted by Napon (Post 54827)
nothing wrong with database hes not installed it wtite at all drop db resign up and add user:cool:

hi napon,

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

Thanks

Asterix 11th May 2020 17:46

1 Attachment(s)
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.

iseeyoucopy 11th May 2020 20:59

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'

:ok:

Asterix 11th May 2020 21:34

:drink: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',

iseeyoucopy 11th May 2020 21:56

Quote:

Originally Posted by Asterix (Post 54831)
:drink: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'

:drink:

Asterix 11th May 2020 22:21

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.

:drink:

Dehas 15th May 2020 12:38

hello
I registered and i can't donwload !!
Thx


All times are GMT +2. The time now is 21:25.

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