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
Invalid Database Query
Avatar
Alan Newman
Member
Free Members
sp_UserOfflineSmall Offline
Oct 31, 2014 - 8:15 pm

Hello,

 

I updated a plugin File Uploader with Plupload to version 4.0.1

I am using Simple Press 5.5.0.

 

November 1, 2014 12:03 am | spaErrError | 2 | database


file: /problem-with-post-edit-buttonome/kingsrea/public_html/wp-content/sp-resources/forum-plugins/plupload/sp-plupload-plugin.php

line: 198

function: sp_plupload_do_forumview_query

error: Table 'kingsrea_13112012al.wp_sfpostattachments' doesn't exist

SELECT topic_id FROM wp_sfpostattachments WHERE topic_id IN (5,253,152,245,98,133,204,203,179,34)

 

I am now getting the Invalid Database Query error when choosing a forum.

I think its because the File Uploader with Plupload to version 4.0.1 is only compatible with Simplepress 5.5.1

I see there is a Simplepress 5.5.2 available but that requires WP 4.0 and I am using 3.9.1

If there a older version of the Fileuploader plugin I can get from somewhere?

Thanks

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 31, 2014 - 8:18 pm

you need at least simple press 5.5.1 (the current version is 5.5.2) to run that version of the file uploader plugin...

please upgrade your simple press install...

Avatar
Alan Newman
Member
Free Members
sp_UserOfflineSmall Offline
Oct 31, 2014 - 8:26 pm

Hi

 

I dont really want to upgrade to WP version 4.0 as SP 5.5.2 requires it just yet in case of any conflicts.

I just wanted to backout the plugin upgrade

 

Thanks

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 31, 2014 - 8:40 pm

you will only be able to go back to previous version if you have a db backup since the upgrade physically makes changes to the database...

fyi, WP version 5.1 beta is due out this weekend or next week...

Avatar
Alan Newman
Member
Free Members
sp_UserOfflineSmall Offline
Oct 31, 2014 - 8:44 pm

found older copy of plugin and restored it for now

 

I dont like upgrading wordpress and simplepress without having checked everything

 

I need to be more careful when upgrading simplepress plugin

the invalid db query error has gone now

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 31, 2014 - 8:50 pm

you may have issues with uploads... but could be okay too since the most of the data was moved in the 5.5.2 upgrade script...

Avatar
Alan Newman
Member
Free Members
sp_UserOfflineSmall Offline
Oct 31, 2014 - 8:53 pm

ok thanks!

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 31, 2014 - 11:24 pm

you are welcome...  btw, due to changes in WP 4.1, we will have to update a version 5.5.3 at the same time...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
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: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626