Input Final Grades - Rosario

[LeoRAS]

Goodmorning Francois,

I have a version of Rosario on paid Webhosting. When I clicked Input Final Grade (as Teacher or Admin), I encountered the following error:

We have a problem, please contact technical support...

Date: 07/15/2014 09:38:26

Failure Notice: DB Execute Failed.

Additional Information: ERROR: function credit(integer, unknown) does not exist LINE 1: ...ITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit(2, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

This issue has been posted before, but was apparently discontinued by the opener. On basis of your response I checked the page source, however I cannot find the Web developer --> Page Source ?

I have another version on WAMP server where this problem does not occur.

Thank you.

[francoisjacquet]

Hello @LeoRAS,

Thank you for your bug report,

could you please click right on the message in Firefox and click Inspect element. Then, you should see the <!-- SQL STATEMENT part after in the source. It would be useful to me if you could copy the whole statement.

François

Le 15/07/2014 04:45 a.m., LeoRAS a écrit :

Goodmorning Francois,

I have a version of Rosario on paid Webhosting. When I clicked Input Final Grade (as Teacher or Admin), I encountered the following error:

We have a problem, please contact technical support...

Date: 07/15/2014 09:38:26

Failure Notice: DB Execute Failed.

Additional Information: ERROR: function credit(integer, unknown) does not exist LINE 1: ...ITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit(2, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

This issue has been posted before, but was apparently discontinued by the opener. On basis of your response I checked the page source, however I cannot find the Web developer --> Page Source ?

I have another version on WAMP server where this problem does not occur.

Thank you.

— Reply to this email directly or view it on GitHub https://github.com/francoisjacquet/rosariosis/issues/50.

[LeoRAS]

Hello Francois, Found it, however I cannot copy-paste so I am typing. (Also, cannot include the html comment signs.)

SQL STATEMENT:

SELECT cp.COURSE_ID,c.TITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit(3, '7') AS CREDITS, DOES_CLASS_RANK AS CLASS_RANK, c.CREDIT_HOURS FROM COURSE_PERIODS cp, COURSES c WHERE cp.COURSE_ID = c.COURSE_ID AND cp.COURSE_PERIOD_ID='3'

Thank you.

[LeoRAS]

Hello Francois, Related to this issue, I want to refer to a conversation some time ago with the helpdesk of my hosting platform:

Goodmorning,

Thank you so much, the connection problems have been resolved now.

The new problem is: when importing data into Postgre, it only reads structure, not data. In the initial SQL file, there is a minimum of data to setup the admin account for example. See table 'Staff'. There should be data here.

When testing this same SQL file in phppgadmin of WAMPserver it works fine.

See SQL file in attachment. Thank you.

MonJul 7 2014 8:31am - Peter Smith
Hello Leo,

Thank you for contacting us.

Could you please provide exact steps you are taking, so we can try and replicate this issue? Please also let us know if you're getting any error messages.

Awaiting your reply.

Best Regards, Peter Smith

MonJul 7 2014 8:56am Dear Sir,

I've destroyed all previous Postgre databases and created the latest 1696591_sis (via my dashboard).

Entered phpPgadmin.

Selected the database on the left panel, then clicked SQL button on right panel.

Uploaded the SQL file via menu at bottom of page (browse --> execute) (pls. note that when sql file is copy-pasted and not uploaded via file, not even 1 table is created. This is not working at all. Maybe because file is large.)

Postgre executes the file when uploaded. At the top. I get some errors that do not influence the import of data like :

(rosariosis.sql:28: ERROR: language "plpgsql" does not exist HINT: Use CREATE LANGUAGE to load the language into the database.)

However, at the bottom of the sql query where the data is inserted I get:

rosariosis.sql:5600: ERROR: function t_update_mp_stats() does not exist Total runtime: 16,375.171 ms SQL executed.

Please feel free to work in the database of my account to test and resolve this issue.

Thank you.

MonJul 7 2014 9:00am - Peter Smith

Hello Leo,

Thank you for contacting us.

Please allow us some time to investigate this issue and we will get back to you as soon as possible.

Thank you for your patience.

Best Regards, Peter Smith

MonJul 7 2014 9:03am - Peter Smith
Hello Leo,

I've confirmed the issue. I'm now passing the ticket to the admins, so that they can resolve the problem. I can't give out a timeline, since no such timeline has been given to us.

Best Regards, Peter Smith

MonJul 7 2014 12:06pm - Peter Smith
Hello Leo,

Thank you for your patience.

We have looked into your issue and we managed to pinpoint the exact problem. It seems that it is not possible to create trigger functions in C on our shared hosting platform. We apologize for the caused inconvenience.

Feel free to reopen this ticket in case you have more questions or you need further assistance.

Thank you for choosing our services.

Best Regards, Peter Smith

[francoisjacquet]

Hello Leo,

could you please update the InputFinalGrades.php file (in modules/Grades folder) with the fix in this commit (the additions are in green): https://github.com/francoisjacquet/rosariosis/commit/e75f76ffac08e4f33311d7b004ae56e62df1458e

If the fix works for you, I will publish it in the next release.

[LeoRAS]

Hello Francois, I've edited the lines, but to no avail. I get the same error. I've copy pasted this part of my InputFinalGrades.php below. Did you read my previous comment ? Does web hosting allow enough permissions etc. to run Rosario ? It's not easy to find one because of the Postgre. Thank you.

//modif Francois: add CLASS_RANK //modif Francois: add Credit Hours //$course_RET = DBGet(DBQuery("SELECT cp.COURSE_ID,c.TITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit($course_period_id, '".$_REQUEST['mp']."') AS CREDITS, (SELECT ATTENDANCE FROM SCHOOL_PERIODS WHERE PERIOD_ID=cp.PERIOD_ID) AS ATTENDANCE FROM COURSE_PERIODS cp, COURSES c WHERE cp.COURSE_ID = c.COURSE_ID AND cp.COURSE_PERIOD_ID='".$course_period_id."'")); //$course_RET = DBGet(DBQuery("SELECT cp.COURSE_ID,c.TITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit($course_period_id, '".$_REQUEST['mp']."') AS CREDITS, DOES_CLASS_RANK AS CLASS_RANK, c.CREDIT_HOURS FROM COURSE_PERIODS cp, COURSES c WHERE cp.COURSE_ID = c.COURSE_ID AND cp.COURSE_PERIOD_ID='".$course_period_id."'")); $course_RET = DBGet(DBQuery("SELECT cp.COURSE_ID,c.TITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit(".$course_period_id."::integer, '".$_REQUEST['mp']."'::varchar) AS CREDITS, DOES_CLASS_RANK AS CLASS_RANK, c.CREDIT_HOURS FROM COURSE_PERIODS cp, COURSES c WHERE cp.COURSE_ID = c.COURSE_ID AND cp.COURSE_PERIOD_ID='".$course_period_id."'")); if(!$course_RET[1]['GRADE_SCALE_ID'])

[francoisjacquet]

Hello Leo,

Yes I read your previous comment. My comment on this is that RosarioSIS needs the t_update_mp_stats() trigger to run properly. Your provider says it is not possible to create trigger functions in C on their shared hosting platform. So my answer would be no, it is not possible to run RosarioSIS. Maybe you should try with a dedicated server, it is more complicated though as you need to configure it. I also offer RosarioSIS hosting on my server.

As for your specific error, (credit() is not a trigger), I would like to do one more intent: https://github.com/francoisjacquet/rosariosis/commit/79953046baa176c881a410c7f6501b164298fc0a Could you please copy the line in green?

François

Le 17/07/2014 03:37 a.m., LeoRAS a écrit :

Hello Francois, I've edited the lines, but to no avail. I get the same error. I've copy pasted this part of my InputFinalGrades.php below. Did you read my previous comment ? Does web hosting allow enough permissions etc. to run Rosario ? It's not easy to find one because of the Postgre. Thank you.

//modif Francois: add CLASS_RANK //modif Francois: add Credit Hours //$course_RET = DBGet(DBQuery("SELECT cp.COURSE_ID,c.TITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit($course_period_id, '".$_REQUEST['mp']."') AS CREDITS, (SELECT ATTENDANCE FROM SCHOOL_PERIODS WHERE PERIOD_ID=cp.PERIOD_ID) AS ATTENDANCE FROM COURSE_PERIODS cp, COURSES c WHERE cp.COURSE_ID = c.COURSE_ID AND cp.COURSE_PERIOD_ID='".$course_period_id."'")); //$course_RET = DBGet(DBQuery("SELECT cp.COURSE_ID,c.TITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit($course_period_id, '".$_REQUEST['mp']."') AS CREDITS, DOES_CLASS_RANK AS CLASS_RANK, c.CREDIT_HOURS FROM COURSE_PERIODS cp, COURSES c WHERE cp.COURSE_ID = c.COURSE_ID AND cp.COURSE_PERIOD_ID='".$course_period_id."'")); $course_RET = DBGet(DBQuery("SELECT cp.COURSE_ID,c.TITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit(".$course_period_id."::integer, '".$_REQUEST['mp']."'::varchar) AS CREDITS, DOES_CLASS_RANK AS CLASS_RANK, c.CREDIT_HOURS FROM COURSE_PERIODS cp, COURSES c WHERE cp.COURSE_ID = c.COURSE_ID AND cp.COURSE_PERIOD_ID='".$course_period_id."'")); if(!$course_RET[1]['GRADE_SCALE_ID'])

— Reply to this email directly or view it on GitHub https://github.com/francoisjacquet/rosariosis/issues/50#issuecomment-49273461.

[LeoRAS]

Hello Francois, Unfortunately, this one's also not working, still the same error ........ Leo

[ghost]

Hi Francois,

I am having exactly the same error.

Failure Notice: DB Execute Failed. Additional Information: ERROR: function credit(integer, unknown) does not exist LINE 1: ...ITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit(2, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

I've applied the suggested modifications, still with same error.

[francoisjacquet]

Hello Bishnu,

What are your host specifications? Did you have any error during the rosariosis.sql file instructions import?

Th issue will be hard for me to resolve as I cannot reproduce it unfortunately.

Le 01/08/2014 07:43 p.m., bishnusharma a écrit :

Hi Francois,

I am having exactly the same error.

Failure Notice: DB Execute Failed. Additional Information: ERROR: function credit(integer, unknown) does not exist LINE 1: ...ITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit(2, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

I've applied the suggested modifications, still with same error.

— Reply to this email directly or view it on GitHub https://github.com/francoisjacquet/rosariosis/issues/50#issuecomment-50948880.

[francoisjacquet]

Thank you for your comment @bishnusharma . Please see the commit above, should fix the issue.

[ghost]

Hi, Just applied the fix, and still the same error: Date:
08/10/2014 05:15:27 Failure Notice: DB Execute Failed. Additional Information: ERROR: function credit(integer, character varying) does not exist LINE 1: ...ITLE as COURSE_NAME, cp.TITLE, cp.GRADE_SCALE_ID, credit(CAS... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

[francoisjacquet]

The function credit(integer, character varying) is created via the SQL commands in the rosariosis.sql file. If you had an error when importing those commands in the database, you will not be able to use RosarioSIS properly (hence the error), see above messages in the same thread.

[ghost]

Strange enough, when I imported rosariosis.sql, no error there. But, it triggers while running the script.

[francoisjacquet]

A simple way to be sure if you have the credit function is to browse the functions of your database via phpPGadmin.

Le 10/08/2014 05:27 p.m., bishnusharma a écrit :

Strange enough, when I imported rosariosis.sql, no error there. But, it triggers while running the script.

— Reply to this email directly or view it on GitHub https://github.com/francoisjacquet/rosariosis/issues/50#issuecomment-51729446.

[kbjaoui]

Hi Francois,

I am having exactly the same error.

We have a problem, please contact technical support ... Date:
09/20/2017 03:48:24 Failure Notice: DB Execute Failed. Additional Information: ERREUR: la relation � config � n'existe pas LINE 2: FROM CONFIG ^

SQL STATEMENT:

SELECT TITLE, CONFIG_VALUE FROM CONFIG WHERE SCHOOL_ID='0'

Thank you.

[francoisjacquet]

Hello @kbjaoui

What does the diagnostic.php page tell? https://github.com/francoisjacquet/rosariosis/blob/mobile/INSTALL.md#installation-problems