Help please…
...one site in my sites in a MSM setup is down and only shows some SQL garbage on the front page and any URL I try manually:
# # TABLE STRUCTURE FOR: exp_actions # DROP TABLE IF EXISTS exp_actions; CREATE TABLE `exp_actions` ( `action_id` int(4) unsigned NOT NULL auto_increment, `class` varchar(50) NOT NULL, `method` varchar(50) NOT NULL, PRIMARY KEY (`action_id`) ) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8; INSERT INTO exp_actions (action_id, class, method) VALUES (‘1’, ‘Comment’, ‘insert_new_comment’); INSERT INTO exp_actions ...
Its an EE 1.6.9 installation and the two other sites in the same MSM installation seem to be unaffected, backend shows fine as well.
I already tried to repair and optimize the MySQL tables from within the CP as well as phpMyAdmin, delete the cache, restart the mysql server and the complete machine ... no luck. Templates seem to be okay as well.
index.php and path.php don’t seem to be hacked - running out of ideas at the moment.
-Markus
UPDATE:
Just received the following error in the backend:
MySQL ERROR:
Error Number: 1064
Description: 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 ‘ORDER BY exp_lg_polls.id ASC LIMIT 1’ at line 20
Query: SELECT exp_lg_polls.id as id, exp_lg_polls.entry_id as entry_id, exp_lg_polls.weblog_id as weblog_id, exp_lg_polls.total_votes as total_votes, exp_lg_polls.voting_groups as voting_groups, exp_lg_polls.result_mode as result_mode, exp_lg_polls.result_order as result_order, exp_lg_polls.allow_duplicates as allow_duplicates, exp_lg_polls.voting_groups as voting_groups, exp_weblog_titles.title as entry_title, exp_weblog_titles.entry_date as entry_date, exp_weblog_titles.expiration_date as expiration_date, exp_weblog_titles.status as status FROM exp_lg_polls LEFT JOIN exp_weblog_titles ON exp_weblog_titles.entry_id = exp_lg_polls.entry_id WHERE exp_lg_polls.entry_id = ORDER BY exp_lg_polls.id ASC LIMIT 1
Will look at it and perhaps try to disable lg_polls.
UPDATE 2:
Deleting all references to LG Polls and deinstalling the module solved the problem. Maybe an incomaptibility with EE 1.6.9 that I haven’t noticed earlier?
Sorry for bothering anyone, site is running again.