1
kerkyra
Private messages bug
  • 2010/6/10 10:39

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


hi i'm trying to view the messages in private messaging and i get an empty table in the site although i have 2 unread messages. in debug i get the following error.

SELECT COUNT(*) FROM `priv_msgs` WHERE (to_delete = '0' AND to_userid = '1' AND to_save = '0')
Error number: 1054
Error message: Unknown column 'to_delete' in 'where clause'

i have xoops 2.4.5RC2

any ideas?

2
tsbmusic
Re: Private messages bug
  • 2010/6/10 12:50

  • tsbmusic

  • Just popping in

  • Posts: 22

  • Since: 2010/4/12


Did you update Xoops?

3
ghia
Re: Private messages bug
  • 2010/6/10 15:16

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


The problem might come from the fact that the sql from the install comes with a table structure for the priv_msgs table that is not on par with the sql file from the PM module itself and where these fields are missing.
An uninstall and reinstall of the PM module should fix this.

This is also the case in the current version 2.4.4.
I wonder what is the point of having the priv_msg table is in the general xoops install, while the PM module has to be installed separatly at the end of the install procedure.

4
kerkyra
Re: Private messages bug
  • 2010/6/10 17:19

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


thanks, i reinstalled the module and the problem is fixed
whttp://www.guidemap.gr - Beta is out...

5
deka87
Re: Private messages bug
  • 2010/6/10 20:43

  • deka87

  • Friend of XOOPS

  • Posts: 1125

  • Since: 2007/10/5


i also had this issue on xoops.org when it showed me in the right block that i have an unread message though i had none.
Mind anchors

6
madDan
Re: Private messages bug
  • 2010/6/10 23:56

  • madDan

  • Not too shy to talk

  • Posts: 105

  • Since: 2010/1/6 1


Quote:

deka87 wrote:
i also had this issue on xoops.org when it showed me in the right block that i have an unread message though i had none.



I have found on my site that all the sortof realtime blocks and modules like PMs etc need the same cache ie little to none, as some users were a little impatient and if things were not updated on the fly they saw them as a bug and couldn't get their heads around the idea of caches.

Although I suppose it is our own faults I have three areas that highlight PM's the area under the banner the view your messages envelope icon, the user menu inbox and the MP Manager block, then I still get people asking how/where to send a PM etc? (Privately I am not sure some people should use the internet )

Login

Who's Online

222 user(s) are online (143 user(s) are browsing Support Forums)


Members: 0


Guests: 222


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits