Building database fridhems_fridhem5 using SilverStripe\ORM\Connect\MySQL 11.4.13-MariaDB-cll-lve

Creating database tables

• Answers (0 records)
• BackOfficeMapper (237 records)
• LunchWeek (520 records)
• LunchItem (7502 records)
• Field LunchItem.IsVeg: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field LunchItem.IsDinner: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Question (0 records)
• SchoolSoftCourse (38 records)
• Field SchoolSoftCourse.IsGenereal: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field SchoolSoftCourse.IsOpen: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• SlideCard (44 records)
• Field SlideCard.PromoteOnStartPage: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field SlideCard.isQuote: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field SlideCard.CropByHeight: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• CCBS_Building (6 records)
• Field CCBS_Building.BoardingIsOnSite: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• CCBS_Course (216 records)
• Field CCBS_Course.Vat: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• CCBS_CourseApplicationLetter (37357 records)
• CCBS_CourseApplication (14357 records)
• Field CCBS_CourseApplication.Accepted: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.Queued: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.Paid: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.BathEnsuite: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.ToiletEnsuite: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.IsMember: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.InfoSent: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.SpecialDiet: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.FoodVegan: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.FoodNoGluten: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.FoodNoMilkProtein: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.FoodNoSoy: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.FoodNoEgg: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.FoodNoNuts: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.PaperInfo: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.Agree: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.Dorm: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseApplication.CompleteImportData: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• CCBS_CourseCategory (11 records)
• CCBS_CourseInstance (550 records)
• Field CCBS_CourseInstance.IsCulture: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseInstance.IsGeneral: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseInstance.IsActive: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseInstance.ShowTeacherInfoInWelcomeLetter: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• CCBS_CourseType (4 records)
• Field CCBS_CourseType.HasBoarding: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_CourseType.BoardingIsOpen: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• CCBS_EducationOption (7 records)
• Field CCBS_EducationOption.IsActive: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• CCBS_FaultReport (66 records)
• Field CCBS_FaultReport.RoomManuallySelected: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_FaultReport.WantsToBeHome: changed to tinyint(1) unsigned not null default '1' (from tinyint(3) unsigned not null default '1')
• CCBS_Invoice (0 records)
• CCBS_Payment (0 records)
• CCBS_BoardingPreference (4 records)
• Field CCBS_BoardingPreference.SingleRoom: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_BoardingPreference.DoubleRoom: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_BoardingPreference.Dorm: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_BoardingPreference.PrivateBathroom: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_BoardingPreference.PrivateShower: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_BoardingPreference.OnSchoolPremises: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• CCBS_Room (167 records)
• Field CCBS_Room.BoardingHasPrivateBathroom: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_Room.BoardingHasPrivateShower: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_Room.Disability_friendly: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_Room.Wifi: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_Room.PetsAllowed: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_Room.LaundryRoom: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_Room.OnePersonBookable: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field CCBS_Room.Active: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• CCBS_RoomPrice (18 records)
• CCBS_RoomQueue (7994 records)
• Field CCBS_RoomQueue.Booked: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• CCBS_Test (0 records)
• CCBS_TimePeriod (46 records)
• ApplicationToSociety (214 records)
• WhistleBlowerSubmisson (0 records)
• MenuItem (19 records)
• Field MenuItem.IsNewWindow: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• MenuSet (2 records)
• File (2009 records)
• Field File.IsTemporary: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field File.ShowInSearch: changed to tinyint(1) unsigned not null default '1' (from tinyint(3) unsigned not null default '1')
• Field File_Live.IsTemporary: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field File_Live.ShowInSearch: changed to tinyint(1) unsigned not null default '1' (from tinyint(3) unsigned not null default '1')
• Field File_Versions.WasPublished: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field File_Versions.WasDeleted: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field File_Versions.WasDraft: changed to tinyint(1) unsigned not null default '1' (from tinyint(3) unsigned not null default '1')
• Field File_Versions.IsTemporary: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field File_Versions.ShowInSearch: changed to tinyint(1) unsigned not null default '1' (from tinyint(3) unsigned not null default '1')
• SiteConfig (3 records)
• Field SiteConfig.RoomBookingIsInactive: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field SiteConfig.SummerCoursesAdminCanAlwaysBook: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field SiteConfig.SummerCoursesActiveButUnbookable: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field SiteConfig.SummerCoursesAreInactive: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Field SiteConfig.SummerCoursesAreInvisible: changed to tinyint(1) unsigned not null default '0' (from tinyint(3) unsigned not null default '0')
• Table SiteConfig_ViewerGroups: renamed from siteconfig_viewergroups

[Emergency] Uncaught SilverStripe\ORM\Connect\DatabaseException: Couldn't run query: ALTER TABLE "__TEMP__SiteConfig_ViewerGroups" RENAME "SiteConfig_ViewerGroups" Table 'SiteConfig_ViewerGroups' already exists

GET /dev/build

Line 63 in /home/fridhems/fridhem5/vendor/silverstripe/framework/src/ORM/Connect/DBConnector.php

Source

