Loading...
 
Features / Usability

Features / Usability

Forum List Topic List

Forums » Features / Usability » Blank page (no html) when using {SQL}
 
Thread actions
PDF Print this page
  • Print all pages

    • Blank page (no html) when using {SQL}

    Posted by Halfbat posts: 9

    HI
    Newbie issue that may be known but I'm struggling to find a resolution.

    Whenever I try a SQL statement through the SQL plugin I end up with a completely blank page. I've checked all the SQL pluging requirements (memory,etc) and they should be fine. I've defined the DSN, and am using that, but I've also tried a 'tiki' DSN and that ends up with the same blank result, too. The SQL is fine (ran it through phpMyAdmin to make sure, but I've been using SQL for a few years).

    Every other page using the same wiki page template works fine.

    Any thoughts, details I've almost cretainly missed?

    Reads: 2148
    Link
    Posted by Halfbat posts: 9
    Halfbat wrote:

    HI
    Newbie issue that may be known but I'm struggling to find a resolution.

    Whenever I try a SQL statement through the SQL plugin I end up with a completely blank page. I've checked all the SQL pluging requirements (memory,etc) and they should be fine. I've defined the DSN, and am using that, but I've also tried a 'tiki' DSN and that ends up with the same blank result, too. The SQL is fine (ran it through phpMyAdmin to make sure, but I've been using SQL for a few years).

    Every other page using the same wiki page template works fine.

    Any thoughts, details I've almost cretainly missed?

    Link

    Posted by Rick Sapir / Tiki for Smarties posts: 3665 United States
    Halfbat wrote:

    HI
    Newbie issue that may be known but I'm struggling to find a resolution.

    Whenever I try a SQL statement through the SQL plugin I end up with a completely blank page. I've checked all the SQL pluging requirements (memory,etc) and they should be fine. I've defined the DSN, and am using that, but I've also tried a 'tiki' DSN and that ends up with the same blank result, too. The SQL is fine (ran it through phpMyAdmin to make sure, but I've been using SQL for a few years).

    Every other page using the same wiki page template works fine.

    Any thoughts, details I've almost cretainly missed?


    Some questions for clarification:

    • What Tiki version are you using?
    • What is the SQL that you're trying to use?
    • Did you turn on Tiki error reporting and logging? What errors are being thrown?



    HTH,

    - Rick | My Tiki Blog | My Tiki UserPage

    Now Available: Tiki Essentials, the #1 (and only) book for Tiki! Learn more...
    Coming Spring, 2011: Tiki for Dummies Smarties, the best (and only) Tiki beginner's guide! Learn more...


    Need more help? Try Tiki for Dummies Smarties: A beginner's guide and Tiki Essentials: What all Smarties need to know about Tiki Wiki CMS Groupware.

    Link

    Posted by Halfbat posts: 9

    - Tiki version is latest downloadable from here (e.g. it's only just been set up)
    - SQL statement is the trial SQL statement from the SQLPlugin page - the best way to test is to use what's suggested
    - Can't see any errors in the log. :-(

    Link
    Posted by Halfbat posts: 9

    OK.
    A bit more precise wrt logs - "nothing I can understand" (Newbie) - there is nothing in the wiki logs, but the Apache log says: 

    PHP Fatal error: Uncaught exception 'PDOException' 
     with message 'could not find driver'
 	 in /home/halfbat/public_html/tiki/lib/tikilib.php:168\n
  Stack trace:\n
  #0 /home/halfbat/public_html/tiki/lib/tikilib.php(168): 
    PDO->__construct(':host=;dbname=', '', '')
  #1 /home/halfbat/public_html/tiki/lib/wiki-plugins/wikiplugin_sql.php(69):
    TikiLib->get_db_by_name('tiki')
  #2 /home/halfbat/public_html/tiki/lib/tikilib.php(5350): 
    wikiplugin_sql(' ??SELECT login...', Array, 38, Array)
  #3 /home/halfbat/public_html/tiki/lib/tikilib.php(4858):
    TikiLib->plugin_execute('sql', ' ??SELECT login...', Array, 38, false, Array) 
  #4 /home/halfbat/public_html/tiki/lib/tikilib.php(5822): 
    TikiLib->parse_first('!SQL Test Page?...', Array, Array, Array)\n
  #5 /home/halfbat/public_html/tiki/lib/wiki/wikilib.php(393): 
    TikiLib->parse_data('!SQL Test Page?...', Array)\n
  #6 /home/halfbat/public_html/tiki/lib/wiki/renderlib.php(339):
    WikiLib->get_parse('TestSQL', false)\n
  #7 /home/halfbat/public_html/tiki/lib/wiki/renderlib.php(126):
    WikiRenderer->setupPage()\n
  #8 /home/half in /home/halfbat/public_html/tiki/lib/tikilib.php 
    on line 168, referer: [...]/tiki/tiki-listpages.php
    Link