Re: MYSQL error with IBMDB2 engine

[Scott Klement <web400@xxxxxxxxxxxxxxxx>]

I don't run SugarCRM (yet...  might use it some day) but I've had 
problems like this when creating my own tables with (ugh, I hope my 
memory is correct...) utf8_general_ci.  Changing it to another one of 
MySQL's utf-8 encodings solved the problem.  Sorry, my memory is fuzzy, 
so I might've got that wrong.

I also know there were some bugs related to error 2501 that were fixed 
in MySQL.  You might want to make sure you're running the current 
version. 5.1.39 was released yesterday, though the fixed I'm thinking of 
were originally added in 5.1.36.  (But.. there may have been updates 
since then, I don't know -- at any rate, you may as well go to the 
current version.)

Whether IBM provides support or not...?  I don't know...   if you find 
out, please let me know.

dale janus wrote:
> We have been using PHP and MYSQL (and APACHE) for about 2 years.    We 
> have been pretty successful created web based aps to view I series data 
> using the DB2 calls Zend put into  PHP.  We are running V5R4.
>
> We were very happy to see that IBM finally created a database engine for 
> DB2 for MYSQL.  We installed it back in May.
>
> Now we are expanding and trying to create web based front ends for our 
> data entry programs.   We set up PHP to use MYSQL with the DB2 engine to 
> edit and enter a batch file for our billing system.    At first, it 
> worked fine.  Now we are getting errors:
>
> Got error 2501 'Error opening codeset conversion from UTF-8 to UTF-16 
> (errno = 0)' from IBMDB2
>
>
> We could not chase it down, so we switched the engine back to MYISAM in 
> MYSQL and naturally it works perfectly.  
>
> For this particular application it does not matter what engine is used, 
> but we are getting the same error with SUGARCRM .
>
>
> We installed SugarCrm  back in May with the default test data using the 
> IBMDB2 engine in MYSQL.  Sure enough, it created a I SERIES library 
> called "sugarcrm" and a bunch of physical and logical files, all lower 
> case with " "around them.   I played around with it a while back in May 
> and then moved on to more pressing problems.  Now I have come back to 
> it, and it starts with  the error 2501.  We had to change the user file 
> in SugarCrm MYSQL from IBMDB2 back to MYISAM.  Then we could log on.  
> This removed the file from the I series library "sugarcrm".
>
>
>
> This allow SugarCrm to run, but  whenever I try to view the existing  
> test  data  provided by SUGARCRM, I get  an error messasge: Error 
> retrieving record. This record may be deleted or you may not be 
> authorized to view it. 
>
> This happens no matter if I am logged on as myself, a test user, or 
> administrator.
>
> Here I am, finally getting ready to put my data into SugarCrm and it's 
> broken.
>
>
> Is anybody trying to use MYSQL with native files?  Has anyone run into 
> this problem?
>
> Is this something I can call IBM Software Support about?
>
>
>
>
> Some of the MYSQL forums indicate these causes for the error can be:
>
> This is due to lack of support for the collations on v5r4
>
> or
>
> When a user selects an unsupported character set for an IBMDB2I table
>
>
> It appears MYSQL will eventually release a patch, but all it does is change the error message from internal error to user error.
>
>
>
>
>
> ---Dale