RichKavanagh

As a test, I copied the file wp-includes/query.php from the old version of the site to the new 3.8 version and hey presto, the search functions are now all working again.

Obviously this is not an ideal solution going forwards so I’m still looking for the exact cause / cure if anyone can help?

Interesting!

Thanks for your help with this one mattyrob, it would appear that WP_DEBUG has revealed a rather fundamental issue I think.

WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ‘wp_subscribe2’.]
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE ‘ N’wp_subscribe2”

WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure ‘SHOW’.]
SHOW TABLES

WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named ‘wp_subscribe2’ in the database.]
CREATE TABLE wp_subscribe2 ( id int NOT NULL IDENTITY(1,1), email NVARCHAR(64) COLLATE database_default NOT NULL default ”, active tinyint default 0, date DATE default ‘2013-05-13′ NOT NULL, time TIME DEFAULT ’00:00:00’ NOT NULL, ip char(64) NOT NULL default ‘admin’, conf_date DATE, conf_time TIME, conf_ip char(64), CONSTRAINT [wp_subscribe2_id] PRIMARY KEY CLUSTERED (id) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY];

WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure ‘SHOW’.]
SHOW TABLES

This could explain a lot?

Hi there mattyrob,

Confirmed the plugin is set to send from a specific (on-domain) email account.

As mentioned, the plugin can send an email using the “Send email” option on the admin page – not sure if that’s relevant though.

Any other suggestions or things I can look for / test?

Thanks!