search

friends-of-forkcms / fork-cms-module-banners

Banners module for Fork CMS 5
https://www.fork-cms.com
MIT License
1 stars 3 forks source link

I installed the module and cannot edit it afterwards. #4

Open huseyinates opened 4 years ago

huseyinates commented 4 years ago

Hi, Module setup successful I added a banner and page failed. I can't log back into the module

Thanks

Error message; SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY sequence asc' at line 6

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY sequence asc' at line 6

at vendor/spoon/library/spoon/database/database.php:662 at PDOStatement->execute() (vendor/spoon/library/spoon/database/database.php:662) at SpoonDatabase->getRecords('SELECT b.id, b.sequence, bt.title FROM Banner b INNER JOIN BannerTranslation bt WHERE bt.locale = :locale AND bt.bannerId = b.id GROUP BY b.id ORDER BY b.sequence ORDER BY sequence asc', array('locale' => object(Locale))) (vendor/spoon/library/spoon/datagrid/source_db.php:139) at SpoonDatagridSourceDB->getData(null, null, 'sequence', 'asc') (vendor/spoon/library/spoon/datagrid/datagrid.php:743) at SpoonDataGrid->parse() (vendor/spoon/library/spoon/datagrid/datagrid.php:505) at SpoonDataGrid->getContent() (src/Backend/Core/Engine/DataGrid.php:344) at Backend\Core\Engine\DataGrid->getContent() (src/Backend/Modules/Banners/Domain/Banner/BannerDataGrid.php:40) at Backend\Modules\Banners\Domain\Banner\BannerDataGrid::getHtml() (src/Backend/Modules/Banners/Actions/BannerIndex.php:14) at Backend\Modules\Banners\Actions\BannerIndex->execute() (src/Backend/Core/Engine/Action.php:63) at Backend\Core\Engine\Action->execute() (src/Backend/Core/Engine/Backend.php:25) at Backend\Core\Engine\Backend->display() (app/ForkController.php:106) at ForkCMS\App\ForkController->handleApplication(object(Backend)) (app/ForkController.php:54) at ForkCMS\App\ForkController->backendController() (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (app/Kernel.php:53) at ForkCMS\App\Kernel->handle(object(Request)) (index.php:59)

jeroendesloovere commented 4 years ago

Hi there,

I've noticed the query has "ORDER BY b.sequence ORDER BY sequence asc'," => It is not allowed to have two "order by" after each other. Can you try removing or commenting this line https://github.com/friends-of-forkcms/fork-cms-module-banners/blob/master/src/Backend/Modules/Banners/Domain/Banner/BannerDataGrid.php#L21 then everything will work

huseyinates commented 4 years ago

Thanks, the problem has been fixed.

huseyinates commented 4 years ago

sorry i will disturb you again, My admin panel problem has been solved, I added and edited. I added the module to the frontend and I get the following error.

Type error: Argument 1 passed to Common\Locale::fromString() must be of the type string, null given, called in /home/wjango/domains/wjango.com/public_html/cms/src/Common/Doctrine/Type/LocaleType.php on line 29

Symfony\Component\Debug\Exception\ FatalThrowableError in src/Common/Locale.php (line 21) protected function __construct(string $locale) { $this->setLocale($locale); } public static function fromString(string $locale): self { return new static($locale); } abstract protected function getPossibleLanguages(): array; Locale::fromString(null) in src/Common/Doctrine/Type/LocaleType.php (line 29) LocaleType->convertToPHPValue(null, object(MySQL57Platform)) in vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php (line 316) AbstractHydrator->gatherRowData(array('id_1' => '69440274-8b35-11ea-a0c5-960000406534', 'sequence_2' => '0', 'status_3' => 'active', 'image_4' => '5afc309dcde660070c25f002b1dc14bd29d89211.png', 'createdOn_5' => '2020-04-30 22:53:30', 'editedOn_6' => '2020-05-01 20:39:46', 'locale_8' => null, 'title_9' => null, 'subTitle_10' => null, 'linkToUrl_11' => null, 'bannerId_12' => null), array('r' => '|69440274-8b35-11ea-a0c5-960000406534', 'e0' => ''), array('r' => true)) in vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ObjectHydrator.php (line 331) ObjectHydrator->hydrateRowData(array('id_1' => '69440274-8b35-11ea-a0c5-960000406534', 'sequence_2' => '0', 'status_3' => 'active', 'image_4' => '5afc309dcde660070c25f002b1dc14bd29d89211.png', 'createdOn_5' => '2020-04-30 22:53:30', 'editedOn_6' => '2020-05-01 20:39:46', 'locale_8' => null, 'title_9' => null, 'subTitle_10' => null, 'linkToUrl_11' => null, 'bannerId_12' => null), array()) in vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ObjectHydrator.php (line 162) ObjectHydrator->hydrateAllData() in vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php (line 153) AbstractHydrator->hydrateAll(object(PDOStatement), object(ResultSetMapping), array('deferEagerLoad' => true)) in vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php (line 893) BasicEntityPersister->loadAll(array('status' => object(Status)), array('sequence' => 'ASC'), null, null) in vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php (line 178) EntityRepository->findBy(array('status' => object(Status)), array('sequence' => 'ASC')) in src/Backend/Modules/Banners/Domain/Banner/BannerRepository.php (line 22) BannerRepository->findAllActive() in src/Frontend/Modules/Banners/Widgets/Carousel.php (line 18) Carousel->execute() in src/Frontend/Core/Engine/Block/Widget.php (line 110) Widget->execute() in src/Frontend/Core/Engine/Page.php (line 367) Page->parseBlock(array('extra' => object(Widget)), array()) in src/Frontend/Core/Engine/Page.php (line 346) Page->parsePositions() in src/Frontend/Core/Engine/Page.php (line 199) Page->display() in src/Frontend/Core/Engine/Frontend.php (line 25) Frontend->display() in app/ForkController.php (line 106) ForkController->handleApplication(object(Frontend)) in app/ForkController.php (line 80) ForkController->frontendController() in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151) HttpKernel->handleRaw(object(Request), 1) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68) HttpKernel->handle(object(Request), 1, true) in app/Kernel.php (line 53) Kernel->handle(object(Request)) in /index.php (line 59)