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
Want to migrate my simple:press installation from one wp blog to another...
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 3, 2012 - 2:08 pm

Please run a page that gives the database error message. Then go to the forum admin > Toolbox > Error log and see what the error at the top is and paste it here in a reply.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Eric Grey
Member
Free Members
sp_UserOfflineSmall Offline
Jul 3, 2012 - 2:23 pm

I looked at the error log - it talked about attachments, so I thought I would see if disabling the SP file upload plugin would stop the error, and it did.  So, I'm no longer getting that permissions error for users.  I don't know if that information is useful - but it at least gives me a fix.

--

 

Here's the error:

 

file: /mnt/stor7-wc2-dfw1/538952/582652/www.deepesthealth.com/web/content/wp-content/plugins/simple-press/forum/content/classes/sp-topic-view-class.php
line: 231
function: select
error: Unknown column 'attachments' in 'field list'

SELECT wp_sftopics.topic_id, wp_sftopics.forum_id, topic_name, topic_slug, topic_status, topic_icon, wp_sftopics.post_count, forum_slug, forum_status, forum_rss_private, wp_sfposts.post_id, post_date, wp_sfposts.user_id, guest_name, guest_email, post_status, post_pinned, post_index, post_edit, poster_ip, post_content, wp_sfwaiting.post_count AS new_post, attachments, post_ratings, rating_id, vote_count, ratings_sum, ips, members, topic_subs, topic_watches FROM wp_sftopics JOIN wp_sfposts ON wp_sftopics.topic_id=wp_sfposts.topic_id JOIN wp_sfforums ON wp_sftopics.forum_id=wp_sfforums.forum_id LEFT JOIN wp_sfwaiting ON wp_sfposts.post_id=wp_sfwaiting.post_id LEFT JOIN wp_sfpostratings ON wp_sfpostratings.post_id = wp_sfposts.post_id WHERE wp_sftopics.topic_id=1 ORDER BY post_pinned DESC, wp_sfposts.post_id ASC LIMIT 0, 20

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 3, 2012 - 2:39 pm

yes - it means that on the source system the uploader SP plugin was not active so it had never created this field in the database.

If you uninstall the uploader plugin as opposed to deactivate it then you can install it again and it should create the correct db column,. It will revert to default settings of course.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Eric Grey
Member
Free Members
sp_UserOfflineSmall Offline
Jul 3, 2012 - 2:42 pm

Ah, ok!  I'll do that.  Thanks!

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jul 3, 2012 - 4:35 pm

let us know - fingers crossed...

Avatar
Eric Grey
Member
Free Members
sp_UserOfflineSmall Offline
Jul 3, 2012 - 4:35 pm

Done, fixed.  Strangely, I had to do this TWICE. But, it worked, and has stayed fixed!  Hurrah!

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jul 3, 2012 - 4:36 pm

sounds promising!  took us while, but we got there (hopefully) wink

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: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626