2

I would like to display other MySQL database by Views, and having the similar situation as this question. Except, I'm not able to enable the "SQLite", because I have no control on the server end. While adding the data block on New Forena Report, I got the message "PDO driver support for sqlite not installed", as shown in the screenprint below:

enter image description here

My question: Is it possible to display other MySQL data by Views without installing and enabling support for SQLite? What are my other options?

===== Updated June 6, 2015 at 12:45pm - Data block format ====
Below are the screenshots where I fix the Data Block format for data column with double quote.

screenshot 1 - While you edit the Forena Reports, you actually can configure each column(block) by left click the gear as screenshot from blow. enter image description here

screenshot 2 - Choosing the "drupal_text_format" format will remove double quotes enter image description here

1

The Forena module is shipped with 3 types of "sample" reports:

  • Reports about your own Drupal database (the drupal/* 'data blocks' in your screenprint), typically in MySQL database format.
  • Forena tutorials, which are actually also delivered in the format of "Reports" which refer to datablocks in XML format (the forena_help/* 'data blocks' in your screenprint).
  • Reports about some Sample database which is also delivered with Forena, in the format of an SQLite database (none of these Sample/* 'data blocks' are shown in your screenprint, as they are normally shown when PDO driver support for SQLite is available).

So the error shown in your screenprint is to inform you about something like "sorry, there is no SQLite support available here, so I can't handle the Sample database (which is in SQLite format)".

If however you have MySQL support available on the server where your MySQL data resides (eg: if it's on the same server as where Drupal resides, but just another MySQL database), then you should be able to use Forena for creating reports about that MySQL database. To access that MySQL database, you need to define (within Forena admin) a Data Connection to that MySQL database and 1 or more data blocks (SQL queries). And from then on you should be able to build your custom reports about that MySQL database, e.g. using the WYSIWYG report writer that comes with Forena.

Note: if you're interested in trying out Forena, use SimplyTest.Me to do so. If you do, and after you login to such site, you'll also get the same PDO driver support for sqlite not installed error message, after you visit the "/reports" link for the first time (or use the "My Reports" menu option in the Navigation menu). That error is shown because support for SQLite is not enabled on SimplyTest.Me. You get a similar error message if you visit the reports/sample.toc link (because the sample reports and graphs are using an SQLite database). However, reports such as these run just fine (they don't require SQLite):

  • /reports/help.toc.
  • /reports/drupaladmin.enabled_contributions (by the way: shows all enabled modules in such simplytest.me setup ...).
  • Thats a big help. I realize I have to use "Data" tab "SQL Query". – CocoSkin Jun 16 '15 at 12:42
  • Everything seem fine except the "body" field display from other Drupal or CMS. Not sure should I put a new ticket about this. – CocoSkin Jun 16 '15 at 14:40
  • What's the issue / question about that "... the "body" field display from other Drupal or CMS ..."? Can you better explain what is happening (or not)? – Pierre.Vriens Jun 16 '15 at 14:44
  • The external MySQL database I using for Forena is containing a Drupal Body field in a table, which has single and double quotes. It may the reason causing the display. – CocoSkin Jun 16 '15 at 15:08
  • I solved the issue by changing the "Block" format to "Drupal_text_format" in Report. – CocoSkin Jun 16 '15 at 16:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.