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.
Loading data error
Re: Loading data error
Hi Stimulsoft team,
I worked for an week to this report and now I can use it. Please give me an answer.
Thanks.
I worked for an week to this report and now I can use it. Please give me an answer.
Thanks.
Re: Loading data error
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
[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
Hello.
Do you have access to your database from remote host?
Please, check also your connection string.
Thank you.
Do you have access to your database from remote host?
Please, check also your connection string.
Thank you.
Re: Loading data error
Hi,
I solved the problem, finally. I installed the mysqli extension in cpanel.
I solved the problem, finally. I installed the mysqli extension in cpanel.
Re: Loading data error
Hello.
The mysqli extension should be available to get connection to MySQL database.
Thank you.
The mysqli extension should be available to get connection to MySQL database.
Thank you.