Jump to content


Photo

Need Help With SQL Error Badly


  • Please log in to reply
3 replies to this topic

#1 Rowan

Rowan
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 17 March 2006 - 11:58 AM

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!

DEBUG MODE

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?
http://www.hazardforum.co.uk
Come And Visit Hazard Forum

#2 Rowan

Rowan
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 17 March 2006 - 01:17 PM

Sorry btw I just noticed theres an SQL Help section and this will prob come under that.. ill post it there :)
GFX, Gaming, Movies, Music, Computers, Anime, Competitions, Books And Much More?
http://www.hazardforum.co.uk
Come And Visit Hazard Forum

#3 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 17 March 2006 - 01:53 PM

[!--quoteo(post=355916:date=Mar 17 2006, 01:17 PM:name=Rowan)--][div class=\'quotetop\']QUOTE(Rowan @ Mar 17 2006, 01:17 PM) View Post[/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.
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#4 Rowan

Rowan
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 17 March 2006 - 02:05 PM

What do you mean m8??

Also ive made that topic in mySQL Help.. will I continue this problem in this topic or there??
GFX, Gaming, Movies, Music, Computers, Anime, Competitions, Books And Much More?
http://www.hazardforum.co.uk
Come And Visit Hazard Forum




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users