Due to the 5,000 items threshold limitation it can become very frustrating to administrate Sharepoint. For example, if your list has more than 5,000 items, you cannot add an index, delete a lookup/people column, delete the list or the website, and more ! Hopefully some of the operations can be done with REST API, and […]

Continue reading...

Finding the documentation for the Search REST API of Sharepoint is difficult…. There is a very old blog post that I’m going to replicate here to give more visibility:   Location of the Search Rest service The Search REST service is located at the following URI: http://host/site/_api/search   The Search REST API The Search REST […]

Continue reading...

After diging around for an exim4 problem (remote_smtp: message is too big (transport limit = 1)), I found the answer in this post: Add “IGNORE_SMTP_LINE_LENGTH_LIMIT=1” in the exim4 config file (/etc/exim4/update-exim4.conf.conf), then restart exim4

Continue reading...

With Sharepoint you can use SP.Utilities.Utility.SendEmail to send email in JavaScript, however you could receive the below error: “The e-mail message cannot be sent. Make sure the e-mail has a valid recipient.” After searching the web, I found the solution: instead of using an email address for the recipients you have to use the userDomain […]

Continue reading...

When I want to reload my MariaDB server, I receive the below error: /usr/bin/mysqladmin: connect to server at ‘localhost’ failed error: ‘Access denied for user ‘root’@’localhost’ (using password: NO)’ The solution is to provide the root’s password in the file `/etc/mysql/debian.cnf` and then the error is gone!

Continue reading...

As explained in some threads, Internet Explorer adds some invisible extra characters when returning a date from the JavaScript function new Intl.DateTimeformat. var day = “Thursday”; var intlDay = new Intl.DateTimeFormat(‘en-US’, {weekday:”long”}).format(new Date(2019,1,7)); console.log(day === intlDay); // return FALSE with IE intlDay = intlDay.replace(/\u200E/g, ”); // replace \u200E console.log(day === intlDay); // return TRUE with […]

Continue reading...

Sources: https://stackoverflow.com/questions/44988163/create-self-signed-certificate-for-testing-localhost-and-have-it-accepted-by-the http://woshub.com/how-to-create-self-signed-certificate-with-powershell/ https://stackoverflow.com/questions/4691699/how-to-convert-crt-to-pem/4691749#4691749 https://webpack.js.org/configuration/dev-server/#devserver-https If you develop with Webpack under Windows and you want to open your localhost server in HTTPS with IE11 you may receive a message like : “Content was blocked because it was not signed by a valid security certificate.” Below I explain the steps to make it work with IE11: […]

Continue reading...

(this is a copy of a post that is not available anymore) DateRangesOverlap Value Type I don’t know if any back-end developers have run into this same issue when working with the SPQuery to pull expanded recurrence date, but from here, not all DateRangesOverlap Value types work the way they should. And they’re cryptically-documented, where […]

Continue reading...

I wanted to inject some codes on Github, however I received Content Security Policy errors. It’s because Github blocks this kind of injected code. To bypass this restriction I installed the addon Content Security Policy Override (if you have Firefox you can install this Chrome addon using Chrome Store Foxified) then I applied the below […]

Continue reading...

I have this document library on Sharepoint where I have one custom column called Metadata and that is a lookup to another list on my Sharepoint. When the users download an Office document from this library and then re-upload it we could have the below error message: There is at least one lookup column that […]

Continue reading...