Support Forum
Support Forum
Offline
any time i try to add a new forum i get an error message that the create forum has failed I also get a error of invalid database query when i try to view any exsisting forums view error log below 
Offline
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?
 |
YELLOW
SWORDFISH
|
Offline
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
Offline
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?
|
YELLOW
SWORDFISH
|
Offline
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 -
- table 'sfposts' - column 'poster_ip' should be set as a varchar 39 characters. Is it?
- table 'sfforums' - should have a column called 'keywords'. Does it?
- 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?
|
YELLOW
SWORDFISH
|
Offline
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
Offline
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...
|
YELLOW
SWORDFISH
|
All RSS