Announcement

Collapse
No announcement yet.

Database error in vBulletin 4.0.1: Error 1146

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

  • [Forum] Database error in vBulletin 4.0.1: Error 1146

    I got this error many times a day:

    Database error in vBulletin 4.0.1:

    Invalid SQL:

    REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
    VALUES (0, '66.249.65.xxx', 1, 'Pachicola', '', 'post.dateline', 'DESC', 7.64523, 1, '2216', 1265760954, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{ i:594;s:9:\"Pachicola\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0; s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', '3127e2226942c76362dc07f3f4985692');

    MySQL Error : Table 'beasty1952.search' doesn't exist
    Error Number : 1146
    Request Date : Tuesday, February 9th 2010 @ 07:15:54 PM
    Error Date : Tuesday, February 9th 2010 @ 07:16:18 PM
    Script : "**many different**"
    Referrer :
    IP Address : 66.249.65.xxx
    Username : Niet geregistreerd
    Classname : vB_Database
    MySQL Version :
    i looked in ACP-->Settings-->search type and that is standing on "DB Search" (it's the only option)

    Does anyone know how this can be fixed?

  • #2
    That is from a modification. There is no table called 'search' in vb4. There was in vB3 though. So, turn off the modification and you should stop getting the errors.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      I found the problem, it was in my "Thank You hack"

      But thanks for your reaction!

      Comment


      • #4
        Originally posted by MrKramer View Post
        I found the problem, it was in my "Thank You hack"
        It's the same for me. How did you solve the problem? Now I have stopped the mod but it is very appreciated from users so I need to repair it. Any idea?
        Thanks.

        Comment


        • #5
          Good question. My population loves that hack. Which table would it run instead?
          No, my site isn't about Motorcycle Maintenance...

          Comment


          • #6
            The equivelent table is called searchlog.

            However, the table definition and contents are not exactly the same, so you cannot just change the name in any code.
            Baby, I was born this way

            Comment


            • #7
              Man, this upgrade has been unpleasant. Hacks I thought would be available are not, when I try to fix them I find out that even the simplest functions have been made complex and that I have to add thirty plugins to render things...

              I'm going to need to take a class on this...

              No, my site isn't about Motorcycle Maintenance...

              Comment


              • #8
                Anyway, I simply shut off the profile links that put in a search link and it stopped all the database errors. I would just like to fix that particular part if I can. Is there some blog or something that covers new search functionality in vb4?
                No, my site isn't about Motorcycle Maintenance...

                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...
                X