[Fixed] Data not recording (MySQL MyISAM to InnoDB)

This site is best viewed in a modern browser with JavaScript enabled.

[Fixed] Data not recording (MySQL MyISAM to InnoDB)

kmcmillen

When trying to set up marking periods, they do not save. If I add a semester, the plus arrow will appear to add a quarter, and if I add the quarter, then the progress period, but nothing will record.

francoisjacquet

Hello kmcmillen

What you are reporting is strange to me.
Can you please share a video showing this behavior?
Are you able to reproduce this behavior on the demo?

kmcmillen

https://youtu.be/BQ9u4B56qhI

I was able to create and delete marking periods on the demo.

francoisjacquet

kmcmillen

Thank you for the video.
It looks like Marking Periods are saved, but they do not appear in the list.
I do not know if it is related, but there is something wrong:

Today's date is 1969-12-31 according to your server configuration...
RosarioSIS heavily relies on dates. Please make your server displays the correct date (for both PHP and database, whether MySQL or PostgreSQL).

Please let me know if you still have the issue after correcting the date.

francoisjacquet

Also, how come you were able to delete all the default Marking Periods?
RosarioSIS is designed such as the "Delete" button does not appear if there is only 1 quarter left.

Or did any Marking Period appear at all when you first logged in?

kmcmillen

francoisjacquet There were marking periods. I was able to delete, but I believe when I edited the quarter and saved it, it no longer showed up.

francoisjacquet

kmcmillen OK, and were you able to fix the server's date?

kmcmillen

No, I haven't been able to get it working correctly.

francoisjacquet

Hello kmcmillen

The error or strange behavior you experience has been reported by another admin.
I am trying to determine first what is the specific configuration causing this.
Would you please communicate the installation instructions you have followed along with your OS, PHP, and MySQL or PostgreSQL versions?

francoisjacquet

Hello kmcmillen

We were able to determine the following:
This issue happens with MySQL (MyISAM) only, and when the database has wrong collation.
The MySQL database (all its tables, views, etc) must have the utf8mb4_unicode_520_ci (InnoDB ) collation as stated in the installation instructions.

Convert tables from MyISAM engine to InnoDB:
https://modx.com/blog/convert-myisam-to-innodb-with-phpmyadmin

francoisjacquet

Regarding the date issue, I was able to reproduce it.
It happens when the PHP intl extension is not activated (please refer to the installation instructions).
Activate it, restart your server and the date should be today's date.

As for your issue with Marking Periods, I was not able to reproduce it with the date issue. So it must be related to something else.

francoisjacquet

Since RosarioSIS 10.4.3, the InnoDB engine will be enforced

OK, I was able to reproduce the behavior, and it is caused by the MyISAM engine specifically.