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/5162-need-help-with-sql-error-badly/ Share on other sites More sharing options...
Rowan Posted March 17, 2006 Author Share Posted March 17, 2006 Sorry btw I just noticed theres an SQL Help section and this will prob come under that.. ill post it there :) Quote Link to comment https://forums.phpfreaks.com/topic/5162-need-help-with-sql-error-badly/#findComment-18335 Share on other sites More sharing options...
redarrow Posted March 17, 2006 Share Posted March 17, 2006 [!--quoteo(post=355916:date=Mar 17 2006, 01:17 PM:name=Rowan)--][div class=\'quotetop\']QUOTE(Rowan @ Mar 17 2006, 01:17 PM) [snapback]355916[/snapback][/div][div class=\'quotemain\'][!--quotec--]Sorry btw I just noticed theres an SQL Help section and this will prob come under that.. ill post it there :)[/quote]post your exact insert code ok. Quote Link to comment https://forums.phpfreaks.com/topic/5162-need-help-with-sql-error-badly/#findComment-18338 Share on other sites More sharing options...
Rowan Posted March 17, 2006 Author Share Posted March 17, 2006 What do you mean m8??Also ive made that topic in mySQL Help.. will I continue this problem in this topic or there?? Quote Link to comment https://forums.phpfreaks.com/topic/5162-need-help-with-sql-error-badly/#findComment-18340 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.