help Database Error Number : 1146

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • matheus2
    Member
    • Oct 2014
    • 48
    • 5.1.x

    help Database Error Number : 1146

    When installing this mod I get this error
    when I click on user perfil



    Database error
    The http://mysite.com database has encountered a problem.

    Please try the following:
    • Load the page again by clicking the button in your web browser.
    • Open the http://mysite.com home page, then try to open another page.
    • Click the button to try another link.
    The http://mysite.com forum technical staff have been notified of the error, though you may if the problem persists.
    We apologise for any inconvenience.
    Database error in vBulletin 3.8.9:

    Invalid SQL:
    SELECT COUNT(*) as X FROM thanks WHERE userid = 1;

    MySQL Error : Table 'gtgt34.thanks' doesn't exist
    Error Number : 1146
    Request Date : Saturday, April 22nd 2017 @ 02:18:24 AM
    Error Date : Saturday, April 22nd 2017 @ 02:18:24 AM
    Script : http://mysite.com/member.php?u=1
    Referrer : http://mysite.com/index.php
    IP Address : 111.123.123.123
    Username : ROOTMASTER
    Classname : vB_Database_MySQLi
    MySQL Version : 5.6.33-cll-lve
    Last edited by matheus2; Fri 21 Apr '17, 6:44pm.
  • Paul M
    Former Lead Developer
    vB.Com & vB.Org
    • Sep 2004
    • 9886

    #2

    The error is self explanatory, a table is missing

    MySQL Error : Table 'gtgt34.thanks' doesn't exist
    Thats not a standard vB table either, its from a modification, so you need to seek help in the relevant thread on vbulletin.org
    Baby, I was born this way

    Comment

    • pet0etie
      New Member
      • Mar 2010
      • 18
      • 3.8.x

      #3
      you are using the expanded edition i guess but that's no longer available from the forum as it might be archeived
      is it somehow possible to see/have the code from that mod (the expanded version) ?

      are u using a prefix for your tables ? see includes/config.php >>> $config['Database']['tableprefix'] = ?

      Comment

      • matheus2
        Member
        • Oct 2014
        • 48
        • 5.1.x

        #4
        Originally posted by pet0etie
        you are using the expanded edition i guess but that's no longer available from the forum as it might be archeived
        is it somehow possible to see/have the code from that mod (the expanded version) ?

        are u using a prefix for your tables ? see includes/config.php >>> $config['Database']['tableprefix'] = ?
        not plefix , help plis

        / ****** TABLE PREFIX ******
        // Prefix that your vBulletin tables have in the database.
        $config['Database']['tableprefix'] = '';

        Last edited by matheus2; Sat 22 Apr '17, 12:40pm.

        Comment

        • Trevor Hannant
          vBulletin Support
          • Aug 2002
          • 24325
          • 5.7.X

          #5
          As Paul states, you need to speak to the modification author for assistance with this error.
          Vote for:

          - Admin Settable Paid Subscription Reminder Timeframe (vB6)
          - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

          Comment

          • matheus2
            Member
            • Oct 2014
            • 48
            • 5.1.x

            #6
            Originally posted by Trevor Hannant
            As Paul states, you need to speak to the modification author for assistance with this error.
            The author does not answer me.

            Comment

            • Mark.B
              vBulletin Support
              • Feb 2004
              • 24286
              • 6.0.X

              #7
              Originally posted by matheus2

              The author does not answer me.
              That doesn't change anything. We can't provide support for third party code, and that's because we have absolutely no idea how such code is written.

              You can ask for help on vbulletin.org, even if the author isn't around, others should be able to assist.

              You can try disabling the add-on, which looks like some sort of thanks add-on.
              MARK.B
              vBulletin Support
              ------------
              My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
              My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

              Comment

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