Something is wrong with your install there I feel. Those errors are indicative of some sort of underlying issue with the original install. Can you talk me through the installation? Were there any issues or anything odd about it?

not that i noticed i updated from 5.1.4 to 5.2.6 yesterday seemed to work fine yesterday i have been having issues installing the file attach plugin so been trouble shooting that but just seemed to lose the connection this morning

Ah. So actually any problem may have been during the upgrade to 5.2.6.
do you know how to and have easy access to look at database tables?

yeah i can what am i looking for

Going to just ask you to look one or two random things up to see if there is a general issue there or if it is fairly isolated… So –

1. table ‘sfposts’ – column ‘poster_ip’ should be set as a varchar 39 characters. Is it?
2. table ‘sfforums’ – should have a column called ‘keywords’. Does it?
3. is there a table named ‘sflogmeta’

And can you tell me what Simple:Press forum theme you are using and, if one of ours, is it up to date?

1. this is set as varchar 39

2. there is no keywords column

3. there is not table sflogmeta

i am just using the deflaut theme but have never updateded it

So… somewhere along the line of the upgrade it started to miss things which is not good. But what is really bad is that it should have aborted the upgrade with errors – especially if it failed on the SQL updates which clearly in at least two cases – it did.

So do you have any data already created or is this the very start of creating it? We either need to check what is missing and add it back or scrap what you have and start again so that really depends on any data you already haver set…

there are a few posts in the system if possible would rather keep them but depends on how much work it is going to be

Give me a little while and I will try and work out what we might need to do. Might not be that bad…

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’.

it only says ‘can view email addresses of members’

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

i am now getting

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