View Single Post
  #5  
Old 08-08-2006, 10:26 PM
Cky47's Avatar
Cky47 Cky47 is offline
 
Join Date: Feb 2006
Location: PA
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01197 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