Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Private messages disappearing
Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Nov 18, 2013 - 5:59 am

You are correct, one row is indeed missing. All messages in that thread have two rows except for the one reported missing, there's only one row. However, there are no warnings or error messages logged for PMs other than the 'header already sent' posted prior. Everything else are just notices unrelated to PMs (a lot of those currently).

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 18, 2013 - 6:44 am

Ah well. Good and bad news!

Good in that we can pinpoint where the problem lies but bad that we don't know why. I was hoping for the error log entry as a 'headers already sent' condition might help explain missing entries although, to be fair, I would probably expect no entries to be made rather than just one.

And that leaves us with a difficult problem in terms of tracking down what is, currently, a one-off problem.

Were there no accompanying SQL DB errors reported in the Simple:Press error log (under Toolbox)?

On the Notices front - we do deal with those that get reported and any that our own tests and logs turn up. The problem is that so many are data related - i.e., a setting somewhere that has never been visited and didn't get properly initialised when created - that the potential combination is huge. And dealing with every one can add sometimes a lie or two of code. But yes - we deal with them all when we encounter them.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Nov 18, 2013 - 6:54 am

I do, occasionally, clean out the error logs. But when I checked yesterday I only found two header warnings and I hadn't cleaned up prior. But I am going to dig into my backups for the past few days and see if I can retrieve something else.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 18, 2013 - 7:07 am

That is much appreciated. thanks

andy-signature.png
YELLOW
SWORDFISH
Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Nov 18, 2013 - 7:17 am

So I just loaded a backup from 11/15. One of the messages that disappeared was sent on 11/14. But, there is no entry pertaining to PMs in the error log on that date. There are two on 11/15, but they are simply notices:

file: /wp-content/sp-resources/forum-plugins/private-messaging/ahah/sp-pm-ahah-post.php<br />line: 236<br />function: sp_pm_send_email<br />Notice | Undefined variable: newpost

file: /wp-content/sp-resources/forum-plugins/private-messaging/forms/sp-pm-compose-form.php<br />line: 113<br />function: sp_render_compose_pm_form<br />Notice | Undefined variable: change

127 notices for each. Sorry to say there is nothing else. I'll check another backup for a message that went missing on 11/16.

 

Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Nov 18, 2013 - 7:22 am

Nope, nothing, only those two notices again on 11/17. One warning on 11/16 pertaining to the blog post linking plugin, but that's it. The rest are all notices.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 18, 2013 - 8:53 am

Oh well - thanks for checking.

Guess our next task is to take a second look at the code around that bit to see if we can spot anything...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 18, 2013 - 8:04 pm

no, typo.. meant the recipients table as originally started in post 2...

this missing pm was between two folks, right?  any chance that one of them deleted the pm or thread?  wondering if perhaps a wrong element was removed... cannot duplicate though and first report, so as Andy says hard to neck down...

Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Nov 19, 2013 - 4:27 am

Yes, this has always occurred between two students. And no, the other student didn't delete the message, they never actually received it. And as mentioned it's also not pulling under the sending student's PMs either. I am sure this should still be in there even if the recipient deletes it on their side?

This has been reported on three occasions so far hence is rather seldom and random. But PMs are used extensively on our forum because students have to work together on homework, maybe that's why we've been noticing it.

Is there a way for me to put the missing row(s) in manually? I know this will be difficult to troubleshoot so in the meantime I'd prefer having an option to fix it manually if I need to.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 19, 2013 - 4:58 am

You certainly can manually create the needed rows in the recipients table using a tool like phpMyAdmin. All you need to know are the thread_id, the message_id and the user_id. Recipient_id is automatically filled and the other two columns can be set to 1.

I have opened a ticket on this but it is going to be hard to track down without a replicable scenario to work with. But I do assure you we will be looking at it...

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 617
Members: 17359
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10125
Posts: 79620