Posts made by Jerry Lau

Moodle in English -> General help -> File not found. Empty spaces in filename workaround? -> Re: File not found. Empty spaces in filename workaround?

by Jerry Lau -

It looks like their moodle, 2.6.4+ (build 20140821) does not seem to automatically insert dashes or underscores where there are spaces in their file names.

Can this be fixed retroactively and moving forward?

They are using Redhat 6 ES, Apache 2.4, PHP-FPM (fast cgi) and PHP 5.5

Any suggestions on how to fix this once and for all?

Thanks



Average of ratings: -

Moodle in English -> General help -> File not found. Empty spaces in filename workaround?

by Jerry Lau -

Hello,


I have a colleague who believes the reason why their users are having problems with accessing files because the files have spaces in the names.

More information about this error

Debug info:
Error code: filenotfound

Stack trace:

  • line 463 of /lib/setuplib.php: moodle_exception thrown
  • line 1955 of /lib/filelib.php: call to print_error()
  • line 4584 of /lib/filelib.php: call to send_file_not_found()
  • line 38 of /pluginfile.php: call to file_pluginfile()

They are using Linux as their platform and MS SQL server on the back end.

Their Moodle version is: Moodle 2.6.4+ (Build: 20140821)

How can they fix the current file name problems and prevent this from happening in the future (short of telling their users not to use spaces as part of their file names)

Will globally changing the file name in the mdl_file to remove the spaces work as it points to a hash file anyway? If so, the best of way of doing it via script or SQL/DML language?

Thanks




Average of ratings: -

Moodle in English -> General help -> Moodle 2.6+ , MariaDB 10.x, and MySQL Fabric

by Jerry Lau -

Hello folks,

We are running 2.6.4+ (2010717) on Redhat Enterprise 6.5 64-bit, php 5.3.3+ and MySQL 5.1.77 source distro.

We are investigating and planning to replace our MySQL with MariaDB 10.x instead.

Has anybody used this combination in production and would love your observation and general issues you have encountered.

I am also looking at MySQL Fabric and investigate its use as a failover option. 

Has anyone used MySQL Fabric with Moodle and what are the gotchas?

This is to plan when we move to 2.8.x and above next year... we have a year to test thoughtful whether it is worth doing the replacement or not.

Thank you.

Jerry





Average of ratings: -

Moodle in English -> Authentication -> SQL statement assistance - how to update field with same value from another field in same table -> Re: SQL statement assistance - how to update field with same value from another field in same table

by Jerry Lau -

Thank you Peter. We have used the built in tool already to insert that data.

We are just making sure we want to update those records that don't have value in the idnumber field before we implemented the use of the builtin tool from moodle that's all. We only started using this a week ago. We have about 75,000 that are empty approve

Average of ratings: -