Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 02-03-2006, 07:04 AM
Xplorer4x4 Xplorer4x4 is offline
 
Join Date: Apr 2005
Posts: 938
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Query problem

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?
Reply With Quote
  #2  
Old 02-03-2006, 07:23 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 02-03-2006, 07:54 AM
Xplorer4x4 Xplorer4x4 is offline
 
Join Date: Apr 2005
Posts: 938
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well this is the error I got at the time of installing hte product,
Quote:
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:
Code:
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.
Attached Files
File Type: txt dberror.txt (362.6 KB, 13 views)
Reply With Quote
  #4  
Old 02-06-2006, 04:42 AM
Xplorer4x4 Xplorer4x4 is offline
 
Join Date: Apr 2005
Posts: 938
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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?
Reply With Quote
  #5  
Old 02-06-2006, 01:18 PM
harmor19 harmor19 is offline
 
Join Date: Apr 2005
Posts: 1,324
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #6  
Old 02-06-2006, 11:48 PM
Xplorer4x4 Xplorer4x4 is offline
 
Join Date: Apr 2005
Posts: 938
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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!
Attached Files
File Type: txt dberror.txt (362.6 KB, 3 views)
Reply With Quote
  #7  
Old 02-07-2006, 12:02 AM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your DB is messed up.
PM me an ACP account and phpMyAdmin login please, as it's difficult to describe how to fix it.
Reply With Quote
  #8  
Old 02-07-2006, 12:09 AM
Xplorer4x4 Xplorer4x4 is offline
 
Join Date: Apr 2005
Posts: 938
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

^Done
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:27 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.10919 seconds
  • Memory Usage 2,281KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (2)postbit_attachment
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_attachment
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete