i tried running the update again and got the following errors this time

[31-Jul-2013 10:36:43 UTC] PHP Notice:  Use of undefined constant SF_USE_PRETTY_CBOX – assumed ‘SF_USE_PRETTY_CBOX’

[31-Jul-2013 10:36:44 UTC] WordPress database error Unknown column ‘keywords’ in ‘field list’ for query SELECT  wp_2_sftopics.forum_id, forum_slug, forum_name, forum_status, group_id, topic_count, forum_icon, topic_icon, topic_icon_new, forum_desc, forum_rss,

                                                                                                                forum_rss_private, parent, children, forum_message, keywords,

                                                                                                                wp_2_sftopics.topic_id, topic_slug, topic_name, topic_status, topic_pinned,

                                                                                                                topic_opened, wp_2_sftopics.post_id, wp_2_sftopics.post_count FROM wp_2_sftopics JOIN wp_2_sfforums ON wp_2_sftopics.forum_id = wp_2_sfforums.forum_id WHERE wp_2_sfforums.forum_id=3 ORDER BY topic_pinned DESC, wp_2_sftopics.post_id ASC LIMIT 0, 12 made by require(‘C:inetpubwwwrootwp-blog-header.php’), require_once(‘C:inetpubwwwrootwp-includestemplate-loader.php’), include(‘C:inetpubwwwrootwp-contentthemeschurchopepage.php’), get_template_part, locate_template, load_template, require(‘C:inetpubwwwrootwp-contentthemeschurchopeloop.php’), the_content, apply_filters(‘the_content’), call_user_func_array, sp_render_forum, sp_process_template, sp_load_template, include(‘C:inetpubwwwrootwp-contentsp-resourcesforum-themesdefaulttemplatesspForumView.php’), sp_this_forum, spForumView->__construct, spForumView->sp_forumview_query, spdbComplex->select, spdb_select

[31-Jul-2013 10:36:44 UTC] PHP Notice:  Use of undefined constant SF_USE_PRETTY_CBOX – assumed ‘SF_USE_PRETTY_CBOX’

[31-Jul-2013 10:36:44 UTC] PHP Notice:  Use of undefined constant SF_USE_PRETTY_CBOX – assumed ‘SF_USE_PRETTY_CBOX’

not sure about the pretty checkbox one – its not an error just a notice and annoyance but we will try to get rid of the notice…

but the missing keywords column is of concern… can you look in your database, the sfforums table and verify that you have or do not have a keywords column in there?  that was added via update some time ago… not sure how you would have missed an update… and oddly had one other user with same issue yesterday… he upgraded from a quite older version – dont remember on you…

if the column is missing, it will need to be added via phpmyadmin or other db tool…   you can get the structure of the column from simple-press/sp-startup/install/sp-install.php

Steve – we’ve been through all of this earlier in the thread and it is more than just this one column. The update from the 5.1.x original to the 5.2.6 is failing – simple as that. No script errors or anything. Best to just read the thread actually.

I am wondering at the moment if this might be an IIS issue.

so you are on top of the SF_USE_PRETTY_CBOX one?   thats not used anywhere in the current code or in 5.2.6…   It was used in 5.1.4 where the upgrade was from which makes me wonder whether there really is 5.2.6 on the server…  Even if the upgrade is failing, the code on the server should be correct…

Think I would reupload it… 

SF_USE_PRETTY_CBOX needs a theme update. This was moved into the themes functions file.

Still struggling to understand what can be wrong with this one. Something IIS related is a possibility. WordPress does not recommend IIS and I do know people have struggled with IIS WP sites before. But before we go anywhere near that can of worms! can you list me the WordPress plugins that are active? You can get that list from the forum admin > Toolbox > Environment panel.

hi guys

sorry about the late reply to this the only other plug in i have active on the site is advance custom feilds

which btw, is known to have issues with wp 3.6 until they update… but doubt that is a player here…

Hi Guys

I have managed to get the forms working again as the upgardes on the test server and my other server where diffrent but am now having an issue with the plugin for attachments it disables the add reply button

Do you men you managed to get an update to actually run? If so that is better of course but you may still be missing something. What is in the error log? (Clear it out and then run a front forum page, a topic list and a post list and see what is reported)

hi the error log looks like this

