묻고답하기
cafe24 XE3 STEP 3 단계에서 에러가 발생합니다.
2019.10.10 12:14
(2/2) QueryException |
|---|
| in Connection.php line 664 |
| at Connection->runQueryCallback('create table `xe_category` (`id` int unsigned not null auto_increment primary key comment \'ID\', `name` varchar(100) not null comment \'category name\', `count` int not null default \'0\' comment \'The count of category item\') default character set utf8 collate utf8_unicode_ci engine = InnoDB', array(), object(Closure))in Connection.php line 624 |
| at Connection->run('create table `xe_category` (`id` int unsigned not null auto_increment primary key comment \'ID\', `name` varchar(100) not null comment \'category name\', `count` int not null default \'0\' comment \'The count of category item\') default character set utf8 collate utf8_unicode_ci engine = InnoDB', array(), object(Closure))in Connection.php line 459 |
| at Connection->statement('create table `xe_category` (`id` int unsigned not null auto_increment primary key comment \'ID\', `name` varchar(100) not null comment \'category name\', `count` int not null default \'0\' comment \'The count of category item\') default character set utf8 collate utf8_unicode_ci engine = InnoDB')in Blueprint.php line 86 |
| at Blueprint->build(object(MySqlConnection), object(MySqlGrammar))in Builder.php line 252 |
| at Builder->build(object(Blueprint))in Builder.php line 165 |
| at Builder->create('category', object(Closure))in Facade.php line 221 |
| at Facade::__callStatic('create', array('category', object(Closure)))in CategoryMigration.php line 47 |
| at CategoryMigration->install()in XeInstall.php line 812 |
| at XeInstall->migrateCore()in XeInstall.php line 726 |
| at XeInstall->installFramework()in XeInstall.php line 229 |
| at XeInstall->process()in XeInstall.php line 159 |
| at XeInstall->handle() |
| at call_user_func_array(array(object(XeInstall), 'handle'), array())in BoundMethod.php line 29 |
| at BoundMethod::Illuminate\Container\{closure}()in BoundMethod.php line 87 |
| at BoundMethod::callBoundMethod(object(Application), array(object(XeInstall), 'handle'), object(Closure))in BoundMethod.php line 31 |
| at BoundMethod::call(object(Application), array(object(XeInstall), 'handle'), array(), null)in Container.php line 549 |
| at Container->call(array(object(XeInstall), 'handle'))in Command.php line 183 |
| at Command->execute(object(ArrayInput), object(OutputStyle))in Command.php line 255 |
| at Command->run(object(ArrayInput), object(OutputStyle))in Command.php line 170 |
| at Command->run(object(ArrayInput), object(BufferedOutput))in Application.php line 963 |
| at Application->doRunCommand(object(XeInstall), object(ArrayInput), object(BufferedOutput))in Application.php line 254 |
| at Application->doRun(object(ArrayInput), object(BufferedOutput))in Application.php line 147 |
| at Application->run(object(ArrayInput), object(BufferedOutput))in Application.php line 88 |
| at Application->run(object(ArrayInput), object(BufferedOutput))in Application.php line 177 |
| at Application->call('xe:install', object(Collection), null)in Kernel.php line 249 |
| at Kernel->call('xe:install', array('--config' => '/ff02170/www/storage/app/installConfig', '--no-interaction' => true))in Facade.php line 221 |
| at Facade::__callStatic('call', array('xe:install', array('--config' => '/ff02170/www/storage/app/installConfig', '--no-interaction' => true)))in InstallController.php line 181 |
| at InstallController->install(object(Request), object(CookieJar)) |
| at call_user_func_array(array(object(InstallController), 'install'), array(object(Request), object(CookieJar)))in Controller.php line 54 |
| at Controller->callAction('install', array(object(Request), object(CookieJar)))in ControllerDispatcher.php line 45 |
| at ControllerDispatcher->dispatch(object(Route), object(InstallController), 'install')in Route.php line 212 |
| at Route->runController()in Route.php line 169 |
| at Route->run()in Router.php line 658 |
| at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 30 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php line 68 |
| at VerifyCsrfToken->handle(object(Request), object(Closure))in ExceptAppendableVerifyCsrfToken.php line 49 |
| at ExceptAppendableVerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php line 41 |
| at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php line 49 |
| at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php line 63 |
| at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37 |
| at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php line 66 |
| at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102 |
| at Pipeline->then(object(Closure))in Router.php line 660 |
| at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 635 |
| at Router->runRoute(object(Request), object(Route))in Router.php line 601 |
| at Router->dispatchToRoute(object(Request))in Router.php line 590 |
| at Router->dispatch(object(Request))in Kernel.php line 176 |
| at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in TrustProxies.php line 56 |
| at TrustProxies->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30 |
| at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30 |
| at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27 |
| at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 46 |
| at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102 |
| at Pipeline->then(object(Closure))in Kernel.php line 151 |
| at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116 |
| at Kernel->handle(object(Request))in index.php line 57 |
(1/2) PDOException |
|---|
| in Connection.php line 458 |
| at PDOStatement->execute()in Connection.php line 458 |
| at Connection->Illuminate\Database\{closure}('create table `xe_category` (`id` int unsigned not null auto_increment primary key comment \'ID\', `name` varchar(100) not null comment \'category name\', `count` int not null default \'0\' comment \'The count of category item\') default character set utf8 collate utf8_unicode_ci engine = InnoDB', array())in Connection.php line 657 |
| at Connection->runQueryCallback('create table `xe_category` (`id` int unsigned not null auto_increment primary key comment \'ID\', `name` varchar(100) not null comment \'category name\', `count` int not null default \'0\' comment \'The count of category item\') default character set utf8 collate utf8_unicode_ci engine = InnoDB', array(), object(Closure))in Connection.php line 624 |
| at Connection->run('create table `xe_category` (`id` int unsigned not null auto_increment primary key comment \'ID\', `name` varchar(100) not null comment \'category name\', `count` int not null default \'0\' comment \'The count of category item\') default character set utf8 collate utf8_unicode_ci engine = InnoDB', array(), object(Closure))in Connection.php line 459 |
| at Connection->statement('create table `xe_category` (`id` int unsigned not null auto_increment primary key comment \'ID\', `name` varchar(100) not null comment \'category name\', `count` int not null default \'0\' comment \'The count of category item\') default character set utf8 collate utf8_unicode_ci engine = InnoDB')in Blueprint.php line 86 |
| at Blueprint->build(object(MySqlConnection), object(MySqlGrammar))in Builder.php line 252 |
| at Builder->build(object(Blueprint))in Builder.php line 165 |
| at Builder->create('category', object(Closure))in Facade.php line 221 |
| at Facade::__callStatic('create', array('category', object(Closure)))in CategoryMigration.php line 47 |
| at CategoryMigration->install()in XeInstall.php line 812 |
| at XeInstall->migrateCore()in XeInstall.php line 726 |
| at XeInstall->installFramework()in XeInstall.php line 229 |
| at XeInstall->process()in XeInstall.php line 159 |
| at XeInstall->handle() |
| at call_user_func_array(array(object(XeInstall), 'handle'), array())in BoundMethod.php line 29 |
| at BoundMethod::Illuminate\Container\{closure}()in BoundMethod.php line 87 |
| at BoundMethod::callBoundMethod(object(Application), array(object(XeInstall), 'handle'), object(Closure))in BoundMethod.php line 31 |
| at BoundMethod::call(object(Application), array(object(XeInstall), 'handle'), array(), null)in Container.php line 549 |
| at Container->call(array(object(XeInstall), 'handle'))in Command.php line 183 |
| at Command->execute(object(ArrayInput), object(OutputStyle))in Command.php line 255 |
| at Command->run(object(ArrayInput), object(OutputStyle))in Command.php line 170 |
| at Command->run(object(ArrayInput), object(BufferedOutput))in Application.php line 963 |
| at Application->doRunCommand(object(XeInstall), object(ArrayInput), object(BufferedOutput))in Application.php line 254 |
| at Application->doRun(object(ArrayInput), object(BufferedOutput))in Application.php line 147 |
| at Application->run(object(ArrayInput), object(BufferedOutput))in Application.php line 88 |
| at Application->run(object(ArrayInput), object(BufferedOutput))in Application.php line 177 |
| at Application->call('xe:install', object(Collection), null)in Kernel.php line 249 |
| at Kernel->call('xe:install', array('--config' => '/ff02170/www/storage/app/installConfig', '--no-interaction' => true))in Facade.php line 221 |
| at Facade::__callStatic('call', array('xe:install', array('--config' => '/ff02170/www/storage/app/installConfig', '--no-interaction' => true)))in InstallController.php line 181 |
| at InstallController->install(object(Request), object(CookieJar)) |
| at call_user_func_array(array(object(InstallController), 'install'), array(object(Request), object(CookieJar)))in Controller.php line 54 |
| at Controller->callAction('install', array(object(Request), object(CookieJar)))in ControllerDispatcher.php line 45 |
| at ControllerDispatcher->dispatch(object(Route), object(InstallController), 'install')in Route.php line 212 |
| at Route->runController()in Route.php line 169 |
| at Route->run()in Router.php line 658 |
| at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 30 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php line 68 |
| at VerifyCsrfToken->handle(object(Request), object(Closure))in ExceptAppendableVerifyCsrfToken.php line 49 |
| at ExceptAppendableVerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php line 41 |
| at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php line 49 |
| at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php line 63 |
| at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37 |
| at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php line 66 |
| at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102 |
| at Pipeline->then(object(Closure))in Router.php line 660 |
| at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 635 |
| at Router->runRoute(object(Request), object(Route))in Router.php line 601 |
| at Router->dispatchToRoute(object(Request))in Router.php line 590 |
| at Router->dispatch(object(Request))in Kernel.php line 176 |
| at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in TrustProxies.php line 56 |
| at TrustProxies->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30 |
| at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30 |
| at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27 |
| at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 46 |
| at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 149 |
| at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53 |
| at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102 |
| at Pipeline->then(object(Closure))in Kernel.php line 151 |
| at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116 |
| at Kernel->handle(object(Request))in index.php line 57 |
살려주십쇼... 운영 환경은 다음과 같습니다. 10G 광아우토반 FullSSD 절약형 UTF-8 (PHP7.3, mariadb-10.0.x) |
태그 연관 글
- [2023/08/23] 묻고답하기 쇼핑몰 기능
- [2020/12/16] 묻고답하기 footer 하단에 고정하려면 어딜 수정해야 할까요?
- [2020/01/31] 묻고답하기 2단메뉴 *2
- [2019/03/27] 묻고답하기 모바일에서만 '권한이 없습니다'가 나오는 이유가 궁금합니다. *1
- [2019/03/15] 포럼 웹 에이전시 디스케이션에서 레이아웃 템플릿 판매 개시했습니다. *2
댓글 3
-
이미 한번 설치하다가 에러난 환경에서 다시 한번 설치하시려는 것 같습니다.
해당 문제는 DB를 모두 지웠다가 또는 XE3 Prefix를 사용하는 데이터베이스를 삭제한 후 다시 설치하시면 될 것 같습니다. -
저도 저기서 안넘어가서 다시업로드 하고 디비도 삭제해보고 있습니다..
될려나 ㅠㅠ 일단 디비삭제는 안먹히네요
XE3 면 https://www.xpressengine.io/qna 에 글을 남겨보세요