Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-8691

Error creating log_time index

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.0.x
    • 3.0.10-RC1
    • Installation system
    • None
    • PHP Environment: 5.2.10
      Database: MySQL 5.0.67

    Description

      When updating phpbb 3.0.5 to 3.0.6-RC1 it get:

      Result :: Some queries failed, the statements and errors are listing below.
       
          * Error :: You have an error in your SQL syntax; check the manual that corresponds to your
             MySQL server version for the right syntax to use near 'log(log_time)' at line 1
            SQL :: CREATE INDEX log_time ON log(log_time)
      

      I assume this is because LOG is a mysql function and that I don't have any table prefixs.

      I tried this which worked:

          CREATE INDEX log_time ON `log`(log_time);
      

      Attachments

        Issue Links

          Activity

            People

              bantu Andreas Fischer
              aweiredguy aweiredguy
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: