Support Forum
Support Forum
Offline
There are a lot of php errors on the site around depreciated code for the sites theme that I need to fix but I can't see any related to the forum.
Offline
This is most disturbing. And the fact that it left the old table in place is even more strange - which still to me suggests an error...
Tell me - after you reactivated the PM plugin and ran the next page did it sem to take a long time to load? Just wondering about a timeout condition...
Do you know how to run database queries at all? Another approach would be to find out exactly what should get selected... and I can probably create a query to find out.
 |
YELLOW
SWORDFISH
|
Offline
No much experience with DB queries but i am sure i can figure it out.
Quite the opposite it actually activates the plugin in 1-2 seconds which seems too fast
Offline
No it should activate quite fast. It would be the next admin page load that probably mattered more.
I would try this query:
SELECT DISTINCT title, message_slug FROM wp_sfmessages ORDER BY message_id WHERE to_id <> from_id';
You may need to change the table prefix (wp_) if you changed to from the default at set up time,
You can run this via phpMyAdmin. It is a simple select and really we just need to find out if it returns any data rows - and if so - how many.
|
YELLOW
SWORDFISH
|
Offline
Hi I am getting the error
ERROR: Unclosed quote @ 97
Offline
Whoops. Sorry - should not have that single quote at the end. Copy and paste error. The semi-colon is optional.
|
YELLOW
SWORDFISH
|
Offline
Unfortunately still getting errors even without the semi colon:
SQL query: [Image Can Not Be Found]
SELECT DISTINCT title, message_slug FROM wp_sfmessages ORDER BY message_id WHERE to_id <> from_id
LIMIT 0, 25
MySQL said: [Image Can Not Be Found]
Offline
From the error message it looks like the angle brackets are getting converted to html entities and thus mangled as far as SQL goes. You probably need to type it in not copy and paste.
|
YELLOW
SWORDFISH
|
Offline
Hi I typed it in and it has made no difference. Is there anyway I can just rename the old table and import the data?
The plugin is not seeing the table at all, I am not sure where to go from here. I need to upgrade the live forum asap but don't want users to loose there PM's.
This is a far from ideal situation.
All RSS1 Guest(s)