Browse Tricks, Roster

[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.

[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

[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

[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

[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...

[miasoft]

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

Thanks, Neil! Thanks, I updated everything to the newest version and now everything works!

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 ...