Database error in vBulletin 3.8.8

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • boscony
    New Member
    • Mar 2005
    • 7
    • 3.8.x

    Database error in vBulletin 3.8.8

    Invalid SQL:

    CREATE TABLE IF NOT EXISTS aaggregate_temp_1412867400 (
    attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
    views INT UNSIGNED NOT NULL DEFAULT '0',
    KEY attachmentid (attachmentid)
    ) ENGINE = MEMORY;

    MySQL Error : CREATE command denied to user 'sl_mysqlmast'@'xxx.xxx.xxx.xxx' for table 'aaggregate_temp_1412867400'
    Error Number : 1142

    Not sure why I am getting this error. We did move to a newer server and this is when I started to receive this error.
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74167

    #2
    You'll need to ask your host to give you access to create and delete tables on your database.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • boscony
      New Member
      • Mar 2005
      • 7
      • 3.8.x

      #3
      Wayne,

      It was due to wrong version of PHP. All good now!

      Comment

      • Paul M
        Former Lead Developer
        vB.Com & vB.Org
        • Sep 2004
        • 9886

        #4
        The "wrong version of php" will not cause that error, so who told you that ?
        Baby, I was born this way

        Comment

        Related Topics

        Collapse

        Working...