Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
Private messaging stopped working
Avatar
Stefano Prete
Melbourne, Australia
Member
Free Members
sp_UserOfflineSmall Offline
Nov 4, 2013 - 4:04 pm

Hi guys.

Out of a sudden, on the forum page a pop up message appears.

I have it in Italian, in English it sounds like "Non valid request to the database".

All the PMs disappeared and the PM plugin stopped working. I uninstalled it, installed it again but still the same problem. I have no idea why it happened...It's like a table is gone from the dB, but I could be wrong...

How can I fix it?

Thank you.

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 4, 2013 - 5:20 pm

just stopped working?  what changed?  something must have...

take a look at the forum - toolbox - error log admin panel and please tell us the entire error message...  best to look right after trying to view pms...

paste the message here, but please do not at this time post and php notices you might be seeing - just want warnings or errors...

Avatar
Stefano Prete
Melbourne, Australia
Member
Free Members
sp_UserOfflineSmall Offline
Nov 5, 2013 - 1:11 am

Steve, I have no idea what happened...

The error log is full of stuff!

Here is what I see re.errors.

The following dB tables do not exist:

wp_sfpmthreads

wp_sfbuddies

wp_sfpmrecipients

 

Also something else happened!

I have a file sp-plugin-styles-all.css completely custom. Everytime the forum gets updated, I overwrite that file with mine and everything works fine.But now something changed...

Looking at Firebug, I noticed that the css comes from wp-content/sp-resources/forum-cache/

So I have overwritten that file as well, but nothing changes. Also, in Firebug, the link is wp-content/sp-resources/forum-cache//sp-plugin-styles-all.css

Where is that double slash coming from?

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

Private Messaging

So it looks like when you activated/updated the PM plugin then it was unable to create the necessary new tables. And that is a little worrying. I assume you have current messages in your database that are wanted so we can't uninstall it and start again. I will need to do some tests and talk to Steve regarding the best way to force the upgrade of PMs to have another go. I believe this is the only report we have of this so it is curious as to why the upgrade failed to run...

Combined CSS Cache

We did indeed relocate this as it had become apparent that placing it directly under the wp-content folder was not an option for all users. Your double-slash issue is also a unique report to the best of my knowledge. Again - I will have to ask around here to see if there are any ideas but I suspect external influence in some way....

andy-signature.png
YELLOW
SWORDFISH
Avatar
Stefano Prete
Melbourne, Australia
Member
Free Members
sp_UserOfflineSmall Offline
Nov 5, 2013 - 4:39 am

Thank you Andy!

All the PMs have been lost, but that's not a problem. The problem now is, it's not possible to send a PM!

It says "Unable to create a new PM thread".

As for the CSS, is that file somewhere else, apart from wp-content and sp-resources/cache?

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

The existing PMs should not be lost. They are just currently inaccessible.

No the CSS file is only held in that one location. But that is a good point. Go to the forum admin > Integration > Storage Locations and check the 'forum-cache' folder. Is it held in there correctly? No slash ion the end?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Stefano Prete
Melbourne, Australia
Member
Free Members
sp_UserOfflineSmall Offline
Nov 5, 2013 - 5:03 am

No trailing slash at the end, Andy.

As for the PMs, I uninstalled and reinstalled the plugin once again and now it's working!laugh

All the older PMs are gone, but that's fine.

Now I need to fix the problem with the damn CSS file...

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 5, 2013 - 5:59 am

Ah yes - uninstall will remove all the old ones I am afraid. But still - if that is OK at least it gets you back working.

I have left a note to ask Steve about the CSS file issue but am still thinking it might be an external thing. Anything installed that might be effecting url's in this way/

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 5, 2013 - 11:47 am

why do you overwrite with your own version of a cache file? risky at best...  its a generated file and could get recreated as needed...

as Andy says, the location was moved and is now controlled on the forum - integration - storage locations...

the // issue was introduced during the move and already has been fixed for next version (Andy was on vacation and missed the ticket/fix)...  but its harmless...  the // directory will be the same as a single slash directory...

so not really sure what css issue you are having (apart from overwriting a generated file - risky)...

Avatar
Stefano Prete
Melbourne, Australia
Member
Free Members
sp_UserOfflineSmall Offline
Nov 5, 2013 - 3:04 pm

Steve, that CSS file is located in the wp-content folder.

I used to overwrite it after each upgrade and it was working perfectly.

I have tried and delete the one created in the cache and the system generates it again as it should, but it's not like the one I have overwritten in wp-content.

Pretty strange...

Could W3 Total Cache be involved somewhat? I had W3TC up and running even before and nothing ever happened...

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: 619
Members: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625