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
Plupload - image upload not working - database corrupted?
Avatar
AriM
Member
sp_UserOfflineSmall Offline
Sep 29, 2014 - 3:05 am

Made the change. First I got:

Parse error: syntax error, unexpected '|', expecting ')' in /problem-with-post-edit-buttonome/suomenor/public_html/wp-content/plugins/simple-press/sp-startup/forum/sp-forum-support-functions.php on line 552

Then changed the code back and tried again with '|'. This time it went through. No more missing argument errors.

But, still cannot upload images:

tietokannan virhe = database error

[29-Sep-2014 09:45:32 Europe/Helsinki] WordPress-tietokannan virhe Table 'suomenor_wp52.qbi_sfpostattachments' doesn't exist kyselylle SELECT topic_id FROM qbi_sfpostattachments WHERE topic_id IN (2) Tekijä: require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Divi/page.php'), the_content, apply_filters('the_content'), call_user_func_array, sp_render_forum, sp_process_template, sp_load_template, include('/sp-resources/forum-themes/default/templates/spForumView.php'), sp_this_forum, spForumView->__construct, spForumView->sp_forumview_query, apply_filters('sph_forumview_combined_data'), call_user_func_array, sp_plupload_forumview_query, sp_plupload_do_forumview_query, spdb_select

[29-Sep-2014 09:45:42 Europe/Helsinki] WordPress-tietokannan virhe Table 'suomenor_wp52.qbi_sfpostattachments' doesn't exist kyselylle SELECT * FROM qbi_sfpostattachments WHERE post_id IN (10,9,6,5,4) Tekijä: require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Divi/page.php'), the_content, apply_filters('the_content'), call_user_func_array, sp_render_forum, sp_process_template, sp_load_template, include('/sp-resources/forum-themes/default/templates/spTopicView.php'), sp_this_topic, spTopicView->__construct, spTopicView->sp_topicview_query, apply_filters('sph_topicview_combined_data'), call_user_func_array, sp_plupload_post_records, sp_plupload_do_post_records, spdb_table, spdb_select

Avatar
AriM
Member
sp_UserOfflineSmall Offline
Sep 29, 2014 - 3:46 am

Made the change. No more  “missing argument 2 for sp_setup…” errors.

However, I still couldn't upload images and the database error existed (because of the missing images?)

Deleted all forums and made a new one. 

Plupload still not working. "Start upload" button does not respond.

Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Sep 29, 2014 - 6:29 am

This is by the look of it outside my knowledge, so unfortunately we will probably have to wait for Steve to take a look, but if everything is right with the forum and the Plupload button is still not working, going back to basics are you getting any JS conflicts on the page?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 29, 2014 - 9:37 am

as I mentioned, fixing your other plugin/theme issue for the error will have no impact on the file uploading...

if the button is non responsive, its going to come down to js conflict...  do you have link to site so we can check for obvious error?

is this sp 5.5.1?  the db error seem to indicate you are missing a key db table...  do you see a wp_sfpostattachments table in your db?  your wp db prefix might be other than wp_

Avatar
AriM
Member
sp_UserOfflineSmall Offline
Sep 30, 2014 - 10:01 am

Progress made, I found a plugin that conflicts with Plupload. After removing  it, the image upload works!

However, I still keep getting those "Invalid database inquiry" messages every time I read a forum topic.

No, I do not see any wp_sfpostattachments table, but qbi_sfposts contains the newly uploaded image files

This is 5.5.1

Here is the link: http://ams21.siteground.eu/~su.....r/forum-2/  - site not published yet

The login details are in a PM for Papa

Thank you for your patience with this!

Edit: 

php_errorlog shows:

[30-Sep-2014 20:34:05 Europe/Helsinki] WordPress-tietokannan virhe Table 'suomenor_wp52.qbi_sfpostattachments' doesn't exist kyselylle SELECT topic_id FROM qbi_sfpostattachments WHERE ...

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 30, 2014 - 10:46 pm

No...  sfposts will not contain any images...  it contains only the post content...  it may contain some html img tags, but no uploaded images (semantics perhaps)...

so if uploads are occurring are they showing in posts? complete with the the attachments box below the post with links to the attachments?

With the error and missing table, I highly doubt it...  The image may be uploading and an html img tag to it generated in the content, but you probably dont have the real attachment...  it is only stored in the sfpostattachments table...

so something went amiss on your server at install or upgrade and the script that creates the table errored out...  to get rid of the error and really get attachments, you will have to manually create that table...

what version of file uploader??  want to make sure its the latest...

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