cyberflo
Forum Replies Created
-
Forum: Plugins
In reply to: [Chained Quiz] Question not savedHello,
if I change the name “rank” to another name, could there be other problems? I would rename the name in basic.php and question.php before activating the plugin.
Should this be possible without any problems?Best Regards
Forum: Plugins
In reply to: [Chained Quiz] Question not savedHello,
i think i found the syntax “error”.rank() is a function in SQL ( new in version 8), as you can read here . So the plugin would work with a different name than rank for the question rank.
I hope I’m not too brazen when I ask you if you could change the name ‘rank’? Or has it been possible by the license that I change only in my installation? And if i can change it on my installation is there any other problem that a new name for ‘rank’ could cause?
p.s.: I have not posted to stackoverflow.
Thanks again and best regards
Forum: Plugins
In reply to: [Chained Quiz] Question not savedHello,
thank you for your reply.I have searched a lot (and unfortunatly i don′t know much about mySQL or the syntax), but i have not found a solution. These characters \n\t\t\t are only new line and tabulator that is in your plugin code. Is it unusual that these characters show up in the apache error log?
I dont know, if this could be because the website and wordpress is in german? Maybe there are any false character sets with the mySQL database?I use mySQL 8.0.15
PHP 7.3
Wordpress 5.4.1
This is no multisite
mySQL uses utf8mb4Have you a hint for me?
Is it ok for you, if i post this error (with the function of code the error shows) on stackoverflow or so, perhaps i can get there a hint for a solution?Is there anything i can change on the database to solve the problem?
Thank you for your help!
Best regards
Hello,
i found more information about this error. I get the following error when i activate (install) the plugin and this error causes the error i reported at first.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 'system INT NOT NULL,\n \t\t\trandomness_order INT NOT NULL,\n \t\t\tloggedin_user_cont' at line 19 f\xc3\xbcr Abfrage CREATE TABLE gowp_mlw_quizzes (\n \t\t\tquiz_id mediumint(9) NOT NULL AUTO_INCREMENT,\n \t\t\tquiz_name TEXT NOT NULL,\n \t\t\tmessage_before TEXT NOT NULL,\n \t\t\tmessage_after TEXT NOT NULL,\n \t\t\tmessage_comment TEXT NOT NULL,\n \t\t\tmessage_end_template TEXT NOT NULL,\n \t\t\tuser_email_template TEXT NOT NULL,\n \t\t\tadmin_email_template TEXT NOT NULL,\n \t\t\tsubmit_button_text TEXT NOT NULL,\n \t\t\tname_field_text TEXT NOT NULL,\n \t\t\tbusiness_field_text TEXT NOT NULL,\n \t\t\temail_field_text TEXT NOT NULL,\n \t\t\tphone_field_text TEXT NOT NULL,\n \t\t\tcomment_field_text TEXT NOT NULL,\n \t\t\temail_from_text TEXT NOT NULL,\n \t\t\tquestion_answer_template TEXT NOT NULL,\n \t\t\tleaderboard_template TEXT NOT NULL,\n \t\t\tsystem INT NOT NULL,\n \t\t\trandomness_order INT NOT NULL,\n \t\t\tloggedin_user_contact INT NOT NULL,\n \t\t\tshow_score INT NOT NULL,\n \t\t\tsend_user_email INT NOT NULL,\n \t\t\tsend_admin_email INT NOT NULL,\n \t\t\tcontact_info_location INT NOT NULL,\n \t\t\tuser_name INT NOT NULL,\n \t\t\tuser_comp INT NOT NULL,\n \t\t\tuser_email INT NOT NULL,\n \t\t\tuser_phone INT NOT NULL,\n \t\t\tadmin_email TEXT NOT NULL,\n \t\t\tcomment_section INT NOT NULL,\n \t\t\tquestion_from_total INT NOT NULL,\n \t\t\ttotal_user_tries INT NOT NULL,\n \t\t\ttotal_user_tries_text TEXT NOT NULL,\n \t\t\tcertificate_template TEXT NOT NULL,\n \t\t\tsocial_media INT NOT NULL,\n \t\t\tsocial_media_text TEXT NOT NULL,\n \t\t\tpagination INT NOT NULL,\n \t\t\tpagination_text TEXT NOT NULL,\n \t\t\ttimer_limit INT NOT NULL,\n \t\t\tquiz_stye TEXT NOT NULL,\n \t\t\tquestion_numbering INT NOT NULL,\n \t\t\tquiz_settings TEXT NOT NULL,\n \t\t\ttheme_selected TEXT NOT NULL,\n \t\t\tlast_activity DATETIME NOT NULL,\n \t\t\trequire_log_in INT NOT NULL,\n \t\t\trequire_log_in_text TEXT NOT NULL,\n \t\t\tlimit_total_entries INT NOT NULL,\n \t\t\tlimit_total_entries_text TEXT NOT NULL,\n \t\t\tscheduled_timeframe TEXT NOT NULL,\n \t\t\tscheduled_timeframe_text TEXT NOT NULL,\n \t\t\tdisable_answer_onselect INT NOT NULL,\n \t\t\tajax_show_correct INT NOT NULL,\n \t\t\tquiz_views INT NOT NULL,\n \t\t\tquiz_taken INT NOT NULL,\n \t\t\tdeleted INT NOT NULL,\n quiz_author_id INT NOT NULL,\n \t\t\tPRIMARY KEY (quiz_id)\n \t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci von activate_plugin, do_action('activate_quiz-master-next/mlw_quizmaster2.php'), WP_Hook->do_action, WP_Hook->apply_filters, QSM_Install::install, dbDelta
My mySQL version is in my message before. Can i make any mySQL settings to solve the problem? Have i false charater sets in mysql or something? Or could there be a name length restriction or anything else? Or perhaps because the website is in german?
Thank you and best regards
- This reply was modified 4 years, 10 months ago by Yui. Reason: please use CODE button for proper formatting
Forum: Plugins
In reply to: [Chained Quiz] Question not savedHello, thanks for your quick reply,
sorry i have not copied the complete error message because i don′t know if the error message contains private details from the server etc.
Here is the complete error message from the apache error log:
[Wed May 13 10:30:59 2020] [notice] WordPress-Datenbank-Fehler 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 ‘rank=0, title=’Test’, autocontinue=0, sort_order=1, \n\t\t\taccept_comments=0, accep’ at line 2 f\xc3\xbcr Abfrage INSERT INTO gowp_chained_questions SET\n\t\t\tquiz_id=1, question=’Test text’, qtype=’checkbox’, rank=0, title=’Test’, autocontinue=0, sort_order=1, \n\t\t\taccept_comments=0, accept_comments_label=’Your comments:’ von do_action(‘admin_page_chainedquiz_questions’), WP_Hook->do_action, WP_Hook->apply_filters, ChainedQuizQuestions::manage, ChainedQuizQuestions::add_question, ChainedQuizQuestion->add
If there are any details, that should not be public please tell me about it and i remove the details.
Thanks for your help!