Error uploading video via incoming folder

Using Concrete / Help
1

C5 version: 8.5.2
PHP version: 7.2.34

I am trying to upload a 173Mb video to my C5 website. I tried using file manager but the upload progress bar got to about 80% then the upload failed with a 500 error. I then uploaded the video to the incoming folder and tried importing it from there. Again I got an error:

Error

An exception occurred while executing ‘SELECT t0.uID AS uID_1, t0.uName AS uName_2, t0.uEmail AS uEmail_3, t0.uPassword AS uPassword_4, t0.uIsActive AS uIsActive_5, t0.uIsFullRecord AS uIsFullRecord_6, t0.uIsValidated AS uIsValidated_7, t0.uDateAdded AS uDateAdded_8, t0.uLastPasswordChange AS uLastPasswordChange_9, t0.uHasAvatar AS uHasAvatar_10, t0.uLastOnline AS uLastOnline_11, t0.uLastLogin AS uLastLogin_12, t0.uPreviousLogin AS uPreviousLogin_13, t0.uNumLogins AS uNumLogins_14, t0.uLastAuthTypeID AS uLastAuthTypeID_15, t0.uLastIP AS uLastIP_16, t0.uTimezone AS uTimezone_17, t0.uDefaultLanguage AS uDefaultLanguage_18, t0.uIsPasswordReset AS uIsPasswordReset_19, t20.usID AS usID_21, t20.uID AS uID_22, t20.createdBy AS createdBy_23 FROM Users t0 LEFT JOIN UserSignups t20 ON t20.uID = t0.uID WHERE t0.uID = ? LIMIT 1’ with params [1]:

Error while sending QUERY packet. PID=2853340

