vb.org Archive - View Single Post

Cky47 · #5 08-08-2006, 10:26 PM

Ok i am the one helping him and it is giving methis error also.

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
	(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
	('1', '5', 'Post Thank You  Hank', 'admin_maintenance', 'if ($_REQUEST[\'do\'] == \'chooser\')\r\n{\r\n	print_form_header(\'misc\', \'post_thanks_user_amount\');\r\n	print_table_header($vbphrase[\'post_thanks_user_amount\'], 2, 0);\r\n	print_description_row($vbphrase[\'post_thanks_user_amount_help\']);\r\n	print_input_row($vbphrase[\'number_of_users_to_process_per_cycle\'], \'perpage\', 1000);\r\n	print_submit_row($vbphrase[\'post_thanks_user_amount\']);\r\n\r\n	print_form_header(\'misc\', \'post_thanks_thanked_posts\');\r\n	print_table_header($vbphrase[\'post_thanks_thanked_posts\'], 2, 0);\r\n	print_description_row($vbphrase[\'post_thanks_thanked_posts_help\']);\r\n	print_input_row($vbphrase[\'number_of_users_to_process_per_cycle\'], \'perpage\', 1000);\r\n	print_submit_row($vbphrase[\'post_thanks_thanked_posts\']);\r\n\r\n	print_form_header(\'misc\', \'post_thanks_thanked_times\');\r\n	print_table_header($vbphrase[\'post_thanks_thanked_times\'], 2, 0);\r\n	print_description_row($vbphrase[\'post_thanks_thanked_times_help\']);\r\n	print_input_row($vbphrase[\'number_of_users_to_process_per_cycle\'], \'perpage\', 1000);\r\n	print_submit_row($vbphrase[\'post_thanks_thanked_times\']);\r\n	\r\n	print_form_header(\'misc\', \'post_thanks_post_amount\');\r\n	print_table_header($vbphrase[\'post_thanks_post_amount\'], 2, 0);\r\n	print_description_row($vbphrase[\'post_thanks_post_amount_help\']);\r\n	print_input_row($vbphrase[\'number_of_posts_to_process_per_cycle\'], \'perpage\', 1000);\r\n	print_submit_row($vbphrase[\'post_thanks_post_amount\']);\r\n}\r\n\r\nif ($_REQUEST[\'do\'] == \'post_thanks_user_amount\')\r\n{\r\n	if (empty($vbulletin->GPC[\'perpage\']))\r\n	{\r\n		$vbulletin->GPC[\'perpage\'] = 1000;\r\n	}\r\n\r\n	$finishat = $vbulletin->GPC[\'startat\'] + $vbulletin->GPC[\'perpage\'];\r\n\r\n	echo \'<p>\' . $vbphrase[\'post_thanks_user_amount\'] . \'</p>\';\r\n\r\n	$users = $db->query_read(\"\r\n		SELECT *\r\n		FROM \" . TABLE_PREFIX . \"user\r\n		WHERE userid >= \" . $vbulletin->GPC[\'startat\'] . \" AND userid < $finishat\r\n		ORDER BY userid\r\n	\");\r\n	while ($user = $db->fetch_array($users))\r\n	{\r\n		$total = $db->query_first(\"\r\n			SELECT COUNT(*) AS post_thanks_user_amount FROM \" . TABLE_PREFIX . \"post_thanks\r\n			WHERE userid = $user[userid]\r\n		\");\r\n\r\n        if (!($total[post_thanks_user_amount]))\r\n        {\r\n          $total[post_thanks_user_amount] = 0;\r\n        }\r\n\r\n		$db->query_write(\"\r\n            UPDATE \" . TABLE_PREFIX . \"user\r\n            SET post_thanks_user_amount = $total[post_thanks_user_amount]\r\n            WHERE userid = $user[userid]\r\n            \");\r\n\r\n		echo construct_phrase($vbphrase[\'processing_x\'], $user[\'userid\']) . \"<br />\\n\";\r\n		vbflush();\r\n	}\r\n\r\n	if ($checkmore = $db->query_first(\"SELECT userid FROM \" . TABLE_PREFIX . \"user WHERE userid >= $finishat LIMIT 1\"))\r\n	{\r\n		print_cp_redirect(\"misc.php?\" . $vbulletin->session->vars[\'sessionurl\'] . \"do=post_thanks_user_amount&startat=$finishat&pp=\" . $vbulletin->GPC[\'perpage\']);\r\n		echo \"<p><a href=\\\"misc.php?\" . $vbulletin->session->vars[\'sessionurl\'] . \"do=post_thanks_user_amount&amp;startat=$finishat&amp;pp=\" . $vbulletin->GPC[\'perpage\'] . \"\\\">\" . $vbphrase[\'click_here_to_continue_processing\'] . \"</a></p>\";\r\n	}\r\n	else\r\n	{\r\n		define(\'CP_REDIRECT\', \'misc.php\');\r\n		print_stop_message(\'updated_post_counts_successfully\');\r\n	}\r\n}\r\n\r\nif ($_REQUEST[\'do\'] == \'post_thanks_thanked_posts\')\r\n{\r\n	if (empty($vbulletin->GPC[\'perpage\']))\r\n	{\r\n		$vbulletin->GPC[\'perpage\'] = 1000;\r\n	}\r\n\r\n	$finishat = $vbulletin->GPC[\'startat\'] + $vbulletin->GPC[\'perpage\'];\r\n\r\n	echo \'<p>\' . $vbphrase[\'post_thanks_thanked_posts\'] . \'</p>\';\r\n\r\n	$users = $db->query_read(\"\r\n		SELECT *\r\n		FROM \" . TABLE_PREFIX . \"user\r\n		WHERE userid >= \" . $vbulletin->GPC[\'startat\'] . \" AND userid < $finishat\r\n		ORDER BY userid\r\n	\");\r\n	while ($user = $db->fetch_array($users))\r\n	{\r\n		$total = $db->query_first(\"\r\n			SELECT COUNT(*) AS post_thanks_thanked_posts FROM \" . TABLE_PREFIX . \"post\r\n			WHERE userid = $user[userid] AND post_thanks_amount > 0\r\n		\");\r\n\r\n        if (!($total[post_thanks_thanked_posts]))\r\n        {\r\n          $total[post_thanks_thanked_posts] = 0;\r\n        }\r\n\r\n		$db->query_write(\"\r\n            UPDATE \" . TABLE_PREFIX . \"user\r\n            SET post_thanks_thanked_posts = $total[post_thanks_thanked_posts]\r\n            WHERE userid = $user[userid]\r\n            \");\r\n\r\n		echo construct_phrase($vbphrase[\'processing_x\'], $user[\'userid\']) . \"<br />\\n\";\r\n		vbflush();\r\n	}\r\n\r\n	if ($checkmore = $db->query_first(\"SELECT userid FROM \" . TABLE_PREFIX . \"user WHERE userid >= $finishat LIMIT 1\"))\r\n	{\r\n		print_cp_redirect(\"misc.php?\" . $vbulletin->session->vars[\'sessionurl\'] . \"do=post_thanks_thanked_posts&startat=$finishat&pp=\" . $vbulletin->GPC[\'perpage\']);\r\n		echo \"<p><a href=\\\"misc.php?\" . $vbulletin->session->vars[\'sessionurl\'] . \"do=post_thanks_thanked_posts&amp;startat=$finishat&amp;pp=\" . $vbulletin->GPC[\'perpage\'] . \"\\\">\" . $vbphrase[\'click_here_to_continue_processing\'] . \"</a></p>\";\r\n	}\r\n	else\r\n	{\r\n		define(\'CP_REDIRECT\', \'misc.php\');\r\n		print_stop_message(\'updated_post_counts_successfully\');\r\n	}\r\n}\r\n\r\nif ($_REQUEST[\'do\'] == \'post_thanks_thanked_times\')\r\n{\r\n	if (empty($vbulletin->GPC[\'perpage\']))\r\n	{\r\n		$vbulletin->GPC[\'perpage\'] = 1000;\r\n	}\r\n\r\n	$finishat = $vbulletin->GPC[\'startat\'] + $vbulletin->GPC[\'perpage\'];\r\n\r\n	echo \'<p>\' . $vbphrase[\'post_thanks_thanked_times\'] . \'</p>\';\r\n\r\n	$users = $db->query_read(\"\r\n		SELECT *\r\n		FROM \" . TABLE_PREFIX . \"user\r\n		WHERE userid >= \" . $vbulletin->GPC[\'startat\'] . \" AND userid < $finishat\r\n		ORDER BY userid\r\n	\");\r\n	while ($user = $db->fetch_array($users))\r\n	{\r\n		$total = $db->query_first(\"\r\n			SELECT SUM(post_thanks_amount) AS post_thanks_thanked_times FROM \" . TABLE_PREFIX . \"post\r\n			WHERE userid = $user[userid] AND post_thanks_amount > 0\r\n		\");\r\n\r\n        if (!($total[post_thanks_thanked_times]))\r\n        {\r\n          $total[post_thanks_thanked_times] = 0;\r\n        }\r\n\r\n		$db->query_write(\"\r\n            UPDATE \" . TABLE_PREFIX . \"user\r\n            SET post_thanks_thanked_times = $total[post_thanks_thanked_times]\r\n            WHERE userid = $user[userid]\r\n            \");\r\n\r\n		echo construct_phrase($vbphrase[\'processing_x\'], $user[\'userid\']) . \"<br />\\n\";\r\n		vbflush();\r\n	}\r\n\r\n\r\n	if ($checkmore = $db->query_first(\"SELECT userid FROM \" . TABLE_PREFIX . \"user WHERE userid >= $finishat LIMIT 1\"))\r\n	{\r\n		print_cp_redirect(\"misc.php?\" . $vbulletin->session->vars[\'sessionurl\'] . \"do=post_thanks_thanked_times&startat=$finishat&pp=\" . $vbulletin->GPC[\'perpage\']);\r\n		echo \"<p><a href=\\\"misc.php?\" . $vbulletin->session->vars[\'sessionurl\'] . \"do=post_thanks_thanked_times&amp;startat=$finishat&amp;pp=\" . $vbulletin->GPC[\'perpage\'] . \"\\\">\" . $vbphrase[\'click_here_to_continue_processing\'] . \"</a></p>\";\r\n	}\r\n	else\r\n	{\r\n		define(\'CP_REDIRECT\', \'misc.php\');\r\n		print_stop_message(\'updated_post_counts_successfully\');\r\n	}\r\n}\r\n\r\nif ($_REQUEST[\'do\'] == \'post_thanks_post_amount\')\r\n{\r\n	if (empty($vbulletin->GPC[\'perpage\']))\r\n	{\r\n		$vbulletin->GPC[\'perpage\'] = 1000;\r\n	}\r\n\r\n	$finishat = $vbulletin->GPC[\'startat\'] + $vbulletin->GPC[\'perpage\'];\r\n\r\n	echo \'<p>\' . $vbphrase[\'post_thanks_post_amount\'] . \'</p>\';\r\n\r\n	$posts = $db->query_read(\"\r\n		SELECT *\r\n		FROM \" . TABLE_PREFIX . \"post\r\n		WHERE postid >= \" . $vbulletin->GPC[\'startat\'] . \" AND postid < $finishat\r\n		ORDER BY postid\r\n	\");\r\n	while ($post = $db->fetch_array($posts))\r\n	{\r\n		$total = $db->query_first(\"\r\n			SELECT COUNT(*) AS post_thanks_amount FROM \" . TABLE_PREFIX . \"post_thanks\r\n			WHERE postid = $post[postid]\r\n		\");\r\n\r\n        if (!($total[post_thanks_amount]))\r\n        {\r\n          $total[post_thanks_amount] = 0;\r\n        }\r\n\r\n		$db->query_write(\"\r\n            UPDATE \" . TABLE_PREFIX . \"post\r\n            SET post_thanks_amount = $total[post_thanks_amount]\r\n            WHERE postid = $post[postid]\r\n            \");\r\n\r\n		echo construct_phrase($vbphrase[\'processing_x\'], $post[\'postid\']) . \"<br />\\n\";\r\n		vbflush();\r\n	}\r\n\r\n\r\n	if ($checkmore = $db->query_first(\"SELECT postid FROM \" . TABLE_PREFIX . \"post WHERE postid >= $finishat LIMIT 1\"))\r\n	{\r\n		print_cp_redirect(\"misc.php?\" . $vbulletin->session->vars[\'sessionurl\'] . \"do=post_thanks_post_amount&startat=$finishat&pp=\" . $vbulletin->GPC[\'perpage\']);\r\n		echo \"<p><a href=\\\"misc.php?\" . $vbulletin->session->vars[\'sessionurl\'] . \"do=post_thanks_post_amount&amp;startat=$finishat&amp;pp=\" . $vbulletin->GPC[\'perpage\'] . \"\\\">\" . $vbphrase[\'click_here_to_continue_processing\'] . \"</a></p>\";\r\n	}\r\n	else\r\n	{\r\n		define(\'CP_REDIRECT\', \'misc.php\');\r\n		print_stop_message(\'updated_post_counts_successfully\');\r\n	}\r\n}', 'post_thanks');

MySQL Error  : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date         : Tuesday, August 8th 2006 @ 06:01:49 PM
Script       : http://www.youngmoneyweb.com/board/admincp/plugin.php
Referrer     : http://www.youngmoneyweb.com/board/admincp/plugin.php?do=productadd
IP Address   : 24.239.216.190
Username     : Huron
Classname    : vb_database

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01212 seconds Memory Usage 1,823KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: