Problem connecting to mySQL

tony.tomov · Post by **tony.tomov** » Tue Apr 12, 2011 7:45 am

Hello rahulmes,
Sorry I do not tested with newly reports.

If we create new report the problem is here - I can confirm that columns can not be retrieved.

Regards

tony.tomov · Post by **tony.tomov** » Tue Apr 12, 2011 7:55 am

Hello again,

If this help - future investigations tell me that when we click - Retrieve Columns button,
the client key "RetrieveColumns" in sti_client_event_handler function is not passed.

Regards
Tony

Post by **Vladimir** » Tue Apr 12, 2011 8:54 am

Hello,

We could not reproduce the problem on the version from 2011.04.07, columns are retrieved correctly.
Could you, please describe the steps how you do this?

Also, please try to download the latest prerelease build from April, 12, when it available.

Thank you.

tony.tomov · Post by **tony.tomov** » Tue Apr 12, 2011 8:56 am

Hello,
Thanks Vladimir.
The version used from me is 2011.04.06 and not 2011.04.07

Will try to download the latest one and let you known

Tony

tony.tomov · Post by **tony.tomov** » Tue Apr 12, 2011 10:25 am

Hello,
The problem disappear in version dated from 2011.04.07
Thanks.

Tony

Post by **Andrew** » Tue Apr 12, 2011 11:38 am

Good news. Thank you for letting us know about this.

rahulmes · Post by **rahulmes** » Tue Apr 12, 2011 7:54 pm

Thanks all for your replies. Unfortunately, the problem still continues for me. I have downloaded the pre-release build version also (12-Apr) and tried. The same problem persists. As I have mentioned in my earlier post, version from 2011.04.07 also did not work for me.

However, since Tony has confirmed that it is working for him, there is clearly a specific issue on my computer. What could it be? I am using Win Vista SP 1, mySQL 5.5.11 and PHP 5.2.1, Apache 2.2. I have connected with root privileges on port 3306. Are all these components ok? Please help, I am keen to use this product.

I have also attached a couple of screenshots.

Thanks.

tony.tomov · Post by **tony.tomov** » Wed Apr 13, 2011 1:54 am

Hello,

In the pictures attached I see in the report

select * from crm.company_master

while in the console

select * from company_master

Not sure, but maybe MySQL driver does not like to set the database before the table.

Just try in the report as you do in the console

Code: Select all

select * from company_master

Regards
Tony

Post by **Vladimir** » Wed Apr 13, 2011 2:10 am

Hello,

Also, you can enable the data logger of all transmitted data. To do this, in the 'config.xml' file set to True the EnableDataLogger option in Connection section. Then run the designer again and repeat all actions.

After that, go to the Main Menu and using the 'Save Log File' button, save the text file and send it to us.

Thank you.

rahulmes · Post by **rahulmes** » Thu Apr 14, 2011 11:19 am

Dear Vladimir,

I have attached the log file. Please have a look.

Thanks.