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
Invalid database query error and can't create forum
Avatar
dogsday
Member
Free Members
sp_UserOfflineSmall Offline
Jul 10, 2018 - 4:42 am

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 10, 2018 - 5:07 am

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
dogsday
Member
Free Members
sp_UserOfflineSmall Offline
Jul 10, 2018 - 5:15 am

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 10, 2018 - 6:16 am

No that will do... that one is bad enough! You are missing one of the most important tables!

So - some questions before going further.

  1. Is this a completely NEW and first time install of SP?
  2. If NO - i.e., it has been installed before but not used - was it properly uninstalled before (as opposed to simply being deactivated)?
  3. If YES - were no error messages shown during the install?
  4. If YES - do you have any sort of security plugin or restriction on being able to create new database tables?
andy-signature.png
YELLOW
SWORDFISH
Avatar
dogsday
Member
Free Members
sp_UserOfflineSmall Offline
Jul 10, 2018 - 6:27 am

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 10, 2018 - 6:39 am

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
dogsday
Member
Free Members
sp_UserOfflineSmall Offline
Jul 10, 2018 - 8:32 am

Thanks.

Seems like there are loads of tables with 'sf' but no 'sfforums'. Here's a screenshot...sftables.pngImage Enlarger

Cheers

DD

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 10, 2018 - 12:28 pm

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
dogsday
Member
Free Members
sp_UserOfflineSmall Offline
Jul 10, 2018 - 12:59 pm

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

Avatar
dogsday
Member
Free Members
sp_UserOfflineSmall Offline
Jul 10, 2018 - 1:07 pm

If it helps, here's the environment.

Plugins are unique to this test site, not the other.

Environment.pngImage Enlarger

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online: Lucille Splichal
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 639
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17342
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10116
Posts: 79581