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 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. Link to comment https://forums.phpfreaks.com/topic/5167-urgent-help-needed/#findComment-18405 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.