Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > Advanced Warning System (AWS)
FAQ Community Calendar Today's Posts Search

Closed Thread
 
Thread Tools
Database Problem.. Details »»
Database Problem..
Version: , by Vman Vman is offline
Developer Last Online: May 2008 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 05-31-2005 Last Update: Never Installs: 0
 
No support by the author.

Im not sure is this is the cause...but when I try to install this hack I get this:

I may have a corrupt sql database:
++++++++++++++++++++++++++++++++++++++++++++++++
Code:
Database error in vBulletin 3.0.7:
 
Invalid SQL: UPDATE language SET title = title, phrasegroup_cphome = 'a:139:{s:15:\"add_new_avatars\";s:15:\"Add New Avatars\";s:15:\"add_new_bb_code\";s:15:\"Add New BB Code\";s:16:\"add_new_calendar\";s:16:\"Add New Calendar\";s:16:\"add_new_faq_item\";s:16:\"Add New FAQ Item\";s:13:\"add_new_forum\";s:13:\"Add New Forum\";s:17:\"add_new_post_icon\";s:17:\"Add New Post Icon\";s:22:\"add_new_scheduled_task\";s:22:\"Add New Scheduled Task\";s:14:\"add_new_smilie\";s:14:\"Add New Smilie\";s:20:\"add_new_subscription\";s:20:\"Add New Subscription\";s:12:\"add_new_user\";s:12:\"Add New User\";s:26:\"add_new_user_profile_field\";s:26:\"Add New User Profile Field\";s:17:\"add_new_user_rank\";s:17:\"Add New User Rank\";s:23:\"add_new_user_reputation\";s:23:\"Add New User Reputation\";s:18:\"add_new_user_title\";s:18:\"Add New User Title\";s:17:\"add_new_usergroup\";s:17:\"Add New Usergroup\";s:18:\"admin_help_manager\";s:18:\"Admin Help Manager\";s:19:\"administrator_notes\";s:19:\"Administrator Notes\";s:23:\"attachment_storage_type\";s:23:\"Attachment Storage Type\";s:16:\"attachment_usage\";s:16:\"Attachment Usage\";s:31:\"attachments_awaiting_moderation\";s:21:\"Moderated Attachments\";s:14:\"avatar_manager\";s:14:\"Avatar Manager\";s:19:\"avatar_storage_type\";s:19:\"Avatar Storage Type\";s:8:\"ban_user\";s:8:\"Ban User\";s:15:\"bb_code_manager\";s:15:\"BB Code Manager\";s:20:\"business_development\";s:20:\"Business Development\";s:16:\"calendar_manager\";s:16:\"Calendar Manager\";s:20:\"calendar_permissions\";s:20:\"Calendar Permissions\";s:9:\"calendars\";s:9:\"Calendars\";s:12:\"collapse_all\";s:12:\"Collapse All\";s:22:\"collapse_setting_group\";s:22:\"Collapse Setting Group\";s:16:\"community_forums\";s:16:\"Community Forums\";s:18:\"control_panel_home\";s:18:\"Control Panel Home\";s:19:\"custom_avatar_usage\";s:12:\"Avatar Usage\";s:15:\"custom_bb_codes\";s:15:\"Custom BB Codes\";s:28:\"custom_profile_picture_usage\";s:21:\"Profile Picture Usage\";s:30:\"custom_signature_picture_usage\";s:35:\"Custom Signature Picture Disk Usage\";s:19:\"database_data_usage\";s:10:\"Data Usage\";s:20:\"database_index_usage\";s:11:\"Index Usage\";s:23:\"download_latest_version\";s:23:\"Download Latest Version\";s:25:\"download_upload_languages\";s:27:\"Download / Upload Languages\";s:22:\"download_upload_styles\";s:24:\"Download / Upload Styles\";s:38:\"download_vbulletin_x_from_members_area\";s:60:\"Click here to download vBulletin %1$s from the Members\' Area\";s:9:\"due_tasks\";s:9:\"Due Tasks\";s:26:\"events_awaiting_moderation\";s:16:\"Moderated Events\";s:20:\"expand_setting_group\";s:20:\"Expand Setting Group\";s:5:\"extra\";s:5:\"Extra\";s:11:\"faq_manager\";s:11:\"FAQ Manager\";s:21:\"file_uploads_disabled\";s:21:\"FILE_UPLOADS Disabled\";s:15:\"forum_home_page\";s:15:\"Forum Home Page\";s:13:\"forum_manager\";s:13:\"Forum Manager\";s:17:\"forum_permissions\";s:17:\"Forum Permissions\";s:20:\"graphics_development\";s:20:\"Graphics Development\";s:15:\"holiday_manager\";s:15:\"Holiday Manager\";s:21:\"htl_cphome_hacks_menu\";s:10:\"Hacks menu\";s:26:\"htl_cphome_menu_navigation\";s:15:\"Menu Navigation\";s:31:\"htl_cphome_refresh_current_menu\";s:20:\"Refresh current menu\";s:27:\"htl_cphome_standard_vb_menu\";s:23:\"Standard vBulletin menu\";s:16:\"language_manager\";s:16:\"Language Manager\";s:9:\"languages\";s:9:\"Languages\";s:26:\"latest_version_available_x\";s:30:\"Latest version available: %1$s\";s:11:\"log_manager\";s:11:\"Log Manager\";s:12:\"members_area\";s:13:\"Members\' Area\";s:11:\"merge_users\";s:11:\"Merge Users\";s:20:\"moderate_attachments\";s:20:\"Moderate Attachments\";s:15:\"moderate_events\";s:15:\"Moderate Events\";s:14:\"moderate_posts\";s:14:\"Moderate Posts\";s:16:\"moderate_threads\";s:16:\"Moderate Threads\";s:5:\"mysql\";s:5:\"MySQL\";s:21:\"mysql_language_lookup\";s:21:\"MySQL Language Lookup\";s:21:\"mysql_max_packet_size\";s:17:\"MySQL Packet Size\";s:15:\"new_posts_today\";s:15:\"New Posts Today\";s:17:\"new_threads_today\";s:17:\"New Threads Today\";s:15:\"new_users_today\";s:15:\"New Users Today\";s:17:\"no_frames_support\";s:63:\"Your browser does not support frames. Please get one that does!\";s:24:\"other_contributions_from\";s:24:\"Other Contributions From\";s:19:\"php_function_lookup\";s:19:\"PHP Function Lookup\";s:17:\"php_max_post_size\";s:17:\"PHP Max Post Size\";s:19:\"php_max_upload_size\";s:23:\"PHP Maximum Upload Size\";s:16:\"php_memory_limit\";s:16:\"PHP Memory Limit\";s:14:\"phrase_manager\";s:14:\"Phrase Manager\";s:51:\"please_note_deleting_this_item_will_remove_children\";s:87:\"<b>Please note</b>: deleting this item will also remove any child entries of this item.\";s:17:\"post_icon_manager\";s:17:\"Post Icon Manager\";s:25:\"posts_awaiting_moderation\";s:15:\"Moderated Posts\";s:26:\"private_message_statistics\";s:26:\"Private Message Statistics\";s:15:\"product_manager\";s:15:\"Product Manager\";s:11:\"prune_users\";s:18:\"Prune / Move Users\";s:25:\"quick_administrator_links\";s:25:\"Quick Administrator Links\";s:21:\"quick_moderator_links\";s:21:\"Quick Moderator Links\";s:17:\"quick_user_finder\";s:17:\"Quick User Finder\";s:16:\"reference_manual\";s:16:\"Reference Manual\";s:9:\"referrals\";s:9:\"Referrals\";s:22:\"repair_optimize_tables\";s:24:\"Repair / Optimize Tables\";s:28:\"replacement_variable_manager\";s:28:\"Replacement Variable Manager\";s:12:\"revert_prefs\";s:12:\"Revert Prefs\";s:9:\"safe_mode\";s:9:\"Safe Mode\";s:22:\"scheduled_task_manager\";s:22:\"Scheduled Task Manager\";s:16:\"search_for_users\";s:16:\"Search for Users\";s:17:\"search_in_phrases\";s:17:\"Search in Phrases\";s:19:\"search_in_templates\";s:19:\"Search in Templates\";s:19:\"search_ip_addresses\";s:19:\"Search IP Addresses\";s:19:\"send_email_to_users\";s:19:\"Send Email to Users\";s:20:\"server_load_averages\";s:20:\"Server Load Averages\";s:11:\"server_type\";s:11:\"Server Type\";s:19:\"show_all_moderators\";s:19:\"Show All Moderators\";s:14:\"smilie_manager\";s:14:\"Smilie Manager\";s:21:\"software_developed_by\";s:21:\"Software Developed By\";s:20:\"software_development\";s:20:\"Software Development\";s:13:\"style_manager\";s:13:\"Style Manager\";s:20:\"subscription_manager\";s:20:\"Subscription Manager\";s:30:\"sure_you_want_to_log_out_of_cp\";s:54:\"Are you sure you want to log out of the control panel?\";s:18:\"test_communication\";s:18:\"Test Communication\";s:34:\"there_is_a_newer_vbulletin_version\";s:59:\"There is a newer version of vBulletin available to download\";s:27:\"threads_awaiting_moderation\";s:17:\"Moderated Threads\";s:32:\"unique_registered_visitors_today\";s:20:\"Unique Members Today\";s:13:\"upload_avatar\";s:13:\"Upload Avatar\";s:16:\"upload_post_icon\";s:16:\"Upload Post Icon\";s:13:\"upload_smilie\";s:13:\"Upload Smilie\";s:12:\"useful_links\";s:12:\"Useful Links\";s:26:\"user_profile_field_manager\";s:26:\"User Profile Field Manager\";s:17:\"user_rank_manager\";s:17:\"User Rank Manager\";s:10:\"user_ranks\";s:10:\"User Ranks\";s:23:\"user_reputation_manager\";s:23:\"User Reputation Manager\";s:16:\"user_reputations\";s:16:\"User Reputations\";s:18:\"user_title_manager\";s:18:\"User Title Manager\";s:11:\"user_titles\";s:11:\"User Titles\";s:17:\"usergroup_manager\";s:17:\"Usergroup Manager\";s:25:\"users_awaiting_moderation\";s:15:\"Moderated Users\";s:31:\"users_online_x_members_y_guests\";s:48:\"%1$s Users Online (%2$s members and %3$s guests)\";s:37:\"vbulletin_developers_and_contributors\";s:39:\"vBulletin Developers &amp; Contributors\";s:17:\"view_banned_users\";s:17:\"View Banned Users\";s:16:\"view_permissions\";s:16:\"View Permissions\";s:13:\"view_php_info\";s:13:\"View PHP info\";s:14:\"view_reminders\";s:14:\"View Reminders\";s:10:\"web_server\";s:10:\"Web Server\";s:44:\"welcome_to_the_vbulletin_admin_control_panel\";s:44:\"Welcome to the vBulletin Admin Control Panel\";s:48:\"welcome_to_the_vbulletin_moderator_control_panel\";s:48:\"Welcome to the vBulletin Moderator Control Panel\";s:35:\"you_are_running_vbulletin_version_x\";s:48:\"You are currently running vBulletin version %1$s\";s:20:\"you_have_x_tasks_due\";s:38:\"You have %1$s tasks now due or overdue\";s:39:\"your_version_of_vbulletin_is_up_to_date\";s:47:\"Your version of vBulletin (%1$s) is up-to-date.\";}', phrasegroup_cpuser = 'a:189:{s:10:\"accept_all\";s:10:\"Accept All\";s:21:\"add_new_custom_avatar\";s:21:\"Add New Custom Avatar\";s:18:\"add_new_user_title\";s:18:\"Add New User Title\";s:16:\"additional_users\";s:16:\"Additional Users\";s:41:\"all_members_of_this_usergroup_will_revert\";s:73:\"All members of this usergroup will revert to the <i>registered</i> group.\";s:30:\"all_posts_will_be_set_to_guest\";s:50:\"All posts made by this user will be set to \'Guest\'\";s:8:\"all_time\";s:8:\"All Time\";s:21:\"allow_access_to_forum\";s:21:\"Allow Access to Forum\";s:68:\"are_you_sure_want_to_delete_private_messages_belonging_to_the_user_x\";s:194:\"Are you <b>sure</b> you want to delete the private messages belonging to the user called \'%1$s\'?<br /><span class=\"smallfont\">(%2$s: %3$s)</span><br /><br /> %4$s This action can not be un-done.\";s:63:\"are_you_sure_want_to_delete_private_messages_sent_by_the_user_x\";s:189:\"Are you <b>sure</b> you want to delete the private messages sent by the user called \'%1$s\'?<br /><span class=\"smallfont\">(%2$s: %3$s)</span><br /><br /> %4$s This action can not be 
mysql error: Unknown column 'phrasegroup_shoutbox' in 'field list'
 
mysql error number: 1054
 
Date: Tuesday 31st of May 2005 03:34:27 AM
Script: http://www.bodybuildingcentral.net/f...step=dophrases
Referer: http://www.bodybuildingcentral.net/f...ds_install.php
Username: Vman
IP Address: 69.225.21.225
I had to delete alot to make it fit!!!!

But this happens when I try to install any hack at this point!

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 06-03-2005, 05:51 PM
Vman Vman is offline
 
Join Date: Apr 2004
Posts: 167
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have re-uploaded all the vB files to over ride the old once to get rid of any hacks...so its a sql database thing...

Do you know of a hack I can use to clean up my sql?
  #13  
Old 06-03-2005, 06:13 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You can use ImpEx found in your member area downloads to get rid of the database modifications by hacks.
  #14  
Old 06-04-2005, 06:57 AM
Vman Vman is offline
 
Join Date: Apr 2004
Posts: 167
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ill try that. I just tried to install another hack and got and sql database error in the Phrase section!!!!...

This seems to be the problem with all the hack the Phrases!
Closed Thread


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:27 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04932 seconds
  • Memory Usage 2,268KB
  • Queries Executed 20 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (3)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete