Hi, Just installed opensis v9x on a localhost using the 'install wizard'. I believe the installation went well. I tried to add a user/password entry. However I cannot use this entry to login because it said that the password is incorrect. I tried to modify it using the super admin account. The password/text field shows a different password than originally entered. I'm guessing it is displaying a hash or something.
Hi Samuel, The way I handled it was upgrading to the latest version (v9). Find it here: https://github.com/OS4ED/openSIS-Classic -Evan On Fri, Mar 3, 2023 at 10:22 AM Samuel Mukwamboweshango mukwambo@users.sourceforge.net wrote: I am running v7.6, the rollover attempted to backup copy of the database and then stopped, nothing was rolled over. How can this issue be handled? Rollover version 7.2 https://sourceforge.net/p/opensis-ce/discussion/1110993/thread/d100c6a37f/?limit=25#432c Sent from sourceforge.net...
I am running v7.6, the rollover attempted to backup copy of the database and then stopped, nothing was rolled over. How can this issue be handled?
Greetings! Our school is using the free version of OpenSis (8.0) and we needed to change the end of the marking period to a later date. We made all the changes under School Setup>Marking Periods, but the students are still showing as Ïnactive as the original marking period already ended. Is there a way to make this adjustment? Thanks for your help.
Update: I solved the problem. There is nothing wrong with the Rollover process. It is working as designed. This issue was caused by user error. The issue was that I was attempting a rollover before the school year began. For example, in August 2022 I rolled over to a school year that begins in August 2023. This won't be a problem in a production environment because no one will ever need to rollover a school year before it begins or ends. Rather it was an issue that I found during testing. The rollover...
Can you give an example of a data issue you've seen before that might break the rollover process?
I'm seeing a problem with the Rollover process in version 8. I created a demo school with only 2 students enrolled for the 2022-2023 school year. My demo school year started in August 2022 and ends in June 2023. I rolled over the school into a new year (2023-2024). After the rollover was completed I saw in the success confirmation message that two students were rolled over; "Students (2)". I logged in and I can see my two students with either school year selected. I checked the database table student_enrollment...
In case someone else comes across this, in later versions of openSIS a similar error is caused by the max_execution_time timeout caused by the database creation. The database creation takes longer than the time limit configured in the php.ini file. Check your php.ini file on the server and search for the variable "max_execution_time" and set to "3600". max_execution_time=3600 See openSIS article: https://support.os4ed.com/hc/en-us/articles/115000440183-Why-do-I-see-a-blank-screen-while-installin...
Hi all, I am trying to install openSIS 8.0 on my VPS (Plesk CentOS 7.9). Everything installs fine and works when installing via Softaculous, unfortunately Softaculous’ latest version is 6.5 and it looks quite outdated. So I am attempting a manual install, my PHP, cURL and Apache all meets system requirements. The problem lies on the Database Connection page. I followed available guides online to just hit next with the following default values: Server: localhost Port: 3306 MySQL Username: root MySQL...
Softaculous' latest version is 6.5 unfortunately. Is there a way to upgrade from 6.5 to 8.0? I see the 8.0 installer is only for upgrading from 7.1 or higher.
There is a data import utility under Tools. Apart from file type there is no other information. Could someone post the steps they used to successfully use this tool. Thank you.
This worked for me: Find out what user is running apache: ps aux | grep -E '[a]pache|[h]ttpd|[_]www|[w]ww-data|[n]ginx' | grep -v root | head -1 (the user is most likely www-data. It may also be: apache or httpd) sudo chown -R yourusername:www-data ./opensis sudo chmod -R g+rw ./opensis https://unix.stackexchange.com/questions/35711/giving-php-permission-to-write-to-files-and-folders
This worked for me: Find out what user is running apache: ps aux | grep -E '[a]pache|[h]ttpd|[_]www|[w]ww-data|[n]ginx' | grep -v root | head -1 (the user is most likely www-data. It may also be: apache or httpd) chown -R yourusername:www-data ./opensis chmod -R g+rw ./opensis https://unix.stackexchange.com/questions/35711/giving-php-permission-to-write-to-files-and-folders
The broken link is here: https://web.archive.org/web/20210514095604/http://blog.lysender.com/2015/07/centos-7-selinux-php-apache-cannot-writeaccess-file-no-matter-what/
goto github.com/os4ed and ask there.
Anytime I try to schedule students, selecting the course gives me this pop up error, I've tried it on different installs with different data sets, and can't find any that don't give me this error. Any suggestions? This is a time sensitive project for me.
OpenSIS supports SuiteCRM, and this software can be easily downloaded as a VM: https://www.univention.com/products/univention-app-center/app-catalog/digitec-suitecrm/ OpenSIS should look at doing something similar.
Yes, the parent is the teacher of the class. Scheduling is where you assign a student to a course.
Can you explain more?
That is very good to hear Evan, thank you. On Mon, Nov 22, 2021 at 8:51 PM Evan evanofmt@users.sourceforge.net wrote: I had a similar issue with v 7.6. The rollover attempted to my a backup copy of the database and then stopped after rolling over the Users (ie. staff) table. After version 8 was released, I copied the following files from version 8 and added them to my version 7.6. Just tested and the rollover completed successfully. /functions/CustomFunctionsFnc.php /js/Ajaxload.js /modules/tools/Rollover.php...
I had a similar issue with v 7.6. The rollover attempted to my a backup copy of the database and then stopped after rolling over the Users (ie. staff) table. After version 8 was released, I copied the following files from version 8 and added them to my version 7.6. Just tested and the rollover completed successfully. /functions/CustomFunctionsFnc.php /js/Ajaxload.js /modules/tools/Rollover.php /BackupForRollover.php /RolloverShadow.php I tested with the first four files in the list with no success....
I had a similar issue with v 7.6. The rollover attempted to my a backup copy of the database and then stopped after rolling over the Users (ie. staff) table. After version 8 was released, I copied the following files from version 8 and added them to my version 7.6. Just tested and the rollover completed successfully. /functions/CustomFunctionsFnc.php /js/Ajaxload.js /modules/tools/Rollover.php /BackupForRollover.php /RolloverShadow.php It seems like "RolloverShadow.php" is the problem. I haven't...
Here is where one can get an OVA for VirtualBox installation. (It is installed with Ubuntu Desktop 18.04) https://drive.google.com/file/d/1wZxPQpoyc2avmowsoCqP-Q5oXc1pMWYO/view?usp=sharing In VirtualBox, import the Appliance. Make sure the VM uses Bridged networking Start the VM. In the VM, goto a terminal box, and type in: ifconfig to find the IP address of the VM. In a Browser, type: IP-address/opensis. ie. 10.0.6.33/opensis username: admin password: adminadmin1$
Here is where one can get an OVA for VirtualBox installation. (It is installed with Ubuntu Desktop 18.04) https://drive.google.com/file/d/1wZxPQpoyc2avmowsoCqP-Q5oXc1pMWYO/view?usp=sharing In VirtualBox, import the Appliance. Make sure the VM uses Bridged networking Start the VM. In the VM, goto a terminal box, and type in: ifconfig to find the IP address of the VM. In a Browser, type: \<ip address="">/opensis username: admin password: adminadmin1$</ip>
Here is where one can get an OVA for VirtualBox installation. (It is installed with Ubuntu Desktop 18.04) https://drive.google.com/file/d/1wZxPQpoyc2avmowsoCqP-Q5oXc1pMWYO/view?usp=sharing In VirtualBox, import the Appliance. Make sure the VM uses Bridged networking Start the VM. In the VM, goto a terminal box, and type in: ifconfig to find the IP address of the VM. In a Browser, type: <ip address="">/opensis username: admin password: adminadmin1$</ip>
Here is where one can get an OVA for VirtualBox installation. (It is installed with Ubuntu 18.04) https://drive.google.com/file/d/1wZxPQpoyc2avmowsoCqP-Q5oXc1pMWYO/view?usp=sharing In VirtualBox, import the Appliance. Make sure the VM uses Bridged networking Start the VM. In the VM, goto a terminal box, and type in: ifconfig to find the IP address of the VM. In a Browser, type: <ip address="">/opensis username: admin password: adminadmin1$</ip>
A suggestion: Get the 7.x Bitnami ova file. https://bitnami.com/stack/lamp/virtual-machine https://bitnami.com/redirect/to/1781449/bitnami-lampstack-7.3.32-4-r01-linux-debian-10-x86_64-nami.ova Run it in VirtualBox with a bridged network (or in VMware Player). sudo apt install nano sudo nano /opt/bitnami/mariadb/conf/my.cnf add this section to [mysqld] : [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION (or use sql_mode=""...
A suggestion: Get the 7.x Bitnami ova file. https://bitnami.com/stack/lamp/virtual-machine https://bitnami.com/redirect/to/1781449/bitnami-lampstack-7.3.32-4-r01-linux-debian-10-x86_64-nami.ova Run it in VirtualBox with a bridged network (or in VMware Player). sudo apt install nano sudo nano /opt/bitnami/mariadb/conf/my.cnf add this section to [mysqld] : [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION (or use sql_mode=""...
A suggestion: Get the 7.x Bitnami ova file. https://bitnami.com/stack/lamp/virtual-machine https://bitnami.com/redirect/to/1781449/bitnami-lampstack-7.3.32-4-r01-linux-debian-10-x86_64-nami.ova Run it in VirtualBox with a bridged network (or in VMware Player). sudo apt install nano sudo nano /opt/bitnami/mariadb/conf/my.cnf add this section to [mysqld] : [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION wget https://github.com/OS4ED/openSIS-Classic/files/6972128/opensis8.0.zip...
A suggestion: Get the 7.x Bitnami ova file. https://bitnami.com/stack/lamp/virtual-machine https://bitnami.com/redirect/to/1781449/bitnami-lampstack-7.3.32-4-r01-linux-debian-10-x86_64-nami.ova Run it in VirtualBox with a bridged network (or in VMware Player). sudo apt install nano sudo nano /opt/bitnami/mariadb/conf/my.cnf add this section to [mysqld] : [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION wget https://github.com/OS4ED/openSIS-Classic/files/6972128/opensis8.0.zip...
A suggestion: Get the Bitnami ova file. https://bitnami.com/stack/lamp/virtual-machine Run it in VirtualBox with a bridged network (or in VMware Player). sudo apt install nano sudo nano /opt/bitnami/mariadb/conf/my.cnf add this section to [mysqld] : [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION wget https://github.com/OS4ED/openSIS-Classic/files/6972128/opensis8.0.zip unzip ./opensis8.0.zip sudo cp -R ./opensis ./htdocs/...
A suggestion: Get the Bitnami ova file. https://bitnami.com/stack/lamp/virtual-machine Run it in VirtualBox with a bridged network (or in VMware Player). sudo apt install nano sudo nano /opt/bitnami/mariadb/conf/my.cnf add this section to [mysqld] : [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION wget https://github.com/OS4ED/openSIS-Classic/files/6972128/opensis8.0.zip unzip ./opensis8.0.zip sudo cp -R ./opensis ./htdocs/...
A suggestion: Get the Bitnami ova file. https://bitnami.com/stack/lamp/virtual-machine Run it in VirtualBox with a bridged network (or in VMware Player). sudo nano /opt/bitnami/mariadb/conf/my.cnf add this section to [mysqld] : [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Wget https://github.com/OS4ED/openSIS-Classic/files/6972128/opensis8.0.zip unzip ./opensis8.0.zip Sudo cp -R ./opensis ./htdocs/ Sudo chmod -R...
I have just installed OpenSIS with the following: Ubuntu 18.04 Apache 2.4, PHP 7.4 MySQL 5.6. I suggest installing one app at a time, testing the app, and saving a snapshot in a VM after each app install. Need new repositories to install MySQL.
I have just installed OpenSIS with the following: Ubuntu 18.04 Apache 2.4, PHP 7.4 MySQL 5.6. I suggest installing one app at a time, testing the app, and saving a snapshot in a VM after each app install. Need to app repositories to install MySQL.
I have just installed OpenSIS with the following: Ubuntu 18.04 Apache 2.4, PHP 7.4 MySQL 5.6 and Apache 2.4 I suggest installing one app at a time, testing the app, and saving a snapshot in a VM after each app install. Need to app repositories to install MySQL.
Hi I have a course with a custom date range. When I try to do a group schedule of adding students to the course, the course does not appear for selection only the courses for the fall 2021 marking period. I also notice in the course catalog that my course with a custom date range does not show a marking period. Any suggestions or fix for custom date courses? Thank you
Hi I have a course with a custom date range. When I try to do a group schedule of adding students to the course, the course does not appear for selection only the courses for the fall 2021 marking period. I also notice in the course catalog that my course with a custom date range does not show a marking period. Any suggestions or fix for custom date courses? Thank you
Hi I have a course with a custom date range. When I try to do a group schedule of adding students to the course, the course does not appear for selection only the courses for the fall 2021 marking period. I also notice in the course catalog that my course with a custom date range does not show a marking period. Any suggestions or fix for custom date courses? Thank you
Hi I have a course with a custom date range. When I try to do a group schedule of adding students to the course, the course does not appear for selection only the courses for the fall 2021 marking period. I also notice in the course catalog, my course with a custom date range does not show a marking period. Any suggestions or fix for custom date courses? Thank you
Hi I have a course with a custom date range. When I try to do a group schedule of adding students to the course, the course does not appear for selection only the courses for the fall 2021 marking period. I also notice in the course catalog, my course with a custom date range does not show a marking period. Any suggestions or fix for custom date courses? Thank you
In version 8, how can I set up the Grade configuration? I need to change the passing grade and also a special grade to say when the credits are earned and when not (transferred, etc.). Thanks for your help Dr Jonathan Bersot Ph. D., M.A. (th.), M. Éd. www.waast.org - www.fatad.org
How i can change the copyright option in Opensis 8.0 version? Can anyone help me?
How do I use this for my umbrella school? I need it to allow each family to only see their students and input grades and attendance for each of their students they are teaching. Can this be done? Do I set the parent up as a teacher? How do I connect a teacher to specific students?
Attachment download not possible from message received from teacher or received to teacher download file name is DownloadWindow.txt if we download from send item the download is working fine any solution for this please Thank you
Sorry to hear that. Why don't you try the latest openSIS code? We are now using GitHub as the main repo. https://github.com/OS4ED/openSIS-Classic Let me know how this goes. If you face difficulties, do a screen cast and share the link in GH. We would try to replicate the issue and resolve it. Thanks
I have installed OpenSIS(v6.5) via softaculous. The installation completes successfully and I can access the login page via the relevant link. Upon entering credentials and logging in, it redirects to a blank page and that's it. Won't go any further. Solutions found and tried: Set php execution time to 3600 Turned off strict mode in MYSQL Installed on another website's cpanel downgraded to MySQL 5.7 Tried MariaDB 10.4 All to no avail. Any suggestions would be greatly appreciated. Thank you.
I have installed OpenSIS(v6.5) via softaculous. The installation completes successfully and I can access the login page via the relevant link. Upon entering credentials and logging in, it redirects to a blank page and that's it. Won't go any further. Solutions found and tried: Set php execution time to 3600 Turned off strict mode in MYSQL Installed on another website's cpanel downgraded to MySQL 5.7 Tried MariaDB 10.4 All to no avail. Any suggestions would be greatly appreciated. Thank you.
Hi, When trying to create a student, I get an error "Please enter a valid birthdate." The calendar icon does not open a date selector. So I tried every possible date format: yyyy-mm-dd, Jan/02/1993, etc. Nothing seems to be working. Anyone facing the same issue or have any suggestions? Thank you.
Hello dear, Configuration.php in this path: modules/grades isn't working, page is ERROR 500... how to fix it?
opensis not updated on Softaculous what shall i do ?
I translated the whole file ... Download it from attach's... Now, How do I change the alignment? is there a global CSS file that I can edit?
I translated the whole file ... but in a way that suits my educational institution ... Now, How do I change the alignment? is there a global CSS file that I can edit?
I translated the whole file ... but in a way that suits my educational institution ... Now, How do I change the alignment? is there a global CSS file that I can edit?
This is because in the install/OpensisProcsMysqlInc.sql file the rank is declared as numeric, but in newer versions of MySQL this is a reserved word (RANK (R); added in 8.0.2 (reserved))
Mohammad, Thanks for your post. Please use the language file from here: https://github.com/OS4ED/openSIS-Responsive-Design/blob/master/lang/lang_en.php This is the English file. You can change the literals within " " in Arabic and send us the file to info@os4ed.com We will then make the right to left template and upload it to the demo site so that you can check it for correctness. Once confirmed, we will me commit the file to the repository. Regards
I am trying to translate opensis 7.6 to Arabic which is a Right to Left language. Is there a specific file that contains all the phrases or they are scattered? How do I change the alignment? is there a global CSS file that I can edit?
The dates are required because that marks the beginning and end of the Full Year school term. OpenSIS must know when a school term begins and ends so that it can track student progress from one grade level to graduation. School term date ranges are also used when "rolling over" the old school year term to the next. The school calendar uses these dates because it is assumed school related events occur during the active school term. You can change the beginning and end dates. On the main menu, go to...
The dates are required because that marks the beginning and end of the Full Year school term. OpenSIS must know when a school term begins and ends so that it can track student progress from one grade level to graduation. School term date ranges are also used when "rolling over" the old school year term to the next. The school calendar uses these dates because it is assumed school related events occur during the active school term. You can change the beginning and end dates. On the main menu, go to...
I'm attempting to upgrade a 6.5 installation to v7, and after entering MySQL credentials I get an essentially blank screen. Where does one look to find diagnostic information to identify the problem? In php.ini I have max_execution_time=600 and display_errors = On. Does OpenSIS produce any of its own log files I can examine? Any guidance will be appreciated Davewww.hbcfrankfort.org
Hi, We are a group of Master degree students at the institute of technology and management, TU Berlin. This Questionnaire is a part of our research for the term paper we are working on. Please fill the questionnaire. The link is given below: https://forms.gle/HoBTjy8BR2RXiHVh6 You don't necessarily need to be a FOSS contributor to fill the form. We appreciate all the input! If you encounter issues when filling the form, please feel free to write to me. Thank you for your time in advance,
Hi, I am trying to install openSIS CE 7.3 using cPanel on my shared hosting account. I created a mysql user, SWhen I run the Installation wizard of the openSIS (extracted to a directory folder), I get a message that says Access denied for user 'mysqluser-I-created'@'localhost' to database 'databasename'
When I installed openSIS it required start and end dates, now when I set calendars it requires I use those dates. Why are they required? Is there a way to change them?
There could be a data issue. Please purchase support contract and have OS4ED resolve it.
This could be due to MyQL scrtict mode on. USe this command. mysql -u root -p -e "SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';"
what is wrong with openSIS after installing, i see the screen not showing login page
As for the support icon, the code is also in the Modules.php file, but near the top of the file. Search for the text "". It lives within this DIV. Notice that there is IF/ELSE logic checking for the user profile/role. However, it appears that all of the links are the same.
If you're using version 7.4, the footer copyright text is found in the Modules.php file (in the root directory). It's near the bottom of the file.
I upgraded from 7.2 to 7.4. Rollover still does not work.
Has anyone else faced an issue while trying to rollover the academic year? Last academic year we were on the older version and did not have any trouble. This time around we are on ver 7.2 and when we intiate the rollover it is stuck on the screen where it says School year rolling over, please wait.... Anyone else facing this? Any suggestions?
I had the same problem with MySQL 8. To resolve, I had to use MySQL 5.7 instead. Also, I was able to install using MariaDB 10.23 (the non-Oracle fork of MySQL). Something in the SQL syntax is not compatible with version 8 of MySQL, but the syntax is accepted by MySQL 5.7 and MariaDB 10. Maria download at: https://mariadb.org/
hi, any luck on this one?
Hi, I want to add year in copyright area which file i need to modify? and also add a new button next to opensis support. Can any one help? I have attached screen shots of both copyright footer and support menu link. Thanks for your help.
please add arabic translation for json in opensis 7.3 , the file in attachment.
Bug fixes
User reported defect fixes
Geting this error in both version 6.5 and 7.3 during installation.. Using WAMP with following config Apache 2.4.41 PHP 7.3.12 MySQL 8.0.18 Port 3308 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank NUMERIC; declare cur1 cursor for select mp.markingperiodid, ' at line 9
Hi there, After I create a field "Notes" under categrory "Enrollment info", I can't edit or remove it. Please check the attachment, thanks. Regards, Tony Shi
hi, when i go to enter a primary teacher in open sis community edition version 6.5, no teacher load. i have 3 teachers in the system with start dates and everything filled out. yet no teachers load. can someone help me with this issue ?
hello, i have run into the same issue . I have start dates entered for all tecahers and eveything in my program is set up but when i want to enter a primary tecaher no tecahers load except "n/a". i even trued using the beta school in the systen and any new teachers added will not load. anyone know how to fix this ?
incorrect validation removed
To generate report card with percentage only, just do not use any grade scale. Enter final grades as percentage and when generating report card select the show percentage switch.
Make sure the course period is using the Grade scale where you have added the GP values. Most common mistake is that the course period does not have grade scale associated.
Looks like a permission issue. Please download the latest version, 7.3 and try it. We fixed many things in the latest build. If you still get the error, report it back and we will look into it.
Click on the + sign under First Term
There are no utilities to delete the sample school. You can try to use SQL and delete records that matches the school id number of the sample school. It is recommended that when you use openSIS for production, do a fresh install with your real school. If you have a budget, send it to info@os4ed.com and we can clean it for you for $200.
openSIS Community Edition responsive design commit
Deprecated code for non-responsive version
Deprecated code. openSIS non-responsive version 6.5