Query problem

[Xplorer4x4]

So as intructed here https://vborg.vbsupport.ru/showpost....&postcount=123 , I changed the plug in from

PHP Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (isstaffrank INT(6) UNSIGNED NOT NULL DEFAULT '')"); 


to

PHP Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (isstaffrank INT(6) UNSIGNED NOT NULL)"); 


Now I get a datbase error every time I attempt to install product. I forgot to make a database back up before hand, so does anyone have any suggestions on fixxing the results of the second query?

[Marco van Herwaarden]

I suggest you post in the thread of the hack itself, instead of general forum. More chance of a quick answer.

Also it might help if you post the error message you get.

[Xplorer4x4]

Well this is the error I got at the time of installing hte product,

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-End Error Mess = 'a:4:{s:17:\"custom_link_added\";s:44:\"The custom link has su' at line 1
Error Number : 1064

As far as the datbase error itself, it depends on the hack, but lets use vBug Tracker for example:

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_inlinemod = 'a:37:{s:19:\"approve_attachments\";s:19:\"Approve Attachments\";s:13:\"approve_posts\";s:13:\"Approve Posts\";s:15:\"approve_threads\";s:15:\"Approve Threads\";s:15:\"clear_post_list\";s:18:\"Deselect All Posts\";s:17:\"clear_thread_list\";s:20:\"Deselect All Threads\";s:13:\"close_threads\";s:13:\"Close Threads\";s:14:\"delete_threads\";s:14:\"Delete Threads\";s:12:\"deselect_all\";s:29:\"<strong>Deselect</strong> All\";s:14:\"from_this_page\";s:17:\"From This Page...\";s:16:\"invert_selection\";s:33:\"<strong>Invert</strong> Selection\";s:11:\"merge_posts\";s:11:\"Merge Posts\";s:13:\"merge_threads\";s:13:\"Merge Threads\";s:16:\"moderated_thread\";s:16:\"Moderated Thread\";s:23:\"moderated_thread_prefix\";s:10:\"Moderated:\";s:10:\"moderation\";s:10:\"Moderation\";s:10:\"move_posts\";s:10:\"Move Posts\";s:12:\"move_threads\";s:12:\"Move Threads\";s:12:\"open_threads\";s:12:\"Open Threads\";s:10:\"select_all\";s:27:\"<strong>Select</strong> All\";s:21:\"select_closed_threads\";s:38:\"Select <strong>Closed</strong> Threads\";s:20:\"select_deleted_posts\";s:37:\"Select <strong>Deleted</strong> Posts\";s:22:\"select_deleted_threads\";s:39:\"Select <strong>Deleted</strong> Threads\";s:24:\"select_posts_from_guests\";s:41:\"Select Posts from <strong>Guests</strong>\";s:29:\"select_posts_with_attachments\";s:46:\"Select Posts with <strong>Attachments</strong>\";s:21:\"select_sticky_threads\";s:38:\"Select <strong>Sticky</strong> Threads\";s:31:\"select_threads_with_attachments\";s:48:\"Select Threads with <strong>Attachments</strong>\";s:25:\"select_threads_with_polls\";s:42:\"Select Threads with <strong>Polls</strong>\";s:23:\"select_unapproved_posts\";s:40:\"Select <strong>Unapproved</strong> Posts\";s:25:\"select_unapproved_threads\";s:42:\"Select <strong>Unapproved</strong> Threads\";s:13:\"stick_threads\";s:13:\"Stick Threads\";s:21:\"unapprove_attachments\";s:21:\"Unapprove Attachments\";s:15:\"unapprove_posts\";s:15:\"Unapprove Posts\";s:17:\"unapprove_threads\";s:17:\"Unapprove Threads\";s:14:\"undelete_posts\";s:14:\"Undelete Posts\";s:16:\"undelete_threads\";s:16:\"Undelete Threads\";s:15:\"unstick_threads\";s:15:\"Unstick Threads\";s:8:\"x_y_by_z\";s:19:\"(%1$s) %2$s by %3$s\";}', phrasegroup_plugins = 'a:104:{s:6:\"active\";s:6:\"Active\";s:18:\"add_import_product\";s:18:\"Add/Import Product\";s:30:\"add_new_install_uninstall_code\";s:30:\"Add New Install/Uninstall Code\";s:14:\"add_new_plugin\";s:14:\"Add New Plugin\";s:15:\"add_new_product\";s:15:\"Add New Product\";s:31:\"allow_overwrite_upgrade_product\";s:91:\"Allow Overwrite<br /><dfn>If you wish to upgrade a product, you must set this to yes.</dfn>\";s:36:\"are_you_sure_want_to_delete_plugin_x\";s:162:\"Are you <b>sure</b> you want to delete the plugin called \'%1$s\'?<br /><span class=\"smallfont\">(%2$s: %3$s)</span><br /><br /> %4$s This action can not be un-done.\";s:37:\"are_you_sure_want_to_delete_product_x\";s:166:\"Are you <b>sure</b> you want to uninstall the product called \'%1$s\'?<br /><span class=\"smallfont\">(%2$s: %3$s)</span><br /><br /> %4$s This action can not be un-done.\";s:13:\"developer_key\";s:13:\"Developer Key\";s:7:\"disable\";s:7:\"Disable\";s:13:\"edit_plugin_x\";s:44:\"Edit Plugin <span class=\"normal\">%1$s</span>\";s:14:\"edit_product_x\";s:45:\"Edit Product <span class=\"normal\">%1$s</span>\";s:6:\"enable\";s:6:\"Enable\";s:31:\"existing_install_uninstall_code\";s:31:\"Existing Install/Uninstall Code\";s:13:\"hook_location\";s:13:\"Hook Location\";s:18:\"hook_location_desc\";s:102:\"This specifies the location within the vBulletin code of the hook that will fire this plugin function.\";s:18:\"hooktype_admindata\";s:18:\"Admin Data Manager\";s:19:\"hooktype_adminindex\";s:20:\"Admin CP Index Pages\";s:13:\"hooktype_ajax\";s:14:\"AJAX Functions\";s:21:\"hooktype_announcement\";s:13:\"Announcements\";s:16:\"hooktype_archive\";s:7:\"Archive\";s:19:\"hooktype_attachdata\";s:23:\"Attachment Data Manager\";s:19:\"hooktype_attachment\";s:12:\"Attachments \";s:17:\"hooktype_calendar\";s:8:\"Calendar\";s:13:\"hooktype_cron\";s:4:\"Cron\";s:15:\"hooktype_digest\";s:7:\"Digests\";s:15:\"hooktype_editor\";s:6:\"Editor\";s:17:\"hooktype_editpost\";s:9:\"Edit Post\";s:18:\"hooktype_eventdata\";s:18:\"Event Data Manager\";s:17:\"hooktype_external\";s:20:\"External Syndication\";s:12:\"hooktype_faq\";s:3:\"FAQ\";s:19:\"hooktype_forumadmin\";s:20:\"Forum Administration\";s:17:\"hooktype_forumbit\";s:10:\"Forum Bits\";s:18:\"hooktype_forumdata\";s:18:\"Forum Data Manager\";s:21:\"hooktype_forumdisplay\";s:13:\"Forum Display\";s:18:\"hooktype_forumhome\";s:10:\"Forum Home\";s:16:\"hooktype_general\";s:7:\"General\";s:21:\"hooktype_generaladmin\";s:22:\"General Administration\";s:19:\"hooktype_generalmod\";s:31:\"General Moderator Control Panel\";s:18:\"hooktype_inlinemod\";s:17:\"Inline Moderation\";s:20:\"hooktype_joinrequest\";s:13:\"Join Requests\";s:14:\"hooktype_login\";s:14:\"Login / Logout\";s:15:\"hooktype_member\";s:16:\"Member\'s Profile\";s:19:\"hooktype_memberlist\";s:11:\"Member List\";s:13:\"hooktype_misc\";s:13:\"Miscellaneous\";s:22:\"hooktype_moderatordata\";s:22:\"Moderator Data Manager\";s:22:\"hooktype_newattachment\";s:34:\"New Attachments (Incomplete Posts)\";s:16:\"hooktype_newpost\";s:8:\"New Post\";s:17:\"hooktype_newreply\";s:9:\"New Reply\";s:18:\"hooktype_newthread\";s:10:\"New Thread\";s:15:\"hooktype_online\";s:13:\"Who\'s Online?\";s:16:\"hooktype_paidsub\";s:18:\"Paid Subscriptions\";s:15:\"hooktype_pmdata\";s:30:\"Private Messaging Data Manager\";s:13:\"hooktype_poll\";s:6:\"Polls \";s:17:\"hooktype_polldata\";s:17:\"Poll Data Manager\";s:21:\"hooktype_pollvotedata\";s:22:\"Poll Vote Data Manager\";s:16:\"hooktype_postbit\";s:9:\"Post Bits\";s:17:\"hooktype_postdata\";s:17:\"Post Data Manager\";s:18:\"hooktype_posticons\";s:10:\"Post Icons\";s:20:\"hooktype_printthread\";s:12:\"Print Thread\";s:16:\"hooktype_private\";s:17:\"Private Messaging\";s:16:\"hooktype_profile\";s:24:\"Profile / Option Updates\";s:17:\"hooktype_register\";s:12:\"Registration\";s:15:\"hooktype_report\";s:15:\"Report Bad Post\";s:19:\"hooktype_reputation\";s:10:\"Reputation\";s:15:\"hooktype_search\";s:9:\"Searching\";s:20:\"hooktype_sendmessage\";s:12:\"Send Message\";s:19:\"hooktype_showgroups\";s:27:\"Show Groups (Forum Leaders)\";s:17:\"hooktype_showpost\";s:9:\"Show Post\";s:19:\"hooktype_showthread\";s:11:\"Show Thread\";s:18:\"hooktype_threadbit\";s:11:\"Thread Bits\";s:19:\"hooktype_threaddata\";s:19:\"Thread Data Manager\";s:21:\"hooktype_threadfpdata\";s:37:\"Thread Data Manager (with First Post)\";s:21:\"hooktype_threadmanage\";s:17:\"Thread Management\";s:19:\"hooktype_threadrate\";s:13:\"Thread Rating\";s:23:\"hooktype_threadratedata\";s:26:\"Thread Rating Data Manager\";s:18:\"hooktype_useradmin\";s:19:\"User Administration\";s:15:\"hooktype_usercp\";s:18:\"User Control Panel\";s:17:\"hooktype_userdata\";s:17:\"User Data Manager\";s:17:\"hooktype_usernote\";s:10:\"User Notes\";s:20:\"hooktype_userpicdata\";s:26:\"User Pictures Data Manager\";s:16:\"hooktype_usersub\";s:38:\"User Subscriptions (Thread and Forums)\";s:16:\"hooktype_wysiwyg\";s:15:\"WYSIWYG Parsing\";s:22:\"import_plugin_xml_file\";s:34:\"Import Plugin Definitions XML File\";s:14:\"import_product\";s:14:\"Import Product\";s:17:\"importing_plugins\";s:28:\"Importing Plugin Definitions\";s:17:\"importing_product\";s:17:\"Importing Product\";s:12:\"install_code\";s:12:\"Install Code\";s:18:\"installed_products\";s:18:\"Installed Products\";s:18:\"plugin_active_desc\";s:122:\"If this plugin is marked as inactive, it will not be called by vBulletin. Use this to temporarily turn plugins on and off.\";s:16:\"plugin_code_desc\";s:67:\"Use this field to enter the PHP code that you would like to be run.\";s:39:\"plugin_inactive_due_to_product_disabled\";s:99:\"<strong>This plugin is currently inactive due to the product <em>%1$s</em> being disabled.</strong>\";s:16:\"plugin_is_active\";s:16:\"Plugin is Active\";s:15:\"plugin_php_code\";s:15:\"Plugin PHP Code\";s:13:\"plugin_system\";s:13:\"Plugin System\";s:17:\"plugin_title_desc\";s:41:\"Enter a title that describes this plugin.\";s:22:\"plugins_disable_config\";s:71:\"<b>Warning:</b> Plugins are currently globally disabled via config.php.\";s:24:\"plugins_disabled_options\";s:276:\"<b>Warning:</b> Plugins are currently globally disabled in your options. In order for plugins and products to function correctly, you must <a href=\"options.php?do=options&amp;dogroup=plugin\">enable the plugin system</a>. Importing a product will do this for you automatically.\";s:10:\"product_id\";s:10:\"Product ID\";s:18:\"save_active_status\";s:18:\"Save Active Status\";s:9:\"uninstall\";s:9:\"Uninstall\";s:14:\"uninstall_code\";s:14:\"Uninstall Code\";s:18:\"vb_prefix_reserved\";s:237:\"The product ID prefix <strong>vb</strong> is reserved for official vBulletin products.<br />\r\n<br />\r\nIf you have not received express permission from the vBulletin development team to use the vb prefix, please alter your product ID now.\";s:7:\"version\";s:7:\"Version\";}', phrasegroup_messaging = 'a:47:{s:26:\"add_x_to_your_contact_list\";s:52:\"Add <span dir=\"ltr\">%1$s</span> 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:18:\"image_verification\";s:18:\"Image Verification\";s:3:\"msn\";s:3:\"MSN\";s:29:\"msn_functions_only_work_in_ie\";s:72:\"The MSN functions only work when launched from Internet Explorer (MSIE).\";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:33:\"please_enter_the_text_above_image\";s:53:\"Please enter the text that appears in the above image\";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:32:\"send_message_via_skype_to_x_link\";s:82:\"Send Message Via Skype 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:42:\"Send <span dir=\"ltr\">%1$s</span> a message\";s:5:\"skype\";s:5:\"Skype\";s:17:\"skype_add_contact\";s:25:\"Add to Skype contact list\";s:21:\"skype_leave_voicemail\";s:27:\"Leave voicemail using Skype\";s:15:\"skype_send_file\";s:23:\"Send a file using Skype\";s:16:\"skype_start_call\";s:22:\"Start Skype voice call\";s:16:\"skype_start_chat\";s:21:\"Start Skype text chat\";s:18:\"skype_view_profile\";s:18:\"View Skype profile\";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.

