Database error

Called 'db_res' function with erroneous argument #0.

I have one of these errors with importing Facebook events.

This is causing error;

if (db_res($sql)) {

                $sqlQuery = "SELECT `bx_events_main`.`ID` FROM bx_events_main WHERE `bx_events_main`.`ResponsibleID` = '{$iProfileId}' ORDER BY `bx_events_main`.`Date` DESC LIMIT 1";

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 12 Mar 2013

I'm not 100% sure but try putting tick marks ` on both sides of that second bx_events_main so it looks like this:

if (db_res($sql)) {

                $sqlQuery = "SELECT `bx_events_main`.`ID` FROM `bx_events_main` WHERE `bx_events_main`.`ResponsibleID` = '{$iProfileId}' ORDER BY `bx_events_main`.`Date` DESC LIMIT 1";

 

 

Called 'db_res' function with erroneous argument #0.

I have one of these errors with importing Facebook events.

This is causing error;

if (db_res($sql)) {

                $sqlQuery = "SELECT `bx_events_main`.`ID` FROM bx_events_main WHERE `bx_events_main`.`ResponsibleID` = '{$iProfileId}' ORDER BY `bx_events_main`.`Date` DESC LIMIT 1";

 

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 12 Mar 2013

Hey Scott, thanks for pointing that out, unfortunately I still have problems.

I guess I need to trash this module as now it is giving more errors; I'm sure the events database structure has changed and this is causing the problems now.

The module is for 7.0.7 I have modified all the way to .9 but looks like the fix for it is now beyond my knowledge of code. Yell

[edit] oh, and the module creator was banned to the "moon" long ago...

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 14 Mar 2013
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.