Print Page | Close Window

SQL HUGE Error!

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14232
Printed Date: 29 March 2026 at 10:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: SQL HUGE Error!
Posted By: os008
Subject: SQL HUGE Error!
Date Posted: 13 March 2005 at 9:05pm

Hi all,

ok, now to the point ... i have a vBulletin Forums installed on my server, i have the latest PHP and cPanel, i get this error when i try to add a Phrase to in the Phrase Management in the Forums AdminCP:

Invalid SQL: UPDATE language SET title = title, phrasegroup_messaging = 'a:34:{s:26:\"add_x_to_your_contact_list\";s:29:\"Add %1$s to your contact list\";s:3:\"aim\";s:3:\"AIM\";s:20:\"aim_hi_are_you_there\";s:18:\"Hi.+Are+you+there?\";s:13:\"emai l_subject\";s:13:\"Email Subject\";s:15:\"email_to_friend\";s:15:\"Email to Friend\";s:29:\"errors_occured_when_submitted\";s:61:\"The following errors occurred when this message was submitted\";s:4:\"from\";s:4:\"From\";s:3:\"icq\";s:3:\"ICQ\";s:3:\"msn\";s:3:\"MSN\";s:13:\"online_ status\";s:13:\"Online Status\";s:19:\"only_used_to_report\";s:139:\"<strong>Note</strong>: This is ONLY to be used to report spam, advertising messages, and problematic (harassment, fighting, or rude) posts.\";s:5:\"other\";s:5:\"Other\";s:23:\"recipient_email_address\";s:23:\"Recipient Email Address\";s:14:\"recipient_name\";s:14:\"Recipient Name\";s:15:\"report_bad_post\";s:15:\"Report Bad Post\";s:33:\"send_email_to_forum_administrator\";s:40:\"Send an Email to the Forum Administrator\";s:12:\"send_message\";s:12:\"Send Message\";s:30:\"send_message_via_aim_to_x_link\";s:80:\"Send Message Via AIM to <a href=\"%1$s\" target=\"_blank\"><strong>%2$s</strong></a>\";s:32:\"send_message_via_email_to_ x_link\";s:84:\"Send a message via Email to <a href=\"%1$s\" target=\"_blank\"><strong>%2$s</strong></a>\";s:30:\"send_message_via_icq_to_x_ link\";s:80:\"Send Message Via ICQ to <a href=\"%1$s\" target=\"_blank\"><strong>%2$s</strong></a>\";s:30:\"send_message_via_msn_to_x_ link\";s:80:\"Send Message Via MSN to <a href=\"%1$s\" target=\"_blank\"><strong>%2$s</strong></a>\";s:23:\"send_message_via_x_to_y\"; s:29:\"Send message via %1$s to %2$s\";s:32:\"send_message_via_yahoo_to_x_link\";s:83:\"Send Message Via Yahoo! to <a href=\"%1$s\" target=\"_blank\"><strong>%2$s</strong></a>\";s:21:\"send_page_to_a_friend\";s: 21:\"Send Page to a Friend\";s:16:\"send_x_a_message\";s:19:\"Send %1$s a message\";s:27:\"these_functions_require_aim\";s:129:\"Please note that these functions require that you actually have the AOL Instant Messenger application installed on your computer.\";s:27:\"these_functions_require_msn\";s:222:\"Please note that these functions require that you to be logged into either MSN Messenger or Windows Messenger. You will not be able to send messages to the email address that you are logged into MSN/Windows Messenger with.\";s:27:\"thought_might_be_interested\";s:118:\"I thought you might be interested in reading this web page:
%1$s/showthread.php?t=%2$s&referrerid=%3$s

