Populated the TokenStorage with an anonymous Token.
CRITICAL
request
Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT r0_.name AS name_0 FROM regions r0_ WHERE r0_.id_region IN (?)' with params [""]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oceanexpert_dev.regions' doesn't exist" at /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61
Log messages generated by using features marked as deprecated.
Time
Channel
php
(none)
Message
php
User Deprecated: The Symfony\Bundle\TwigBundle\Loader\FilesystemLoader class is deprecated since version 4.3 and will be removed in 5.0; use Twig notation for templates instead.
User Deprecated: The Symfony\Bundle\TwigBundle\TwigEngine class is deprecated since version 4.3 and will be removed in 5.0; use \Twig\Environment instead.
User Deprecated: The Symfony\Bundle\FrameworkBundle\Templating\EngineInterface interface is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
User Deprecated: The Symfony\Bundle\FrameworkBundle\Templating\Loader\TemplateLocator class is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
User Deprecated: The Symfony\Bundle\FrameworkBundle\Templating\TemplateNameParser class is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
User Deprecated: The method "Symfony\Component\Intl\Intl::getRegionBundle()" is deprecated since Symfony 4.3, use "Symfony\Component\Intl\Countries" instead.
User Deprecated: The "Doctrine\Common\Inflector\Inflector::classify" method is deprecated and will be dropped in doctrine/inflector 2.0. Please update to the new Inflector API.
User Deprecated: The Symfony\Bundle\FrameworkBundle\Templating\TemplateReference class is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
The "Symfony\Component\Config\Definition\Builder\TreeBuilder::root()" method called for the "sensio_framework_extra" configuration is deprecated since Symfony 4.3, pass the root name to the constructor instead.
The "Doctrine\Common\Persistence\ManagerRegistry" service alias is deprecated, use "Doctrine\Persistence\ManagerRegistry" instead. It is being referenced by the ".service_locator.m_UuKYL" service.
The Symfony\Bundle\FrameworkBundle\CacheWarmer\TemplatePathsCacheWarmer class is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
The Symfony\Bundle\FrameworkBundle\CacheWarmer\TemplateFinderInterface interface is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
The Symfony\Bundle\FrameworkBundle\Templating\Loader\TemplateLocator class is deprecated since version 4.3 and will be removed in 5.0; use Twig instead.
The fos_rest.routing.loader.directory service is deprecated since FOSRestBundle 2.8. You can disable it by setting the config `fos_rest.routing_loader.enabled` to `false`.
The fos_rest.routing.loader.processor service is deprecated since FOSRestBundle 2.8. You can disable it by setting the config `fos_rest.routing_loader.enabled` to `false`.
The fos_rest.routing.loader.controller service is deprecated since FOSRestBundle 2.8. You can disable it by setting the config `fos_rest.routing_loader.enabled` to `false`.
The fos_rest.routing.loader.reader.action service is deprecated since FOSRestBundle 2.8. You can disable it by setting the config `fos_rest.routing_loader.enabled` to `false`.
Not passing an instance of FOS\RestBundle\Routing\Loader\Reader\RestControllerReader as the 3rd argument of FOS\RestBundle\Routing\Loader\RestRouteLoader::__construct() is deprecated since FOSRestBundle 2.8.
The fos_rest.routing.loader.yaml_collection service is deprecated since FOSRestBundle 2.8. You can disable it by setting the config `fos_rest.routing_loader.enabled` to `false`.
The fos_rest.routing.loader.xml_collection service is deprecated since FOSRestBundle 2.8. You can disable it by setting the config `fos_rest.routing_loader.enabled` to `false`.
Referencing controllers with OceanExpertBundle:Default:index is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::indexAction" instead.
Referencing controllers with OceanExpertBundle:Default:statistics is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::statisticsAction" instead.
Referencing controllers with OceanExpertBundle:Dashboard:index is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DashboardController::indexAction" instead.
Referencing controllers with OceanExpertBundle:Registration:checkUsernameAvailable is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\RegistrationController::checkUsernameAvailableAction" instead.
Referencing controllers with OceanExpertBundle:Registration:checkEmailAvailable is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\RegistrationController::checkEmailAvailableAction" instead.
Referencing controllers with OceanExpertBundle:Registration:confirmProfile is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\RegistrationController::confirmProfileAction" instead.
Referencing controllers with OceanExpertBundle:Api:checkSession is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ApiController::checkSessionAction" instead.
Referencing controllers with OceanExpertBundle:Security:socialSignIn is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SecurityController::socialSignInAction" instead.
Referencing controllers with OceanExpertBundle:Countries:getAllCountries is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\CountriesController::getAllCountriesAction" instead.
Referencing controllers with OceanExpertBundle:Institution:getInstitutionByCountry is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\InstitutionController::getInstitutionByCountryAction" instead.
Referencing controllers with OceanExpertBundle:Institution:getInstitutionAddress is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\InstitutionController::getInstitutionAddressAction" instead.
Referencing controllers with OceanExpertBundle:Institution:addInstitution is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\InstitutionController::addInstitutionAction" instead.
Referencing controllers with OceanExpertBundle:Institution:getInstitutionsAjax is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\InstitutionController::getInstitutionsAjaxAction" instead.
Referencing controllers with OceanExpertBundle:Search:generalSearch is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::generalSearchAction" instead.
Referencing controllers with OceanExpertBundle:Profile:userProfile is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::userProfileAction" instead.
Referencing controllers with OceanExpertBundle:Profile:edit is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::editAction" instead.
Referencing controllers with OceanExpertBundle:Profile:viewProfile is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::viewProfileAction" instead.
Referencing controllers with OceanExpertBundle:Profile:getExpertsAjax is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::getExpertsAjaxAction" instead.
Referencing controllers with OceanExpertBundle:Registration:profileStatus is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\RegistrationController::profileStatusAction" instead.
Referencing controllers with OceanExpertBundle:Profile:updateProfileTime is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::updateProfileTimeAction" instead.
Referencing controllers with OceanExpertBundle:Profile:activateUser is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::activateUserAction" instead.
Referencing controllers with OceanExpertBundle:Profile:deactivateUser is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::deactivateUserAction" instead.
Referencing controllers with OceanExpertBundle:Institution:viewInstitution is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\InstitutionController::viewInstitutionAction" instead.
Referencing controllers with OceanExpertBundle:Institution:viewInstitutes is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\InstitutionController::viewInstitutesAction" instead.
Referencing controllers with OceanExpertBundle:Institution:editInstituteSuccess is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\InstitutionController::editInstituteSuccessAction" instead.
Referencing controllers with OceanExpertBundle:User:createUser is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\UserController::createUserAction" instead.
Referencing controllers with OceanExpertBundle:Search:advancedSearch is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::advancedSearchAction" instead.
Referencing controllers with OceanExpertBundle:Search:getSeaRegions is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::getSeaRegionsAction" instead.
Referencing controllers with OceanExpertBundle:Search:getMemberGroups is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::getMemberGroupsAction" instead.
Referencing controllers with OceanExpertBundle:Search:getJobTypes is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::getJobTypesAction" instead.
Referencing controllers with OceanExpertBundle:Search:getCountries is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::getCountriesAction" instead.
Referencing controllers with OceanExpertBundle:Search:getSubjectArea is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::getSubjectAreaAction" instead.
Referencing controllers with OceanExpertBundle:Search:getEventTypes is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::getEventTypesAction" instead.
Referencing controllers with OceanExpertBundle:Search:getInstitutionTypes is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::getInstitutionTypesAction" instead.
Referencing controllers with OceanExpertBundle:Search:getDocumentTypes is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::getDocumentTypesAction" instead.
Referencing controllers with OceanExpertBundle:Default:createMapJson is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::createMapJsonAction" instead.
Referencing controllers with OceanExpertBundle:Resetting:changeUsername is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ResettingController::changeUsernameAction" instead.
Referencing controllers with OceanExpertBundle:Resetting:changeEmail is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ResettingController::changeEmailAction" instead.
Referencing controllers with OceanExpertBundle:Registration:deleteAccount is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\RegistrationController::deleteAccountAction" instead.
Referencing controllers with OceanExpertBundle:Registration:recoverAccount is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\RegistrationController::recoverAccountAction" instead.
Referencing controllers with OceanExpertBundle:Institution:activateInstitute is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\InstitutionController::activateInstituteAction" instead.
Referencing controllers with OceanExpertBundle:Institution:deactivateInstitute is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\InstitutionController::deactivateInstituteAction" instead.
Referencing controllers with OceanExpertBundle:Profile:qccontrol is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::qccontrolAction" instead.
Referencing controllers with OceanExpertBundle:Profile:setRetired is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::setRetiredAction" instead.
Referencing controllers with OceanExpertBundle:Profile:setDeceased is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::setDeceasedAction" instead.
Referencing controllers with OceanExpertBundle:Profile:setDoNotInvite is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::setDoNotInviteAction" instead.
Referencing controllers with OceanExpertBundle:Profile:setAdmincomments is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::setAdmincommentsAction" instead.
Referencing controllers with OceanExpertBundle:Group:setGroups is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::setGroupsAction" instead.
Referencing controllers with OceanExpertBundle:Profile:setPrivileges is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::setPrivilegesAction" instead.
Referencing controllers with OceanExpertBundle:Profile:resetPasswordLink is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::resetPasswordLinkAction" instead.
Referencing controllers with OceanExpertBundle:User:sendEmailVerification is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\UserController::sendEmailVerificationAction" instead.
Referencing controllers with OceanExpertBundle:Profile:assignRoles is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ProfileController::assignRolesAction" instead.
Referencing controllers with OceanExpertBundle:Default:disclaimer is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::disclaimerAction" instead.
Referencing controllers with OceanExpertBundle:Default:getExpertsLastName is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::getExpertsLastNameAction" instead.
Referencing controllers with OceanExpertBundle:Default:getExpertCountryList is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::getExpertCountryListAction" instead.
Referencing controllers with OceanExpertBundle:Default:getExpertsSubjects is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::getExpertsSubjectsAction" instead.
Referencing controllers with OceanExpertBundle:Default:getExpertsSeaRegions is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::getExpertsSeaRegionsAction" instead.
Referencing controllers with OceanExpertBundle:Default:getInstitutionNameList is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::getInstitutionNameListAction" instead.
Referencing controllers with OceanExpertBundle:Default:getInstitutionCountryList is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::getInstitutionCountryListAction" instead.
Referencing controllers with OceanExpertBundle:Default:getInstitutionTypes is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::getInstitutionTypesAction" instead.
Referencing controllers with OceanExpertBundle:Default:getInstitutesSeaRegions is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::getInstitutesSeaRegionsAction" instead.
Referencing controllers with OceanExpertBundle:Admin:getTaskAjax is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::getTaskAjaxAction" instead.
Referencing controllers with OceanExpertBundle:Mails:index is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\MailsController::indexAction" instead.
Referencing controllers with OceanExpertBundle:Event:calendar is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::calendarAction" instead.
Referencing controllers with OceanExpertBundle:Event:viewEvent is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::viewEventAction" instead.
Referencing controllers with OceanExpertBundle:Event:viewPlanningWheel is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::viewPlanningWheelAction" instead.
Referencing controllers with OceanExpertBundle:Event:confirmEventCreation is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::confirmEventCreationAction" instead.
Referencing controllers with OceanExpertBundle:Event:registerEvent is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::registerEventAction" instead.
Referencing controllers with OceanExpertBundle:Registration:register is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\RegistrationController::registerAction" instead.
Referencing controllers with OceanExpertBundle:Event:viewPrintableParticipants is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::viewPrintableParticipantsAction" instead.
Referencing controllers with OceanExpertBundle:Event:viewAgendaPrintable is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::viewAgendaPrintableAction" instead.
Referencing controllers with OceanExpertBundle:Event:getIcs is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::getIcsAction" instead.
Referencing controllers with OceanExpertBundle:Event:viewAnnonatedAgendaPrintable is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::viewAnnonatedAgendaPrintableAction" instead.
Referencing controllers with OceanExpertBundle:Event:eventImageUpload is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::eventImageUploadAction" instead.
Referencing controllers with OceanExpertBundle:Event:confirmEventParticipation is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::confirmEventParticipationAction" instead.
Referencing controllers with OceanExpertBundle:Event:downloadEventParticipantsInfo is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::downloadEventParticipantsInfoAction" instead.
Referencing controllers with OceanExpertBundle:Default:downloadExpertsPerCountry is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DefaultController::downloadExpertsPerCountryAction" instead.
Referencing controllers with OceanExpertBundle:Document:searchDocument is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::searchDocumentAction" instead.
Referencing controllers with OceanExpertBundle:Document:getDocumentById is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::getDocumentByIdAction" instead.
Referencing controllers with OceanExpertBundle:Document:documentDownloadBlock is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::documentDownloadBlockAction" instead.
Referencing controllers with OceanExpertBundle:Document:downloadFile is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::downloadFileAction" instead.
Referencing controllers with OceanExpertBundle:Document:viewDocument is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::viewDocumentAction" instead.
Referencing controllers with OceanExpertBundle:Document:viewDocuments is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::viewDocumentsAction" instead.
Referencing controllers with OceanExpertBundle:Document:viewDoclist is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::viewDoclistAction" instead.
Referencing controllers with OceanExpertBundle:Document:viewAllDoclists is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::viewAllDoclistsAction" instead.
Referencing controllers with OceanExpertBundle:Mails:processEmail is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\MailsController::processEmailAction" instead.
Referencing controllers with OceanExpertBundle:Mails:mandrillWebhook is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\MailsController::mandrillWebhookAction" instead.
Referencing controllers with OceanExpertBundle:Lme:editProject is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\LmeController::editProjectAction" instead.
Referencing controllers with OceanExpertBundle:Lme:searchProjects is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\LmeController::searchProjectsAction" instead.
Referencing controllers with OceanExpertBundle:Lme:viewProject is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\LmeController::viewProjectAction" instead.
Referencing controllers with OceanExpertBundle:Lme:getLmeStatus is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\LmeController::getLmeStatusAction" instead.
Referencing controllers with OceanExpertBundle:Admin:emailTest is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::emailTestAction" instead.
Referencing controllers with OceanExpertBundle:Crons:dailyApproveCron is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\CronsController::dailyApproveCronAction" instead.
Referencing controllers with OceanExpertBundle:Mails:unsubscribe is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\MailsController::unsubscribeAction" instead.
Referencing controllers with OceanExpertBundle:Admin:index is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::indexAction" instead.
Referencing controllers with OceanExpertBundle:Message:userMessages is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\MessageController::userMessagesAction" instead.
Referencing controllers with OceanExpertBundle:Message:allMessages is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\MessageController::allMessagesAction" instead.
Referencing controllers with OceanExpertBundle:Group:sendGroupEmail is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::sendGroupEmailAction" instead.
Referencing controllers with OceanExpertBundle:Mails:uploadEmailAttachments is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\MailsController::uploadEmailAttachmentsAction" instead.
Referencing controllers with OceanExpertBundle:Document:editDoclist is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::editDoclistAction" instead.
Referencing controllers with OceanExpertBundle:Message:viewMessage is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\MessageController::viewMessageAction" instead.
Referencing controllers with OceanExpertBundle:Mails:emailQueue is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\MailsController::emailQueueAction" instead.
Referencing controllers with OceanExpertBundle:Mails:removeEmailAttachment is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\MailsController::removeEmailAttachmentAction" instead.
Referencing controllers with OceanExpertBundle:Event:addAgendaItemAjax is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::addAgendaItemAjaxAction" instead.
Referencing controllers with OceanExpertBundle:Event:deleteAgendaItemAjax is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::deleteAgendaItemAjaxAction" instead.
Referencing controllers with OceanExpertBundle:Event:updateAgendaItemAjax is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::updateAgendaItemAjaxAction" instead.
Referencing controllers with OceanExpertBundle:Event:updatePresentationAgenda is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::updatePresentationAgendaAction" instead.
Referencing controllers with OceanExpertBundle:Event:saveAgendaOrder is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::saveAgendaOrderAction" instead.
Referencing controllers with OceanExpertBundle:Event:deleteImportParticipant is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::deleteImportParticipantAction" instead.
Referencing controllers with OceanExpertBundle:Event:addEventParticipants is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::addEventParticipantsAction" instead.
Referencing controllers with OceanExpertBundle:Event:checkParticipantsDetail is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::checkParticipantsDetailAction" instead.
Referencing controllers with OceanExpertBundle:Event:importParticipants is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::importParticipantsAction" instead.
Referencing controllers with OceanExpertBundle:Event:editParticipant is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::editParticipantAction" instead.
Referencing controllers with OceanExpertBundle:Admin:approveDocuments is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::approveDocumentsAction" instead.
Referencing controllers with OceanExpertBundle:Admin:disapproveDocuments is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::disapproveDocumentsAction" instead.
Referencing controllers with OceanExpertBundle:Document:deleteDocumentList is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::deleteDocumentListAction" instead.
Referencing controllers with OceanExpertBundle:Document:removeDocumentFromList is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::removeDocumentFromListAction" instead.
Referencing controllers with OceanExpertBundle:Document:addDocumentToDoclist is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::addDocumentToDoclistAction" instead.
Referencing controllers with OceanExpertBundle:Document:deleteDocument is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::deleteDocumentAction" instead.
Referencing controllers with OceanExpertBundle:Document:removeDocumentFile is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::removeDocumentFileAction" instead.
Referencing controllers with OceanExpertBundle:Document:addDocument is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::addDocumentAction" instead.
Referencing controllers with OceanExpertBundle:Event:addEventDocument is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::addEventDocumentAction" instead.
Referencing controllers with OceanExpertBundle:Document:uploadEventDocument is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::uploadEventDocumentAction" instead.
Referencing controllers with OceanExpertBundle:Document:deleteEventDocument is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\DocumentController::deleteEventDocumentAction" instead.
Referencing controllers with OceanExpertBundle:Admin:approveUser is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::approveUserAction" instead.
Referencing controllers with OceanExpertBundle:Admin:disApproveUser is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::disApproveUserAction" instead.
Referencing controllers with OceanExpertBundle:Admin:deleteUser is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::deleteUserAction" instead.
Referencing controllers with OceanExpertBundle:Admin:hardDeleteUser is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::hardDeleteUserAction" instead.
Referencing controllers with OceanExpertBundle:Admin:addExpert is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::addExpertAction" instead.
Referencing controllers with OceanExpertBundle:Admin:experts is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::expertsAction" instead.
Referencing controllers with OceanExpertBundle:Admin:addExpertSuccess is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::addExpertSuccessAction" instead.
Referencing controllers with OceanExpertBundle:Admin:approveInstitutes is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::approveInstitutesAction" instead.
Referencing controllers with OceanExpertBundle:Admin:disapproveInstitutes is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::disapproveInstitutesAction" instead.
Referencing controllers with OceanExpertBundle:Admin:deleteInstitutes is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::deleteInstitutesAction" instead.
Referencing controllers with OceanExpertBundle:Admin:approveProjects is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::approveProjectsAction" instead.
Referencing controllers with OceanExpertBundle:Admin:disapproveProjects is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::disapproveProjectsAction" instead.
Referencing controllers with OceanExpertBundle:Admin:deleteProjects is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::deleteProjectsAction" instead.
Referencing controllers with OceanExpertBundle:Lme:projectSuccess is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\LmeController::projectSuccessAction" instead.
Referencing controllers with OceanExpertBundle:Admin:approveEvents is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::approveEventsAction" instead.
Referencing controllers with OceanExpertBundle:Admin:disapproveEvents is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::disapproveEventsAction" instead.
Referencing controllers with OceanExpertBundle:Admin:deleteEvents is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::deleteEventsAction" instead.
Referencing controllers with OceanExpertBundle:Event:listUserEvents is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::listUserEventsAction" instead.
Referencing controllers with OceanExpertBundle:Event:createEvent is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::createEventAction" instead.
Referencing controllers with OceanExpertBundle:Event:copyEvent is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::copyEventAction" instead.
Referencing controllers with OceanExpertBundle:Event:addEventMember is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::addEventMemberAction" instead.
Referencing controllers with OceanExpertBundle:Event:addBulkEventMember is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::addBulkEventMemberAction" instead.
Referencing controllers with OceanExpertBundle:Event:deleteEventMember is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::deleteEventMemberAction" instead.
Referencing controllers with OceanExpertBundle:Event:editEventMember is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::editEventMemberAction" instead.
Referencing controllers with OceanExpertBundle:Event:editEventContacts is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::editEventContactsAction" instead.
Referencing controllers with OceanExpertBundle:Event:eventClearContact is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::eventClearContactAction" instead.
Referencing controllers with OceanExpertBundle:Event:sendInvitesEventParticipants is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::sendInvitesEventParticipantsAction" instead.
Referencing controllers with OceanExpertBundle:Event:updateEventStatus is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\EventController::updateEventStatusAction" instead.
Referencing controllers with OceanExpertBundle:Group:addGroups is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::addGroupsAction" instead.
Referencing controllers with OceanExpertBundle:Group:editGroup is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::editGroupAction" instead.
Referencing controllers with OceanExpertBundle:Group:saveGroup is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::saveGroupAction" instead.
Referencing controllers with OceanExpertBundle:Group:viewGroup is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::viewGroupAction" instead.
Referencing controllers with OceanExpertBundle:Admin:viewGroup is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::viewGroupAction" instead.
Referencing controllers with OceanExpertBundle:Group:saveGroupOrder is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::saveGroupOrderAction" instead.
Referencing controllers with OceanExpertBundle:Group:saveGroupMemberOrder is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::saveGroupMemberOrderAction" instead.
Referencing controllers with OceanExpertBundle:Group:allGroups is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::allGroupsAction" instead.
Referencing controllers with OceanExpertBundle:Admin:allGroups is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\AdminController::allGroupsAction" instead.
Referencing controllers with OceanExpertBundle:Group:getGroupData is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::getGroupDataAction" instead.
Referencing controllers with OceanExpertBundle:Group:getGroupExpertsAddresses is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::getGroupExpertsAddressesAction" instead.
Referencing controllers with OceanExpertBundle:Group:dataTablesServerProcessing is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::dataTablesServerProcessingAction" instead.
Referencing controllers with OceanExpertBundle:Search:getMembers is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SearchController::getMembersAction" instead.
Referencing controllers with OceanExpertBundle:Group:addGroupMember is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::addGroupMemberAction" instead.
Referencing controllers with OceanExpertBundle:Group:addBulkGroupMember is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::addBulkGroupMemberAction" instead.
Referencing controllers with OceanExpertBundle:Group:getAllGroupJson is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::getAllGroupJsonAction" instead.
Referencing controllers with OceanExpertBundle:Group:deleteGroup is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::deleteGroupAction" instead.
Referencing controllers with OceanExpertBundle:Group:rebuildGroups is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::rebuildGroupsAction" instead.
Referencing controllers with OceanExpertBundle:Group:updateGroupMembers is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::updateGroupMembersAction" instead.
Referencing controllers with OceanExpertBundle:Group:getGroupDataDb is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::getGroupDataDbAction" instead.
Referencing controllers with OceanExpertBundle:Group:setGroupRole is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::setGroupRoleAction" instead.
Referencing controllers with OceanExpertBundle:Group:deleteGroupMember is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::deleteGroupMemberAction" instead.
Referencing controllers with OceanExpertBundle:Group:updateMemberIds is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\GroupController::updateMemberIdsAction" instead.
Referencing controllers with OceanExpertBundle:Api:login is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ApiController::loginAction" instead.
Referencing controllers with OceanExpertBundle:Api:eventParticipant is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ApiController::eventParticipantAction" instead.
Referencing controllers with OceanExpertBundle:Security:login is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SecurityController::loginAction" instead.
Referencing controllers with OceanExpertBundle:Security:check is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SecurityController::checkAction" instead.
Referencing controllers with OceanExpertBundle:Security:logout is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\SecurityController::logoutAction" instead.
Referencing controllers with OceanExpertBundle:Registration:checkEmail is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\RegistrationController::checkEmailAction" instead.
Referencing controllers with OceanExpertBundle:Registration:confirm is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\RegistrationController::confirmAction" instead.
Referencing controllers with OceanExpertBundle:Registration:confirmed is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\RegistrationController::confirmedAction" instead.
Referencing controllers with OceanExpertBundle:Resetting:request is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ResettingController::requestAction" instead.
Referencing controllers with OceanExpertBundle:Resetting:sendEmail is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ResettingController::sendEmailAction" instead.
Referencing controllers with OceanExpertBundle:Resetting:checkEmail is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ResettingController::checkEmailAction" instead.
Referencing controllers with OceanExpertBundle:Resetting:reset is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ResettingController::resetAction" instead.
Referencing controllers with OceanExpertBundle:ChangePassword:changePassword is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ChangePasswordController::changePasswordAction" instead.
Referencing controllers with OceanExpertBundle:Api:index is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\ApiController::indexAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiExpert:viewExpert is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiExpertController::viewExpertAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiExpert:viewExpertEventsParticipation is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiExpertController::viewExpertEventsParticipationAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiEvent:createEvent is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiEventController::createEventAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiEvent:getUpcomingEvents is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiEventController::getUpcomingEventsAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiEvent:getEventCalendar is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiEventController::getEventCalendarAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiEvent:getEventDetails is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiEventController::getEventDetailsAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiEvent:viewEventRecord is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiEventController::viewEventRecordAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiEvent:viewEventAgenda is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiEventController::viewEventAgendaAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiEvent:viewEventDocs is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiEventController::viewEventDocsAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiEvent:eventOverview is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiEventController::eventOverviewAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiEvent:viewEventParticipants is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiEventController::viewEventParticipantsAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiEvent:updateEventParticipants is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiEventController::updateEventParticipantsAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiGroup:viewGroup is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiGroupController::viewGroupAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiGroup:viewGroupslist is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiGroupController::viewGroupslistAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiSearch:advancedSearch is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiSearchController::advancedSearchAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiSearch:getCountryList is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiSearchController::getCountryListAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiReports:countryReports is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiReportsController::countryReportsAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiReports:eventParticipant is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiReportsController::eventParticipantAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiInstitution:viewInstitution is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiInstitutionController::viewInstitutionAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiInstitution:getInstitutes is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiInstitutionController::getInstitutesAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiDocument:viewDocumentRecord is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiDocumentController::viewDocumentRecordAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiDocument:viewDocFilesPopup is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiDocumentController::viewDocFilesPopupAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiDocument:downloadDocument is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiDocumentController::downloadDocumentAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiDocument:viewDoclistRecord is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiDocumentController::viewDoclistRecordAction" instead.
Referencing controllers with OceanExpertBundle:Api/ApiDocument:doclists is deprecated since Symfony 4.1, use "OceanExpertBundle\Controller\Api\ApiDocumentController::doclistsAction" instead.
SELECT i0_.id_ind AS id_ind_0, i0_.title AS title_1, i0_.fname AS fname_2, i0_.mname AS mname_3, i0_.sname AS sname_4, i0_.identifier AS identifier_5, i0_.reg_type AS reg_type_6, i0_.use_inst_addr AS use_inst_addr_7, i0_.private_address AS private_address_8, i0_.addr_1 AS addr_1_9, i0_.addr_2 AS addr_2_10, i0_.city AS city_11, i0_.state AS state_12, i0_.postcode AS postcode_13, i0_.country_code AS country_code_14, i0_.id_nationality AS id_nationality_15, i0_.gender AS gender_16, i0_.tel AS tel_17, i0_.fax AS fax_18, i0_.email1 AS email1_19, i0_.email2 AS email2_20, i0_.email3 AS email3_21, i0_.emailtouse AS emailtouse_22, i0_.url1 AS url1_23, i0_.url1Valid AS url1Valid_24, i0_.url2 AS url2_25, i0_.url2Valid AS url2Valid_26, i0_.url3 AS url3_27, i0_.url3Valid AS url3Valid_28, i0_.urlsChecked AS urlsChecked_29, i0_.linkedin AS linkedin_30, i0_.facebook AS facebook_31, i0_.twitter AS twitter_32, i0_.flickr AS flickr_33, i0_.other AS other_34, i0_.degree AS degree_35, i0_.activeng AS activeng_36, i0_.activother AS activother_37, i0_.jobtitle AS jobtitle_38, i0_.dept AS dept_39, i0_.studyregion AS studyregion_40, i0_.languages AS languages_41, i0_.skills AS skills_42, i0_.comments AS comments_43, i0_.do_not_invite AS do_not_invite_44, i0_.do_no_invite_by AS do_no_invite_by_45, i0_.do_no_invite_on AS do_no_invite_on_46, i0_.admin_comments AS admin_comments_47, i0_.id_imagefile AS id_imagefile_48, i0_.id_imagefile_full AS id_imagefile_full_49, i0_.receive_mail AS receive_mail_50, i0_.member_alert AS member_alert_51, i0_.cit_alert AS cit_alert_52, i0_.f_date_ent AS f_date_ent_53, i0_.l_date_upd AS l_date_upd_54, i0_.created_by AS created_by_55, i0_.last_edit_by AS last_edit_by_56, i0_.quality_checked_by AS quality_checked_by_57, i0_.quality_checked_date AS quality_checked_date_58, i0_.quality_checked AS quality_checked_59, i0_.is_global AS is_global_60, i0_.status AS status_61, i0_.statusLastChanged AS statusLastChanged_62, i0_.deceased AS deceased_63, i0_.deceased_date AS deceased_date_64, i0_.retired AS retired_65, i0_.retired_date AS retired_date_66, i0_.id AS id_67, p1_.name AS name_68, p1_.path AS path_69, i2_.id_inst AS id_inst_70, i2_.inst_name AS inst_name_71, i2_.country_code AS country_code_72, i2_.state AS state_73, i2_.city AS city_74, i2_.postcode AS postcode_75, i2_.inst_address AS inst_address_76, i2_.addr_2 AS addr_2_77 FROM indiv i0_ LEFT JOIN profile_images p1_ ON (p1_.id_ind = i0_.id_ind) LEFT JOIN indiv_institution i3_ ON (i0_.id_ind = i3_.id_ind) LEFT JOIN institutions i2_ ON (i3_.id_inst = i2_.id_inst) WHERE i0_.id_ind = ? AND i0_.status = 1
SELECT j0_.jobname AS jobname_0, j0_.id_job AS id_job_1 FROM indiv_jobtype i1_ LEFT JOIN jobtypes j0_ ON (j0_.id_job = i1_.id_job) WHERE i1_.id_ind = ?
SELECT g0_.groupname AS groupname_0, g0_.id_group AS id_group_1 FROM member_groups m1_ LEFT JOIN groups g0_ ON (m1_.id_group = g0_.id_group) WHERE m1_.id_ind = ? ORDER BY g0_.groupname ASC
SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = ? LIMIT 1
SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = ? LIMIT 1
SELECT c0_.country AS country_0, c0_.country_code AS country_code_1, c0_.longitude AS longitude_2, c0_.latitude AS latitude_3 FROM countries c0_ WHERE c0_.id_country IN (?) OR c0_.country_code IN (?)
SELECT s0_.subname AS subname_0, s0_.id_sub AS id_sub_1 FROM indiv_subjects i1_ LEFT JOIN subjects s0_ ON (s0_.id_sub = i1_.id_sub) WHERE i1_.id_ind = ?
SELECT c0_.country AS country_0, c0_.country_code AS country_code_1, c0_.longitude AS longitude_2, c0_.latitude AS latitude_3 FROM countries c0_ WHERE c0_.id_country IN (?) OR c0_.country_code IN (?)
Changed reference of service "OceanExpertBundle\Controller\AdminController" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "OceanExpertBundle\Controller\ApiController" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "OceanExpertBundle\Controller\ChangePasswordController" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "OceanExpertBundle\Controller\EventController" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "OceanExpertBundle\Controller\ProfileController" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "OceanExpertBundle\Controller\ResettingController" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "OceanExpertBundle\Controller\UserController" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "locale_listener" previously pointing to "router.default" to "router".
Changed reference of service "http_kernel" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "services_resetter" previously pointing to "debug.validator" to "validator".
Changed reference of service "services_resetter" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "fragment.renderer.inline" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "console.command.event_dispatcher_debug" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "console.command.router_debug" previously pointing to "router.default" to "router".
Changed reference of service "console.command.router_match" previously pointing to "router.default" to "router".
Changed reference of service "console.command.translation_debug" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "test.private_services_locator" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "test.private_services_locator" previously pointing to "jms_serializer.serializer" to "jms_serializer".
Changed reference of service "test.private_services_locator" previously pointing to "jms_serializer.serializer" to "jms_serializer".
Changed reference of service "test.private_services_locator" previously pointing to "lexik_jwt_authentication.encoder.lcobucci" to "lexik_jwt_authentication.encoder".
Changed reference of service "test.private_services_locator" previously pointing to "OceanExpertBundle\Command\CheckMandrillForEmailStatusCommand" to "console.command.public_alias.OceanExpertBundle\Command\CheckMandrillForEmailStatusCommand".
Changed reference of service "test.private_services_locator" previously pointing to "OceanExpertBundle\Command\CheckMandrillForWebhooksCommand" to "console.command.public_alias.OceanExpertBundle\Command\CheckMandrillForWebhooksCommand".
Changed reference of service "test.private_services_locator" previously pointing to "OceanExpertBundle\Command\CleanupDatabaseCommand" to "console.command.public_alias.OceanExpertBundle\Command\CleanupDatabaseCommand".
Changed reference of service "test.private_services_locator" previously pointing to "OceanExpertBundle\Command\CleanupEventsCommand" to "console.command.public_alias.OceanExpertBundle\Command\CleanupEventsCommand".
Changed reference of service "test.private_services_locator" previously pointing to "OceanExpertBundle\Command\CleanupFOSUsersCommand" to "console.command.public_alias.OceanExpertBundle\Command\CleanupFOSUsersCommand".
Changed reference of service "test.private_services_locator" previously pointing to "OceanExpertBundle\Command\CreateSitemapsCommand" to "console.command.public_alias.OceanExpertBundle\Command\CreateSitemapsCommand".
Changed reference of service "test.private_services_locator" previously pointing to "OceanExpertBundle\Command\ProcessQueuedMailFilesCommand" to "console.command.public_alias.OceanExpertBundle\Command\ProcessQueuedMailFilesCommand".
Changed reference of service "test.private_services_locator" previously pointing to "OceanExpertBundle\Command\ReportGroupInactiveMembersCommand" to "console.command.public_alias.OceanExpertBundle\Command\ReportGroupInactiveMembersCommand".
Changed reference of service "test.private_services_locator" previously pointing to "OceanExpertBundle\Command\ReportRejectedMailsCommand" to "console.command.public_alias.OceanExpertBundle\Command\ReportRejectedMailsCommand".
Changed reference of service "test.private_services_locator" previously pointing to "OceanExpertBundle\Command\SendEmailsToMandrillCommand" to "console.command.public_alias.OceanExpertBundle\Command\SendEmailsToMandrillCommand".
Changed reference of service "test.private_services_locator" previously pointing to "swiftmailer.mailer.transport.accord_mandrill" to "swiftmailer.mailer.default.transport".
Changed reference of service "test.private_services_locator" previously pointing to "templating.engine.twig" to "templating".
Changed reference of service "test.private_services_locator" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "test.private_services_locator" previously pointing to "router.default" to "router".
Changed reference of service "test.private_services_locator" previously pointing to "router.default" to "router".
Changed reference of service "test.private_services_locator" previously pointing to "router.default" to "router".
Changed reference of service "test.private_services_locator" previously pointing to "router.default" to "router".
Changed reference of service "test.private_services_locator" previously pointing to "security.user_password_encoder.generic" to "security.password_encoder".
Changed reference of service "test.private_services_locator" previously pointing to "templating.engine.twig" to "templating".
Changed reference of service "test.private_services_locator" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "test.private_services_locator" previously pointing to "debug.validator" to "validator".
Changed reference of service "test.private_services_locator" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "test.private_services_locator" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "test.private_services_locator" previously pointing to "swiftmailer.mailer.transport.accord_mandrill" to "swiftmailer.mailer.default.transport".
Changed reference of service "test.private_services_locator" previously pointing to "cache.default_clearer" to "cache.app_clearer".
Changed reference of service "test.private_services_locator" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "test.private_services_locator" previously pointing to "debug.validator" to "validator".
Changed reference of service "test.private_services_locator" previously pointing to "doctrine_cache.contains_command" to "console.command.public_alias.doctrine_cache.contains_command".
Changed reference of service "test.private_services_locator" previously pointing to "doctrine_cache.delete_command" to "console.command.public_alias.doctrine_cache.delete_command".
Changed reference of service "test.private_services_locator" previously pointing to "doctrine_cache.flush_command" to "console.command.public_alias.doctrine_cache.flush_command".
Changed reference of service "test.private_services_locator" previously pointing to "doctrine_cache.stats_command" to "console.command.public_alias.doctrine_cache.stats_command".
Changed reference of service "test.private_services_locator" previously pointing to "router.default" to "router".
Changed reference of service "test.private_services_locator" previously pointing to "router.default" to "router".
Changed reference of service "test.private_services_locator" previously pointing to "fos_rest.serializer.form_error_handler" to "jms_serializer.form_error_handler".
Changed reference of service "test.private_services_locator" previously pointing to "templating.engine.twig" to "templating".
Changed reference of service "test.private_services_locator" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "test.private_services_locator" previously pointing to "jms_serializer.configured_deserialization_context_factory" to "jms_serializer.deserialization_context_factory".
Changed reference of service "test.private_services_locator" previously pointing to "jms_serializer.configured_serialization_context_factory" to "jms_serializer.serialization_context_factory".
Changed reference of service "test.private_services_locator" previously pointing to "jms_serializer.doctrine_object_constructor" to "jms_serializer.object_constructor".
Changed reference of service "test.private_services_locator" previously pointing to "jms_serializer.handler_registry" to "fos_rest.serializer.jms_handler_registry".
Changed reference of service "test.private_services_locator" previously pointing to "jms_serializer.metadata.doctrine_type_driver" to "jms_serializer.metadata_driver".
Changed reference of service "test.private_services_locator" previously pointing to "jms_serializer.serializer" to "jms_serializer".
Changed reference of service "test.private_services_locator" previously pointing to "lexik_jwt_authentication.encoder.lcobucci" to "lexik_jwt_authentication.encoder".
Changed reference of service "test.private_services_locator" previously pointing to "lexik_jwt_authentication.key_loader.raw" to "lexik_jwt_authentication.key_loader".
Changed reference of service "test.private_services_locator" previously pointing to "router.default" to "router".
Changed reference of service "test.private_services_locator" previously pointing to "security.user_password_encoder.generic" to "security.password_encoder".
Changed reference of service "test.private_services_locator" previously pointing to "swiftmailer.mailer.transport.accord_mandrill" to "swiftmailer.mailer.default.transport".
Changed reference of service "test.private_services_locator" previously pointing to "templating.engine.twig" to "templating".
Changed reference of service "test.private_services_locator" previously pointing to "templating.loader.filesystem" to "templating.loader".
Changed reference of service "test.private_services_locator" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "test.private_services_locator" previously pointing to "debug.validator" to "validator".
Changed reference of service "form.type_guesser.validator" previously pointing to "debug.validator" to "validator".
Changed reference of service "form.type.choice" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type.file" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type_extension.form.transformation_failure_handling" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type_extension.form.validator" previously pointing to "debug.validator" to "validator".
Changed reference of service "form.type_extension.upload.validator" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "form.type_extension.csrf" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "validator.builder" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "data_collector.events" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "data_collector.validator" previously pointing to "debug.validator" to "validator".
Changed reference of service "data_collector.translation" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "router_listener" previously pointing to "router.default" to "router".
Changed reference of service "Symfony\Bundle\FrameworkBundle\Controller\RedirectController" previously pointing to "router.default" to "router".
Changed reference of service "Symfony\Bundle\FrameworkBundle\Controller\TemplateController" previously pointing to "templating.engine.twig" to "templating".
Changed reference of service "security.authentication.manager" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.logout_url_generator" previously pointing to "router.default" to "router".
Changed reference of service "security.http_utils" previously pointing to "router.default" to "router".
Changed reference of service "security.http_utils" previously pointing to "router.default" to "router".
Changed reference of service "security.context_listener" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.abstract" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.form" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.simple_form" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.simple_preauth" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.x509" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.json" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.remote_user" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.switchuser_listener" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.rememberme" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.guard_handler" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.provider.guard" previously pointing to "security.user_password_encoder.generic" to "security.password_encoder".
Changed reference of service "debug.security.firewall" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.form.api_login" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.provider.guard.api" previously pointing to "security.user_password_encoder.generic" to "security.password_encoder".
Changed reference of service "security.context_listener.0" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.listener.form.main" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "security.authentication.switchuser_listener.main" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "twig.extension.trans" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "twig.extension.routing" previously pointing to "router.default" to "router".
Changed reference of service "swiftmailer.mailer.abstract" previously pointing to "swiftmailer.mailer.transport.accord_mandrill" to "swiftmailer.mailer.default.transport".
Changed reference of service "swiftmailer.mailer.default" previously pointing to "swiftmailer.mailer.transport.accord_mandrill" to "swiftmailer.mailer.default.transport".
Changed reference of service "fos_rest.view_handler.default" previously pointing to "router.default" to "router".
Changed reference of service "fos_rest.view_handler.default" previously pointing to "templating.engine.twig" to "templating".
Changed reference of service "fos_rest.request.param_fetcher" previously pointing to "debug.validator" to "validator".
Changed reference of service "fos_rest.serializer.jms" previously pointing to "jms_serializer.serializer" to "jms_serializer".
Changed reference of service "fos_rest.serializer.jms" previously pointing to "jms_serializer.configured_serialization_context_factory" to "jms_serializer.serialization_context_factory".
Changed reference of service "fos_rest.serializer.jms" previously pointing to "jms_serializer.configured_deserialization_context_factory" to "jms_serializer.deserialization_context_factory".
Changed reference of service "fos_rest.view_handler" previously pointing to "router.default" to "router".
Changed reference of service "fos_rest.view_handler" previously pointing to "templating.engine.twig" to "templating".
Changed reference of service "jms_serializer.twig_extension.serializer_runtime_helper" previously pointing to "jms_serializer.serializer" to "jms_serializer".
Changed reference of service "jms_serializer.templating.helper.serializer" previously pointing to "jms_serializer.serializer" to "jms_serializer".
Changed reference of service "fos_user.security.interactive_login_listener" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "fos_user.user_provider.username" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "fos_user.user_provider.username_email" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "fos_user.user_provider.email" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "fos_user.util.user_manipulator" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "fos_user.util.user_manipulator" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "fos_user.mailer.default" previously pointing to "router.default" to "router".
Changed reference of service "fos_user.mailer.default" previously pointing to "templating.engine.twig" to "templating".
Changed reference of service "fos_user.mailer.twig_swift" previously pointing to "router.default" to "router".
Changed reference of service "fos_user.listener.flash" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "fos_user.user_to_username_transformer" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "fos_user.profile.controller" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "fos_user.profile.controller" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "fos_user.registration.controller" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "fos_user.registration.controller" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "fos_user.listener.email_confirmation" previously pointing to "router.default" to "router".
Changed reference of service "fos_user.change_password.controller" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "fos_user.change_password.controller" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "fos_user.listener.resetting" previously pointing to "router.default" to "router".
Changed reference of service "fos_user.resetting.controller" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "fos_user.resetting.controller" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "knp_paginator" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "knp_paginator.helper.processor" previously pointing to "router.default" to "router".
Changed reference of service "knp_paginator.helper.processor" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "nelmio_cors.cors_listener" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "web_profiler.controller.profiler" previously pointing to "router.default" to "router".
Changed reference of service "web_profiler.controller.router" previously pointing to "router.default" to "router".
Changed reference of service "debug.file_link_formatter.url_format" previously pointing to "router.default" to "router".
Changed reference of service "web_profiler.debug_toolbar" previously pointing to "router.default" to "router".
Changed reference of service "fos_js_routing.extractor" previously pointing to "router.default" to "router".
Changed reference of service "fos_js_routing.router_debug_exposed_command" previously pointing to "router.default" to "router".
Changed reference of service "lexik_jwt_authentication.security.authentication.provider" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "lexik_jwt_authentication.security.authentication.listener" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "lexik_jwt_authentication.jws_provider.default" previously pointing to "lexik_jwt_authentication.key_loader.raw" to "lexik_jwt_authentication.key_loader".
Changed reference of service "lexik_jwt_authentication.jwt_manager" previously pointing to "lexik_jwt_authentication.encoder.lcobucci" to "lexik_jwt_authentication.encoder".
Changed reference of service "lexik_jwt_authentication.jwt_manager" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "lexik_jwt_authentication.jws_provider.lcobucci" previously pointing to "lexik_jwt_authentication.key_loader.raw" to "lexik_jwt_authentication.key_loader".
Changed reference of service "lexik_jwt_authentication.handler.authentication_success" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "lexik_jwt_authentication.handler.authentication_failure" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "lexik_jwt_authentication.handler.authentication_failure" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "lexik_jwt_authentication.security.jwt_authenticator" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "lexik_jwt_authentication.security.jwt_authenticator" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "lexik_jwt_authentication.security.guard.jwt_token_authenticator" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "lexik_jwt_authentication.security.guard.jwt_token_authenticator" previously pointing to "translator.data_collector" to "translator".
Changed reference of service "lexik_jwt_authentication.check_config_command" previously pointing to "lexik_jwt_authentication.key_loader.raw" to "lexik_jwt_authentication.key_loader".
Changed reference of service ".service_locator.sDHplmp" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service ".service_locator.xI4tcWT" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service ".service_locator.JPEOy76" previously pointing to "fos_user.user_manager.default" to "fos_user.user_manager".
Changed reference of service "debug.security.voter.security.access.authenticated_voter" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "debug.security.voter.security.access.role_hierarchy_voter" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service "debug.security.voter.security.access.expression_voter" previously pointing to "debug.event_dispatcher" to "event_dispatcher".
Changed reference of service ".service_locator.XSes1R5" previously pointing to "translator.data_collector" to "translator".
Changed reference of service ".service_locator.m90YCjy" previously pointing to "router.default" to "router".
Changed reference of service "fos_rest.serializer.form_error_handler.inner" previously pointing to "translator.data_collector" to "translator".
Changed reference of service ".service_locator.iVGSRie" previously pointing to "fos_rest.serializer.form_error_handler" to "jms_serializer.form_error_handler".
Changed reference of service "jms_serializer" previously pointing to "jms_serializer.handler_registry" to "fos_rest.serializer.jms_handler_registry".
Changed reference of service "jms_serializer" previously pointing to "jms_serializer.configured_serialization_context_factory" to "jms_serializer.serialization_context_factory".
Changed reference of service "jms_serializer" previously pointing to "jms_serializer.configured_deserialization_context_factory" to "jms_serializer.deserialization_context_factory".
Changed reference of service "console.command.public_alias.OceanExpertBundle\Command\CheckMandrillForEmailStatusCommand" previously pointing to "router.default" to "router".
Changed reference of service "console.command.public_alias.OceanExpertBundle\Command\CheckMandrillForWebhooksCommand" previously pointing to "router.default" to "router".
Changed reference of service "console.command.public_alias.OceanExpertBundle\Command\CleanupDatabaseCommand" previously pointing to "router.default" to "router".
Changed reference of service "console.command.public_alias.OceanExpertBundle\Command\CleanupFOSUsersCommand" previously pointing to "router.default" to "router".
Changed reference of service "console.command.public_alias.OceanExpertBundle\Command\CreateSitemapsCommand" previously pointing to "router.default" to "router".
Changed reference of service "console.command.public_alias.OceanExpertBundle\Command\ProcessQueuedMailFilesCommand" previously pointing to "router.default" to "router".
Changed reference of service "console.command.public_alias.OceanExpertBundle\Command\ReportGroupInactiveMembersCommand" previously pointing to "router.default" to "router".
Changed reference of service "console.command.public_alias.OceanExpertBundle\Command\ReportRejectedMailsCommand" previously pointing to "router.default" to "router".
Changed reference of service "console.command.public_alias.OceanExpertBundle\Command\SendEmailsToMandrillCommand" previously pointing to "router.default" to "router".