On these pages are my WordPress plugins, the odd article and my Support Forum.

For my random rantings on everything else please visit my blog at Yellow Swordfish

WP Plugins


Articles

If you find any of my plugins useful, please comsider a donation towards my running costs.

Thank you

In preparation for the release of the first beta of Simple:Press Version 4.0, the Support Forum has moved to a new site dedicated to the plugin. This will also be the future home for Simple:Press Forum.


Version 3.1.4 will still be available for download here in the short term.


For the support forum - and to visit our new site click on the logo to take you to simplepressforum.com

This forum is currently locked - access is read only
Current User: Guest
Please consider registering

 
Search Forums:


 




Error Activating Plugin

UserPost

5:04 pm
22 Jan 2008


gbr

Member

posts 6

1

Hi,

I get the following errors when activating the plug in:

 [STDERR] WordPress database error You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near ” AND meta_value < DATE_SUB(CURDATE(),
INTERVAL 1 YEAR)’ at line 1 for query UPDATE gbr_usermeta SET
meta_value=now() WHERE meta_key = gbr_sflast’ AND meta_value <
DATE_SUB(CURDATE(), INTERVAL 1 YEAR);

 [STDERR] WordPress database error Table
‘gerald_wordpress.gbr_sfsettings’ doesn’t exist for query DELETE FROM
gbr_sfsettings WHERE setting_name <> ‘maxonline’;

 WordPress database error Table ‘gerald_wordpress.gbr_sfsettings’
doesn’t exist for query ALTER TABLE gbr_sfsettings MODIFY setting_name
VARCHAR(50) NOT NULL;

 WordPress database error Table ‘gerald_wordpress.gbr_sfsettings’ doesn’t exist for query DESC gbr_sfsettings

 

This is probably my fault, but I’m still looking for help.  I had wordpress and simple forums on  a machine.  I then moved the database over to a new machine and got everything running there.  My problem is that I only moved the wordpress tables, and none of the Simple Forum tables.  I didn’t need to save the simple forum data.

I imagine the Wordpress tables contain simple forums setup info.  Is there a quick way I can get simple forums installed?

Thanks,

Gerald 

 

5:40 pm
22 Jan 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252

2

My guess is that you didn’t use the uninstall option before removing the tables. This means that the tables were dumped but the option records were not. One of the options holds the version flag so when you re-activated, it looked in  the options, found the version flag and, quite righty, decided your forum software was up to date so didn’t install anything else.

Either use the uninstall option now and then deactivate the plugin (You may get errors but it should work). Or, remove all of the option records that start ’sf’ (although it is safe to just remove the ’sfversion’ and ’sfbuild’ records from your Options table. 

6:21 pm
22 Jan 2008


gbr

Member

posts 6

3

Thanks for the reply.  I tried the uninstall, but the page errors out.  I’ll give it another go.

Just in case it doesn’t work, could you tell me the SQL commands for deleting the records?  My SQL is really rusty.

Thanks,
Gerald

 

8:16 pm
22 Jan 2008


gbr

Member

posts 6

4

Nope, can’t get the plugin to delete itself.  If you could help me out with the SQL I’ll need, I appreciate it.

Thanks,

Gerald

 

8:26 pm
22 Jan 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252

5

Use this:

DELETE FROM XXXX_options WHERE option_name = ’sfversion’ OR option_name=’sfbuild’;

changing the ‘XXXX’ for your table prefix.

 

10:44 pm
22 Jan 2008


gbr

Member

posts 6

6

Thank-you.  It’s all working again.

 Gerald 



Reply to Topic: Error Activating Plugin

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 12 + 7        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

11 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 16

Topics: 2068

Posts: 14091

Members:

There are 1003 members

There are 837 guests


Yellow Swordfish has made 5252 posts

Top Posters:

Mr Papa - 1602

-Radio- - 558

ovizii - 114

jfv - 82

angelic007 - 72

Administrator: Yellow Swordfish | Moderators: Yellow Swordfish, Mr Papa, -Radio-


© Simple:Press Forum - Version 3.1.4 (Build 357)