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

SQL Azure does not allow SELECT FROM sysfiles

XMLWordPrintable

      The ACP statistics try to list the database size retrieved with 'SELECT ((SUM(size) * 8.0) * 1024.0) as dbsize FROM sysfiles' which does not work on Azure.

      Relevant code from phpBB/includes/functions_admin.php:

      		case 'mssql':
      		case 'mssql_odbc':
      		case 'mssqlnative':
      			$sql = 'SELECT ((SUM(size) * 8.0) * 1024.0) as dbsize
      				FROM sysfiles';
      			$result = $db->sql_query($sql, 7200);
      			$database_size = ($row = $db->sql_fetchrow($result)) ? $row['dbsize'] : false;
      			$db->sql_freeresult($result);
      		break;
      
      

            bantu Andreas Fischer [X] (Inactive)
            naderman Nils Adermann
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: