The Linux Page

Help other users realize that everything is possible, especially avoiding Windows for their own personal use.

Welcome to The Linux Page


Fox Trot by Bill Amend. Click to enlarge.
Click to enlarge

This site is a collection of my own work with Linux. Certain things are easy, others take time to decipher and if I ever need to repeat the work (which usually happens!), then I need to remember everything by memory or... have a site with all the steps taken and to take again.

The following are my most recent posts:

You may have noticed that whenever you create a Datasheet you can double click on the right edge to resize the column to the widest text currently defined in that column.

This is neat but if I create a table with 10 columns, that's work. Especially if I need to reload data in that table each time I use it, 10 times an hour. (i.e. 100 x double click would definitively kill me!)

Of course, you may not need to resize all 10 columns each time, but wouldn't it be neat to have the columns width auto-adjust with the data you put in that Datasheet table?!

I think it would be!

The solution

Today I bumped in another problem.

Some QuickBooks tables cannot properly be updated with QODBC. In my case it was the SalesOrderLine table. The first error I got was:

Error parsing complete XML return string (8)

I just couldn't be sure what that meant...

I had looked at the XML output closely and noticed that the identifier of a line was improperly shown in a separate tag.

The fact is, I just could not update multiple lines with FQSaveToCache flag set to 1.

Today we discovered that our SSL system on our server broke when we upgraded the server to Ubuntu 8.10 (Intrepid.)

The technical error message is rather cryptic:

  SSL connect error; error:140773F2:SSL routines:SSL23_GET_SERVER_HELLO:sslv3 ...  
          ... alert unexpected message (https://secure.example.com/path.php)

I also get this message from HttpRequest (in our PHP server running with Apache):

Story

Inserting a row ina database is done with the INSERT INTO command line. This is quite standard SQL.

MS-Access supports the INSERT INTO instruction too. You can write macros that make use of it.

I have used it for a while and had not problems. But yesterday I discovered that there was a case when it simply wouldn't work at all. The strangest thing was that it did not work with an MS-Access database without any one error. No error at all.

Today we again ran in an out of memory error. As we are adding more websites our foot print is growing... Our servers use a VPS that has limited resources and whenever the limit is reached, the system automatically kills processes. How the VPS selects the process to kill isn't clear to me, but twice it has been our database manager meaning that all of a sudden all the websites stop working.

So... We got an extra bit of RAM because our package allowed it, but that's still small.

I use all sorts of tricks in order to duplicate functionality without actually duplicating PHP code.

One of the main, easiest way under Unix is to create softlinks. First put all your code in one folder, then create a softlink to it. That gives you two paths:

Today I resolved a problem with setting up a sub-form recordset in a report.

In a form, you can do a lot of things, but reports are very much constrained. Most certainly because that way they are more sure that the data won't change while printing the report. But for sure, it is very annoying.

I got this error first:

"This feature is only available in an ADP"

In itself, that error means totally nothing. I have no clue what an ADP is. The solution to that error is available in Microsoft website here:

Managing your own Drupal Download Site

The other day, I was thinking, it would be nice if I could find the way to manage my own download site so people who use my modules that I do not provide directly on https://www.drupal.org would still show as expected (i.e. Green in the update window).

I found this page about it: https://www.drupal.org/node/210984

This is done by creating a service in your Drupal environment. You should use the ready made script named:

project-release-serve-history.php

which you can find in the D6 version of the Drupal project named Project. Being very ...

I created this page to have a place to save my copy of IrfanView.

I have to say that the author has made his download so complicated (at least last time I tried it was deadly complex!) that I have to just keep my own copy somewhere. Maybe it's illegal, but the software is freeware anyway.

You can find the original (and most certainly more advanced version) on his website: http://www.irfanview.com

There other tools one can use to work on images as follow:

In my work with MS-Access and QuickBooks, I'm slowly progressing toward incredebilitiousness (some Franglais as we say in French).

I was working on adding Items to the ItemInventory table. All you have to do is an INSERT or an UPDATE.

Thank you for visiting my website.