Non-core contributed modules

Birthday Block + PostgreSQL

Details

  • Type: New Feature New Feature
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.9.2
  • Fix Version/s: None
  • Component/s: Block: Birthday
  • Labels:
    None
  • Environment:
    The block does not work with postgreSQL.
  • Database:
    PostgreSQL
  • Affected Branches:
    MOODLE_19_STABLE

Description

It did not work in Moodle 1.9.2 with Postgres 8.1.
No error!
It just says, "There are no birthdays today.".

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Anthony Borrow added a comment -

I do not believe it is a security issue - the date function used in the sql query were just not recognized by postgres so I am changing it to use extract which is recognized in both mysql and postgres. Peace - Anthony

Show
Anthony Borrow added a comment - I do not believe it is a security issue - the date function used in the sql query were just not recognized by postgres so I am changing it to use extract which is recognized in both mysql and postgres. Peace - Anthony
Hide
Permalink
Anthony Borrow added a comment -

Ana - I have updated the HEAD version so that we can test the change to ensure it works in both Postgres and MySQL. Let me know if there are problems. I will upload the revised file to make it easier for you to test. Peace - Anthony

Show
Anthony Borrow added a comment - Ana - I have updated the HEAD version so that we can test the change to ensure it works in both Postgres and MySQL. Let me know if there are problems. I will upload the revised file to make it easier for you to test. Peace - Anthony
Hide
Permalink
Anthony Borrow added a comment -

Ana - Here is the revised block_birthday.php file which should work now in both mysql and postgres. Thanks for bringing this issue to my attention. Peace - Anthony

Show
Anthony Borrow added a comment - Ana - Here is the revised block_birthday.php file which should work now in both mysql and postgres. Thanks for bringing this issue to my attention. Peace - Anthony
Hide
Permalink
Anthony Borrow added a comment -

Ana - I am going to go ahead and resolve this but do let me know if there are any issues. It would also help if you let me know if it works for you and then I will commit the change back to the 1.9 version. I just want to have a little verification from someone else that it is in fact working. Peace - Anthony

Show
Anthony Borrow added a comment - Ana - I am going to go ahead and resolve this but do let me know if there are any issues. It would also help if you let me know if it works for you and then I will commit the change back to the 1.9 version. I just want to have a little verification from someone else that it is in fact working. Peace - Anthony
Hide
Permalink
Anthony Borrow added a comment -

Closing all of my resolved issues. Peace - Anthony

Show
Anthony Borrow added a comment - Closing all of my resolved issues. Peace - Anthony

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.