Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • SQL-Query gets only empty page back

    Posted by nemesis

    Hi,
    I want to use a SQL-Querry to post only the last 5 news on my starting-page.
    But when I open the page with the Query, I only gt a blank page.
    The code is:

    Copy to clipboard
    {SQL(db=>'mqdsn')} SELECT row FROM table{SQL}

    DSN is aktivated.

    I don't know whats going wrong here. I hope somebody can help me with that.

    thx!

    Reads: 1830
    Posted by rgaunt

    I am having the same problem with both the SQL and DBREPORT plugins. There has been some discussion on this in the following tracker item:

    http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=3016Question

    However, I was unable to resolve the problem even though this item is listed as closed. I am running a windows machine and the php_pdo_mysql.dll extension is enabled in the php.ini file. I also tried adding $api_tiki='adodb'; to the local.php file, which allows the page to run, but the plugins are still not working properly. This all occurred after upgrading from 3.4 to 4.1

    I would really like to use these plugins. Does anybody have these plugins working properly under 4.1???

    Thanks....


    Posted by rgaunt

    So...it turns out that adding the line $api_tiki='adodb' in the local.php file actually worked. But the version of wikiplugin_dbreport that was in the new installation of Tiki did not work for me. Many instances of '=&' had been replaced with simply '='. Copying the dbreport plugin from the installation of Tiki3.3 into the directory for Tiki4.1 magically made it all work again.

    Does anyone have any comments on why these changes were made in the dbreport php file?

    Thanks...