Special Days Input were Invalid

Hello dear Gibbon Support,

I have installed Gibbon. But i am facing an issue
When i add a special Day on 20th March 2015 “School closure” then it appears as

“” Your inputs were invalid "

But on few days it appears as successful and on some days it appears as Your inputs were invalid

Kindly provide solution.

Best Regards:
Gibbon Lovers

Mr. Shah,

It seems like the problem is that two records already exist for this day, which is confusing the system: it does not know what to display, so it is displaying the day as no special days…and it is not letting you add something.

Can you look in your database and see if this is the case. Check in the table gibbonSchoolYearSpecialDay for the day in question. If there are multiple records, delete one or the other…or both and start again.

This can happen if you double click on a link slowly (you end up with two requests), or if the server hangs mid-request (which I noticed yours did, giving me a time out message), and you refresh the processing page.

The code causing this issue is some of the oldest in Gibbon, and could fail more gracefully. I have made a note to address this in v9.1.

Let us know how you go. Thanks,

Ross

Thank Admin,

You Suppport is Excellent it successfully added

But

It`s not appearing as red text on the calender.
It successfully added but on few days it appears as red and on few it appears nothing.
Is it server error ?

No problem! This is a strange problem. Can you check your gibbonSchoolYearSpecialDay table, and record the entries you have, letting me know which work and which don’t. I will then try and replicate on my side. Thanks! Ross.

Hi, I had the same problem with one day, following the suggestion I went to the gibbonSchoolYearSpecialDay table, I looked for the record, I deleted it, and success, now I can create a new especial day.

Sorry to be asking the same again, but I have the same problem again about “Special Days Input were Invalid”, and I really dont remember how to fix it, I know I have to open the “gibbonSchoolYearSpecialDay” table, but dont remember how to find it :frowning:

Hi @oflodac

Luckily the issue that likely caused this error has been fixed in the upcoming v13. For your version you can fix it manually by editing your MySQL database (a tool like PHPMyAdmin or DBeaver can help with this), then following Ross’ instructions should do the trick: Check in the table gibbonSchoolYearSpecialDay for the day in question. If there are multiple records, delete one or the other…or both and start again.

Hope this helps!

Many thanks skuipers, I already fixed this problem. My contribution for newbies, what do think when you read the "open the “gibbonSchoolYearSpecialDay table”?? suggestion, first thought is to look for it in gibbon, thats the first mistake, this table cannot bee seen in gibbon, you have to go where you have installed gibbon (SiteGround is our server host), then go to “PhpMyAdmin”, go to “DataBases”, look for a database with name …_gibbon, scroll down and look for the “gibbonSchoolYearSpecialDay” table and open it, and finally, delete the record with problems.