Announcement

Collapse
No announcement yet.

At The End Of My Tether - VB4 Help *PLEASE*

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

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

    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.

  • #2
    Are you using UTF8 or any other character encode?
    anders | vbulletin team | check out the new vbulletin facebook app
    Proudly vBulletin'ing since 2001
    Please be my friend!
    http://www.twitter.com/inetskunkworks
    vBulletin Performance Articles:
    Click here to read

    Comment


    • #3
      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!

      Comment


      • #4
        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..

        Comment


        • #5
          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]Click image for larger version

Name:	frirefox.JPG
Views:	1
Size:	16.7 KB
ID:	3677833

          What does this mean?

          Comment


          • #6
            Originally posted by JamieinNH View Post
            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

            Comment


            • #7
              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.
              anders | vbulletin team | check out the new vbulletin facebook app
              Proudly vBulletin'ing since 2001
              Please be my friend!
              http://www.twitter.com/inetskunkworks
              vBulletin Performance Articles:
              Click here to read

              Comment


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

                Comment


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

                  Comment


                  • #10
                    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
                    Vote for:

                    - *Admin Settable Paid Subscription Reminder Timeframe*
                    -
                    *PM - Add ability to reply to originator only*
                    - Add Admin ability to auto-subscribe users to specific channel(s)
                    - Highlight the correct navigation tab when you are on a custom page
                    - "Quick Route" Interface...
                    - Allow to use custom icons for individual forums

                    Comment


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

                      Click image for larger version

Name:	database 1.JPG
Views:	1
Size:	90.7 KB
ID:	3677840

                      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:

                      Click image for larger version

Name:	database 2.JPG
Views:	1
Size:	60.6 KB
ID:	3677841

                      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?

                      Comment


                      • #12
                        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

                        Comment


                        • #13
                          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...
                          Vote for:

                          - *Admin Settable Paid Subscription Reminder Timeframe*
                          -
                          *PM - Add ability to reply to originator only*
                          - Add Admin ability to auto-subscribe users to specific channel(s)
                          - Highlight the correct navigation tab when you are on a custom page
                          - "Quick Route" Interface...
                          - Allow to use custom icons for individual forums

                          Comment


                          • #14
                            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.
                            ComunidadHosting Web Hosting Forums

                            Comment

                            Related Topics

                            Collapse

                            • kehindelawal
                              Exception_trace
                              by kehindelawal
                              i got exception_trace error when trying to post. It just came out of the blues so to say. i have not been getting many errors previously.

                              Here is the error generated: i ave tried to remove...
                              Sat 28th Jun '14, 12:35am
                            • kehindelawal
                              Exception_trace
                              by kehindelawal
                              i got exception_trace error when trying to post. It just came out of the blues so to say. i have not been getting many errors previously.

                              Here is the error generated: i ave tried to remove...
                              Sat 28th Jun '14, 12:40am
                            Working...
                            X