Details
/home/gspcsg5/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(131): Doctrine\DBAL\DBALException->null
/home/gspcsg5/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException->driverExceptionDuringQuery
/home/gspcsg5/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): Whoops\Exception\ErrorException->null
/home/gspcsg5/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOStatement->execute
/home/gspcsg5/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(847): Doctrine\DBAL\Driver\PDOStatement->execute
/home/gspcsg5/public_html/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(712): Doctrine\DBAL\Connection->executeQuery
/home/gspcsg5/public_html/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(196): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load
/home/gspcsg5/public_html/concrete/src/User/UserInfoRepository.php(85): Doctrine\ORM\EntityRepository->findOneBy
/home/gspcsg5/public_html/concrete/src/User/UserInfoRepository.php(27): Concrete\Core\User\UserInfoRepository->get
/home/gspcsg5/public_html/concrete/src/File/File.php(115): Concrete\Core\User\UserInfoRepository->getByID
/home/gspcsg5/public_html/concrete/src/File/Importer.php(391): Concrete\Core\File\File->add
/home/gspcsg5/public_html/concrete/controllers/backend/file.php(263): Concrete\Core\File\Importer->importIncomingFile
/home/gspcsg5/public_html/concrete/src/Controller/AbstractController.php(294): Concrete\Controller\Backend\File->importIncoming
/home/gspcsg5/public_html/concrete/src/Controller/AbstractController.php(294): null->call_user_func_array
/home/gspcsg5/public_html/concrete/src/Routing/ControllerRouteAction.php(64): Concrete\Core\Controller\AbstractController->runAction
/home/gspcsg5/public_html/concrete/src/Http/RouteDispatcher.php(37): Concrete\Core\Routing\ControllerRouteAction->execute
/home/gspcsg5/public_html/concrete/src/Http/Middleware/DispatcherDelegate.php(39): Concrete\Core\Http\RouteDispatcher->dispatch
/home/gspcsg5/public_html/concrete/src/Http/Middleware/MiddlewareStack.php(86): Concrete\Core\Http\Middleware\DispatcherDelegate->next
/home/gspcsg5/public_html/concrete/src/Http/DefaultDispatcher.php(125): Concrete\Core\Http\Middleware\MiddlewareStack->process
/home/gspcsg5/public_html/concrete/src/Http/DefaultDispatcher.php(58): Concrete\Core\Http\DefaultDispatcher->handleDispatch
/home/gspcsg5/public_html/concrete/src/Http/Middleware/DispatcherDelegate.php(39): Concrete\Core\Http\DefaultDispatcher->dispatch
/home/gspcsg5/public_html/concrete/src/Http/Middleware/ThumbnailMiddleware.php(76): Concrete\Core\Http\Middleware\DispatcherDelegate->next
/home/gspcsg5/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(50): Concrete\Core\Http\Middleware\ThumbnailMiddleware->process
/home/gspcsg5/public_html/concrete/src/Http/Middleware/FrameOptionsMiddleware.php(39): Concrete\Core\Http\Middleware\MiddlewareDelegate->next
/home/gspcsg5/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(50): Concrete\Core\Http\Middleware\FrameOptionsMiddleware->process
/home/gspcsg5/public_html/concrete/src/Http/Middleware/CookieMiddleware.php(35): Concrete\Core\Http\Middleware\MiddlewareDelegate->next
/home/gspcsg5/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(50): Concrete\Core\Http\Middleware\CookieMiddleware->process
/home/gspcsg5/public_html/concrete/src/Http/Middleware/ApplicationMiddleware.php(29): Concrete\Core\Http\Middleware\MiddlewareDelegate->next
/home/gspcsg5/public_html/concrete/src/Http/Middleware/MiddlewareDelegate.php(50): Concrete\Core\Http\Middleware\ApplicationMiddleware->process
/home/gspcsg5/public_html/concrete/src/Http/Middleware/MiddlewareStack.php(86): Concrete\Core\Http\Middleware\MiddlewareDelegate->next
/home/gspcsg5/public_html/concrete/src/Http/DefaultServer.php(85): Concrete\Core\Http\Middleware\MiddlewareStack->process
/home/gspcsg5/public_html/concrete/src/Foundation/Runtime/Run/DefaultRunner.php(128): Concrete\Core\Http\DefaultServer->handleRequest
/home/gspcsg5/public_html/concrete/src/Foundation/Runtime/DefaultRuntime.php(102): Concrete\Core\Foundation\Runtime\Run\DefaultRunner->run
/home/gspcsg5/public_html/concrete/dispatcher.php(45): Concrete\Core\Foundation\Runtime\DefaultRuntime->run
/home/gspcsg5/public_html/index.php(4): null->require

I have limited experience so if I need to change a setting I would appreciate exact directions on where the setting is located.

Thanks.

2

@gspcsg Are you able to paste your Concrete CMS site’s configuration, the Environment Information can be found under.
Dashboard > System & Settings > Environment > Environment Information

We’ll look at the PHP Settings and make sure your server will allow large files.

Thank you,
Jess

3

Hi Jess and thanks for offering to help.

Here’s the environment info. The max file upload is 512M so 177M shouldn’t be a problem…

concrete5 Version

Core Version - 8.5.2
Version Installed - 8.5.2
Database Version - 20190925072210

Database Information

Version: 10.3.36-MariaDB-log
SQL Mode: NO_ENGINE_SUBSTITUTION

concrete5 Packages

ExchangeCore reCAPTCHA (1.1.1), PDF Viewer (1.0.1), Stucco (2.1.6)

concrete5 Overrides

None

concrete5 Cache Settings

Block Cache - On
Overrides Cache - On
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Every 6 hours (default setting).

Server Software

Apache

Server API

cgi-fcgi

PHP Version

7.2.34

PHP Extensions

bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, enchant, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imagick, imap, intl, ionCube Loader, json, ldap, libxml, mbstring, monarxprotect, mysqli, mysqlnd, odbc, openssl, pcntl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, readline, Reflection, session, SimpleXML, snmp, soap, sockets, sodium, SPL, sqlite3, standard, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib

PHP Settings

max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 6200
memory_limit - 128M
post_max_size - 512M
upload_max_filesize - 512M
ic24.api.max_timeout - 7
ldap.max_links - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - no value
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5