[Suite] Help please!

[trick2008]

I am getting this error when I try to upgrade from 3.6.8

Database error in vBulletin 3.8.4:

Invalid SQL:
INSERT INTO vbulletin_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');

MySQL Error : Duplicate entry 'sitemap' for key 2
Error Number : 1062
Request Date : Monday, December 21st 2009 @ 03:42:33 PM
Error Date : Monday, December 21st 2009 @ 03:42:33 PM
Script : http://modern-mommies.com/forums/ins...0a1.php?step=3
Referrer : http://modern-mommies.com/forums/ins...0a1.php?step=2
IP Address : 83.84.22.29
Username :
Classname : vB_Database
MySQL Version : 5.0.77mm0.1-log

[trick2008]

I mean 3.8.4 lol

[Zachery]

Do you have any hacks or addons?

[trick2008]

Nope, I removed them all...

[Zachery]

All of them? Including vBSEO and vBSEO's Sitemap addon?

[trick2008]

Ok yeah that was the problem, fixed it now.. but got this error now?

Database error in vBulletin 3.8.4:

Invalid SQL:
ALTER TABLE vbulletin_post ADD INDEX ipaddress (ipaddress);

MySQL Error : Duplicate key name 'ipaddress'
Error Number : -1
Request Date : Monday, December 21st 2009 @ 04:43:26 PM
Error Date : Monday, December 21st 2009 @ 04:43:31 PM
Script : http://modern-mommies.com/forums/ins...a1.php?step=11
Referrer : http://modern-mommies.com/forums/ins...a1.php?step=10
IP Address : 83.84.22.29
Username :
Classname : vB_Database
MySQL Version :

Any ideas?

[Zachery]

Looks like you'll need to remove the index key on that field before proceeding, or edit it out of the upgrader.

[trick2008]

Ok... I dont want to mess up my database by removing what I am not suppposed to... Can you point me in the right direction please?

[trick2008]

If i remove it from the database, how will it affect my forum? Just making sure, is this what I drop?

Indexes:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 361658 postid
userid INDEX 438 userid
threadid INDEX 361658 threadid
userid
dateline INDEX 361658 dateline
threadid_visible_dateline INDEX 361658 threadid
visible
dateline
userid
postid
ipaddress INDEX 4205 ipaddress
title FULLTEXT 1 title
pagetext

[Zachery]

Try removing:

        $upgrade->add_index(
            sprintf($upgradecore_phrases['create_index_x_on_y'], 'ipaddress', TABLE_PREFIX . 'post'),
            'post',
            'ipaddress',
            array('ipaddress')
        ); 

from the upgrade script, and rerunning it.

[trick2008]

you are awesome! Thanks so much!

[chloe]

Thank you so much! Both of you!!