Rollover err DB Execute Failed. ERROR: relation "school_marking_periods_

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

Rollover err DB Execute Failed. ERROR: relation "school_marking_periods_

hhieb

07/10/2020 17:54:22
Date
DB Execute Failed. ERROR: relation "school_marking_periods_marking_period_id_seq" does not exist LINE 4: SELECT nextval('school_marking_periods_marking_period_id... ^
Failure Notice
INSERT INTO SCHOOL_MARKING_PERIODS (MARKING_PERIOD_ID,PARENT_ID,SYEAR,MP,
SCHOOL_ID,TITLE,SHORT_NAME,SORT_ORDER,START_DATE,END_DATE,POST_START_DATE,
POST_END_DATE,DOES_GRADES,DOES_COMMENTS,ROLLOVER_ID)
SELECT nextval('school_marking_periods_marking_period_id_seq'),PARENT_ID,SYEAR+1,MP,
SCHOOL_ID,TITLE,SHORT_NAME,SORT_ORDER,START_DATE+365,END_DATE+365,
POST_START_DATE+365,POST_END_DATE+365,DOES_GRADES,DOES_COMMENTS,MARKING_PERIOD_ID
FROM SCHOOL_MARKING_PERIODS
WHERE SYEAR='2019'
AND SCHOOL_ID='2'
SQL query

hhieb

Hello, I'm quite new to rosariosis. Our Rosariosis got 2 school inside and I try to rollover err above.
May you help me point out issue, or any changing to fix issue. Many thanks in advance.

francoisjacquet

Hello hhieb

What is your RosarioSIS version?
What is your server (cPanel, Linux, Windows)?
Have you upgraded from a version inferior to 5.0 lately? (4 or anterior)

hhieb

Hello @francoisjacquet
Currently I use rosariosis 4.8 , and I backup database and try to run on Rosariosis 5.6.2 , v6.7.2 but still got the same issue. I use Ubuntu Linux server 18.04
please help , any more information let me know , thanks.

francoisjacquet

hhieb when you overwrite the (all) files to upgrade from v4.8 to v6.7.2, the database should automatically upgrade when you first access RosarioSIS.
If you still experience the SQL error, this is because the database is not upgraded.

In this case, I recommend you to try to install RosarioSIS 4.8 from scratch and then upgrade to v6.7.2. Then you can compare with your instance and spot which file or what in your configuration is causing the issue.

hhieb

Hello francoisjacquet,

Thanks for your reply and advice and also sorry my write before got you confused.

Actually I got issue with first post err when I try to rollover on rosario V.4.8, and I troubleshoot on it but can't solve it.
then I try backup database to test on new version but still the same problem when click rollover..
( I not try to upgrade my Rosariosis but need to solve rollover on my existing V 4.8 ) , I did your advice to switch to V6.7.2 but no err when login and using rosariosis but got the same err on click rollover.

I try to show err in php code I got information below , please help me on it, many thanks..

Notice: Undefined index: SCHOOL_MARKING_PERIODS in /var/www/html/rosariosis-as/modules/School_Setup/Rollover.php on line 53
string(20) "ATTENDANCE_CALENDARS" ATTENDANCE_CALENDARS

Notice: Undefined index: ATTENDANCE_CALENDARS in /var/www/html/rosariosis-as/modules/School_Setup/Rollover.php on line 53
string(16) "ATTENDANCE_CODES" ATTENDANCE_CODES

Notice: Undefined index: ATTENDANCE_CODES in /var/www/html/rosariosis-as/modules/School_Setup/Rollover.php on line 53
string(18) "REPORT_CARD_GRADES" REPORT_CARD_GRADES

Notice: Undefined index: REPORT_CARD_GRADES in /var/www/html/rosariosis-as/modules/School_Setup/Rollover.php on line 53
string(7) "COURSES" COURSES

Notice: Undefined index: COURSES in /var/www/html/rosariosis-as/modules/School_Setup/Rollover.php on line 53
string(24) "STUDENT_ENROLLMENT_CODES" STUDENT_ENROLLMENT_CODES
string(18) "STUDENT_ENROLLMENT" STUDENT_ENROLLMENT

Notice: Undefined index: STUDENT_ENROLLMENT in /var/www/html/rosariosis-as/modules/School_Setup/Rollover.php on line 53
string(20) "REPORT_CARD_COMMENTS" REPORT_CARD_COMMENTS

Notice: Undefined index: REPORT_CARD_COMMENTS in /var/www/html/rosariosis-as/modules/School_Setup/Rollover.php on line 53
string(14) "PROGRAM_CONFIG" PROGRAM_CONFIG

Notice: Undefined index: PROGRAM_CONFIG in /var/www/html/rosariosis-as/modules/School_Setup/Rollover.php on line 53
string(22) "ELIGIBILITY_ACTIVITIES" ELIGIBILITY_ACTIVITIES

Notice: Undefined index: ELIGIBILITY_ACTIVITIES in /var/www/html/rosariosis-as/modules/School_Setup/Rollover.php on line 53
string(27) "FOOD_SERVICE_STAFF_ACCOUNTS" string(22) "DISCIPLINE_FIELD_USAGE" DISCIPLINE_FIELD_USAGE

Notice: Undefined index: DISCIPLINE_FIELD_USAGE in /var/www/html/rosariosis-as/modules/School_Setup/Rollover.php on line 53

hhieb

Hello Francoisjacquet,
Great day to you.
Thanks for your reply and advises and also sorry for my writing before got you confused with upgrade to new version.
Actually I got issue with with the first post err when try to rollover on v4.8 , but I not sure how to solve with err " school_marking_periods_marking_period_id_seq not exist " . I try to backup database , and test on new version 5.6.2 and v6.7.2 it works with no err sql but still got the same issue with rollover.

(I not try to upgrade to new version yet but try to solve with my rollover first on V.4.8.
If there are way to find way to solve some missing with nextval('school_marking_periods_marking_period_id_seq'), please kindly help me, thanks.

I try to test more with your recommendation.

hhieb

Hello Francoisjacquet,
Great day to you , after verify found missing sq number in two table school_marking_periods , attendance_calendar . After I create new sq below come in postgres , now it works for rollover.
May you help to advice me , this is correct way to solve it. many thanks..

CREATE SEQUENCE marking_period_seq;
ALTER TABLE school_marking_periods ALTER COLUMN marking_period_id SET DEFAULT nextval('marking_period_seq'::regclass);
SELECT * FROM marking_period_seq; // found 1
SELECT max(marking_period_id) from school_marking_periods;

SELECT setval('MARKING_PERIOD_SEQ', 52, true);

CREATE SEQUENCE calendars_seq;
ALTER TABLE attendance_calendar ALTER COLUMN calendar_id SET DEFAULT nextval('calendars_seq'::regclass);
SELECT * FROM calendars_seq; // found 1
SELECT max(calendar_id) from attendance_calendar; //my max id found is 6
SELECT setval('calendars_seq', 6, true);

Mark

Hi Francoisjacquet, i am a new user of RosarioSIS.

Recntly i do the steps to install the system but when i reach the last step (install db) i get the next error message:

DB Execute Failed. 1193 Unknown system variable 'storage_engine'
Failure Notice

I try to solve it but still get the same error.

I jope that you can help me aboout that issue:

My Environment is:
Servidor: Localhost via UNIX socket
Tipo de servidor: MySQL
Conexión del servidor: No se está utilizando SSL Documentación
Versión del servidor: 8.0.31-0ubuntu0.20.04.1 - (Ubuntu)
Versión del protocolo: 10
Conjunto de caracteres del servidor: UTF-8 Unicode (utf8mb4)

Apache/2.4.41 (Ubuntu)
Versión del cliente de base de datos: libmysql - mysqlnd 7.4.3
extensión PHP: mysqliDocumentación curlDocumentación mbstringDocumentación
Versión de PHP: 7.4.3

francoisjacquet

Hello Mark

Thank you for reporting this error introduced in RosarioSIS 10.4.3.
MySQL versions 5.7 & 8.0 are affected. (MySQL 5.6 & MariaDB are OK)
The error was fixed in RosarioSIS 10.5.1, please upgrade (download it and copy the files over the old ones).