Loading...
 
Features / Usability

Features / Usability

Forum List Topic List

 
Thread actions
PDF Print this page
  • Print all pages

    • pluginSQL help

    Posted by Sridhar Katakam posts: 78 India

    I created a wiki page w/ the code below:

    Image
    Copy to clipboard
    -=New bugs filed this week and currently assigned to India devs (part 1 of 2 of New bugs/week)=-

{SQL(db=>bugzilla)}SELECT COUNT(DISTINCT bugs.bug_id) FROM bugs
INNER JOIN profiles ON bugs.assigned_to = profiles.userid and profiles.teamid = 325
WHERE 
DATE_SUB('2005-04-08' ,INTERVAL 0 DAY) > creation_ts
AND
DATE_SUB('2005-04-08' ,INTERVAL 6 DAY) <= creation_ts
AND
target_milestone = '7.0 SP1'
AND priority = 'P1'{SQL}


    but upon saving, get the following error:

    Image
    Copy to clipboard
    Fatal error: Call to a member function on a non-object in c:\easyphp1-7\www\lib\wiki-plugins\wikiplugin_sql.php on line 38


    Line 38 of the wikiplugin_sql.php file is:

    Image
    Copy to clipboard
    while ($res = $result->fetchRow(DB_FETCHMODE_ASSOC)) {


    More detailed info abt the same is at http://tikiwiki.org/tiki-view_blog.php?blogId=11.

    Any solutions?

    Reads: 1020
    Link
    There are no comments at this time.