Page 2 of 2
Re: Browse Tricks, Roster
Posted: Thu Jan 21, 2021 5:34 pm
by miasoft
I get this error After save:
Code: Select all
[0] :
===USER==========
globeadmin
===PDO MESSAGE===
SQLSTATE[HY000]: General error: 1364 Field 'ros_1' doesn't have a default value
===SQL===========
INSERT INTO roster (roster_id, `ros_id`, `ros_house_id`, `ros_year`, `ros_month`) VALUES ('6009a9eda51273c', '5dbf6c13333132220210', '5dbf6c133331322', '2021', '0');
If I set default value for 'ros_1' in db, then I get the same error for field 'ros_2' etc.
I think I must set default values for all 'ros_xx' in database.
Re: Browse Tricks, Roster
Posted: Thu Jan 21, 2021 6:04 pm
by nac
I don't know the full structure of the roster table, but you could either set default values, as you suggest, or allow them to be NULL. At the moment, it looks as though ros_1 requires a value but you are not supplying one in your INSERT statement.
N
Re: Browse Tricks, Roster
Posted: Thu Jan 21, 2021 7:46 pm
by miasoft
I see a small x in the search box (Roster ex.). But all my sites have not one
21.01_4.png
I can't find where this is done.
I'm tired of banging my head against the wall
Re: Browse Tricks, Roster
Posted: Thu Jan 21, 2021 10:16 pm
by nac
I see a small x in the search box (Roster ex.).
I think this is an add-in that kev1n developed for nuBuilder 4 . See
https://github.com/smalos/nuBuilder4-Co ... arch_field
It is now a standard feature in 4.5
Neil
Re: Browse Tricks, Roster
Posted: Thu Jan 21, 2021 10:56 pm
by kev1n
Neil is right. This x appears because the search field is now a HTML input type="search".
But I don't see how that is related to your initial question...
Re: Browse Tricks, Roster
Posted: Fri Jan 22, 2021 5:59 am
by miasoft
Thanks, Neil! Thanks, I updated everything to the newest version and now everything works!
kev1n wrote:Neil is right. This x appears because the search field is now a HTML input type="search".
But I don't see how that is related to your initial question...
Sorry, kevln. I thought I was in the subject
I try Roster-example and ...