I'm looking to move a large forum over to SP and am creating a test environment to check functionality.
On installation with demo content, I'm getting an 'Invalid database query' error on the front end.. http://dailyphoto.co.uk/forum/ and in the admin, when I try and add a forum to a group, I'm getting a 'New forum creation failed' error.
I've installed SP version 126.96.36.199 running on WP 4.9.2
Any pointers to get me going would be much appreciated.
Thanks for the fast response. There are quite a few. Should I post them all here?
July 10, 2018 10:12 am | spaErrError | 1 | database
error: Table '367570_DP16DbWP1.wp_sfforums' doesn't exist
SELECT * FROM wp_sfforums ORDER BY group_id
No that will do... that one is bad enough! You are missing one of the most important tables!
So - some questions before going further.
- Is this a completely NEW and first time install of SP?
- If NO - i.e., it has been installed before but not used - was it properly uninstalled before (as opposed to simply being deactivated)?
- If YES - were no error messages shown during the install?
- If YES - do you have any sort of security plugin or restriction on being able to create new database tables?
answers to your questions:
1 - completely new, 1st time install
2 - NA
3 - No error messages on install, it counted through the steps and the last one was the successful install message.
4 - Not that I'm aware of. I have successfully installed other plugins on this test domain that require database tables to be created.
4b - However, just to test, I have subsequently installed SP as new install on another domain, same host, and that too has the same front end error and inability to create a forum, so there may be a restriction somewhere. Any suggestions what to look for or update?
Curious. Failing to create a table is a most uncommon experience. In fact I am not sure it has happened before.
if you have access to the database - i.e., via phpMyAdmin for example - could you take a quick look at the table listing? All SP tables are prefixed with 'sf' (after the WP prefix of course). it would be useful to know if they are really there - especially the table 'sfforums'.
If sfforums table IS there can you highlight it so that it lists structure and then click on the 'Operations' menu item at the top. This will show a page that includes a 'Table Maintenance' menu listing. If it comes up then click on 'check table' and see what the feedback is...
You are missing two tables and you have no idea how confused I am by this!
If I give you the SQL statement to create them are you comfortable running the SQL from phpMydmin?
That also has the benefit of reporting a problem if there is one and, perhaps, solving the mystery.
That makes two of us confused. Especially as it's the same on the second test site that I installed.
I'm limited in technical knowledge but not daft enough to try something that I don't understand. I have a colleague who is very competent so I'd defer to him if what you suggest is beyond me.
Thanks for your ongoing support. It's really appreciated.