Support Forum
Support Forum
Offline
Hi there,
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 5.7.5.2 running on WP 4.9.2
Any pointers to get me going would be much appreciated.
Cheers
DD
Offline
Odd. You clearly should not see any problem on a brand new install...
Can you go to the forum admin > toolbox > error log and report any SQL errors that are shown? include any php errors as well. Note these are all shown in pink.
 |
YELLOW
SWORDFISH
|
Offline
Thanks for the fast response. There are quite a few. Should I post them all here?
For example...
July 10, 2018 10:12 am | spaErrError | 1 | database
file: /mnt/target04/367543/367570/www.dailyphoto.co.uk/web/content/wp-content/plugins/simple-press/forum/database/sp-db-statistics.php
line: 200
function: spdb_table
error: Table '367570_DP16DbWP1.wp_sfforums' doesn't exist
SELECT * FROM wp_sfforums ORDER BY group_id
Offline
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?
|
YELLOW
SWORDFISH
|
Offline
Thanks.
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?
Cheers
DD
Offline
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...
|
YELLOW
SWORDFISH
|
Offline
Thanks.
Seems like there are loads of tables with 'sf' but no 'sfforums'. Here's a screenshot...
Cheers
DD
Offline
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.
|
YELLOW
SWORDFISH
|
Offline
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.
DD
All RSS1 Guest(s)