Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

sqlBuilder help

jawelejawele
edited January 2007 in Vanilla 1.0 Help
This is giving me an error: $s->Clear(); $s->SetMainTable('LUM_DiscussionUserWhisperFrom', 'wf'); $s->AddFieldNameValue('DiscussionID', $NewDiscussionID); $s->AddWhere('wf', 'DiscussionID', '', $currentDiscussionID, '='); $s->AddWhere('wf', 'WhisperFromUserID', '', $AuthorUserID, '='); $this->Context->Database->Update($s, $this->Name, 'UpdateWhisper', 'An error occurred while whisper from discussion properties.'); what's wrong? the error I got: Affected Elements ModerationManager.UpdateWhisper(); The error occurred on or near: 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 '='764' where = '749' and = '1' )' at line 1

Comments

  • jawelejawele
    ok figured out I was to tired yesterday to see it... I had to take out the table prefix! lol so stupid I was! so instead of: $s->SetMainTable('LUM_DiscussionUserWhisperFrom', 'wf'); should be this: $s->SetMainTable('DiscussionUserWhisperFrom', 'wf'); hope it helps someone who stumble in the same blund...
This discussion has been closed.