Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] [PostgreSQL] Optimize Database [R]
#1
On a forum that is running PostgreSQL, the optimize table tool doesn't work in the Admin CP.

To reproduce the error, follow the steps below:

1. Admin CP > 'Tools & Maintenance' Tab > Optimize Database (Left Menu)
2. Click "Select All" in the Table Selection area
3. Click "Optimize Selected Tables"

The following error is returned:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    42601 - ERROR: syntax error at or near "TABLE" LINE 1: ANALYZE TABLE trunk_settinggroups ^ 
Query:
    ANALYZE TABLE trunk_settinggroups 

PostgreSQL 8.3.4
PHP 5.2.6
MyBB 1.4.3



Messages In This Thread
[F] [PostgreSQL] Optimize Database [R] - by Chris W. B. - 2008-11-17, 02:17 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)