A A A
Forum Scope


Match



Forum Options



Min search length: 3 characters / Max search length: 84 characters
Forum Login
Lost password?
plugins-topic
Invalid Database Query error with Private Message plugin
Avatar
dogsday

63 Posts
(Offline)
1
Aug 10, 2018 - 6:17 am
Print

Hi there,

I’m installing and configuring a few plugins to see how they work and am having a problem with the Private Messaging plugin.

It uploaded and activated fine and I see the PM inbox on the top bar, but when I click on it, I get an ‘Invalid Database Query’ error as per the attached screenshot.

Any pointers to fix would be appreciated.

Thanks

DD

PM-database-error2018-08-10-at-11.11.22.pngImage Enlarger

Avatar
Yellow Swordfish
Glinton, England

16436 Posts
(Offline)
2
Aug 10, 2018 - 6:32 am
Print

Odd. Two questions: Have you ever had the plugin active before? Are both your SP Core plugin and the PM add-on plugin both up to date?

Can you please go to the forum admin > toolbox > error log.

There may be several entries but can you concentrate in looking for the SQL one that will show the query that is causing the problem. If you could copy the contents of that entry and paste it here we can evaluate what might have caused the issue.

andy-signature.png
YELLOW
SWORDFISH
Avatar
dogsday

63 Posts
(Offline)
3
Aug 10, 2018 - 8:03 am
Print

Thanks,

First time installation this morning. Both core and plugin are up-to date.

Wondering if it’s same issue as initial install when certain database tables weren’t created..?

Trying to paste log below but I’m getting a forbidden message when submitting.

Will get some screen grabs and paste

DD

Avatar
dogsday

63 Posts
(Offline)
4
Aug 10, 2018 - 8:05 am
Print
Avatar
Mr Papa
Simi Valley, CA

19448 Posts
(Offline)
5
Aug 10, 2018 - 6:41 pm
Print

so pretty clearly says a required db table doesn’t exist… seems to be a brand new install of the private messaging plugin?  just confirming… if so, can  you uninstall it (see the link on forum – plugins – plugin list)…  after uninstalling, then go ahead and reactive/install…  lets see if it will create the tables this time… quite odd…

Avatar
Mr Papa
Simi Valley, CA

19448 Posts
(Offline)
6
Aug 10, 2018 - 6:42 pm
Print

nvm… seems like @Yellow Swordfish has a solution… seems the slug having issue fitting into mb4 char…

will let him come back here…

Avatar
Yellow Swordfish
Glinton, England

16436 Posts
(Offline)
7
Aug 11, 2018 - 2:35 am
Print

Ah yes – it’s the problem we had before with the InnoDB utfmb4 index size. My apologies – I did not realise there was another one lurking in the system! Having checked this I see we also have one in the Tags plugin which I will also deal with.

If I recall correctly you were happy to run the create sql in phpMyAdmin before and if that is the case the SQL you will need is in the attached zip file.

And I will open a ticket to get this and the Tags one corrected in the future.

Once again – my apologies.

andy-signature.png
YELLOW
SWORDFISH
Avatar
dogsday

63 Posts
(Offline)
8
Aug 11, 2018 - 3:15 am
Print

Thanks YS.

No need for apologies.

I have just run that SQL script and all is working fine now. I downloaded the Tags plugin too but not installed yet – trying to get my head around one plugin at a time.

How do I get updated plugins? does a notice appear in the SP>Plugin area?

Thanks again for your help

DD

Avatar
Yellow Swordfish
Glinton, England

16436 Posts
(Offline)
9
Aug 11, 2018 - 2:40 pm
Print

Well Tags will fail with the same problem so attached is the zip file needed to create the main tags table. These are all now corrected in the next set of updates which may be 5.8…

andy-signature.png
YELLOW
SWORDFISH
Avatar
dogsday

63 Posts
(Offline)
10
Aug 12, 2018 - 2:58 am
Print

Perfect.

Thanks

DD

Forum Timezone: America/New_York
All RSSShow Stats
Administrators: Blues Dancer, Simple Press, SP Community Support
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 630
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Newest Members:
David Hnát
Gary Lee
Glen Stewart
Rodney Pacis
kent black
Robert Meharg
test test
narek amprachamian
Forum Stats:
Groups: 7
Forums: 17
Topics: 10065
Posts: 79362

 

Member Stats:
Guest Posters: 607
Members: 16923
Moderators: 0
Admins: 3

Most Users Ever Online
499
Currently Online
Guest(s)
8
Currently Browsing this Page

1 Guest(s)