Syndicate content

version

Polylang messes up my canonical link on my website

I just created a new website and added a few plugins, one of which is Polylang. It generally works okay. Not what I really would like to have, but close enough for a Wordpress website.

Only, it has a horrible side effect:

I destroys the canonical URL which instead of appearing as expected appears with a "%pagename%" variable in it. This is because the module caches the results of a previous call and returns that cahed value instead of recomputing it. There isn't really a way for the filter at that low level to know what version should be returned, so it ends up returning the ...

Can I create an INDEX to accelerate a SELECT MIN(IF(...)) in MySQL?

I have a table with a few columns, two of which are integers, one of which can be NULL in which case the other integer is to be used in my query.

CREATE TABLE my_table (col1 INTEGER NOT NULL, col2 INTEGER);

If `col2` is NULL, then use `col1`. As is, there is how my query looks like:

SELECT MIN(IF(col2, col2, col1)) AS smallest FROM my_table LIMIT 1;

In other words, I need to get the row with the smallest integer, but if one column is NULL, I want to use the other column value.

On a very small sample, the query is still very fast, but the real version is not unlikely to have thousands ...

SugarCRM Community Edition for Ubuntu 16.04 with PHP 7

As I wanted to use SugarCRM on my new server, I looked into the Community Edition and apparently the company is not willing to convert their code so it works under PHP 7.

So that would not work on a newer system because the code uses quite a few forbidden mechanism (wrong class definitions, old defunct functions...) and that prevents to even instal the system on your machine.

Now, I have looked closer into it and I am getting a version that works pretty darn well already. I still have some issues here and there, but I think you can already make use of that version. Except for one thing which ...

Old Synergy 64bit version for windows compatible with Ubuntu synergy package version 1.4.12

As I like to have Synergy working on my Windows boxes (i.e. laptops), I am saving a copy of the installer 64 bit version which works fine with WinXP and Win7. I'm about to test it with Win10 which is likely to accept it as is too. Just in case you did not know, Synergy is a driver that takes one mouse device and makes it work on multiple computers. In other words, you can use any number of computers with one mouse and one keyboard. Move the mouse to the right computer and you can use the keyboard on that computer. No need for a KVM anymore (Keyboard Video Mouse device that allowed you to ...

Installing Solaris to compile your software

Now a day I like to install Solaris to check that my code compiles and generally runs under that OS.

I think that's a good way to prove that the code is multi-OS ready even if it is only for Unices.

OpenSolaris is free and can be downloaded from Oracle. The last URL I use was:

http://www.oracle.com/technetwork/server-storage/solaris11/downloads/index.html

The system, by default, comes with a directory named /usr/sfw which includes a really old version of gcc. It is possible, though, to move forward with a newer version of the compiler by installing a package. Under Solaris 11.2, this ...

xhtml2pdf generating an error under 14.04+

Note: This bug is fixed in Ubuntu 16.04

Working on a website I have to convert invoices to PDF so end users have the ability to print and share the invoices from the website.

In order to do that, I generate an HTML page with the invoice which also gets displayed in the website, and then convert that HTML to PDF with xhtml2pdf. I use that tool instead of whtmltopdf because it does not require X11 to work. The other tool is said to require Qt and X11 and we do not want those things on our backend servers.

So... I upgraded to 14.04 and the tool stopped working with an ugly error:

 ...

[ODBC Driver Manager] Data source name not found and no default driver specified

As I was working on a MS-Windows installation, I ran in this weird error: Data source not found and no default driver specified...

This was output when I was running the following in a command line prompt:

osql -E

The result should have been an MSSQL prompt instead!

The problem on the computer was that I uninstalled MSSQL 2005 that was automatically installed by Visual Studio C++ and was not compatible with our application, so I first uninstalled that but that uninstallation is really not proper. It leaves a LOT of things behind.

After that I installed MSSQL 2014 which was reported as ...

List ciphers currently used by Apache2

If you are using Apache and e-Commerce, you probably want to know all the details of the ciphers used by the Apache SSL module.

So listing Apache supported ciphers is done using nmap as follow:

nmap --script ssl-cert,ssl-enum-ciphers -p 443 secure.m2osw.com

This call gives you a complete list of all the ciphers currently accepted by your running version of Apache. For example, the list may look like this:

| ssl-enum-ciphers:
|   SSLv3:
|     ciphers:
|       TLS_DHE_RSA_WITH_3DES_EDE_CBC_SHA - strong
|       TLS_DHE_RSA_WITH_AES_128_CBC_SHA - strong
|       ...

nvidia_XXX.ko No Such Device

Today I got a new video card because it looks like the old one I had was going bad. I hope that was not my KVM, although we'll see when it gets hot again, whether the video goes bouncy again or not... If not, then the old card is good for the trash (although it works in console mode just fine!)

So I got a new card. My old one was a NVidia GT 220. Fairly old model. Yes.

The new card is an NVidia GT 630 (to be precise: Asus GT630-SL-2GD3-L.)

When I tried to start X11, I saw an error (really quick) and the system did not come up. Looking closer into the matter, I could see that the NVidia ...

Remote access to another MS-Windows computer

I have used several different software to gain remote access to other's computers.

With a Unix system, it's easy. You use ssh and you can do everything you want (although some people just cannot handle a console, I'm fine with such, but ssh allows you to access X-Windows if you'd like with the -X command line option.)

With MS-Windows, since that system is just a desktop application, you need a special tool in order to achieve that feat. Most of them are for money or make use of things that do not work under Linux. Yet, there is one that I like, it is called TeamViewer. It was ...

Syndicate content Syndicate content

Diverse Realty

Diverse Realty Team

Want a New Home?
Want to Sell Your House?

Call Alex at
+1 (916)
220 6482

Alexis Wilke, Realtor
Salesperson
Lic. # 02024063

Cory Marcus, Broker
Lic. # 01079165

     

Terms of Site Index

Find the page/content you are looking for with our index.

  • Internet Explorer

    Internet Explorer is the browser offered by Microsoft to browse your file system and the Internet. It is based on the old free software called Mosaic. Now it is borrowing parts of other free software such as Konqueror. It first used Visual Basic as a language, now it supports Javascript very well too. It was a great browser in competition with Netscape 5.x from the start (trying to undermine the company named Netscape.)

  • MS-Access
  • Oracle
  • force
  • reboot

    The action of restarting a computer is called reboot. This reloads the operating system and your different auto-start software.

    There are two types of reboots: a cold reboot and a warm reboot.

    The cold reboot is the one where you turn your computer all the way off and back on. It is considered to be the ultimate reboot which ensures that everything is alright.

    The warm reboot is when you just reboot your operating system. This means some of the hardware parts may not be fully reset as expected in a cold reboot. There are several reasons for this, at times the BIOS of your system does not give the correct signals to all the parts, and at times the signal doesn't propagate to all the parts as it should.

    This is why a warm reboot does not always work (i.e. think when you change a driver and the new driver is not able to properly reset the state of a board or chip... turning the computer all the way off and back on may resolve the problem.)