Page 1 of 1

Loading data error

Posted: Sat Jan 30, 2016 5:12 pm
by catalin
Hi Stimulsoft team,
I made a report and I connect it to mysql DB.
When I run it on designer connected to the local db it's work fine.
When I run it on localhost (viewer) connected to the local db it's work fine, too.
When I run it on localhost (viewer) connected to the remote db it's work fine.
But when I runt it on remote host (viewer) connected to the remote db I have an error: Connection error. Loading data error. If I click "More details" button I see "Load data error".
Both db (local and remote) are the same version 5.6.
I simplified the query: SELECT name FROM mytable limit 1
How can I find more details about the error.

The version I have bought is Stimulsoft-Reports-PHP-2015.2.exe with source code.

Thanks.

Re: Loading data error

Posted: Mon Feb 01, 2016 8:21 am
by catalin
Hi Stimulsoft team,
I worked for an week to this report and now I can use it. Please give me an answer.

Thanks.

Re: Loading data error

Posted: Mon Feb 01, 2016 8:35 am
by catalin
I activate in config.xml <Connection><EnableDataLogger> option and now in error_log file I can see:
[01-Feb-2016 08:25:25 UTC] PHP Fatal error: Call to undefined function mysqli_connect() in /home/myserver/public_html/myproject/public/stimulsoft/stimulsoft/database_mysql.php on line 186

Re: Loading data error

Posted: Mon Feb 01, 2016 9:07 am
by HighAley
Hello.

Do you have access to your database from remote host?
Please, check also your connection string.

Thank you.

Re: Loading data error

Posted: Mon Feb 01, 2016 9:31 am
by catalin
Hi,
I solved the problem, finally. I installed the mysqli extension in cpanel.

Re: Loading data error

Posted: Mon Feb 01, 2016 9:38 am
by HighAley
Hello.

The mysqli extension should be available to get connection to MySQL database.

Thank you.