cyberflo

Hello,
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

Hello,
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

Hello,
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 utf8mb4

Have 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

Hello, 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!