Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-81902

Error writing to database when registering phone number

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Minor Minor
    • None
    • 4.5
    • Messages
    • 2
    • Team Hedgehog 2024 Sprint 2.1

      While testing it and I get an error in the insert when I register my phone number (Note: I got the SMS message but the record is not stored in the sms_messages table. ) See error message: 

       

      Error writing to database (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 'sensitive,status,gatewayid,timecreated) VALUES('+34649702222',NULL,'factor_sms',' at line 1 INSERT INTO mdl_sms_messages (recipientnumber,content,component,messagetype,recipientuserid,sensitive,status,gatewayid,timecreated) VALUES(?,?,?,?,?,?,?,?,?) [array ( 0 => '+34649709238', 1 => NULL, 2 => 'factor_sms', 3 => 'factor', 4 => NULL, 5 => 1, 6 => 'gateway_sent', 7 => 1, 8 => 1715079983, )])

       

       

      Server: MySQL (8.0.36-0)

      Note: This is happening with a clean instance and after the upgrade. 

            michaelh Michael Hawkins
            safat.shahin@moodle.com Safat Shahin
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 7 minutes
                7m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.