Announcement

Collapse
No announcement yet.

Install is not getting past Step 6.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    haha i dont know whats the problem. I've done all that needs to be done, seems the problem wont go away hahaha.. [email protected]

    Comment


    • #17
      Originally posted by Kier
      Actually, you don't need to edit your php.ini file at all. You can actually set the memory limit at run time using a PHP script. The reasons for this are baffling, but there it is.
      Well that's bizarre. Thanks for the tip.

      Comment


      • #18
        Originally posted by Kier
        Actually, you don't need to edit your php.ini file at all. You can actually set the memory limit at run time using a PHP script. The reasons for this are baffling, but there it is.

        To temporarily up your memory limit to 16M for the language install, open up includes/class_xml.php and add this just after the error_reporting line.

        PHP Code:
        ini_set('memory_limit'16777216); 
        Thanks works for me too.
        Hopes is this done in the final version

        Comment


        • #19
          Originally posted by Kier
          PHP Code:
          ini_set('memory_limit'16777216); 
          Did not work for me, I still the get the error msg. I can't up the server memory or restart apache at all. So I guess I won't be using 3.5. :P

          Comment


          • #20
            Try this:

            Open : adminfunctions_language.php

            search Code PHP:
            PHP Code:
            error_reporting(E_ALL & ~E_NOTICE); 
            Add this after:

            PHP Code:
            @ini_set("memory_limit",'12M'); 
            Visit my board Astunet.net

            Comment


            • #21
              hi all

              im helping some friends with their vb upgrade. i came up with this problem.

              Database error in vBulletin :

              Invalid SQL:
              SELECT userid, username FROM user WHERE userid =;

              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 '' at line 1
              Error Number : 1064
              Date : Sunday, June 12th 2005 @ 05:18:53 PM
              Script : http://***********/forums/install/up...0b1.php?step=6
              Referrer :
              IP Address : **********
              Username :
              Classname : vb_database

              Comment


              • #22
                Originally posted by pauloo
                Try this:

                Open : adminfunctions_language.php

                search Code PHP:
                PHP Code:
                error_reporting(E_ALL & ~E_NOTICE); 
                Add this after:

                PHP Code:
                @ini_set("memory_limit",'12M'); 
                Just as an experiment, I tried the reinstall with this method, now I am getting a "Fatel error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1029 bytes) in /home/virtual/site36/fst/var/www/html/testvb/includes/adminfunctions_language.php on line 514"
                I'm noticing a pattern...line 512, 513, 514...

                This never worked for me. The only saving grace was when I raised my memory limit. Now, I am sure this will not be a problem for those upgrading from vb 3.0.7 (the language is already in place changes will just have to be made) but there needs to be some fullproof code that works for everyone....somewhere...especialy for those that will be first time setting up vb. .

                Comment


                • #23
                  Originally posted by pauloo
                  Try this:

                  Open : adminfunctions_language.php

                  search Code PHP:
                  PHP Code:
                  error_reporting(E_ALL & ~E_NOTICE); 
                  Add this after:

                  PHP Code:
                  @ini_set("memory_limit",'12M'); 
                  Actually, that's not going to work, because ini_set('memory_limit' actually requires a number in bytes.

                  If you want to set 12 megabytes, you will need to use
                  PHP Code:
                  @ini_set('memory_limit'12 1024 1024); 

                  Comment


                  • #24
                    After adding the temp ini settings suggested in this thread. I now get this error

                    Code:
                    Database error in vBulletin 3.5.0 Beta 1:
                    
                    Invalid SQL:
                    INSERT INTO phrase
                    (languageid, phrasetypeid, varname, text, product)
                    VALUES
                    (-1, 1, '1_day_ago', '1 Day Ago', 'vbulletin'),
                    (-1, 1, '1_hour_ago', '1 Hour Ago', 'vbulletin'),
                    (-1, 1, '1_minute_ago', '1 Minute Ago', 'vbulletin'),
                    (-1, 1, '1_week_ago', '1 Week Ago', 'vbulletin'),
                    (-1, 1, 'a_closed_forum', 'A Closed Forum', 'vbulletin'),
                    (-1, 1, 'accept', 'Accept', 'vbulletin'),
                    (-1, 1, 'action', 'Action', 'vbulletin'),
                    (-1, 1, 'activate', 'Activate', 'vbulletin'),
                    (-1, 1, 'active_members', 'Active Members', 'vbulletin'),
                    (-1, 1, 'active_subscriptions', 'Active Subscriptions', 'vbulletin'),
                    (-1, 1, 'activity', 'Activity', 'vbulletin'),
                    (-1, 1, 'add_new_folders', 'Add New Folders', 'vbulletin'),
                    (-1, 1, 'add_subscription', 'Add Subscription', 'vbulletin'),
                    (-1, 1, 'add_x_to_buddy_list', 'Add {1} to Your Buddy List', 'vbulletin'),
                    (-1, 1, 'add_x_to_your_ignorelist', 'Add {1} to your Ignore List', 'vbulletin'),
                    (-1, 1, 'admin', 'Admin', 'vbulletin'),
                    (-1, 1, 'admin_control_panel', 'Admin Control Panel', 'vbulletin'),
                    (-1, 1, 'admin_required_register', 'The administrator may have required you to <a href=\"{1}\">register</a> before you can view this page.', 'vbulletin'),
                    (-1, 1, 'administrator_may_disabled_account', 'If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.', 'vbulletin'),
                    (-1, 1, 'advanced_search', 'Advanced Search', 'vbulletin'),
                    (-1, 1, 'age', 'Age', 'vbulletin'),
                    (-1, 1, 'alert_board_off', '<b>Alert:</b> The forums are currently turned off!', 'vbulletin'),
                    (-1, 1, 'all_times_are_gmt_x_time_now_is_y', 'All times are GMT{1}. The time now is <span class=\"time\">{2}</span>.', 'vbulletin'),
                    (-1, 1, 'announcement', 'Announcement', 'vbulletin'),
                    (-1, 1, 'announcements', 'Announcements', 'vbulletin'),
                    (-1, 1, 'announcements_in_forum', 'Announcements in Forum', 'vbulletin'),
                    (-1, 1, 'april', 'April', 'vbulletin'),
                    (-1, 1, 'archive', 'Archive', 'vbulletin'),
                    (-1, 1, 'attachment', 'Attachment', 'vbulletin'),
                    (-1, 1, 'attachment_statistics', 'Attachment Statistics', 'vbulletin'),
                    (-1, 1, 'attachments', 'Attachments', 'vbulletin'),
                    (-1, 1, 'august', 'August', 'vbulletin'),
                    (-1, 1, 'authorize', 'Authorize', 'vbulletin'),
                    (-1, 1, 'best', 'Best', 'vbulletin'),
                    (-1, 1, 'buddy_ignore_lists', 'Buddy / Ignore Lists', 'vbulletin'),
                    (-1, 1, 'buddy_list', 'Buddy List', 'vbulletin'),
                    (-1, 1, 'by_x', 'by <a href=\"{1}\" rel=\"nofollow\">{2}</a>', 'vbulletin'),
                    (-1, 1, 'bytes', 'Bytes', 'vbulletin'),
                    (-1, 1, 'calendar', 'Calendar', 'vbulletin'),
                    (-1, 1, 'cancel', 'Cancel', 'vbulletin'),
                    (-1, 1, 'check_uncheck_all', 'Check / Uncheck All', 'vbulletin'),
                    (-1, 1, 'click_a_smilie_to_insert_it_into_your_message', 'Click a smilie to insert it into your message.', 'vbulletin'),
                    (-1, 1, 'click_here_to_log_in', 'Click here to log in', 'vbulletin'),
                    (-1, 1, 'click_if_browser_does_not_redirect', 'Click here if your browser does not automatically redirect you.', 'vbulletin'),
                    (-1, 1, 'close_this_window', 'Close this window', 'vbulletin'),
                    (-1, 1, 'closed_thread', 'Closed Thread', 'vbulletin'),
                    (-1, 1, 'code', 'Code', 'vbulletin'),
                    (-1, 1, 'contact', 'Contact', 'vbulletin'),
                    (-1, 1, 'contact_us', 'Contact Us', 'vbulletin'),
                    (-1, 1, 'contains_new_posts', 'Contains New Posts', 'vbulletin'),
                    (-1, 1, 'contains_no_new_posts', 'Contains No New Posts', 'vbulletin'),
                    (-1, 1, 'control_panel', 'Control Panel', 'vbulletin'),
                    (-1, 1, 'current_attachment_total_x', 'Current Attachment Total: {1}', 'vbulletin'),
                    (-1, 1, 'current_attachments', 'Current Attachments', 'vbulletin'),
                    (-1, 1, 'currently_active_users', 'Currently Active Users', 'vbulletin'),
                    (-1, 1, 'custom', 'Custom', 'vbulletin'),
                    (-1, 1, 'custom_fields', 'Custom Fields', 'vbulletin'),
                    (-1, 1, 'daily', 'Daily', 'vbulletin'),
                    (-1, 1, 'daily_email_notification', 'Daily email notification', 'vbulletin'),
                    (-1, 1, 'daily_updates_by_email', 'Daily updates by email', 'vbulletin'),
                    (-1, 1, 'date', 'Date', 'vbulletin'),
                    (-1, 1, 'day', 'Day', 'vbulletin'),
                    (-1, 1, 'days', 'Days', 'vbulletin'),
                    (-1, 1, 'december', 'December', 'vbulletin'),
                    (-1, 1, 'default', 'Default', 'vbulletin'),
                    (-1, 1, 'delete', 'Delete', 'vbulletin'),
                    (-1, 1, 'delete_posts', 'Delete Posts', 'vbulletin'),
                    (-1, 1, 'delete_selected', 'Delete Selected', 'vbulletin'),
                    (-1, 1, 'delete_subscription', 'Delete Subscription', 'vbulletin'),
                    (-1, 1, 'delete_thread', 'Delete Thread', 'vbulletin'),
                    (-1, 1, 'delete_user_note', 'Delete User Note', 'vbulletin'),
                    (-1, 1, 'deny', 'Deny', 'vbulletin'),
                    (-1, 1, 'destination_forum', 'Destination Forum', 'vbulletin'),
                    (-1, 1, 'display_options', 'Display Options', 'vbulletin'),
                    (-1, 1, 'do_authorizations', 'Do Authorizations', 'vbulletin'),
                    (-1, 1, 'done', 'Done', 'vbulletin'),
                    (-1, 1, 'edit_avatar', 'Edit Avatar', 'vbulletin'),
                    (-1, 1, 'edit_email_and_password', 'Edit Email &amp; Password', 'vbulletin'),
                    (-1, 1, 'edit_folders', 'Edit Folders', 'vbulletin'),
                    (-1, 1, 'edit_options', 'Edit Options', 'vbulletin'),
                    (-1, 1, 'edit_poll', 'Edit Poll', 'vbulletin'),
                    (-1, 1, 'edit_post', 'Edit Post', 'vbulletin'),
                    (-1, 1, 'edit_profile', 'Edit Profile', 'vbulletin'),
                    (-1, 1, 'edit_profile_picture', 'Edit Profile Picture', 'vbulletin'),
                    (-1, 1, 'edit_signature', 'Edit Signature', 'vbulletin'),
                    (-1, 1, 'edit_thread', 'Edit Thread', 'vbulletin'),
                    (-1, 1, 'edit_user_note', 'Edit User Note', 'vbulletin'),
                    (-1, 1, 'email', 'Email', 'vbulletin'),
                    (-1, 1, 'email_address', 'Email Address', 'vbulletin'),
                    (-1, 1, 'emailing', 'Emailing', 'vbulletin'),
                    (-1, 1, 'enter_password_for_account', 'Please enter a password for your user account. Note that passwords are case-sensitive.', 'vbulletin'),
                    (-1, 1, 'enter_username_to_login_or_register', 'Enter your username and password in the boxes provided to login, or click the \'register\' button to create a profile for yourself.', 'vbulletin'),
                    (-1, 1, 'errors_occured_when_submitted', 'The following errors occurred when this message was submitted', 'vbulletin'),
                    (-1, 1, 'event', 'Event', 'vbulletin'),
                    (-1, 1, 'event_reminders', 'Event Reminders', 'vbulletin'),
                    (-1, 1, 'export', 'Export', 'vbulletin'),
                    (-1, 1, 'faq', 'FAQ', 'vbulletin'),
                    (-1, 1, 'february', 'February', 'vbulletin'),
                    (-1, 1, 'file', 'File', 'vbulletin'),
                    (-1, 1, 'file_to_upload', 'File to Upload', 'vbulletin'),
                    (-1, 1, 'find_all_posts_by_x', 'Find all posts by {1}', 'vbulletin'),
                    (-1, 1, 'find_posts_by_user', 'Find Posts by User', 'vbulletin'),
                    (-1, 1, 'first', 'First', 'vbulletin'),
                    (-1, 1, 'first_page', 'First Page', 'vbulletin'),
                    (-1, 1, 'first_visit_message', 'If this is your first visit, be sure to check out the <a href=\"{1}\"><strong>FAQ</strong></a> by clicking the link above.\r\nYou may have to <a href=\"{2}\"><strong>register</strong></a> before you can post: click the register link above to proceed.\r\nTo start viewing messages, select the forum that you want to visit from the selection below.', 'vbulletin'),
                    (-1, 1, 'folder', 'Folder', 'vbulletin'),
                    (-1, 1, 'folder_controls', 'Folder Controls', 'vbulletin'),
                    (-1, 1, 'folder_is_currently_empty', 'This folder is currently empty.', 'vbulletin'),
                    (-1, 1, 'folder_name', 'Folder Name', 'vbulletin'),
                    (-1, 1, 'folders', 'Folders', 'vbulletin'),
                    (-1, 1, 'forgotten_password_request_email', 'If you have forgotten your username or password, you can request to have your username emailed to you and to reset your password. When you fill in your registered email address, you will be sent instructions on how to reset your password.', 'vbulletin'),
                    (-1, 1, 'forgotten_your_password', 'Forgotten Your Password?', 'vbulletin'),
                    (-1, 1, 'forum', 'Forum', 'vbulletin'),
                    (-1, 1, 'forum_contains_new_posts', 'Forum Contains New Posts', 'vbulletin'),
                    (-1, 1, 'forum_contains_no_new_posts', 'Forum Contains No New Posts', 'vbulletin'),
                    (-1, 1, 'forum_is_closed_for_posting', 'Forum is Closed for Posting', 'vbulletin'),
                    (-1, 1, 'forum_jump', 'Forum Jump', 'vbulletin'),
                    (-1, 1, 'forum_view', 'Forum View', 'vbulletin'),
                    (-1, 1, 'forums', 'Forums', 'vbulletin'),
                    (-1, 1, 'forums_home', 'Forums Home', 'vbulletin'),
                    (-1, 1, 'friday', 'Friday', 'vbulletin'),
                    (-1, 1, 'general', 'General', 'vbulletin'),
                    (-1, 1, 'gigabytes', 'GB', 'vbulletin'),
                    (-1, 1, 'go', 'Go', 'vbulletin'),
                    (-1, 1, 'go_back', 'Go Back', 'vbulletin'),
                    (-1, 1, 'go_first_unread_in_thread_x', 'Go to first unread post in thread \'{1}\'', 'vbulletin'),
                    (-1, 1, 'go_to_first_new_post', 'Go to first new post', 'vbulletin'),
                    (-1, 1, 'go_to_last_post', 'Go to last post', 'vbulletin'),
                    (-1, 1, 'go_to_page', 'Go to Page...', 'vbulletin'),
                    (-1, 1, 'group_memberships', 'Group Memberships', 'vbulletin'),
                    (-1, 1, 'guest', 'Guest', 'vbulletin'),
                    (-1, 1, 'have_new_pm_popup_x_y', 'You have a new private message.\\n\\nSender: {1}\\nTitle: \'{2}\'\\n\\nClick OK to view it, or cancel to hide this prompt.', 'vbulletin'),
                    (-1, 1, 'have_x_posts_in_thread_last_y', 'You have {1} post(s) in this thread, last {2}', 'vbulletin'),
                    (-1, 1, 'hide_thumbnails', 'Hide Thumbnails', 'vbulletin'),
                    (-1, 1, 'hot_thread', 'Hot Thread', 'vbulletin'),
                    (-1, 1, 'html_code', 'HTML Code', 'vbulletin'),
                    (-1, 1, 'html_code_is_x', 'HTML code is <strong>{1}</strong>', 'vbulletin'),
                    (-1, 1, 'hybrid', 'Hybrid', 'vbulletin'),
                    (-1, 1, 'ignore', 'Ignore', 'vbulletin'),
                    (-1, 1, 'img_code_is_x', '<a href=\"{1}\" target=\"_blank\">[IMG]</a> code is <strong>{2}</strong>', 'vbulletin'),
                    (-1, 1, 'importing_x', 'Importing {1}', 'vbulletin'),
                    (-1, 1, 'in_progress', 'In Progress', 'vbulletin'),
                    (-1, 1, 'inbox', 'Inbox', 'vbulletin'),
                    (-1, 1, 'index', 'Index', 'vbulletin'),
                    (-1, 1, 'info', 'Info', 'vbulletin'),
                    (-1, 1, 'instant_email_notification', 'Instant email notification', 'vbulletin'),
                    (-1, 1, 'instant_message_icons', 'Instant Message Icons', 'vbulletin'),
                    (-1, 1, 'instant_messaging', 'Instant Messaging', 'vbulletin'),
                    (-1, 1, 'instant_notification_by_email', 'Instant notification by email', 'vbulletin'),
                    (-1, 1, 'invisible', 'Invisible', 'vbulletin'),
                    (-1, 1, 'ip_address', 'IP Address', 'vbulletin'),
                    (-1, 1, 'january', 'January', 'vbulletin'),
                    (-1, 1, 'join_date', 'Join Date', 'vbulletin'),
                    (-1, 1, 'join_request', 'Join Request', 'vbulletin'),
                    (-1, 1, 'join_requests', 'Join Requests', 'vbulletin'),
                    (-1, 1, 'july', 'July', 'vbulletin'),
                    (-1, 1, 'jump_to_folder', 'Jump to Folder', 'vbulletin'),
                    (-1, 1, 'june', 'June', 'vbulletin'),
                    (-1, 1, 'kilobytes', 'KB', 'vbulletin'),
                    (-1, 1, 'last', 'Last', 'vbulletin'),
                    (-1, 1, 'last_activity', 'Last Activity', 'vbulletin'),
                    (-1, 1, 'last_online', 'Last Online', 'vbulletin'),
                    (-1, 1, 'last_page', 'Last Page', 'vbulletin'),
                    (-1, 1, 'last_post', 'Last Post', 'vbulletin'),
                    (-1, 1, 'last_visited_x_at_y', 'You last visited: {1} at <span class=\"time\">{2}</span>', 'vbulletin'),
                    (-1, 1, 'least', 'Least', 'vbulletin'),
                    (-1, 1, 'list_messages', 'List Messages', 'vbulletin'),
                    (-1, 1, 'list_subscriptions', 'List Subscriptions', 'vbulletin'),
                    (-1, 1, 'location_perm', 'Location', 'vbulletin'),
                    (-1, 1, 'log_in', 'Log in', 'vbulletin'),
                    (-1, 1, 'log_out', 'Log Out', 'vbulletin'),
                    (-1, 1, 'log_out_x', 'Log Out {1}', 'vbulletin'),
                    (-1, 1, 'logged_in_as_x', 'Logged in as <a href=\"{1}\" target=\"_blank\">{2}</a>', 'vbulletin'),
                    (-1, 1, 'logged_in_user', 'Logged in user', 'vbulletin'),
                    (-1, 1, 'lost_password_recovery_form', 'Lost Password Recovery Form', 'vbulletin'),
                    (-1, 1, 'manage', 'Manage', 'vbulletin'),
                    (-1, 1, 'manage_attachments', 'Manage Attachments', 'vbulletin'),
                    (-1, 1, 'march', 'March', 'vbulletin'),
                    (-1, 1, 'mark_forums_read', 'Mark Forums Read', 'vbulletin'),
                    (-1, 1, 'maximum_allowed_messages_x', 'Maximum allowed stored messages: {1}', 'vbulletin'),
                    (-1, 1, 'maximum_attachment_storage_x', 'Maximum Attachment Storage: {1}', 'vbulletin'),
                    (-1, 1, 'may', 'May', 'vbulletin'),
                    (-1, 1, 'may_choose_icon_for_message', 'You may choose an icon for your message from the following list', 'vbulletin'),
                    (-1, 1, 'may_not_have_sufficient_privileges', 'You may not have sufficient privileges to access this page. Are you trying to edit someone else\'s post, access administrative features or some other privileged system?', 'vbulletin'),
                    (-1, 1, 'megabytes', 'MB', 'vbulletin'),
                    (-1, 1, 'member', 'Member', 'vbulletin'),
                    (-1, 1, 'members', 'Members', 'vbulletin'),
                    (-1, 1, 'members_list', 'Members List', 'vbulletin'),
                    (-1, 1, 'message', 'Message', 'vbulletin'),
                    (-1, 1, 'message_deleted_by_x', 'This message has been deleted by <a href=\"{1}\" target=\"_blank\">{2}</a>.', 'vbulletin'),
                    (-1, 1, 'messages', 'Messages', 'vbulletin'),
                    (-1, 1, 'miscellaneous', 'Miscellaneous', 'vbulletin'),
                    (-1, 1, 'miscellaneous_options', 'Miscellaneous Options', 'vbulletin'),
                    (-1, 1, 'mod', 'Mod', 'vbulletin'),
                    (-1, 1, 'moderator', 'Moderator', 'vbulletin'),
                    (-1, 1, 'moderator_control_panel', 'Moderator Control Panel', 'vbulletin'),
                    (-1, 1, 'moderators', 'Moderators', 'vbulletin'),
                    (-1, 1, 'monday', 'Monday', 'vbulletin'),
                    (-1, 1, 'month', 'Month', 'vbulletin'),
                    (-1, 1, 'monthly', 'Monthly', 'vbulletin'),
                    (-1, 1, 'months', 'Months', 'vbulletin'),
                    (-1, 1, 'more_than_x_replies_or_y_views', 'More than {1} replies or {2} views', 'vbulletin'),
                    (-1, 1, 'most', 'Most', 'vbulletin'),
                    (-1, 1, 'most_users_ever_online_was_x_y_at_z', 'Most users ever online was {1}, {2} at {3}.', 'vbulletin'),
                    (-1, 1, 'move_copy_thread', 'Move / Copy Thread', 'vbulletin'),
                    (-1, 1, 'move_delete_subscriptions', 'Move / Delete Subscriptions', 'vbulletin'),
                    (-1, 1, 'move_items', 'Move Items', 'vbulletin'),
                    (-1, 1, 'move_subscribed_threads', 'Move Subscribed Threads', 'vbulletin'),
                    (-1, 1, 'move_to_folder', 'Move to folder', 'vbulletin'),
                    (-1, 1, 'move_x_items_from_y', 'Move {1} items from \'{2}\'', 'vbulletin'),
                    (-1, 1, 'moved_thread_prefix', 'Moved: ', 'vbulletin'),
                    (-1, 1, 'multipage_thread', 'Multi-page thread', 'vbulletin'),
                    (-1, 1, 'multiple_choice_poll', 'Multiple Choice Poll.', 'vbulletin'),
                    (-1, 1, 'my_profile', 'My Profile', 'vbulletin'),
                    (-1, 1, 'n_a', 'N/A', 'vbulletin'),
                    (-1, 1, 'never', 'Never', 'vbulletin'),
                    (-1, 1, 'new_posts', 'New posts', 'vbulletin'),
                    (-1, 1, 'new_posts_nav', 'New Posts', 'vbulletin'),
                    (-1, 1, 'new_user_note', 'New User Note', 'vbulletin'),
                    (-1, 1, 'next', 'Next', 'vbulletin'),
                    (-1, 1, 'next_page', 'Next Page', 'vbulletin'),
                    (-1, 1, 'no', 'No', 'vbulletin'),
                    (-1, 1, 'no_email_notification', 'No email notification', 'vbulletin'),
                    (-1, 1, 'no_icon', 'No icon', 'vbulletin'),
                    (-1, 1, 'no_new_posts', 'No new posts', 'vbulletin'),
                    (-1, 1, 'no_users_selected', 'No users selected!', 'vbulletin'),
                    (-1, 1, 'none', 'None', 'vbulletin'),
                    (-1, 1, 'not', 'not', 'vbulletin'),
                    (-1, 1, 'not_logged_in_fill_in_form', 'You are not logged in. Fill in the form at the bottom of this page and try again.', 'vbulletin'),
                    (-1, 1, 'not_logged_no_permission', 'You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:', 'vbulletin'),
                    (-1, 1, 'nothing', 'Nothing', 'vbulletin'),
                    (-1, 1, 'notification', 'Notification', 'vbulletin'),
                    (-1, 1, 'notification_type', 'Notification Type', 'vbulletin'),
                    (-1, 1, 'november', 'November', 'vbulletin'),
                    (-1, 1, 'number_of_replies', 'Number of Replies', 'vbulletin'),
                    (-1, 1, 'number_of_views', 'Number of Views', 'vbulletin'),
                    (-1, 1, 'october', 'October', 'vbulletin'),
                    (-1, 1, 'off', 'Off', 'vbulletin'),
                    (-1, 1, 'offline', 'Offline', 'vbulletin'),
                    (-1, 1, 'okay', 'Okay', 'vbulletin'),
                    (-1, 1, 'old', 'Old', 'vbulletin'),
                    (-1, 1, 'older', 'Older', 'vbulletin'),
                    (-1, 1, 'on', 'On', 'vbulletin'),
                    (-1, 1, 'online', 'Online', 'vbulletin'),
                    (-1, 1, 'open_buddy_list', 'Open Buddy List', 'vbulletin'),
                    (-1, 1, 'open_message_in_new_window', 'Open the message in a new window?\\n\\n(Press cancel to open in the current window.)', 'vbulletin'),
                    (-1, 1, 'option', 'Option', 'vbulletin'),
                    (-1, 1, 'optional', 'Optional', 'vbulletin'),
                    (-1, 1, 'options', 'Options', 'vbulletin'),
                    (-1, 1, 'or', 'or', 'vbulletin'),
                    (-1, 1, 'originally_posted_by_x', 'Originally Posted by <strong>{1}</strong>', 'vbulletin'),
                    (-1, 1, 'page_x', 'Page {1}', 'vbulletin'),
                    (-1, 1, 'page_x_of_y', 'Page {1} of {2}', 'vbulletin'),
                    (-1, 1, 'pages', 'Pages', 'vbulletin'),
                    (-1, 1, 'paid_subscriptions', 'Paid Subscriptions', 'vbulletin'),
                    (-1, 1, 'password', 'Password', 'vbulletin'),
                    (-1, 1, 'per_page', 'Per Page', 'vbulletin'),
                    (-1, 1, 'perform_action', 'Perform Action', 'vbulletin'),
                    (-1, 1, 'permission', 'Permission', 'vbulletin'),
                    (-1, 1, 'php_code', 'PHP Code', 'vbulletin'),
                    (-1, 1, 'phrase', 'Phrase', 'vbulletin'),
                    (-1, 1, 'please_select_one', 'Please select one', 'vbulletin'),
                    (-1, 1, 'pm_users', 'PM Users', 'vbulletin'),
                    (-1, 1, 'poll', 'Poll', 'vbulletin'),
                    (-1, 1, 'poll_options', 'Poll Options', 'vbulletin'),
                    (-1, 1, 'poll_thread_prefix', 'Poll: ', 'vbulletin'),
                    (-1, 1, 'polls', 'Polls', 'vbulletin'),
                    (-1, 1, 'post', 'Post', 'vbulletin'),
                    (-1, 1, 'post_icons', 'Post Icons', 'vbulletin'),
                    (-1, 1, 'post_new_user_note', 'Post New User Note', 'vbulletin'),
                    (-1, 1, 'post_time_x_at_y', 'Post Time: {1} at {2}', 'vbulletin'),
                    (-1, 1, 'post_user_note', 'Post User Note', 'vbulletin'),
                    (-1, 1, 'post_x', 'Post {1}', 'vbulletin'),
                    (-1, 1, 'posted_by', 'Posted By', 'vbulletin'),
                    (-1, 1, 'posting_rules', 'Posting Rules', 'vbulletin'),
                    (-1, 1, 'posts', 'Posts', 'vbulletin'),
                    (-1, 1, 'powered_by_vbulletin', 'Powered by vBulletin Version {1}<br />Copyright &copy;2000 - {2}, Jelsoft Enterprises Ltd.', 'vbulletin'),
                    (-1, 1, 'prev', 'Prev', 'vbulletin'),
                    (-1, 1, 'prev_page', 'Prev Page', 'vbulletin'),
                    (-1, 1, 'privacy_statement', 'Privacy Statement', 'vbulletin'),
                    (-1, 1, 'private', 'Private', 'vbulletin'),
                    (-1, 1, 'private_message', 'Private Message', 'vbulletin'),
                    (-1, 1, 'private_messages', 'Private Messages', 'vbulletin'),
                    (-1, 1, 'private_messages_nav', '<a href=\"private.php?{3}\">Private Messages</a>: {1}, {2}.', 'vbulletin'),
                    (-1, 1, 'proceed', ' Proceed ', 'vbulletin'),
                    (-1, 1, 'public_poll_users_see_choices', 'Be advised that this is a public poll: other users can see the choice(s) you selected.', 'vbulletin'),
                    (-1, 1, 'quick_language_chooser', 'Quick Language Chooser', 'vbulletin'),
                    (-1, 1, 'quick_links', 'Quick Links', 'vbulletin'),
                    (-1, 1, 'quick_style_chooser', 'Quick Style Chooser', 'vbulletin'),
                    (-1, 1, 'quote', 'Quote', 'vbulletin'),
                    (-1, 1, 'rate_thread', 'Rate Thread', 'vbulletin'),
                    (-1, 1, 'reason', 'Reason', 'vbulletin'),
                    (-1, 1, 'redirect', 'Redirect', 'vbulletin'),
                    (-1, 1, 'redirecting', 'Redirecting...', 'vbulletin'),
                    (-1, 1, 'referrers', 'Referrers', 'vbulletin'),
                    (-1, 1, 'register', 'Register', 'vbulletin'),
                    (-1, 1, 'reload', 'Reload', 'vbulletin'),
                    (-1, 1, 'reload_this_page', 'Reload this Page', 'vbulletin'),
                    (-1, 1, 'remember_me', 'Remember Me?', 'vbulletin'),
                    (-1, 1, 'remember_username_password', 'Remember username/password?', 'vbulletin'),
                    (-1, 1, 'remove', 'Remove', 'vbulletin'),
                    (-1, 1, 'repair', 'Repair', 'vbulletin'),
                    (-1, 1, 'replace', 'Replace', 'vbulletin'),
                    (-1, 1, 'replies', 'Replies', 'vbulletin'),
                    (-1, 1, 'replies_x_views_y', 'Replies: {1}, Views: {2}', 'vbulletin'),
                    (-1, 1, 'reply', 'Reply', 'vbulletin'),
                    (-1, 1, 'reply_prefix', 'Re:', 'vbulletin'),
                    (-1, 1, 'report', 'Report', 'vbulletin'),
                    (-1, 1, 'reputation', 'Reputation', 'vbulletin'),
                    (-1, 1, 'reputation_disabled', 'has disabled reputation', 'vbulletin'),
                    (-1, 1, 'request_reason', 'Request Reason', 'vbulletin'),
                    (-1, 1, 'request_username_password_now', 'Request Username / Password Now', 'vbulletin'),
                    (-1, 1, 'requests_to_join_usergroup', 'Requests to Join Usergroup', 'vbulletin'),
                    (-1, 1, 'reset', 'Reset', 'vbulletin'),
                    (-1, 1, 'reset_fields', 'Reset Fields', 'vbulletin'),
                    (-1, 1, 'results_x_to_y_of_z', 'Results {1} to {2} of {3}', 'vbulletin'),
                    (-1, 1, 'reverse_sort_order', 'Reverse Sort Order', 'vbulletin'),
                    (-1, 1, 'review_join_requests', 'Review Join Requests', 'vbulletin'),
                    (-1, 1, 'saturday', 'Saturday', 'vbulletin'),
                    (-1, 1, 'save_changes', 'Save Changes', 'vbulletin'),
                    (-1, 1, 'save_folders', 'Save Folders', 'vbulletin'),
                    (-1, 1, 'search', 'Search', 'vbulletin'),
                    (-1, 1, 'search_forums', 'Search Forums', 'vbulletin'),
                    (-1, 1, 'search_results', 'Search Results', 'vbulletin'),
                    (-1, 1, 'search_titles_only', 'Search Titles Only', 'vbulletin'),
                    (-1, 1, 'second', 'Second', 'vbulletin'),
                    (-1, 1, 'select_destination_folder_for_move', 'Please select a destination folder for the items that you wish to move.', 'vbulletin'),
                    (-1, 1, 'selected_threads', 'Selected Threads', 'vbulletin'),
                    (-1, 1, 'send', 'Send', 'vbulletin'),
                    (-1, 1, 'send_message_via_aim_to_x', 'Send a message via AIM to {1}', 'vbulletin'),
                    (-1, 1, 'send_message_via_email_to_x', 'Send a message via email to {1}', 'vbulletin'),
                    (-1, 1, 'send_message_via_icq_to_x', 'Send a message via ICQ to {1}', 'vbulletin'),
                    (-1, 1, 'send_message_via_msn_to_x', 'Send a message via MSN to {1}', 'vbulletin'),
                    (-1, 1, 'send_message_via_yahoo_to_x', 'Send a message via Yahoo to {1}', 'vbulletin'),
                    (-1, 1, 'send_new_message', 'Send New Message', 'vbulletin'),
                    (-1, 1, 'send_private_message_to_selected_users', 'Send a private message to selected users', 'vbulletin'),
                    (-1, 1, 'send_private_message_to_x', 'Send a private message to {1}', 'vbulletin'),
                    (-1, 1, 'send_report', 'Send Report', 'vbulletin'),
                    (-1, 1, 'sent_items', 'Sent Items', 'vbulletin'),
                    (-1, 1, 'september', 'September', 'vbulletin'),
                    (-1, 1, 'settings_and_options', 'Settings &amp; Options', 'vbulletin'),
                    (-1, 1, 'show_groups', 'Show Groups', 'vbulletin'),
                    (-1, 1, 'show_results_x_to_y_of_z', 'Show results {1} to {2} of {3}', 'vbulletin'),
                    (-1, 1, 'show_thread_and_close_window', 'Show Thread &amp; Close Window', 'vbulletin'),
                    (-1, 1, 'show_threads_from_last_day', 'Show threads from last day', 'vbulletin'),
                    (-1, 1, 'show_threads_from_last_month', 'Show threads from last month', 'vbulletin'),
                    (-1, 1, 'show_threads_from_last_week', 'Show threads from last week', 'vbulletin'),
                    (-1, 1, 'show_threads_from_last_x_days', 'Show threads from last {1} days', 'vbulletin'),
                    (-1, 1, 'show_threads_from_last_x_months', 'Show threads from last {1} months', 'vbulletin'),
                    (-1, 1, 'show_threads_from_last_x_weeks', 'Show threads from last {1} weeks', 'vbulletin'),
                    (-1, 1, 'show_threads_from_last_year', 'Show threads from last year', 'vbulletin'),
                    (-1, 1, 'show_thumbnails', 'Show Thumbnails', 'vbulletin'),
                    (-1, 1, 'show_x_from_last_y_z', 'Show {1} from last {2} {3}', 'vbulletin'),
                    (-1, 1, 'showing_a_b_to_c_of_d', 'Showing {1} {2} to {3} of {4}', 'vbulletin'),
                    (-1, 1, 'showing_results_x_to_y_of_z', 'Showing results {1} to {2} of {3}', 'vbulletin'),
                    (-1, 1, 'showing_results_x_to_y_of_z_xx', 'Showing results {1} to {2} of {3} ({4} pages)', 'vbulletin'),
                    (-1, 1, 'showing_x_smilies_of_y_total', 'Showing {1} smilies of {2} total.', 'vbulletin'),
                    (-1, 1, 'signature', 'Signature', 'vbulletin'),
                    (-1, 1, 'site_areas', 'Site Areas', 'vbulletin'),
                    (-1, 1, 'smilie_list', 'Smilie List', 'vbulletin'),
                    (-1, 1, 'smilies', 'Smilies', 'vbulletin'),
                    (-1, 1, 'smilies_are_x', '<a href=\"{1}\" target=\"_blank\">Smilies</a> are <strong>{2}</strong>', 'vbulletin'),
                    (-1, 1, 'sorry', 'Sorry', 'vbulletin'),
                    (-1, 1, 'start_date', 'Start Date', 'vbulletin'),
                    (-1, 1, 'sticky_thread', 'Sticky Thread', 'vbulletin'),
                    (-1, 1, 'sticky_thread_prefix', 'Sticky: ', 'vbulletin'),
                    (-1, 1, 'subforums', 'Sub-Forums', 'vbulletin'),
                    (-1, 1, 'subject', 'Subject', 'vbulletin'),
                    (-1, 1, 'submit', 'Submit', 'vbulletin'),
                    (-1, 1, 'submit_note', 'Submit Note', 'vbulletin'),
                    (-1, 1, 'subscribe', 'Subscribe', 'vbulletin'),
                    (-1, 1, 'subscribe_to_forum', 'Subscribe to Forum', 'vbulletin'),
                    (-1, 1, 'subscribe_to_thread', 'Subscribe to Thread', 'vbulletin'),
                    (-1, 1, 'subscribed_threads', 'Subscribed Threads', 'vbulletin'),
                    (-1, 1, 'subscribed_threads_in_folder', 'Subscribed Threads in Folder', 'vbulletin'),
                    (-1, 1, 'subscription', 'Subscription', 'vbulletin'),
                    (-1, 1, 'subscription_title', 'Subscription Title', 'vbulletin'),
                    (-1, 1, 'subscriptions', 'Subscriptions', 'vbulletin'),
                    (-1, 1, 'sum_of_attachments_owned_by_x', 'Sum of all attachments owned by {1}', 'vbulletin'),
                    (-1, 1, 'sunday', 'Sunday', 'vbulletin'),
                    (-1, 1, 'sure_you_want_to_log_out', 'Are you sure you want to log out?', 'vbulletin'),
                    (-1, 1, 'text_editor_control_styles', 'Text Editor Control Styles', 'vbulletin'),
                    (-1, 1, 'there_are_no_outstanding_requests_to_join_this_usergroup', 'There are no outstanding requests to join this usergroup.', 'vbulletin'),
                    (-1, 1, 'there_is_already_setting_named_x', 'There is already a setting named {1}. You may not create duplicate settings.', 'vbulletin'),
                    (-1, 1, 'this_poll_is_closed', 'This poll is closed', 'vbulletin'),
                    (-1, 1, 'this_poll_will_close_on_x_at_y', 'This poll will close on <strong>{1}</strong> at <strong>{2}</strong>', 'vbulletin'),
                    (-1, 1, 'thread', 'Thread', 'vbulletin'),
                    (-1, 1, 'thread_deleted_by_x', 'Thread deleted by <a href=\"{1}\" target=\"_blank\">{2}</a>', 'vbulletin'),
                    (-1, 1, 'thread_rating_x_votes_y_average', 'Thread Rating: {1} votes, {2} average.', 'vbulletin'),
                    (-1, 1, 'thread_starter', 'Thread Starter', 'vbulletin'),
                    (-1, 1, 'threads', 'Threads', 'vbulletin'),
                    (-1, 1, 'thursday', 'Thursday', 'vbulletin'),
                    (-1, 1, 'time', 'Time', 'vbulletin'),
                    (-1, 1, 'timezone', 'Timezone', 'vbulletin'),
                    (-1, 1, 'title', 'Title', 'vbulletin'),
                    (-1, 1, 'to_add_a_new_folder', 'To <strong>add</strong> a new folder, enter the name of the new folder in one of the empty boxes in the list.', 'vbulletin'),
                    (-1, 1, 'to_delete_user_note_check_box', 'To delete this user note, check the box below and then click the \'Delete this Note\' button.', 'vbulletin'),
                    (-1, 1, 'to_rename_a_folder', 'To <strong>rename</strong> a folder, edit the folder\'s name in the list.', 'vbulletin'),
                    (-1, 1, 'today', 'Today', 'vbulletin'),
                    (-1, 1, 'todays_birthdays', 'Today\'s Birthdays', 'vbulletin'),
                    (-1, 1, 'todays_events', 'Today\'s Events', 'vbulletin'),
                    (-1, 1, 'todays_posts', 'Today\'s Posts', 'vbulletin'),
                    (-1, 1, 'top', 'Top', 'vbulletin'),
                    (-1, 1, 'total', 'Total', 'vbulletin'),
                    (-1, 1, 'total_posts_x', 'Total Posts: {1}', 'vbulletin'),
                    (-1, 1, 'total_votes', 'Total Votes', 'vbulletin'),
                    (-1, 1, 'total_x_nav', 'Total {1}', 'vbulletin'),
                    (-1, 1, 'track_messages', 'Track Messages', 'vbulletin'),
                    (-1, 1, 'tuesday', 'Tuesday', 'vbulletin'),
                    (-1, 1, 'unread_date', 'Unread', 'vbulletin'),
                    (-1, 1, 'unread_nav', 'Unread', 'vbulletin'),
                    (-1, 1, 'unread_x_nav', 'Unread {1}', 'vbulletin'),
                    (-1, 1, 'unregistered', 'Unregistered', 'vbulletin'),
                    (-1, 1, 'unsubscribe', 'Unsubscribe', 'vbulletin'),
                    (-1, 1, 'unsubscribe_from_this_forum', 'Unsubscribe from this Forum', 'vbulletin'),
                    (-1, 1, 'upcoming_events_for_the_next_x_days', 'Upcoming Events for the Next {1} Day(s)', 'vbulletin'),
                    (-1, 1, 'update_subscription_type', 'Update Subscription Type', 'vbulletin'),
                    (-1, 1, 'updating_post_counts', 'Updating Post Counts', 'vbulletin'),
                    (-1, 1, 'upload', 'Upload', 'vbulletin'),
                    (-1, 1, 'upload_errors', 'Upload Errors', 'vbulletin'),
                    (-1, 1, 'use', 'Use', 'vbulletin'),
                    (-1, 1, 'user', 'User', 'vbulletin'),
                    (-1, 1, 'user_control_panel', 'User Control Panel', 'vbulletin'),
                    (-1, 1, 'user_cp', 'User CP', 'vbulletin'),
                    (-1, 1, 'user_name', 'User Name', 'vbulletin'),
                    (-1, 1, 'user_notes_for_x', 'User Notes for {1}', 'vbulletin'),
                    (-1, 1, 'usergroup', 'Usergroup', 'vbulletin'),
                    (-1, 1, 'usergroups', 'Usergroups', 'vbulletin'),
                    (-1, 1, 'userid', 'Userid', 'vbulletin'),
                    (-1, 1, 'username', 'User Name', 'vbulletin'),
                    (-1, 1, 'valid_file_extensions', 'Valid file extensions', 'vbulletin'),
                    (-1, 1, 'validity_period', 'Validity Period', 'vbulletin'),
                    (-1, 1, 'vb_code_is_x', '<a href=\"{1}\" target=\"_blank\">vB code</a> is <strong>{2}</strong>', 'vbulletin'),
                    (-1, 1, 'vbulletin_copyright', 'vBulletin v{1}, Copyright &copy;2000-{2}, Jelsoft Enterprises Ltd.', 'vbulletin'),
                    (-1, 1, 'vbulletin_message', 'vBulletin Message', 'vbulletin'),
                    (-1, 1, 'view', 'View', 'vbulletin'),
                    (-1, 1, 'view_all_announcements', 'View All Announcements', 'vbulletin'),
                    (-1, 1, 'view_all_subscribed_threads', 'View all Subscribed Threads', 'vbulletin'),
                    (-1, 1, 'view_birthdays', 'View Birthdays', 'vbulletin'),
                    (-1, 1, 'view_forum_leaders', 'View Forum Leaders', 'vbulletin'),
                    (-1, 1, 'view_poll_results', 'View Poll Results', 'vbulletin'),
                    (-1, 1, 'view_post', 'View Post', 'vbulletin'),
                    (-1, 1, 'view_profile', 'View Profile', 'vbulletin'),
                    (-1, 1, 'view_whos_online', 'View Who\'s Online', 'vbulletin'),
                    (-1, 1, 'views', 'Views', 'vbulletin'),
                    (-1, 1, 'vote_now', 'Vote Now', 'vbulletin'),
                    (-1, 1, 'voters', 'Voters', 'vbulletin'),
                    (-1, 1, 'votes', 'Votes', 'vbulletin'),
                    (-1, 1, 'want_to_register', 'Want to register?', 'vbulletin'),
                    (-1, 1, 'wednesday', 'Wednesday', 'vbulletin'),
                    (-1, 1, 'week', 'Week', 'vbulletin'),
                    (-1, 1, 'weekly_email_notification', 'Weekly email notification', 'vbulletin'),
                    (-1, 1, 'weekly_updates_by_email', 'Weekly updates by email', 'vbulletin'),
                    (-1, 1, 'weeks', 'Weeks', 'vbulletin'),
                    (-1, 1, 'welcome_to_our_newest_member_x', 'Welcome to our newest member, <a href=\"{1}\">{2}</a>', 'vbulletin'),
                    (-1, 1, 'welcome_to_the_x', 'Welcome to the {1}.', 'vbulletin'),
                    (-1, 1, 'welcome_x', 'Welcome, {1}.', 'vbulletin'),
                    (-1, 1, 'whats_going_on', 'What\'s Going On?', 'vbulletin'),
                    (-1, 1, 'who_posted', 'Who Posted?', 'vbulletin'),
                    (-1, 1, 'whos_online', 'Who\'s Online', 'vbulletin'),
                    (-1, 1, 'window_open_failed_blocker', 'Unable to open a new browser window,\\n This might be due to a \'popup blocker\'', 'vbulletin'),
                    (-1, 1, 'within_the_last_x_days', 'Within the Last {1} Days', 'vbulletin'),
                    (-1, 1, 'x_attachments', '{1} Attachment(s)', 'vbulletin'),
                    (-1, 1, 'x_days_ago', '{1} Days Ago', 'vbulletin'),
                    (-1, 1, 'x_does_not_have_any_notes', '{1} does not currently have any notes.', 'vbulletin'),
                    (-1, 1, 'x_downloads', '{1} Downloads', 'vbulletin'),
                    (-1, 1, 'x_from_the_usergroup', '{1}</i> from the usergroup <i>', 'vbulletin'),
                    (-1, 1, 'x_hours_ago', '{1} Hours Ago', 'vbulletin'),
                    (-1, 1, 'x_is_on_your_ignore_list', '<strong>{1}</strong> is on your <a href=\"{2}\" target=\"_blank\">ignore list</a>.', 'vbulletin'),
                    (-1, 1, 'x_is_y', '{1} is {2}', 'vbulletin'),
                    (-1, 1, 'x_mailer', '{1} Forums', 'vbulletin'),
                    (-1, 1, 'x_members_and_y_guests', '{1} members and {2} guests', 'vbulletin'),
                    (-1, 1, 'x_minutes_ago', '{1} Minutes Ago', 'vbulletin'),
                    (-1, 1, 'x_powered_by_vbulletin', '{1} - Powered by vBulletin', 'vbulletin'),
                    (-1, 1, 'x_statistics', '{1} Statistics', 'vbulletin'),
                    (-1, 1, 'x_viewing', '{1} Viewing', 'vbulletin'),
                    (-1, 1, 'x_weeks_ago', '{1} Weeks Ago', 'vbulletin'),
                    (-1, 1, 'x_y_requests', '{1} ({2} requests)', 'vbulletin'),
                    (-1, 1, 'year', 'Year', 'vbulletin'),
                    (-1, 1, 'years', 'Years', 'vbulletin'),
                    (-1, 1, 'yes', 'Yes', 'vbulletin'),
                    (-1, 1, 'yesterday', 'Yesterday', 'vbulletin'),
                    (-1, 1, 'you_are_subscribed_to_this_thread', 'You are subscribed to this thread', 'vbulletin'),
                    (-1, 1, 'you_have_already_voted_on_this_poll', 'You have already voted on this poll', 'vbulletin'),
                    (-1, 1, 'you_may_not_vote_on_this_poll', 'You may not vote on this poll', 'vbulletin'),
                    (-1, 1, 'you_may_only_attach_x_files_per_post', 'You may only attach up to {1} files per post', 'vbulletin'),
                    (-1, 1, 'you_may_x_edit_your_posts', 'You <strong>may {1}</strong> edit your posts', 'vbulletin'),
                    (-1, 1, 'you_may_x_post_attachments', 'You <strong>may {1}</strong> post attachments', 'vbulletin'),
                    (-1, 1, 'you_may_x_post_new_threads', 'You <strong>may {1}</strong> post new threads', 'vbulletin'),
                    (-1, 1, 'you_may_x_post_replies', 'You <strong>may {1}</strong> post replies', 'vbulletin'),
                    (-1, 1, 'your_folders', 'Your Folders', 'vbulletin'),
                    (-1, 1, 'your_username', 'Your Username', 'vbulletin');
                    
                    MySQL Error  : Duplicate entry '1_day_ago--1-1' for key 2
                    Error Number : 1062
                    Date         : Monday, June 13th 2005 @ 10:06:11 PM
                    Script       : http://www.zeldacentralhq.com/zcbeta/install/finalupgrade.php?step=3
                    Referrer     : http://www.zeldacentralhq.com/zcbeta/install/finalupgrade.php?step=2
                    IP Address   : 195.195.42.126
                    Username     : 
                    Classname    : vb_database
                    I'm upgrading from vB3.0.7, should I just empty the phrase table and then retry this step?

                    edit: Emptied the phrase table, even though those memory_limit things are in the code it gives me the fatal error again, and when it doesn't it gives me this database error again.

                    Well as the language data seems to be there already I decided to skip ahead and enter step 4 into the browser and finish the finalupgrade.php

                    Doing this I get the following 2 errors

                    Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3818

                    and when trying to log-in to the admin cp:

                    Unable to add cookies, header already sent.
                    File: /home/virtual/site72/fst/var/www/html/zcbeta/includes/class_core.php
                    Line: 2643


                    EDIT2: I might further stress that although I'm upgrading from 3.0.7 the 3.0.7 was a clean install that I did today with only one modification made to it which was in the header template.


                    EDIT: Nevermind now, I emptied the phrase database and got my host to set the memory_limit higher seeing as the ini_set functions weren't working and it works fine now.
                    Last edited by Aerith_Freak; Tue 14 Jun '05, 6:05am.
                    A E R I T H
                    vBulletin 2 freak! xD

                    Comment


                    • #25
                      Clean Install, empty DB, this happens on Step 6 regardless of my adding the
                      Code:
                      [color=#000000][color=#0000bb] ini_set[/color][color=#007700]([/color][color=#dd0000]'memory_limit'[/color][color=#007700], [/color][color=#0000bb]16777216[/color][color=#007700]);[/color][/color]
                      .

                      I get this MySQL error on step 6:

                      Code:
                      Database error in vBulletin :
                      
                      Invalid SQL:
                      INSERT INTO bbphrase
                      (languageid, phrasetypeid, varname, text, product)
                      VALUES
                      (-1, 0, 'access', 'Access', 'vbulletin'),
                      (-1, 0, 'access_masks', 'Access Masks', 'vbulletin'),
                      (-1, 0, 'add', 'Add', 'vbulletin'),
                      (-1, 0, 'add_new_announcement', 'Add New Announcement', 'vbulletin'),
                      (-1, 0, 'additional_usergroups', 'Additional Usergroups', 'vbulletin'),
                      (-1, 0, 'admin_control_panel', 'Admin Control Panel', 'vbulletin'),
                      (-1, 0, 'administrator_permissions', 'Administrator Permissions', 'vbulletin'),
                      (-1, 0, 'all_default', 'All Default', 'vbulletin'),
                      (-1, 0, 'all_forums', 'All Forums', 'vbulletin'),
                      (-1, 0, 'all_no', 'All No', 'vbulletin'),
                      (-1, 0, 'all_usergroups', 'All Usergroups', 'vbulletin'),
                      (-1, 0, 'all_users', 'All Users', 'vbulletin'),
                      (-1, 0, 'all_yes', 'All Yes', 'vbulletin'),
                      (-1, 0, 'allow_bbcode', 'Allow BB Code', 'vbulletin'),
                      (-1, 0, 'allow_html', 'Allow HTML', 'vbulletin'),
                      (-1, 0, 'allow_img_code', 'Allow [IMG] Code', 'vbulletin'),
                      (-1, 0, 'allow_smilies', 'Allow Smilies', 'vbulletin'),
                      (-1, 0, 'allow_user_selection', 'Allow User Selection', 'vbulletin'),
                      (-1, 0, 'announcement_manager', 'Announcement Manager', 'vbulletin'),
                      (-1, 0, 'announcements', 'Announcements', 'vbulletin'),
                      (-1, 0, 'are_you_sure_want_to_delete_announcement_x', 'Are you <b>sure</b> you want to delete the announcement called \'{1}\'?<br /><span class=\"smallfont\">({2}: {3})</span><br /><br /> {4} This action can not be un-done.', 'vbulletin'),
                      (-1, 0, 'are_you_sure_you_want_to_delete_the_x_called_y', 'Are you <b>sure</b> you want to delete the {1} called \'{2}\'?<br /><span class=\"smallfont\">({3}: {4})</span><br /><br /> {5} This action can not be un-done.', 'vbulletin'),
                      (-1, 0, 'are_you_sure_you_want_to_revert_the_x_called_y', 'Are you <b>sure</b> you want to revert the {1} called \'{2}\'?<br /><span class=\"smallfont\">({3}: {4})</span><br /><br /> {5} This action can not be un-done.', 'vbulletin'),
                      (-1, 0, 'array', 'Array', 'vbulletin'),
                      (-1, 0, 'ascending', 'Ascending', 'vbulletin'),
                      (-1, 0, 'avatars', 'Avatars', 'vbulletin'),
                      (-1, 0, 'banned_users', 'Banned Users', 'vbulletin'),
                      (-1, 0, 'check_all', 'Check All', 'vbulletin'),
                      (-1, 0, 'child_of_x', 'Child of {1}', 'vbulletin'),
                      (-1, 0, 'click_for_help_on_these_options', 'Click for help on these options', 'vbulletin'),
                      (-1, 0, 'click_for_help_on_this_option', 'Click for help on this option', 'vbulletin'),
                      (-1, 0, 'click_here_to_continue_processing', 'Click here to continue processing ...', 'vbulletin'),
                      (-1, 0, 'close', 'Close', 'vbulletin'),
                      (-1, 0, 'color_key', 'Color Key', 'vbulletin'),
                      (-1, 0, 'completed', 'Completed', 'vbulletin'),
                      (-1, 0, 'confirm_deletion', 'Confirm Deletion', 'vbulletin'),
                      (-1, 0, 'confirm_deletion_of_x_y', 'Confirm Deletion of {1}: <span class=\"normal\">{2}</span>', 'vbulletin'),
                      (-1, 0, 'confirm_deletion_x', 'Confirm Deletion: <span class=\"normal\">{1}</span>', 'vbulletin'),
                      (-1, 0, 'continue', 'Continue', 'vbulletin'),
                      (-1, 0, 'control_panel_log', 'Control Panel Log', 'vbulletin'),
                      (-1, 0, 'controls', 'Controls', 'vbulletin'),
                      (-1, 0, 'customized_using_custom_permissions_for_this_usergroup', '<b>Customised:</b> Using custom permissions for this usergroup', 'vbulletin'),
                      (-1, 0, 'data_validation_type', 'Data Validation Type', 'vbulletin'),
                      (-1, 0, 'database_backup', 'Database Backup', 'vbulletin'),
                      (-1, 0, 'datatype_boolean', 'Boolean', 'vbulletin'),
                      (-1, 0, 'datatype_free', 'Free', 'vbulletin'),
                      (-1, 0, 'datatype_numeric', 'Numeric', 'vbulletin'),
                      (-1, 0, 'default_view_age', 'Default View Age <dfn>(Default date cut-off for thread display)', 'vbulletin'),
                      (-1, 0, 'delete_all', 'Delete All', 'vbulletin'),
                      (-1, 0, 'delete_moderator', 'Delete Moderator', 'vbulletin'),
                      (-1, 0, 'descending', 'Descending', 'vbulletin'),
                      (-1, 0, 'description', 'Description', 'vbulletin'),
                      (-1, 0, 'detailed', 'Detailed', 'vbulletin'),
                      (-1, 0, 'diagnostics', 'Diagnostics', 'vbulletin'),
                      (-1, 0, 'display_order', 'Display Order', 'vbulletin'),
                      (-1, 0, 'download', 'Download', 'vbulletin'),
                      (-1, 0, 'edit', 'Edit', 'vbulletin'),
                      (-1, 0, 'edit_text', 'Edit Text', 'vbulletin'),
                      (-1, 0, 'either', 'Either', 'vbulletin'),
                      (-1, 0, 'enable_disable_features', 'Enable / Disable Features', 'vbulletin'),
                      (-1, 0, 'end_date', 'End Date', 'vbulletin'),
                      (-1, 0, 'error', 'Error', 'vbulletin'),
                      (-1, 0, 'exact_match', 'Exact Match', 'vbulletin'),
                      (-1, 0, 'execute_sql_query', 'Execute SQL Query', 'vbulletin'),
                      (-1, 0, 'expand_all', 'Expand All', 'vbulletin'),
                      (-1, 0, 'extensions_and_sizes', 'Extensions &amp; Sizes', 'vbulletin'),
                      (-1, 0, 'field_required', 'Field Required', 'vbulletin'),
                      (-1, 0, 'filename', 'Filename', 'vbulletin'),
                      (-1, 0, 'find', 'Find', 'vbulletin'),
                      (-1, 0, 'find_all_threads_older_than_days', 'Find All Threads Older Than X Days', 'vbulletin'),
                      (-1, 0, 'find_updated_templates', 'Find Updated Templates', 'vbulletin'),
                      (-1, 0, 'forum_and_children', 'Forum <dfn>(Also applies to child forums)</dfn>', 'vbulletin'),
                      (-1, 0, 'generate_mailing_list', 'Generate Mailing List', 'vbulletin'),
                      (-1, 0, 'global_announcements', 'Global Announcements', 'vbulletin'),
                      (-1, 0, 'help', 'Help', 'vbulletin'),
                      (-1, 0, 'here_you_may_edit_forum_access_on_a_user_by_user_basis', 'Here you may edit forum access on a user-by-user basis.<br /><br />Selecting \"Yes\" will allow the user access to the forum. Selecting \"No\" will deny the user access to the forum. Any changes made to one user\'s account will override the default permission settings in their usergroup.<br /><br />Selecting \"Default\" will revert the user to the default permissions settings for their usergroup.<br /><br />(Please note that the permission inheritance system still works here.)<br /><br />(Ensure that you have access masks enabled before attempting to use these!)', 'vbulletin'),
                      (-1, 0, 'home_page', 'Home Page', 'vbulletin'),
                      (-1, 0, 'host_name', 'Host Name', 'vbulletin'),
                      (-1, 0, 'hour', 'Hour', 'vbulletin'),
                      (-1, 0, 'html_content_type', 'HTML Content Type', 'vbulletin'),
                      (-1, 0, 'hybrid', 'Hybrid', 'vbulletin'),
                      (-1, 0, 'if_you_are_not_automatically_redirected_click_here_x', 'If you are not automatically redirected, please <a href=\"{1}\">click here</a>.', 'vbulletin'),
                      (-1, 0, 'if_you_change_display_order', 'If you change the display orders, please be sure to submit the form using the \'Save Display Order\' button at the bottom of the page', 'vbulletin'),
                      (-1, 0, 'image', 'Image', 'vbulletin'),
                      (-1, 0, 'import', 'Import', 'vbulletin'),
                      (-1, 0, 'import_xml_file', '<b>OR</b> import the XML file from your server', 'vbulletin'),
                      (-1, 0, 'language', 'Language', 'vbulletin'),
                      (-1, 0, 'large_edit_box', 'Large Edit Box', 'vbulletin'),
                      (-1, 0, 'links', 'Links', 'vbulletin'),
                      (-1, 0, 'logged_in_user_x_executed_y_queries', 'Logged-in user: {1}; Executed {2} queries.', 'vbulletin'),
                      (-1, 0, 'logs', 'Logs', 'vbulletin'),
                      (-1, 0, 'maintenance', 'Maintenance', 'vbulletin'),
                      (-1, 0, 'mass_move', 'Mass Move', 'vbulletin'),
                      (-1, 0, 'max_length_of_allowed_user_input', 'Max length of allowed user input', 'vbulletin'),
                      (-1, 0, 'mime_type', 'Mime Type', 'vbulletin'),
                      (-1, 0, 'minimum_posts', 'Minimum Posts', 'vbulletin'),
                      (-1, 0, 'minute', 'Minute', 'vbulletin'),
                      (-1, 0, 'moderation', 'Moderation', 'vbulletin'),
                      (-1, 0, 'moderator_log', 'Moderator Log', 'vbulletin'),
                      (-1, 0, 'moderator_username', 'Moderator Username', 'vbulletin'),
                      (-1, 0, 'modify', 'Modify', 'vbulletin'),
                      (-1, 0, 'move', 'Move', 'vbulletin'),
                      (-1, 0, 'new', 'New', 'vbulletin'),
                      (-1, 0, 'no_file_uploaded_and_no_local_file_found', 'No file uploaded and no local file found. {1}', 'vbulletin'),
                      (-1, 0, 'no_one', 'No one', 'vbulletin'),
                      (-1, 0, 'no_posting', 'No Posting', 'vbulletin'),
                      (-1, 0, 'normal', 'Normal', 'vbulletin'),
                      (-1, 0, 'order_by', 'Order By', 'vbulletin'),
                      (-1, 0, 'order_by_date', 'Order By Date', 'vbulletin'),
                      (-1, 0, 'order_by_username', 'Order By User Name', 'vbulletin'),
                      (-1, 0, 'page', 'Page', 'vbulletin'),
                      (-1, 0, 'parent_forum', 'Parent Forum', 'vbulletin'),
                      (-1, 0, 'parent_style', 'Parent Style', 'vbulletin'),
                      (-1, 0, 'permanent', 'Permanent', 'vbulletin'),
                      (-1, 0, 'phrase_type', 'Phrase Type', 'vbulletin'),
                      (-1, 0, 'phrases', 'Phrases', 'vbulletin'),
                      (-1, 0, 'please_wait', 'Please Wait...', 'vbulletin'),
                      (-1, 0, 'primary_usergroup', 'Primary Usergroup', 'vbulletin'),
                      (-1, 0, 'processing_complete_proceed', 'Processing Complete - Proceed', 'vbulletin'),
                      (-1, 0, 'processing_x', 'Processing: {1}', 'vbulletin'),
                      (-1, 0, 'product', 'Product', 'vbulletin'),
                      (-1, 0, 'promotions', 'Promotions', 'vbulletin'),
                      (-1, 0, 'prune', 'Prune', 'vbulletin'),
                      (-1, 0, 'question', 'Question', 'vbulletin'),
                      (-1, 0, 'quick_search', 'Quick Search', 'vbulletin'),
                      (-1, 0, 'rebuild_style_information', 'Rebuild Style Information', 'vbulletin'),
                      (-1, 0, 'reminder', 'Reminder', 'vbulletin'),
                      (-1, 0, 'reminders', 'Reminders', 'vbulletin'),
                      (-1, 0, 'repeat_process', 'Repeat Process', 'vbulletin'),
                      (-1, 0, 'replace_with_text', 'Replace with Text', 'vbulletin'),
                      (-1, 0, 'reputation_level', 'Reputation Level', 'vbulletin'),
                      (-1, 0, 'restart', 'Restart', 'vbulletin'),
                      (-1, 0, 'results', 'Results', 'vbulletin'),
                      (-1, 0, 'revert', 'Revert', 'vbulletin'),
                      (-1, 0, 'save', 'Save', 'vbulletin'),
                      (-1, 0, 'save_display_order', 'Save Display Order', 'vbulletin'),
                      (-1, 0, 'save_open_groups_automatically', 'Save open groups automatically', 'vbulletin'),
                      (-1, 0, 'save_prefs', 'Save Prefs', 'vbulletin'),
                      (-1, 0, 'scheduled_task_log', 'Scheduled Task Log', 'vbulletin'),
                      (-1, 0, 'scheduled_tasks', 'Scheduled Tasks', 'vbulletin'),
                      (-1, 0, 'script', 'Script', 'vbulletin'),
                      (-1, 0, 'search_for_text', 'Search for Text', 'vbulletin'),
                      (-1, 0, 'search_in_x', 'Search in {1}', 'vbulletin'),
                      (-1, 0, 'search_type', 'Search Type', 'vbulletin'),
                      (-1, 0, 'select_forum', 'Select Forum', 'vbulletin'),
                      (-1, 0, 'set_default', 'Set Default', 'vbulletin'),
                      (-1, 0, 'setting_group', 'Setting Group', 'vbulletin'),
                      (-1, 0, 'settings_to_edit', 'Settings to Edit <dfn>Select the settings type you want to edit and click the \"Edit Settings\" button.</dfn>', 'vbulletin'),
                      (-1, 0, 'standard_using_default_usergroup_permissions', '<b>Standard:</b> Using default usergroup permissions', 'vbulletin'),
                      (-1, 0, 'statistics', 'Statistics', 'vbulletin'),
                      (-1, 0, 'status', 'Status', 'vbulletin'),
                      (-1, 0, 'strip_poll', 'Strip Poll', 'vbulletin'),
                      (-1, 0, 'style', 'Style', 'vbulletin'),
                      (-1, 0, 'styles', 'Styles', 'vbulletin'),
                      (-1, 0, 'stylevar', 'Stylevar', 'vbulletin'),
                      (-1, 0, 'stylevars', 'StyleVars', 'vbulletin'),
                      (-1, 0, 'submit', 'Submit', 'vbulletin'),
                      (-1, 0, 'table', 'Table', 'vbulletin'),
                      (-1, 0, 'templates', 'Templates', 'vbulletin'),
                      (-1, 0, 'text', 'Text', 'vbulletin'),
                      (-1, 0, 'thumbnail', 'Thumbnail', 'vbulletin'),
                      (-1, 0, 'time', 'Time', 'vbulletin'),
                      (-1, 0, 'translations', 'Translations', 'vbulletin'),
                      (-1, 0, 'unknown_error', 'Unknown Error', 'vbulletin'),
                      (-1, 0, 'update', 'Update', 'vbulletin'),
                      (-1, 0, 'update_counters', 'Update Counters', 'vbulletin'),
                      (-1, 0, 'updated_x_styles', 'Updated {1} style(s)', 'vbulletin'),
                      (-1, 0, 'upload_xml_file', '<b>EITHER</b> upload the XML file from your computer', 'vbulletin'),
                      (-1, 0, 'user_profile_field', 'User Profile Field', 'vbulletin'),
                      (-1, 0, 'user_profile_fields', 'User Profile Fields', 'vbulletin'),
                      (-1, 0, 'user_rank', 'User Rank', 'vbulletin'),
                      (-1, 0, 'user_reputation', 'User Reputation', 'vbulletin'),
                      (-1, 0, 'usergroup_options', 'Usergroup Options', 'vbulletin'),
                      (-1, 0, 'users', 'Users', 'vbulletin'),
                      (-1, 0, 'varname', 'Varname', 'vbulletin'),
                      (-1, 0, 'vbulletin_default', 'vBulletin Default <dfn>(Will be replaced by upgrade scripts)</dfn>', 'vbulletin'),
                      (-1, 0, 'vbulletin_options', 'vBulletin Options', 'vbulletin'),
                      (-1, 0, 'view_reputation_comments', 'View Reputation Comments', 'vbulletin'),
                      (-1, 0, 'who_voted', 'Who Voted', 'vbulletin'),
                      (-1, 0, 'x_enter_the_options_that_the_user_can_choose_from', '{1}<dfn>Enter the options that the user can choose from.  Separate each option with a new-line (carriage return).</dfn>', 'vbulletin'),
                      (-1, 0, 'x_from_the_calendar_y', '{1}</i> from the calendar <i>{2}', 'vbulletin'),
                      (-1, 0, 'x_from_the_forum_y', '{1}</i> from the forum <i>{2}', 'vbulletin'),
                      (-1, 0, 'x_to_y', '{1} to {2}', 'vbulletin'),
                      (-1, 0, 'x_translation', '{1} Translation', 'vbulletin'),
                      (-1, 0, 'x_y_id_z', '{1}: <span class=\"normal\">{2} (id: {3})</span>', 'vbulletin'),
                      (-1, 0, 'yesterday_today', 'Yesterday / Today', 'vbulletin'),
                      (-1, 0, 'you_did_not_specify_a_file_to_upload', 'You did not specify a file to upload, so vBulletin will attempt to import the file\\n\\n{1}\\n\\nfrom the server\'s file system.\\n\\nAre you sure?', 'vbulletin'),
                      (-1, 0, 'zero_equals_no_display', 'Set to \'0\' to not display this item', 'vbulletin');
                      
                      MySQL Error  : Duplicate entry 'admin_control_panel--1-0' for key 2
                      Error Number : 1062
                      Date		 : Tuesday, June 14th 2005 @ 09:03:14 AM
                      Script	   : http://www.***********.com/area51/install/install.php?step=6
                      Referrer	 : http://www.***********.com/area51/install/install.php?step=5
                      IP Address   : ***.***.***.**
                      Username	 : 
                      Classname	: vb_database
                      Any Ideas?

                      Comment


                      • #26
                        I just got the same error on a fresh install. Have whacked the DB twice and started over. Stops at the exact same spot with the same error.
                        I drank WHAT?! - Socrates

                        Comment


                        • #27
                          I got this error, even after doing what you did (adding the ini_set thing) - however once I had increased the memory limit permantely on my server by editting the php.ini file I didn't get the error and didn't have to empty the phrase table again.

                          Try contacting your host and get them to permantely increase the memory limit.
                          A E R I T H
                          vBulletin 2 freak! xD

                          Comment


                          • #28
                            [EDIT] - I just saw on the bug Traker this has been addressed in Beta 2. Good Job Guys!


                            Originally posted by Aerith_Freak
                            I got this error, even after doing what you did (adding the ini_set thing) - however once I had increased the memory limit permantely on my server by editting the php.ini file I didn't get the error and didn't have to empty the phrase table again.

                            Try contacting your host and get them to permantely increase the memory limit.
                            At this point I would rather not. vBulletin should be able to be installed without needing any special modifications to the servers. Given how easy to use and setup vB is I would suspect some people have no idea what to ask or who to ask for that.

                            Is this something that will remain this way through the Final Release or can this be moved to maybe 2 steps so that each step doesn't require as much memory?
                            Last edited by oglsmm; Fri 17 Jun '05, 4:35am. Reason: Saw it's Fixed Via Bug Traker

                            Comment


                            • #29
                              Originally posted by oglsmm
                              [EDIT] - I just saw on the bug Traker this has been addressed in Beta 2. Good Job Guys!



                              At this point I would rather not. vBulletin should be able to be installed without needing any special modifications to the servers. Given how easy to use and setup vB is I would suspect some people have no idea what to ask or who to ask for that.

                              Is this something that will remain this way through the Final Release or can this be moved to maybe 2 steps so that each step doesn't require as much memory?
                              **cough** See, someone agrees with me . This was in fact one of the reasons I originally purchased VB. At the time I had little experience with web developing and it was wonderful to have this program that was easy to install .

                              Comment


                              • #30
                                We're investigating ways to avoid requiring so much memory on the language import, the problem is that something about the PHP XML handler eats memory, and the language XML file is getting larger all the time...

                                Comment

                                Related Topics

                                Collapse

                                Working...
                                X