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
unable to add new forum or view exsisting
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 30, 2013 - 8:33 am

OK - first up - sorry this has happened. I would really like to know why as this is not something I remember having to do before now. Either an upgrade works OK or errors with a message so this is somewhat strange!

Still - I am getting close I think. Can you make one other check for me in the data?

This time the table is 'sfauths' and we need to check one row of data. For the row with the 'auth_name' of 'view_email' can you tell me what the value is n the 'auth_desc' column? I am hoping it is 'Can view email and IP addresses of members'.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Autism Network
Member
Free Members
sp_UserOfflineSmall Offline
Jul 30, 2013 - 8:44 am

it only says 'can view email addresses of members'

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 30, 2013 - 8:56 am

OK. You may want to make a database backup before we do this. It is always recommended of course.

This is not a 100% perfect solution but it should be close. As long as it works this time of course!

  1. Go to the forum admin > toolbox.
  2. Over on the right in the main toolbox panel in the 'Modify Build Number' enter a number of 9500.
  3. Turn ON the option to Force upgrade to build number.
  4. Click on Update Toolbox.
  5. Select any forum menu and you should be directed to an Upgrade screen.
  6. Run the Update - hopefully to the end!
  7. Re-check the 3 questions asked here (2 in one post and 1 in another) to see if the answers are now correct.
  8. Let me know if all is well and we can take the next step

 

andy-signature.png
YELLOW
SWORDFISH
Avatar
Autism Network
Member
Free Members
sp_UserOfflineSmall Offline
Jul 30, 2013 - 9:01 am

i am now getting

Upgrade Aborted
9500
9877
success
Please copy the details below and include them on any support forum question you may have:
9877 - success
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 30, 2013 - 9:05 am

mmmm. Odd behaviour. What about the answers to the three questions please?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Autism Network
Member
Free Members
sp_UserOfflineSmall Offline
Jul 30, 2013 - 9:09 am

still the same as they were

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 30, 2013 - 9:23 am

This is quite disturbing. It is almost as if you have no rights to make database changes but you must have had to enable installing the plugin in the first place. And when we sort this out that will still leave future updates with a question mark over them.

Are you running any sort of http authentication system on your server? Or any sort of special security layer on your database (for example)?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Autism Network
Member
Free Members
sp_UserOfflineSmall Offline
Jul 30, 2013 - 9:28 am

there was an issue with iis user not having write permissions to the server but this has been fixed i got simple press running on a test server that is set up the same way so don't know what it might be

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 30, 2013 - 9:42 am

Have you run the same SP upgrade on your test server with no issue?

I am going to have to discuss this here to see if we can come up with any ideas... (Steve?)

andy-signature.png
YELLOW
SWORDFISH
Avatar
Autism Network
Member
Free Members
sp_UserOfflineSmall Offline
Jul 30, 2013 - 9:43 am

yes used the same update but ran fine

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: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625