Please turn off Annoying Survey

@robertskiba,

there is a button to the right.

There is no working button. There is only “I have already done it” and it doesnt turn of at all.

strange, when I click “I have already done it” it disappears.

I have Chrome 40 and nothing seems to happen/load/ajax etc. The Box disappears but reappears as soon as I’m loading the next page.

deactivating qTr x and activate again may be?

@robertskiba: are you one the early birds from deprecation of mqTranslate? If so, your database may be out of order, and that is why it does not turn off. I observed this issue on a broken database. I am sorry about that rush of unprepared deprecation, but you would need to migrate again now starting from your clean database, which used to work fine with mq, and using 3.2 version of -X. I hope you still have a backup of that, otherwise it is too much of manual work to undo incorrect effect that early “Convert Database” action. I am sorry again …

Yes I changed to QT-X because I thought it would be a planned advise to do so and I trusted the author of mQ

Can you give me more advice about the tables that are involved?

How can I check if the database is broken or out of order?

…still waiting for an answer…

PS: I didn’t do “convert database to the “square bracket only” style.”

I just imported the mqtranslate-settings…

I am sorry, @robertskiba, I am not sure what is wrong. Is it on your test-copy of the site? If so, you could give us admin login (send it to qtranslateteam at gma il d co m), and we will try to figure out what happened.

Hi Guys,

it is still not possible to turn off the survey.

I have looked into the Database with phpmyadmin. Maybe you can find a reason what maybe the problem.

I’m guessing that jquery or ajax is the origin.

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle <code>wpwack_options</code>
--

