Geeklog Forums

I found this oldie but goldie and thought I'd give it a try.
I modified it a little, tested on GL 1.4 and looks like it does everything you'd expect a PM plugin should do.
File is waiting for you here.
There is still a lot work to be done on it e.g. stripping all the hardcoded language, polish it, etc.
As usual waiting for your feedback

---

Geeklog Polish Support Team

UPDATE: Plugin cause of SQL error? See below:

---

cedko.com -- Cartoonin' The World :)

Question: how do you make it so that when a new user registers at the site, they get a welcome PM?

Thanks, mugen

---

cedko.com -- Cartoonin' The World :)

Hi, after installing the PM plugin I keep getting a SQL error everytime I log out! I think it's something to do with the php block code, because when I disable the PM block, the logout works fine.

Help?

Thanks, mugen

---

cedko.com -- Cartoonin' The World :)

Quoting the error would significantly help to investigate it

---

Geeklog Polish Support Team

Hi Robin, it just displays a blank page with the sentence:

MySQL error returned. (additional text here, can't remember).

Thanks, mugen

---

cedko.com -- Cartoonin' The World :)

Could you switch it on so I can check it myself? Also you can test it on my site.

Anyone else is having this problem?

---

Geeklog Polish Support Team

Hi Robin, it's active now you can see the error message when you logout from the website:
An SQL error has occurred. Please see error.log for details.

in error.log:
Wed 08 Mar 2006 23:04:47 GMT-8 - 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 'and receiverdelete='' and rd=''' at line 1. SQL in question: SELECT * FROM gl_pm WHERE sentto= and receiverdelete='' and rd=''

This only happens when I activate the php block for this plugin, otherwise it works fine.

Thanks for your help, mugen

---

cedko.com -- Cartoonin' The World :)

hello,

i've tried this PM plugin. it's nice & simple but only one problem for me atm.

as what mugen posted, the problem occured when activate php block.

i'm 90% sure that the line below got problem.



below are my error log.

There is one more thing that has to be done after installation of this plugin. You have to add pm.view feature to Logged-in users group.

This can be easily achieved using handy little script by Blaine called Group Access Tool.

I'll get back to you as soon as I have some answers to your issues
Glad you you like it.

---

Geeklog Polish Support Team

I think bieffe is on the right track.

---

cedko.com -- Cartoonin' The World :)

What does it actually write in this line 450?

---

Geeklog Polish Support Team

I'm sorry, I was looking at the wrong error log, the real error message is similar to bieffe's error:

Wed 08 Mar 2006 23:04:47 GMT-8 - 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 'and receiverdelete='' and rd=''' at line 1. SQL in question: SELECT * FROM gl_pm WHERE sentto= and receiverdelete='' and rd=''

Thanks for your help Robin - mugen

---

cedko.com -- Cartoonin' The World :)

This plugin looks nice ... BTW: Installation performed without any error or problems on my v1.4.0sr2 site.

After installation i was also possible to send and recieve messages but does anyone now if the plugin has the possibility to inform a user about his new messages? Right now the only way i see to get informed that a new message was arrived is by manually checking the "Private Messaging" Inbox.

Any Ideas?

c'ya KR

Hi KR, you need to create a special geeklog php block to inform users when they have a new message. To create a php block involves pasting some code in your /system/lib-custom.php file, then activating it in your block admin. Do a search on blocks to learn more.

To display when a new message has arrived, this is what bieffe and myself are trying to do now, but there seems to be some problem with the PM block code. Robin is helping to solve this problem.

Cheers, mugen

---

cedko.com -- Cartoonin' The World :)

What version of MySql are you using?

I checked it on two versions and looks like 4.0.24 returns this error and 4.1.12 doesn't.
So maybe Mysql upgrade would help

---

Geeklog Polish Support Team

Hi Robin, ISP is using 4.0.25 so can't upgrade. Thanks for your help guess have to leave out the block for now.

mugen

---

cedko.com -- Cartoonin' The World :)

my mysql version 4.1.15

OK
Let's give it a try.
I modified this sql from the block code and so far so good
Test it please and let me know about the results

---

Geeklog Polish Support Team

Hi Robin, nope not working, error message:
Fri 10 Mar 2006 12:11:16 GMT-8 - 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 'AND receiverdelete='' AND rd=''' at line 1. SQL in question: SELECT * FROM gl_pm WHERE sentto= AND receiverdelete='' AND rd=''

---

cedko.com -- Cartoonin' The World :)