Announcement

Collapse
No announcement yet.

strange db error

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

  • strange db error

    Database error in vBulletin 3.0.3:
    Invalid SQL:
    SELECT subscribeforumid, forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
    FROM forum AS forum
    LEFT JOIN subscribeforum AS subscribeforum ON (subscribeforum.forumid = forum.forumid AND subscribeforum.userid = 2)

    mysql error: Incorrect information in file: './rb_forum/subscribeforum.frm'
    mysql error number: 1033
    Date: Thursday 10th of February 2005 02:39:42 PM
    Script: http://forum.ritterburgwelt.de/usercp.php?
    Referer: http://forum.ritterburgwelt.de/showt...24968&posted=1
    Username: blah
    IP Address: xxxxx

    -------------

    that i get if u se the user cp link at the head
    if i use the private message link, i can go into the cpo and work very well

    the board is updatet to 3.0.6 with the files from vb, the hole board works very well, no special hacks inside

    can any guy help pls ?

  • #2
    1. Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    2. If you still have this problem, then reupload the original userco.php.php file from the vB zip file. Make sure you upload in ASCII and overwrite the one on the server.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      thx
      working

      Comment


      • #4
        How about this

        I get this error via e-mail. Yet I'm using 3.0.6! (http://forums.officer.com/forums/) The site seems to be working fine...but...these errors keep pouring in!

        Any ideas?
        Thanks
        Dave


        Database error in vBulletin 2.3.0:
        Invalid SQL:

        SELECT *

        FROM session

        WHERE userid = 0

        AND host = '66.31.99.230'

        AND idhash = '23198030a9480c15ad84a7467b858fd7'

        LIMIT 1



        mysql error: Unknown column 'idhash' in 'where clause'

        mysql error number: 1054

        Date: Friday 11th of February 2005 02:44:11 AM

        Script:
        http://forums.officer.com/forums/

        Referer:

        IP Address: 66.31.99.230

        Comment


        • #5
          and...

          Database error in vBulletin 2.3.0:

          Invalid SQL:

          SELECT templateid

          FROM template

          WHERE title = 'STANDARD_ERROR' AND styleid = -1



          mysql error: Unknown column 'styleid' in 'where clause'

          mysql error number: 1054

          Date: Friday 11th of February 2005 02:44:47 AM

          Script:
          http://forums.officer.com/forums/

          Referer:

          IP Address: 24.63.29.119





          Database error in vBulletin :

          Invalid SQL:

          SELECT title, data

          FROM datastore

          WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'rankphp', 'smiliecache', 'bbcodecache', 'mailqueue', 'hidprofilecache')



          mysql error: Table 'fhdb.datastore' doesn't exist

          mysql error number: 1146

          Date: Friday 11th of February 2005 02:31:15 AM

          Script:
          http://forums.officer.com/forums/showthread.php?threadid=27239

          Referer: http://www.advrider.com/forums/showthread.php?t=68245

          IP Address: 66.94.16.81


          Comment


          • #6
            Database error in vBulletin 2.3.0:

            Invalid SQL:

            SELECT *

            FROM session

            WHERE sessionhash = '88c4224bcabb93193f2cf43e5e2d83c0'

            AND lastactivity > 1108104635

            AND host = '65.54.188.52'

            AND idhash = '5f07be81ea7c4d127054ba41bd525800'



            mysql error: Unknown column 'idhash' in 'where clause'

            mysql error number: 1054

            Date: Friday 11th of February 2005 02:40:36 AM

            Script:
            http://forums.officer.com/forums/showthread.php?threadid=24700

            Referer:

            IP Address: 65.54.188.52

            Comment


            • #7
              Firehouse, please start your own thread if you need further help. I have also responded to your support ticket.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment


              • #8
                another point Firehouse this is the forum for Vbulletin 3 Troubleshooting and Problems

                Comment

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