PDA

View Full Version : Database Problem..


Vman
05-31-2005, 06:48 AM
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:
++++++++++++++++++++++++++++++++++++++++++++++++

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_childre n\";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_belon ging_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/forums/admincp/awards_install.php?step=dophrases
Referer: http://www.bodybuildingcentral.net/forums/admincp/awards_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!

sv1cec
05-31-2005, 08:28 AM
I do not know what to say. AWS is adding settings and phrases, but I sincerely doubt if this is the cause of your error.

Sorry I can't be of more help.

Rgds

Marco van Herwaarden
05-31-2005, 01:11 PM
Do you have magic_quotes turned on at your server?

Anyhow try to upload the files again, making sure they are in ASCII format. Then try again.

Do you have/had any other problems on this server?

Marco van Herwaarden
05-31-2005, 01:15 PM
PS This seems more related to the shoutbox hack.

Vman
05-31-2005, 11:21 PM
Im thinking its because of the shoutbox hack, when I tried all the modifications people posted to make it work, Now I can't even uninstall the shoutbox, or any other hack without getting a error like the one above, mind you the sql error will show a large page full of html stuff, and other hack parts all in one...

Any suggestions without wiping out my database?

sv1cec
06-01-2005, 05:19 AM
I am not sure what to say. The error is not even coming from AWS code, so I guess something has messed up with your language tables. Before doing anything scary (like deleting your database) talk with the vB people, I think they have a scipt that allows you to fix some of those things. It's included in the distribution, in the section which is not for uploading.

Rgds

Vman
06-02-2005, 02:20 AM
Thanks Ill check it that...

sv1cec
06-02-2005, 08:00 PM
Let us know of the outcome.

Vman
06-02-2005, 11:47 PM
I can't find that script you are talking about....Im dead in the water!!!

Now I do know of 2 hacks that maybe causing this issue...the AWS and the Stats program that was in german, then translated into english...I can't seem to uninstall them...I don't know of any other way to unintstall them....Any suggestions?

Thanks
Don

sv1cec
06-03-2005, 03:10 AM
If you can give me access to your server I can check if AWS is installed and see if I can solve your problem.

Rgds

Vman
06-03-2005, 05:51 PM
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?

Marco van Herwaarden
06-03-2005, 06:13 PM
You can use ImpEx found in your member area downloads to get rid of the database modifications by hacks.

Vman
06-04-2005, 06:57 AM
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!