Failure Notice: DB Execute Failed

[ericfalcon]

System: Logiciel de gestion ROSARIO
IP: 92.132.16.144
Date: 2025-01-07 13:53:53
User: admin
Profile: admin
Page: /Modules.php
Query string: modname=Custom/Registration.php
Can use modname: true
Referrer: https://rosariosis.fr/Modules.php?modname=Scheduling/Courses.php&subject_id=5&course_id=9&course_period_id=11&course_marking_period_id=1

Error:
Array
(
[0] => Failure Notice: DB Execute Failed.
[1] => Additional Info: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:1:"Y";s:7:"address";s:...' at line 1
[2] => INSERT INTO config (config_value,title,school_id) values('a:4:{s:6:"parent";a:2:{i:0;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:1:"Y";s:7:"address";s:1:"1";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}i:1;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:0:"";s:7:"address";s:0:"";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}}s:7:"address";a:1:{s:6:"fields";s:0:"";}s:7:"contact";a:0:{}s:7:"student";a:1:{s:6:"fields";s:8:"||1||2||";}}','REGISTRATION_FORM','0');
)

Request Array:
Array
(
[modname] => Custom/Registration.php
[modfunc] =>
[search_modfunc] =>
[student_id] =>
)

Session Array:
Array
(
[DefaultSyear] => 2024
[token] => d72ff77ff0f49734a1975999baecbb3b
[locale] => fr_FR.utf8
[STAFF_ID] => 1
[LAST_LOGIN] => 2025-01-06 10:58:56
[UserSyear] => 2024
[FORCE_PASSWORD_CHANGE_USERNAME] => admin
[UserSchool] => 1
[List_PHP_SELF] => Modules.php?modname=Scheduling/Schedule.php&search_modfunc=list&grade=11&course_period_select=5,9,11&w_course_period_id_which=course_period&w_course_period_id=11&w_course_id=9&w_subject_id=5&day_date=07&month_date=01&year_date=2025
[Back_PHP_SELF] => student
[UserCoursePeriod] =>
[staff_id] =>
[UserMP] => 6
[StudentsImport.php] => Array
(
[original_file_name] => TP SAMS CLMT 25 - Liste des stagiaires online pro (1).csv
)

[ReportsBottomButtons] => 1
[MassSchedule.php] => Array
    (
    )

[student_id] =>

)

Debug Backtrace:
Array
(
[0] => Array
(
[file] => /home/have4739/rosariosis.fr/database.inc.php
[line] => 690
[function] => ErrorSendEmail
[args] => Array
(
[0] => Array
(
[0] => Failure Notice: DB Execute Failed.
[1] => Additional Info: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:1:"Y";s:7:"address";s:...' at line 1
[2] => INSERT INTO config (config_value,title,school_id) values('a:4:{s:6:"parent";a:2:{i:0;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:1:"Y";s:7:"address";s:1:"1";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}i:1;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:0:"";s:7:"address";s:0:"";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}}s:7:"address";a:1:{s:6:"fields";s:0:"";}s:7:"contact";a:0:{}s:7:"student";a:1:{s:6:"fields";s:8:"||1||2||";}}','REGISTRATION_FORM','0');
)

                [1] => Database Error
            )

    )

[1] => Array
    (
        [file] => /home/have4739/[rosariosis.fr/database.inc.php](http://rosariosis.infrep63.fr/database.inc.php)
        [line] => 162
        [function] => db_show_error
        [args] => Array
            (
                [0] => INSERT INTO `config` (`config_value`,`title`,`school_id`) values('a:4:{s:6:"parent";a:2:{i:0;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:1:"Y";s:7:"address";s:1:"1";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}i:1;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:0:"";s:7:"address";s:0:"";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}}s:7:"address";a:1:{s:6:"fields";s:0:"";}s:7:"contact";a:0:{}s:7:"student";a:1:{s:6:"fields";s:8:"||1||2||";}}','REGISTRATION_FORM','0');
                [1] => DB Execute Failed.
                [2] => 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:1:"Y";s:7:"address";s:...' at line 1
            )

    )

[2] => Array
    (
        [file] => /home/have4739/[rosariosis.fr/database.inc.php](http://rosariosis.infrep63.fr/database.inc.php)
        [line] => 233
        [function] => db_query
        [args] => Array
            (
                [0] => INSERT INTO `config` (`config_value`,`title`,`school_id`) values('a:4:{s:6:"parent";a:2:{i:0;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:1:"Y";s:7:"address";s:1:"1";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}i:1;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:0:"";s:7:"address";s:0:"";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}}s:7:"address";a:1:{s:6:"fields";s:0:"";}s:7:"contact";a:0:{}s:7:"student";a:1:{s:6:"fields";s:8:"||1||2||";}}','REGISTRATION_FORM','0');
            )

    )

[3] => Array
    (
        [file] => /home/have4739/[rosariosis.fr/functions/DBUpsert.php](http://rosariosis.infrep63.fr/functions/DBUpsert.php)
        [line] => 91
        [function] => DBQuery
        [args] => Array
            (
                [0] => INSERT INTO `config` (`config_value`,`title`,`school_id`) values('a:4:{s:6:"parent";a:2:{i:0;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:1:"Y";s:7:"address";s:1:"1";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}i:1;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:0:"";s:7:"address";s:0:"";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}}s:7:"address";a:1:{s:6:"fields";s:0:"";}s:7:"contact";a:0:{}s:7:"student";a:1:{s:6:"fields";s:8:"||1||2||";}}','REGISTRATION_FORM','0');
            )

    )

[4] => Array
    (
        [file] => /home/have4739/[rosariosis.fr/modules/Custom/includes/Registration.fnc.php](http://rosariosis.infrep63.fr/modules/Custom/includes/Registration.fnc.php)
        [line] => 56
        [function] => DBInsert
        [args] => Array
            (
                [0] => config
                [1] => Array
                    (
                        [CONFIG_VALUE] => a:4:{s:6:"parent";a:2:{i:0;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:1:"Y";s:7:"address";s:1:"1";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}i:1;a:7:{s:8:"relation";s:23:"Maître d'apprentissage";s:7:"custody";s:1:"Y";s:9:"emergency";s:0:"";s:7:"address";s:0:"";s:4:"info";s:0:"";s:13:"info_required";s:0:"";s:6:"fields";s:0:"";}}s:7:"address";a:1:{s:6:"fields";s:0:"";}s:7:"contact";a:0:{}s:7:"student";a:1:{s:6:"fields";s:8:"||1||2||";}}
                        [TITLE] => REGISTRATION_FORM
                        [SCHOOL_ID] => 0
                    )

            )

    )

[5] => Array
    (
        [file] => /home/have4739/[rosariosis.fr/modules/Custom/Registration.php](http://rosariosis.infrep63.fr/modules/Custom/Registration.php)
        [line] => 71
        [function] => RegistrationFormConfig
        [args] => Array
            (
            )

    )

[6] => Array
    (
        [file] => /home/have4739/[rosariosis.fr/Modules.php](http://rosariosis.infrep63.fr/Modules.php)
        [line] => 56
        [args] => Array
            (
                [0] => /home/have4739/[rosariosis.fr/modules/Custom/Registration.php](http://rosariosis.infrep63.fr/modules/Custom/Registration.php)
            )

        [function] => require_once
    )

)

[francoisjacquet]

Hello @ericfalcon

Thank you for the bug report.

Please read #252