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

SQL Azure does not allow SELECT FROM sysfiles

    Details

      Description

      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;
      
      

        Attachments

          Activity

            People

            • Assignee:
              bantu bantu
              Reporter:
              naderman naderman
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: