Forum

[DjPorkchop]

Your phpBB Version: 2.0.22
phpBB Type: Integramod 141
MODs: Yes
Your knowledge: Beginner
Board URL: http://www.mweva.com

PHP Version:
MySQL Version:


What was done before the problem appeared?
Nothing Just a found error


What was done to try to solve the problem?
Nothing



De.scription and Message

I noticed that when you click the Not so gramtically correct link under the forum rules in the acp and choose who to invite to re read the rules and click submit, this is the error I get. Not a big deal, just something I noticed.

Could not insert/update 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 ' 1170206183, '42743a1d', 1, 1, 1, 1)' at line 1

INSERT INTO phpbb_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 (5, 'Attention the Rules has been updated.', 2, , 1170206183, '42743a1d', 1, 1, 1, 1)

Line : 236
File : admin_forum_rules.php

[Teelk]

I'm not getting this error on my test boards, possibly because my php mail function doesn't work so I don't get that far. So, you click "Users that don't have read the Rules" select a user and choose to send them a PM and you get this error? Do you get this error when you're don't choose to send them a PM?

[DjPorkchop]

Well Teelk, Truth be known, I dont have any users listed in the user box even to send anything too. I was just pushing buttons. I was wondering why I didnt have any users listed in the user box.

[Teelk]

I had that once while playing with, there were no users in the list. Now there always are, I can't get it to not have users in the list.

But, my guess would be that because there were no users in the list the SQL couldn't complete. So, I'm not sure about this one.

Are there users in the list for you now? If not, try saving the rules again and then see.

[DjPorkchop]

So I went back and rechecked again and still had no users to choose from so I saved the rules again as suggested and alas, its all good now. Pms and emails get sent fine without the sql error.

Mark as a bug or solved your choice. Im not sure where this falls.

Teelk, I know I'm a royal pain and Im the first to admit it, but thanks to you and Helter and everyone else. Tonights fixes and tricks alone have got me excited about working on my site again. Thx guys. <img>