[05-Aug-2013 14:50:41 UTC] PHP Warning:  include_once(C:inetpubwwwrootwp-contentpluginssimple-press/sp-startup/site/sp-site-deprecated.php): failed to open stream: No such file or directory in C:inetpubwwwrootwp-contentpluginssimple-presssp-startupsp-load-core.php on line 87
[05-Aug-2013 14:50:41 UTC] PHP Warning:  include_once(): Failed opening ‘C:inetpubwwwrootwp-contentpluginssimple-press/sp-startup/site/sp-site-deprecated.php’ for inclusion (include_path=’.;C:phppear’) in C:inetpubwwwrootwp-contentpluginssimple-presssp-startupsp-load-core.php on line 87
[05-Aug-2013 15:51:11 Europe/London] PHP Notice:  Use of undefined constant isAdmin – assumed ‘isAdmin’ in C:inetpubwwwrootallcsppRussiaVotesincludesfunctions.php on line 234
[05-Aug-2013 15:51:11 Europe/London] PHP Notice:  Use of undefined constant isAdmin – assumed ‘isAdmin’ in C:inetpubwwwrootallcsppRussiaVotesincludesmain_menu.php on line 71
[05-Aug-2013 14:51:48 UTC] PHP Warning:  include_once(C:inetpubwwwrootwp-contentpluginssimple-press/sp-startup/site/sp-site-deprecated.php): failed to open stream: No such file or directory in C:inetpubwwwrootwp-contentpluginssimple-presssp-startupsp-load-core.php on line 87
[05-Aug-2013 14:51:48 UTC] PHP Warning:  include_once(): Failed opening ‘C:inetpubwwwrootwp-contentpluginssimple-press/sp-startup/site/sp-site-deprecated.php’ for inclusion (include_path=’.;C:phppear’) in C:inetpubwwwrootwp-contentpluginssimple-presssp-startupsp-load-core.php on line 87
[05-Aug-2013 14:51:50 UTC] PHP Warning:  include_once(C:inetpubwwwrootwp-contentpluginssimple-press/sp-startup/site/sp-site-deprecated.php): failed to open stream: No such file or directory in C:inetpubwwwrootwp-contentpluginssimple-presssp-startupsp-load-core.php on line 87
[05-Aug-2013 14:51:50 UTC] PHP Warning:  include_once(): Failed opening ‘C:inetpubwwwrootwp-contentpluginssimple-press/sp-startup/site/sp-site-deprecated.php’ for inclusion (include_path=’.;C:phppear’) in C:inetpubwwwrootwp-contentpluginssimple-presssp-startupsp-load-core.php on line 87
[05-Aug-2013 14:51:50 UTC] PHP Warning:  include_once(C:inetpubwwwrootwp-contentpluginssimple-press/sp-startup/site/sp-site-deprecated.php): failed to open stream: No such file or directory in C:inetpubwwwrootwp-contentpluginssimple-presssp-startupsp-load-core.php on line 87
[05-Aug-2013 14:51:50 UTC] PHP Warning:  include_once(): Failed opening ‘C:inetpubwwwrootwp-contentpluginssimple-press/sp-startup/site/sp-site-deprecated.php’ for inclusion (include_path=’.;C:phppear’) in C:inetpubwwwrootwp-contentpluginssimple-presssp-startupsp-load-core.php on line 87
[05-Aug-2013 14:51:50 UTC] PHP Warning:  include_once(C:inetpubwwwrootwp-contentpluginssimple-press/sp-startup/site/sp-site-deprecated.php): failed to open stream: No such file or directory in C:inetpubwwwrootwp-contentpluginssimple-presssp-startupsp-load-core.php on line 87
[05-Aug-2013 14:51:50 UTC] PHP Warning:  include_once(): Failed opening ‘C:inetpubwwwrootwp-contentpluginssimple-press/sp-startup/site/sp-site-deprecated.php’ for inclusion (include_path=’.;C:phppear’) in C:inetpubwwwrootwp-contentpluginssimple-presssp-startupsp-load-core.php on line 87

so first question, is wwwroot the right directory?

if so, look in wp-content/plugins/simple-press/sp-startup and see if you actually have an sp-decprecated.php file… perhaps your upload was corrupted…

was this new install or an upgrade?

added the sp-decprecated.php now getting the following errors

[06-Aug-2013 07:42:36 UTC] PHP Notice:  Use of undefined constant SP_COMBINED_SCRIPTS_BASE_NAME – assumed ‘SP_COMBINED_SCRIPTS_BASE_NAME’
[06-Aug-2013 07:42:40 UTC] WordPress database error Duplicate column name ‘keywords’ for query ALTER TABLE wp_2_sfforums ADD (keywords varchar(256) default NULL) made by require(‘C:inetpubwwwrootwp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, sp_ahah_handler, include(‘C:inetpubwwwrootwp-contentpluginssimple-presssp-startupinstallsp-upgrade.php’), spdb_query
[06-Aug-2013 07:43:06 UTC] PHP Warning:  call_user_func_array() expects parameter 1 to be a valid callback, function ‘sp_load_plugin_styles’ not found or invalid function name in C:inetpubwwwrootwp-includesplugin.php on line 403

So it looks like you have other files missing from the install – not just the ‘sp-decprecated.php’ file.

I am not really sure where you up to here. Can you give me an update? Have you ever actually managed to run the upgrade? Is anything working at all?

Yeah i have now got the upgrade to work and the forms are running again as they were i now just have an issue installing the plug in