Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-8691

Error creating log_time index

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.0.10-RC1
    • 3.0.x
    • Installation system
    • None
    • PHP Environment: 5.2.10
      Database: MySQL 5.0.67

      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);
      

            bantu Andreas Fischer [X] (Inactive)
            aweiredguy aweiredguy
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: