Moodle

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 1.8, 1.8.1, 1.8.2, 1.8.3, 1.8.4, 1.8.5, 1.8.6, 1.8.7, 1.8.8, 1.8.9, 1.8.10, 1.9, 1.9.1, 1.9.2, 1.9.3, 1.9.4, 1.9.5, 1.9.6
• Fix Version/s: None
• Component/s: Administration
• Labels:

  None
• Environment:

  Linux + Postgres

Hi,

The create password option fails to get actioned by the admin/cron.php script when running on Postgres. This can be replicated when uploading users and selecting "Create password if needed" for the New User Password setting.

When the cron executes there is a query in the admin/cron.php file (approx line 350) which fails on the following where:
WHERE p.name='create_password' AND p.value=1 AND u.email !=''
to keep postgres happy the 1 should have quotes like so:
WHERE p.name='create_password' AND p.value='1' AND u.email !='' "

I have attached a patch with resolves the above.

Cheers,
Luke

1. 

   create_password.patch

   25/Nov/09 12:43 PM

   0.7 kB

   Luke Tucker

• Assignee:

  Dan Poltawski

  Reporter:

  Luke Tucker

  Participants:

  Dan Poltawski, Luke Tucker

• Created:

  25/Nov/09 12:43 PM

  Updated:

  24/Feb/10 5:51 AM

  Resolved:

  24/Feb/10 5:51 AM