Jump to content


Urgent Help Needed

  • Please log in to reply
1 reply to this topic

#1 Rowan

  • Members
  • PipPip
  • Member
  • 10 posts

Posted 17 March 2006 - 01:18 PM

Hey there,

I recently installed a mod to my phpBB forum. It was a Welcome PM Mod. After I had finished it I decided to test it out. So I made a Test-Member and once I had registered and then logged in I got this:

Could not insert private message sent info!


SQL Error : 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 ' 228, 1142596635, '', 0, 1, 1, 1)' at line 2

INSERT INTO phpbb_sr_privmsgs (privmsgs_type, privmsgs_subject, privmsgs_from_userid, privmsgs_to_userid, privmsgs_date, privmsgs_ip, privmsgs_enable_html, privmsgs_enable_bbcode, privmsgs_enable_smilies, privmsgs_attach_sig) VALUES (1, '', , 228, 1142596635, '', 0, 1, 1, 1)

Line : 97
File : functions_wpm.php

Does anyone know how I fix this??? As I really need it done because I have had members rolling in on my forum the past few days and I dont want some registering, getting the error and disappearing :(

Thanks and all help is appreciated
GFX, Gaming, Movies, Music, Computers, Anime, Competitions, Books And Much More?
Come And Visit Hazard Forum

#2 fenway

  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 17 March 2006 - 08:16 PM

Well, your 3rd value -- for the column named "privmsgs_from_userid" -- is non-existent! So whatever code is composing your INSERT statement isn't correct, or isn't handling null/undef values properly.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users