54         if (!empty($sql)) {
55             $formatter = SQLFormatter::create();
56             $formattedSQL = $formatter->formatPlain($sql);
57             $msg = "Couldn't run query:\n\n{$formattedSQL}\n\n{$msg}";
58         }
59 
60         if ($errorLevel === E_USER_ERROR) {
61             // Treating errors as exceptions better allows for responding to errors
62             // in code, such as credential checking during installation
63             throw new DatabaseException($msg, 0, null, $sql, $parameters);
64         } else {
65             user_error($msg ?? '', $errorLevel ?? 0);
66         }
67     }
68 
69     protected function duplicateEntryError(

Trace

• SilverStripe\ORM\Connect\DBConnector->databaseError
  MySQLiConnector.php:425
• SilverStripe\ORM\Connect\MySQLiConnector->throwRelevantError
  MySQLiConnector.php:212
• SilverStripe\ORM\Connect\MySQLiConnector->query
  Database.php:159
• SilverStripe\ORM\Connect\Database->SilverStripe\ORM\Connect\{closure}
  Database.php:258
• SilverStripe\ORM\Connect\Database->benchmarkQuery
  Database.php:156
• SilverStripe\ORM\Connect\Database->query
  MySQLDatabase.php:415
• SilverStripe\ORM\Connect\MySQLDatabase->query
  DBSchemaManager.php:133
• SilverStripe\ORM\Connect\DBSchemaManager->query
  MySQLSchemaManager.php:133
• SilverStripe\ORM\Connect\MySQLSchemaManager->renameTable
  DBSchemaManager.php:911
• SilverStripe\ORM\Connect\DBSchemaManager->fixTableCase
  DBSchemaManager.php:375
• SilverStripe\ORM\Connect\DBSchemaManager->requireTable
  DB.php:572
• SilverStripe\ORM\DB::require_table
  DataObject.php:3809
• SilverStripe\ORM\DataObject->requireTable
  TableBuilder.php:55
• SilverStripe\ORM\Connect\TableBuilder->SilverStripe\ORM\Connect\{closure}
  DBSchemaManager.php:172
• SilverStripe\ORM\Connect\DBSchemaManager->schemaUpdate
  TableBuilder.php:17
• SilverStripe\ORM\Connect\TableBuilder->buildTables
  DatabaseAdmin.php:322
• SilverStripe\ORM\DatabaseAdmin->doBuild
  DatabaseAdmin.php:157
• SilverStripe\ORM\DatabaseAdmin->build
  DatabaseAdmin.php:129
• SilverStripe\ORM\DatabaseAdmin->index
  RequestHandler.php:321
• SilverStripe\Control\RequestHandler->handleAction
  Controller.php:274
• SilverStripe\Control\Controller->handleAction
  RequestHandler.php:200
• SilverStripe\Control\RequestHandler->handleRequest
  Controller.php:200
• SilverStripe\Control\Controller->handleRequest
  DevBuildController.php:67
• SilverStripe\Dev\DevBuildController->build
  RequestHandler.php:321
• SilverStripe\Control\RequestHandler->handleAction
  Controller.php:274
• SilverStripe\Control\Controller->handleAction
  RequestHandler.php:200
• SilverStripe\Control\RequestHandler->handleRequest
  Controller.php:200
• SilverStripe\Control\Controller->handleRequest
  RequestHandler.php:224
• SilverStripe\Control\RequestHandler->handleRequest
  Controller.php:200
• SilverStripe\Control\Controller->handleRequest
  Director.php:349
• SilverStripe\Control\Director->SilverStripe\Control\{closure}
  VersionedHTTPMiddleware.php:41
• SilverStripe\Versioned\VersionedHTTPMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  LoginSessionMiddleware.php:30
• SilverStripe\SessionManager\Middleware\LoginSessionMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  ExecMetricMiddleware.php:20
• SilverStripe\Control\Middleware\ExecMetricMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  ConfirmationMiddleware.php:254
• SilverStripe\Control\Middleware\ConfirmationMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  ConfirmationMiddleware.php:254
• SilverStripe\Control\Middleware\ConfirmationMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  PasswordExpirationMiddleware.php:84
• SilverStripe\Security\PasswordExpirationMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  BasicAuthMiddleware.php:68
• SilverStripe\Security\BasicAuthMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  AuthenticationMiddleware.php:61
• SilverStripe\Security\AuthenticationMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  CanonicalURLMiddleware.php:245
• SilverStripe\Control\Middleware\CanonicalURLMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  HTTPCacheControlMiddleware.php:39
• SilverStripe\Control\Middleware\HTTPCacheControlMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  ChangeDetectionMiddleware.php:28
• SilverStripe\Control\Middleware\ChangeDetectionMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  FlushMiddleware.php:36
• SilverStripe\Control\Middleware\FlushMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  SessionMiddleware.php:20
• SilverStripe\Control\Middleware\SessionMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  AllowedHostsMiddleware.php:71
• SilverStripe\Control\Middleware\AllowedHostsMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  TrustedProxyMiddleware.php:176
• SilverStripe\Control\Middleware\TrustedProxyMiddleware->process
  HTTPMiddlewareAware.php:62
• SilverStripe\Control\Director->SilverStripe\Control\Middleware\{closure}
  HTTPMiddlewareAware.php:65
• SilverStripe\Control\Director->callMiddleware
  Director.php:358
• SilverStripe\Control\Director->handleRequest
  HTTPApplication.php:115
• SilverStripe\Control\HTTPApplication::SilverStripe\Control\{closure}
  
• call_user_func
  HTTPApplication.php:138
• SilverStripe\Control\HTTPApplication->SilverStripe\Control\{closure}
  HTTPMiddlewareAware.php:65
• SilverStripe\Control\HTTPApplication->callMiddleware
  HTTPApplication.php:131
• SilverStripe\Control\HTTPApplication->execute
  HTTPApplication.php:114
• SilverStripe\Control\HTTPApplication->handle
  index.php:24