CREATE TABLE IF NOT EXISTS <code>wpwack_options</code> (
  <code>option_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>option_name</code> varchar(64) NOT NULL DEFAULT '',
  <code>option_value</code> longtext NOT NULL,
  <code>autoload</code> varchar(20) NOT NULL DEFAULT 'yes',
  PRIMARY KEY (<code>option_id</code>,<code>option_name</code>),
  UNIQUE KEY <code>option_name</code> (<code>option_name</code>)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=233770 ;

--
-- Daten für Tabelle <code>wpwack_options</code>
--

INSERT INTO <code>wpwack_options</code> (<code>option_id</code>, <code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES
(22354, 'widget_qtranslate', 'a:5:{i:3;a:12:{s:5:"title";s:0:"";s:4:"type";s:4:"both";s:10:"hide-title";s:2:"on";s:20:"theme_widget_show_on";s:3:"all";s:26:"theme_widget_page_ids_list";s:0:"";s:19:"theme_widget_styles";s:7:"default";s:23:"theme_widget_front_page";i:0;s:24:"theme_widget_single_post";i:0;s:24:"theme_widget_single_page";i:0;s:23:"theme_widget_posts_page";i:0;s:21:"theme_widget_page_ids";i:0;s:20:"theme_widget_styling";s:0:"";}i:4;a:12:{s:5:"title";s:0:"";s:4:"type";s:4:"both";s:19:"theme_widget_styles";s:7:"default";s:20:"theme_widget_show_on";s:3:"all";s:26:"theme_widget_page_ids_list";s:0:"";s:10:"hide-title";s:2:"on";s:23:"theme_widget_front_page";i:0;s:24:"theme_widget_single_post";i:0;s:24:"theme_widget_single_page";i:0;s:23:"theme_widget_posts_page";i:0;s:21:"theme_widget_page_ids";i:0;s:20:"theme_widget_styling";s:0:"";}i:5;a:12:{s:5:"title";s:0:"";s:4:"type";s:4:"both";s:10:"widget-css";s:0:"";s:19:"theme_widget_styles";s:7:"default";s:20:"theme_widget_show_on";s:3:"all";s:23:"theme_widget_front_page";i:0;s:24:"theme_widget_single_post";i:0;s:24:"theme_widget_single_page";i:0;s:23:"theme_widget_posts_page";i:0;s:21:"theme_widget_page_ids";i:0;s:26:"theme_widget_page_ids_list";s:0:"";s:10:"hide-title";s:2:"on";}i:6;a:11:{s:5:"title";s:16:"Sprache/Language";s:4:"type";s:4:"both";s:10:"widget-css";s:490:".qtranxs_flag_and_text {\r\ntext-decoration: none;\r\nmargin-left: 24.7px;\r\n}\r\n\r\n.qtranxs_flag_and_text span {\r\ncolor: white;\r\nfont-weight: 600;\r\nfont-size: 14px;\r\npadding-left: 1.5em;\r\n}\r\n\r\n.qtranxs_flag_and_text A:visited, A:visited  span {\r\ncolor: white;\r\n} \r\n.qtranxs_flag_and_text A:hover, A:hover span { \r\ncolor: grey; \r\n}\r\n.qtranxs_flag_and_text A span { \r\ncolor: grey;\r\n}\r\n\r\n.qtranxs_widget {\r\ncolor: white;\r\nfont-weight: 600;\r\nfont-size: 0.8em;\r\nmargin-left: -1em;\r\nmargin-top: 1em;\r\n}";s:19:"theme_widget_styles";s:7:"default";s:20:"theme_widget_show_on";s:3:"all";s:23:"theme_widget_front_page";i:0;s:24:"theme_widget_single_post";i:0;s:24:"theme_widget_single_page";i:0;s:23:"theme_widget_posts_page";i:0;s:21:"theme_widget_page_ids";i:0;s:26:"theme_widget_page_ids_list";s:0:"";}s:12:"_multiwidget";i:1;}', 'yes'),
(22372, 'qtranslate_qtranslate_services', '0', 'yes'),
(176098, 'wprc_t_expired_qtranslate/qtranslate.php', '0', 'yes'),
(176124, 'qtranslate_next_update_mo', '1425593644', 'yes'),
(176125, 'qtranslate_language_names', 'a:2:{s:2:"en";s:7:"English";s:2:"de";s:7:"Deutsch";}', 'yes'),
(176126, 'qtranslate_enabled_languages', 'a:2:{i:0;s:2:"de";i:1;s:2:"en";}', 'yes'),
(176127, 'qtranslate_default_language', 'de', 'yes'),
(176129, 'qtranslate_flags', 'a:2:{s:2:"en";s:6:"gb.png";s:2:"de";s:6:"de.png";}', 'yes'),
(176130, 'qtranslate_locales', 'a:2:{s:2:"en";s:5:"en_US";s:2:"de";s:5:"de_DE";}', 'yes'),
(176131, 'qtranslate_na_messages', 'a:2:{s:2:"en";s:55:"Sorry, this entry is only available in %LANG:, : and %.";s:2:"de";s:58:"Leider ist der Eintrag nur auf %LANG:, : und % verfügbar.";}', 'yes'),
(176132, 'qtranslate_date_formats', 'a:2:{s:2:"en";s:14:"%A %B %e%q, %Y";s:2:"de";s:17:"%A, der %e. %B %Y";}', 'yes'),
(176133, 'qtranslate_time_formats', 'a:2:{s:2:"en";s:8:"%I:%M %p";s:2:"de";s:5:"%H:%M";}', 'yes'),
(176134, 'qtranslate_ignore_file_types', 'gif,jpg,jpeg,png,pdf,swf,tif,rar,zip,7z,mpg,divx,mpeg,avi,css,js', 'yes'),
(176135, 'qtranslate_url_mode', '2', 'yes'),
(176136, 'qtranslate_term_name', 'a:0:{}', 'yes'),
(176137, 'qtranslate_use_strftime', '4', 'yes'),
(176140, 'qtranslate_auto_update_mo', '0', 'yes'),
(176141, 'qtranslate_hide_default_language', '0', 'yes'),
(233714, 'qtranslate_next_thanks', '1434230180', 'yes'),
(233715, 'qtranslate_admin_notices', '1', 'yes'),
(233718, 'qtranslate_qtrans_compatibility', '1', 'yes'),
(233737, 'qtranslate_header_css', '.qtranxs_flag_de {background-image: url(https://www.wackenbus.de/wp-content/plugins/qtranslate-x/flags/de.png); background-repeat: no-repeat;}\n.qtranxs_flag_en {background-image: url(https://www.wackenbus.de/wp-content/plugins/qtranslate-x/flags/gb.png); background-repeat: no-repeat;}\n', 'yes'),
(233767, 'qtranslate_show_alternative_content', '1', 'yes');

Hi, @robertskiba, this is good way to troubleshoot it – thank you.

This information is stored in qtranslate_admin_notices, which is supposed to be an array, but you have integer ‘1’ there, for unknown reason. Mine looks like this, for example: a:2:{s:18:"new-options-ver-33";i:1428465459;s:26:"survey-translation-service";i:1428465461;}

Delete option qtranslate_admin_notices, and it should create it again in a correct way, when you dismiss the survey and other notices.

I now adjusted the code to do this fix automatically in the incoming version 3.3. Thank you for figuring it out.

Thank you, John.

I removed the entry and now it shows

a:1:{s:26:”survey-translation-service”;i:1428574020;}

and it behaves like expected

Thank you for the good support!