From,
%4$s\";s:11:\"unread_date\";s:6:\"Unread\";s:34:\"using_form_email_available_to_user\";s:100:\"Note: By using this form, your email address will become available to the user who you are emailing.\";s:21:\"view_the_profile_of_x\";s:24:\"View the profile of %1$s\";s:5:\"yahoo\";s:6:\"Yahoo!\";s:12:\"your_details\";s:12:\"Your Details\";s:9:\"your_name\";s:9:\"Your Name\";}', phrasegroup_forumdisplay = 'a:48:{s:13:\"add_moderator\";s:13:\"Add Moderator\";s:11:\"admin_tools\";s:11:\"Admin Tools\";s:9:\"ascending\";s:9:\"Ascending\";s:9:\"beginning\";s:9:\"Beginning\";s:10:\"descending\"; s:10:\"Descending\";s:11:\"forum_tools\";s:11:\"Forum Tools\";s:8:\"from_the\";s:8:\"From the\";s:25:\"hot_thread_with_new_posts\";s:25:\"Hot thread with new posts\";s:28:\"hot_thread_with_no_new_posts\";s:28:\"Hot thread with no new posts\";s:13:\"last_100_days\";s:13:\"Last 100 Days\";s:12:\"last_10_days\";s:12:\"Last 10 Days\";s:11:\"last_2_days\";s:11:\"Last 2 Days\";s:13:\"last_2_months\";s:13:\"Last 2 Months\";s:12:\"last_2_weeks\";s:12:\"Last 2 Weeks\";s:12:\"last_45_days\";s:12:\"Last 45 Days\";s:12:\"last_75_days\";s:12:\"Last 75 Days\";s:8:\"last_day\";s:8:\"Last Day\";s:10:\"last_month\";s:10:\"Last Month\";s:14:\"last_post_time\";s:14:\"Last Post Time\";s:9:\"last_week\";s:9:\"Last Week\";s:9:\"last_year\";s:9:\"Last Year\";s:20:\"mark_this_forum_read\";s:20:\"Mark This Forum Read\";s:9:\"mass_move\";s:9:\"Mass Move\";s:10:\"mass_prune\";s:10:\"Mass Prune\";s:16:\"massmove_threads\";s:17:\"Mass-Move Threads\";s:17:\"massprune_threads\";s:18:\"Mass-Prune Threads\";s:22:\"no_posts_in_this_forum\";s:33:\"There are no posts in this forum.\";s:26:\"no_posts_last_x_days_forum\";s:61:\"There have been no posts in the last %1$s days in this forum.\";s:17:\"post_a_new_thread\";s:17:\"Post a New Thread\";s:15:\"post_new_thread\";s:15:\"Post New Thread\";s:6:\"rating\";s:6:\"Rating\";s:17:\"search_this_forum\";s:17:\"Search this Forum\";s:12:\"show_threads\";s:12:\"Show Threads\";s:27:\"showing_threads_x_to_y_of_z\";s:36:\"Showing threads %1$s to %2$s of %3$s\";s:10:\"sort_order\";s:10:\"Sort Order\";s:9:\"sorted_by\";s:9:\"Sorted By\";s:23:\"subscribe_to_this_forum\";s:23:\"Subscribe to This Forum\";s:40:\"thread_contains_a_message_written_by_you\";s:40:\"Thread Contains a Message Written By You\";s:16:\"thread_is_closed\";s:16:\"Thread is closed\";s:13:\"thread_rating\";s:13:\"Thread Rating\";s:12:\"thread_title\";s:12:\"Thread Title\";s:16:\"threads_in_forum\";s:16:\"Threads in Forum\";s:34:\"try_controls_below_for_older_posts\";s:74:\"Try using the controls below to search for any older posts that may exist.\";s:21:\"view_attachment_queue\";s:21:\"View Attachment Queue\";s:17:\"view_parent_forum\";s:17:\"View Parent Forum\";s:16:\"view_posts_queue\";s:16:\"View Posts Queue\";s:18:\"x_members_y_guests\";s:30:\"%1$s members &amp; %2$s guests\";s:30:\"you_have_posted_in_this_thread\";s:30:\"You have posted in this thread\";}', phrasegroup_postbit = 'a:34:{s:20:\"add_to_xs_reputation\";s:24:\"Add to %1$s\'s Reputation\";s:19:\"add_x_to_buddy_list\";s:27:\"Add %1$s to Your Buddy List\";s:29:\"administrator_decided_x_quiet\";s:85:\"The administrator has decided that <strong>%1$s</strong> should be quiet for a while.\";s:3:\"age\";s:3:\"Age\";s:14:\"attached_files\";s:14:\"Attached Files\";s:15:\"attached_images\";s:15:\"Attached Images\";s:19:\"attached_thumbnails\";s:19:\"Attached
.
.
.
.
.
mysql error number: 1064

Date: Sunday 13th of March 2005 08:21:08 AM
Script: http://www.ahmedosama.com/forums_vb/admincp/phrase.php - http://www.ahmedosama.com/forums_vb/admincp/phrase.php
Referer: http://www.ahmedosama.com/forums_vb/admincp/phrase.php?do=add&phrasetypeid=11&page=1&per page=15

it was working fine, suddenly it did that, i don't know y!

it's a very long error, i cut a large part, can u please help me, thanks.




Replies:
Posted By: michael
Date Posted: 13 March 2005 at 9:08pm
ehrm. First off I think you are on the wrong forum, this is wwg not vBulletin. Second, we sure like to help but noone can read what you pasted there.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: os008
Date Posted: 13 March 2005 at 9:10pm
that's the point :D
 
i don't understand what this is?!
 
and i know these forums from long ago, i know u people help, and this is a DB thing, so i'm in the right forums, it's not a vBulletin problem, it's an SQL problem, please try to help me, thanks.


Posted By: michael
Date Posted: 14 March 2005 at 7:51pm
Well looking just at the beginning, it says
Invalid SQL: UPDATE language SET title = title
the 2nd title should be in ' ' reading Set title='title'


-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: os008
Date Posted: 15 March 2005 at 8:15am
oops, sorry for not posting that i fixed it, the clue was at the end which i cut off when i posted it here, it said look around "...", when i did i found that the phrase wasn't in the DB, which is very odd, so i deleted the whole feature, and now it's working fine, i'm really sorry man, i'll be more careful about what i post next time, thanks for your support ;)



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net