Trying to upgrade from RC2 to RC4...Error

[Curll]

I have no idea what the hell this means. Any help would be GREATLY appreciated

Step 4) Import latest language

Importing vbulletin-language.xml

There has been and error, blah, blah

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL: UPDATE language SET title = title, phrasegroup_messaging = 'a:35:{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:\"email_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:\"Rec ipient 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:125:\"Please note that these functions require that you actually have the Windows Messenger application installed on your computer.\";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

more coming

[Curll]

Actually, here's the whole thing in an attached text file. Makes more sense, huh?

[MindTrix]

Thats a big error mate :) Best bet is to ask over at www.vbulletin.com though

[Curll]

I did. They said ask the author of the hack that's causing the problem.

[Dean C]

SET title = title

Should have single quotes around the assigned string :)

[Curll]

vb.com said this looks like the problem.

mysql error: Unknown column 'phrasegroup_hacklog' in 'field list'

mysql error number: 1054

And, where would I go to edit the SET title = title?

The hacklog is the HTL hack, which is KuraFire's porject. But, yeah. I didn't install the HTL, our other programmer did.

*sigh*

[Dean C]

Well I don't know much about the HTL but basically you are missing a column which is installed as one of the steps in the HTL. You should ask this in the thread :)