Triona Weblog

In MySQL you can define, that a column contains an auto increment value. This means that, whenever there is an insert command, the ID (this is what the auto increment value is usually used for) will be increment by a pre-defined value.

Now, when you use ad hoc queries (simple string concatenating like “Insert into user values (‘ ” . $username . ” ‘ , ‘ ” . $first_name . ” ‘) “” ); you can invoke the function mysql_insert_id to get the increment value of this insert operation.

But when you use Prepared Statements (Man Page) instead, you have to use the mysqli_insert_id function instead! When using this function, you also have to pass the connection object to the function.

If you try to use the mysql_insert_id function, you will receive an error message saying:
mysql_insert_id() function.mysql-insert-id: A link to the server could not be established in dbOps.php.

Also passing the connection object to function mysql_insert_id() will not help. The error will say then some like mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in dbOps.php.

The freely available CRM software vTiger (version 5.0.4) still has issues with the display of UTF-8 and ISO-8859-1x characters (German umlauts like äöü and ß).

When you open an EMail in the Webmailer module, the text following such a character is completely gone – the rendering engine of vTiger simply stops the rendering of all characters starting from here.

After many reading in the internet and in the relevant forums and trying out several proposals for fixing this issue, one simple change did the trick:

Open ../modules/Webmails/Webmails.php and scroll down to the function declaration load_mail() – in our sources, this is located around line 712.

712
713
714
715

function load_mail($attach_tab)
{
    // parse the message
    $ref_contenu_message =  @imap_headerinfo($this->mbox, $this->mailid);

Right after the “parse…” comment add the following line

716

    global $default_charset;

Now the beginning of the function looks as follows:

712
713
714
715
716
717

function load_mail($attach_tab)
{
    // parse the message
    // HK 25.08.2009 fix for umlaut display problem - added the following line
    global $default_charset;
    $ref_contenu_message =  @imap_headerinfo($this->mbox, $this->mailid);

This solved the issue for us.

After upgrading to the new version 5.1.0, we will have to see whether the developers of this really outstanding piece of software have provided a common fix for all of those Hungarians, Germans and other poor special-character-users like us