Rowan Posted March 17, 2006 Share Posted March 17, 2006 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:[code]Could not insert private message sent info!DEBUG MODESQL 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 2INSERT 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 : 97File : functions_wpm.php[/code]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 Quote Link to comment https://forums.phpfreaks.com/topic/5167-urgent-help-needed/ Share on other sites More sharing options...
fenway Posted March 17, 2006 Share Posted March 17, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/5167-urgent-help-needed/#findComment-18405 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.