Here is the datbase error. I got a time out when tryign to post it.

I made note of the problem a week or more ago in the vB Staff Titles thread which is why I am posting in the SQL forums.

[Xplorer4x4]

Originally Posted by MarcoH64

I suggest you post in the thread of the hack itself, instead of general forum. More chance of a quick answer.

And I already did that before I posted here, yet no response either place?

[harmor19]

The error is indicating that it's trying to place phrases in "Front-End Error Messages" but I downloaded opened the product and I do not see that.

By the looks of that error it appears to be my hack.
If that's the case upload the other product xml.
https://vborg.vbsupport.ru/showthread.php?t=98934
Look in the FAQs

[Xplorer4x4]

Originally Posted by harmor19

The error is indicating that it's trying to place phrases in "Front-End Error Messages" but I downloaded opened the product and I do not see that.

By the looks of that error it appears to be my hack.
If that's the case upload the other product xml.
https://vborg.vbsupport.ru/showthread.php?t=98934
Look in the FAQs

I get a datbase error when trying to use your front end version. I am pretty sure it got an error the first time around when attempting to use the front end version.

I had the regular versions installed, but never added the links. And I was using v1.07 from the start.

No I am very confident it is the staff titles hack, because everything was working fine untill I altered that query. I KNEW I should of made a datbase back up!

[Andreas]

Your DB is messed up.
PM me an ACP account and phpMyAdmin login please, as it's difficult to describe how to fix it.

[Xplorer4x4]

^Done