Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - SQL HUGE Error!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL HUGE Error!

 Post Reply Post Reply
Author
os008 View Drop Down
Newbie
Newbie


Joined: 07 July 2003
Location: Egypt
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote os008 Quote  Post ReplyReply Direct Link To This Post Topic: SQL HUGE Error!
    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
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.



Edited by os008 - 13 March 2005 at 9:11pm
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
os008 View Drop Down
Newbie
Newbie


Joined: 07 July 2003
Location: Egypt
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote os008 Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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'
Back to Top
os008 View Drop Down
Newbie
Newbie


Joined: 07 July 2003
Location: Egypt
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote os008 Quote  Post ReplyReply Direct Link To This Post 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 ;)
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.