
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and enumPreference = 'MY') OR (tblAV_MemberMaster.intCountryID IN ())) WHERE (' at line 1
An exception occured operation could not be completed.
For: SELECT DISTINCT (tblAVMyHomeTheatre_Presentation.IntPresentationID) FROM tblAVMyHomeTheatre_Presentation INNER JOIN tblAVMyHomeTheatre_PresentationDetails ON ( tblAVMyHomeTheatre_Presentation.IntPresentationID = tblAVMyHomeTheatre_PresentationDetails.intPresentationID) INNER JOIN tblAV_MemberMaster ON ( tblAV_MemberMaster.intForumUserID = tblAVMyHomeTheatre_Presentation.intUserID) INNER JOIN tblAVMyHomeTheatre_Preferences ON ((tblAVMyHomeTheatre_Preferences.intUserID = tblAV_MemberMaster.intForumUserID AND tblAVMyHomeTheatre_Preferences.intCountryID IN () and enumPreference = 'MY') OR (tblAV_MemberMaster.intCountryID IN ())) WHERE (tblAVMyHomeTheatre_Presentation.DtLastUpdated >= '2012-05-07' AND tblAVMyHomeTheatre_Presentation.DtLastUpdated <= '2012-05-13') and tblAVMyHomeTheatre_Presentation.enumStatus = 'A' and tblAVMyHomeTheatre_Presentation.enumDeleted = 'N' ORDER BY DtDateAdded DESC
File: class.dbFunctions.php
Method: dbFunctions::dbFetchAll_page
Line: 285
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and enumPreference = 'MY') OR (tblAV_MemberMaster.intCountryID IN ())) WHERE (' at line 1
An exception occured operation could not be completed.
For: SELECT DISTINCT (tblAVMyHomeTheatre_Presentation.IntPresentationID) FROM tblAVMyHomeTheatre_Presentation INNER JOIN tblAVMyHomeTheatre_PresentationDetails ON ( tblAVMyHomeTheatre_Presentation.IntPresentationID = tblAVMyHomeTheatre_PresentationDetails.intPresentationID) INNER JOIN tblAV_MemberMaster ON ( tblAV_MemberMaster.intForumUserID = tblAVMyHomeTheatre_Presentation.intUserID) INNER JOIN tblAVMyHomeTheatre_Preferences ON ((tblAVMyHomeTheatre_Preferences.intUserID = tblAV_MemberMaster.intForumUserID AND tblAVMyHomeTheatre_Preferences.intCountryID IN () and enumPreference = 'MY') OR (tblAV_MemberMaster.intCountryID IN ())) WHERE (tblAVMyHomeTheatre_Presentation.DtLastUpdated >= '2012-05-07' AND tblAVMyHomeTheatre_Presentation.DtLastUpdated <= '2012-05-13') and tblAVMyHomeTheatre_Presentation.enumStatus = 'A' and tblAVMyHomeTheatre_Presentation.enumDeleted = 'N' ORDER BY DtDateAdded DESC
File: class.dbFunctions.php
Method: dbFunctions::dbFetchAll_page
Line: 285
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||