Bravo List - Help with database errors

Bravo List (http://www.bvlist.com/index.php)

- TBDev (http://www.bvlist.com/forumdisplay.php?f=20)

- - Help with database errors (http://www.bvlist.com/showthread.php?t=10758)

flkennard

29th February 2016 15:36

Help with database errors

Hi everyone

I have been trying to get a tbdev source to work but I keep getting database errors. I have combed through all the tbdev section here and can't seem to find anything that seems related.

when i install any tbdev source I get basically the same error.this is the one that always pops up.

Field 'last_login' doesn't have a default value

anyone know what's going on there or have any ideas?

Server Info
Apache 2.2.31
MySQL 5.6.27-75.0
PHP 5.6.14

Chez	29th February 2016 16:22

Its pretty simple. Field "last_login" doesn't have a value like "TRUE" or "FALSE" or "0" or anything else. So you need to set a value for that field and it will work.
You'll need to set this in your database.

This is a correct field:

PHP Code:


		
			
`last_login` datetime NOT NULL default '0000-00-00 00:00:00',

0000-00-00 00:00:00 is the default value

All times are GMT +2. The time now is 18:05.