Loading data error

Stimulsoft Reports.PHP discussion
Post Reply
catalin
Posts: 23
Joined: Sat Jan 30, 2016 10:31 am

Loading data error

Post 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.
catalin
Posts: 23
Joined: Sat Jan 30, 2016 10:31 am

Re: Loading data error

Post 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.
catalin
Posts: 23
Joined: Sat Jan 30, 2016 10:31 am

Re: Loading data error

Post 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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Loading data error

Post by HighAley »

Hello.

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

Thank you.
catalin
Posts: 23
Joined: Sat Jan 30, 2016 10:31 am

Re: Loading data error

Post by catalin »

Hi,
I solved the problem, finally. I installed the mysqli extension in cpanel.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Loading data error

Post by HighAley »

Hello.

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

Thank you.
Post Reply