[Forum] At The End Of My Tether - VB4 Help *PLEASE*

[04wayne]

I filed a ticket at 7:48am. Now 11:15pm - go figure. Really am not amused.

Anyway, the old thread was getting no attention, just like my ticket, and my error has changed anyway to something even more annoying:

Database error in vBulletin 4.0.0 Beta 4:

Invalid SQL:
ALTER TABLE searchcore_text MODIFY title VARCHAR(254) NOT NULL DEFAULT '';

MySQL Error : Column 'keywordtext' cannot be part of FULLTEXT index
Error Number : 1283
Request Date : Tuesday, January 26th 2010 @ 11:14:02 PM
Error Date : Tuesday, January 26th 2010 @ 11:14:02 PM
Script : http://www.vanityedge.com/forum/inst...0b5.php?step=1
Referrer : http://www.vanityedge.com/forum/inst...and=1264547621
IP Address : 82.30.241.130
Username :
Classname : vB_Database
MySQL Version : 5.0.87-community

Any help is sincerely appreciated.

[IBxAnders]

Are you using UTF8 or any other character encode?

[04wayne]

I'm not actually sure. Earlier, I was getting the stage nine error ( Illegal mix of collations error while upgrading from 3.8.2 to 4.01), then my host sorted that issue out. Now I get the above one!

[JamieinNH]

Curious.. Didn't you just do a database dump into your vb install? Did the error occur before or after that? I am wondering if something you dumped into your database has corrupted it somehow.

If you did do a database dump, did you do a backup before you started? Can you install a test site and dump your back up into it and does it work properly?

Sorry I can't really help just trying to shoot some ideas out there for ya..

[04wayne]

Also, another issue I'm having - whenever I click on www.vanityedge.com/forum - Firefox states:

[IMG]file:///C:/DOCUME%7E1/rich/LOCALS%7E1/Temp/moz-screenshot-2.png[/IMG]

What does this mean?

[04wayne]

Curious.. Didn't you just do a database dump into your vb install? Did the error occur before or after that? I am wondering if something you dumped into your database has corrupted it somehow.

If you did do a database dump, did you do a backup before you started? Can you install a test site and dump your back up into it and does it work properly?

Sorry I can't really help just trying to shoot some ideas out there for ya..

As far as databases are concerned, all I do is create them. I let the hosts do the dumping and the rest of it. I did have an original one that was corrupted, so they restored a backup from before that. I can get the forum back under 3.8.2 just fine, but when I go to upgrade, it just doesn't happen. Like before, it'd stop at step 9/13 on VB 4.0.1. So I decided to go to 4.0.0 instead. Now it stops as soon as it gets to the 2nd stage of Beta 4, and it gives me the error shown in the first post

[IBxAnders]

Collations have to be the same on full text index tables; it's a collation problem again.

to be more precise:

All columns of a FULLTEXT index must have not only the same character set but also the same collation.

[04wayne]

^ Okay, thanks a lot! Just onto my host now, who can hopefully fix the issue

[04wayne]

My host is asking me what I'd like to change my collation too?! erm lol

[Trevor Hannant]

From your other thread, you said they're all showing as 'utf8_general_ci' - I'd therefore suggest this if you haven't been in touch with them already

[04wayne]

Well if you look here, all tables are showing this collation:



As you can see, 'utf8_general_ci' and that goes all the way down on each of the tables (183 tables!). Now when you click inside of one of them, for e.g. adminhelp, you see this:



Some different collations. Is this correct, or do those too need to be edited? If they too need to be edited, then that's a mighty whole lot of work.

Trevor - all of the tables are called 'utf8_general_ci' as you can see. So if that isn't the problem, then what else could it be?

[04wayne]

SOLVED

MAHOOOOOSIVE thank you to the one and only, Trevor Hannant - the man honestly is a walking vBulletin machine!! So knowledgeable and so generous with this knowledge. Huge credit to the team.

Thanks! x

[Trevor Hannant]

Glad you got it sorted Wayne - thanks to our one and only Colin F for a couple of pointers along the way in the background also...

[Apolo]

Found this very handy tip:

Just to add to Thomas's good advice: And to sort things out in PHPMyAdmin you have to change the characterset for all columns AT THE SAME TIME.
Just wasted half a day trying again and again to change the columns one at a time and continually getting the error message about the FULLTEXT index.

Source: http://stackoverflow.com/questions/6...fulltext-index

So you just click/select the specific table, select the fields/rows you want to modify and then click on "change". Then you can set the COLLATION for all of them at the same time and click on SAVE.

That's it.