Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2016, 12:27 AM
mangmel mangmel is offline
 
Join Date: Nov 2010
Posts: 107
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default error upgrading 4xx

trying to upgrade 3.8.9 to 4xx but error


Quote:
Duplicate entry 'sitemap' for key 'varname'

Query:

INSERT INTO cron
(nextrun, weekday, day, hour, minute, filename, loglevel, varname, volatile, product)
VALUES
(
1232082000,
'-1',
'-1',
'5',
'a:1:{i:0;i:0;}',
'./includes/cron/sitemap.php',
'1',
'sitemap',
1,
'vbulletin'
)
seems error what is correct QUERYto delete please tell me correct query to delete sitemap from vbseo.
Reply With Quote
  #2  
Old 01-06-2016, 12:28 AM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

DELETE FROM cron WHERE varname = 'sitemap'
Reply With Quote
Благодарность от:
Dragonsys
  #3  
Old 01-06-2016, 02:00 AM
mangmel mangmel is offline
 
Join Date: Nov 2010
Posts: 107
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

wow thanks its correct query ..

but i'm stuck on 20% now..

Quote:
Upgrading to 4.0.0 Alpha 1
Step 39 - Altering cron Table (1 of 1)
Step 40 - Creating searchcore table
Step 41 - Creating searchcore_text table
Step 42 - Creating searchgroup table
Step 43 - Creating searchgroup_text table
Step 44 - Creating searchlog table
Step 45 - Creating indexqueue table
Step 46 - Dropping Old search Table
Step 47 - Dropping Old word Table
Step 48 - Dropping Old tagthread Table
Step 49 - Updating filedata table
Step 50 - Updating attachment table
Step 51 - Creating attachment table
Step 52 - Creating attachmentcategory table
Step 53 - Creating attachmentcategoryuser table
Step 54 - Creating picturelegacy table
Step 55 - Creating stylevar table
Step 56 - Creating stylevardfn table
Step 57 - Altering user Table (1 of 1)
Step 58 - Updating user table
Step 59 - Updating setting table
Updating attachment table
Converting attachments: 1171 to 1221 of 1221
Step 60 - Conversion of attachments complete
Step 61 - Altering filedata table
Step 62 - Altering filedata table
Step 63 - Altering filedata table
Step 64 - Altering filedata table
Step 65 - Altering filedata table
Step 66 - Altering filedata table
Step 67 - Skipping step, not needed
Step 68 - Altering filedata table
Step 69 - Altering filedata table
Step 70 - Altering filedata table
Step 71 - Altering filedata table
Step 72 - Altering filedata table
Step 73 - Altering filedata table
Step 74 - Altering filedata table
Step 75 - Altering filedata table
Step 76 - Updating attachmenttype table
Step 77 - Altering attachmenttype Table (1 of 3)
Step 78 - Altering attachmenttype Table (2 of 3)
Step 79 - Altering attachmenttype Table (3 of 3)
Step 80 - Altering albumpicture Table (1 of 1)
Step 81 - Altering socialgrouppicture Table (1 of 1)
Step 82 - Altering usercss Table (1 of 1)
Step 83 - Altering picturecomment Table (1 of 2)
Step 84 - Altering picturecomment Table (2 of 2)
Step 85 - Altering picturecomment_hash Table (1 of 2)
Step 86 - Altering picturecomment_hash Table (2 of 2)
Step 87 - Altering album Table (1 of 1)
Step 88 - Altering usergroup Table (1 of 1)
Moving photo 194 into the Attachment System
Step 89 - Albums Integration into Attachments Complete
Step 90 - Groups Integration into Attachments Complete
Step 91 - Altering moderator Table (1 of 1)
Step 92 - Altering usergroup Table (1 of 1)
Step 93 - Dropping Old albumpicture Table
Step 94 - Dropping Old socialgrouppicture Table
Step 95 - Dropping Old picture Table
Step 96 - Altering picturecomment Table (1 of 6)
Step 97 - Altering picturecomment Table (2 of 6)
Step 98 - Altering picturecomment Table (3 of 6)
Step 99 - Altering picturecomment Table (4 of 6)
Step 100 - Altering filedata Table (5 of 6)
Step 101 - Altering filedata Table (6 of 6)
Step 102 - Updating attachment table
Step 103 - Updating setting table
The next step may take a long time, please be patient..
some one know how long is this? its about 1 hour now .. still 20%
Reply With Quote
  #4  
Old 01-06-2016, 11:22 AM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sometimes it times out, just restart it.
Reply With Quote
  #5  
Old 01-06-2016, 01:55 PM
squidsk's Avatar
squidsk squidsk is offline
 
Join Date: Nov 2010
Posts: 969
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Depending on your forum and your server it can take hours.
Reply With Quote
Reply


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 07:00 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04044 seconds
  • Memory Usage 2,211KB
  • Queries Executed 11 (?)
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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (1)post_thanks_box_bit
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete