error upgrading 4xx

[mangmel]

trying to upgrade 3.8.9 to 4xx but error



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.

[Dave]

DELETE FROM cron WHERE varname = 'sitemap'

[mangmel]

wow thanks its correct query ..

but i'm stuck on 20% now..

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%

[Dave]

Sometimes it times out, just restart it.

[squidsk]

Depending on your forum and your server it can take hours.