search

statamic / eloquent-driver

Provides support for storing your Statamic data in a database, rather than flat files.
https://statamic.dev/tips/storing-content-in-a-database
MIT License
104 stars 72 forks source link

Problem to reorder entries in Statamic Pro CMS #208

Closed Kapkam closed 3 months ago

Kapkam commented 9 months ago

Hi I need some help with something related with the Stache, that can be a bug or maybe is because I am doing something wrong 😆 . I have an aplication with Statamic PRO as CMS, and using this package to save the entries in BBDD.

My problem is that in my collection (Productos) when I try to "reorder" the list of products in the table it pop ups an error: "array_flip(): Can only flip string and integer values, entry skipped"

Here is the full trace for this error: Trace:

[2023-10-05 14:05:31] local.ERROR: array_flip(): Can only flip string and integer values, entry skipped {"exception":"[object] (ErrorException(code: 0): array_flip(): Can only flip string and integer values, entry skipped at C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\Collection.php:420)
[stacktrace]
#0 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Bootstrap\\HandleExceptions.php(270): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(2, 'array_flip(): C...', 'C:\\\\Users\\\\adrian...', 420)
#1 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}(2, 'array_flip(): C...', 'C:\\\\Users\\\\adrian...', 420)
#2 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\Collection.php(420): array_flip(Array)
#3 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Entries\\Entry.php(405): Illuminate\\Support\\Collection->flip()
#4 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Data\\AbstractAugmented.php(60): Statamic\\Entries\\Entry->order()
#5 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Data\\HasAugmentedInstance.php(14): Statamic\\Data\\AbstractAugmented->get('order')
#6 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Data\\HasAugmentedInstance.php(88): Statamic\\Entries\\Entry->augmentedValue('order')
#7 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Data\\HasAugmentedInstance.php(115): Statamic\\Entries\\Entry->__get('order')
#8 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Data\\HasAugmentedInstance.php(127): Statamic\\Entries\\Entry->offsetGet('order')
#9 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\Arr.php(170): Statamic\\Entries\\Entry->offsetExists('order')
#10 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\helpers.php(77): Illuminate\\Support\\Arr::exists(Object(Statamic\\Eloquent\\Entries\\Entry), 'order')
#11 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\Traits\\EnumeratesValues.php(1049): data_get(Object(Statamic\\Eloquent\\Entries\\Entry), Array)
#12 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\Collection.php(1392): Illuminate\\Support\\Collection->Illuminate\\Support\\Traits\\{closure}(Object(Statamic\\Eloquent\\Entries\\Entry), 0)
#13 C:\\Users\\adrian\\Desktop\\Enea\\enea\\app\\Providers\\AppServiceProvider.php(51): Illuminate\\Support\\Collection->sortBy(Object(Closure))
#14 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Statamic.php(331): App\\Providers\\AppServiceProvider->App\\Providers\\{closure}()
#15 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Providers\\AppServiceProvider.php(29): Statamic\\Statamic::runBootedCallbacks()
#16 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Application.php(972): Statamic\\Providers\\AppServiceProvider->Statamic\\Providers\\{closure}(Object(Illuminate\\Foundation\\Application))
#17 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Application.php(915): Illuminate\\Foundation\\Application->fireAppCallbacks(Array)
#18 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Bootstrap\\BootProviders.php(17): Illuminate\\Foundation\\Application->boot()
#19 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Application.php(242): Illuminate\\Foundation\\Bootstrap\\BootProviders->bootstrap(Object(Illuminate\\Foundation\\Application))
#20 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(176): Illuminate\\Foundation\\Application->bootstrapWith(Array)
#21 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(160): Illuminate\\Foundation\\Http\\Kernel->bootstrap()
#22 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#23 C:\\Users\\adrian\\Desktop\\Enea\\enea\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#24 {main}
"}

Debuggin the error i see that doing the following line of code with the problematic collection returns me an array of IDs and one is null. Code: collect($structure->tree())->keyBy('entry')

image

Anyway, I could avoid the error by adding this peace of code in the function order() of the file vendor/statamic/cms/src/Entries/Entry.php. The function after my hack:

    public function order()
    {
        if (! $this->hasStructure()) {
            return $this->value('order');
        }

        // **HACK**
        if($this->collection=='productos') {
            return $this->structure()->in($this->locale())
                ->flattenedPages()
                ->map->reference()
                ->filter(function ($value, $key) {
                    return $value;
                })
                ->flip()->get($this->id) + 1;
        }
        // ******* 
        return $this->structure()->in($this->locale())
            ->flattenedPages()
            ->map->reference()
            ->flip()->get($this->id) + 1;
    }

But when I try it again another error appears me, i suppose that It have relation with that null entry that I mention before, but lets continue. The new error in this case is : "Duplicate entry [153] in [productos] collection's structure."

Trace of this error:

[2023-10-05 14:15:04] local.ERROR: Duplicate entry [153] in [productos] collection's structure. {"userId":"0abe4b69-f7a9-44b6-9e23-60b16bdf6efc","exception":"[object] (Exception(code: 0): Duplicate entry [153] in [productos] collection's structure. at C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\CollectionStructure.php:72)
[stacktrace]
#0 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(51): Statamic\\Structures\\CollectionStructure->validateTree(Array, 'es')
#1 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\spatie\\blink\\src\\Blink.php(302): Statamic\\Structures\\Tree->Statamic\\Structures\\{closure}()
#2 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\Blink.php(18): Spatie\\Blink\\Blink->once('structure-produ...', Object(Closure))
#3 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Facades\\Facade.php(338): Statamic\\Support\\Blink->__call('once', Array)
#4 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(52): Illuminate\\Support\\Facades\\Facade::__callStatic('once', Array)
#5 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\FluentGetterSetter.php(115): Statamic\\Structures\\Tree->Statamic\\Structures\\{closure}(Array)
#6 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\FluentGetterSetter.php(93): Statamic\\Support\\FluentGetterSetter->runGetterLogic()
#7 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(54): Statamic\\Support\\FluentGetterSetter->args(Array)
#8 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Structures\\CollectionTree.php(37): Statamic\\Structures\\Tree->tree()
#9 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Structures\\CollectionTree.php(25): Statamic\\Eloquent\\Structures\\CollectionTree::makeModelFromContract(Object(Statamic\\Eloquent\\Structures\\CollectionTree))
#10 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Structures\\CollectionTreeRepository.php(25): Statamic\\Eloquent\\Structures\\CollectionTree->toModel()
#11 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(164): Statamic\\Eloquent\\Structures\\CollectionTreeRepository->save(Object(Statamic\\Eloquent\\Structures\\CollectionTree))
#12 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Controllers\\CP\\Collections\\ReorderEntriesController.php(62): Statamic\\Structures\\Tree->save()
#13 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): Statamic\\Http\\Controllers\\CP\\Collections\\ReorderEntriesController->__invoke(Object(Illuminate\\Http\\Request), Object(Statamic\\Eloquent\\Collections\\Collection))
#14 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction('__invoke', Array)
#15 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Statamic\\Http\\Controllers\\CP\\Collections\\ReorderEntriesController), '__invoke')
#16 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController()
#17 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(798): Illuminate\\Routing\\Route->run()
#18 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#19 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\DeleteTemporaryFileUploads.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#20 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\DeleteTemporaryFileUploads->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#21 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\CountUsers.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#22 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\CountUsers->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#23 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootUtilities.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#24 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootUtilities->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#25 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootPreferences.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#26 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootPreferences->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#27 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootPermissions.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#28 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootPermissions->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#29 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\Localize.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#30 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\Localize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#31 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\Authorize.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#32 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\Authorize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#33 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\AddToasts.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#34 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\AddToasts->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#35 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\AuthGuard.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#36 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\AuthGuard->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#37 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\ContactOutpost.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#38 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\ContactOutpost->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#39 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#40 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#41 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#42 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#43 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#44 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#45 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#46 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))
#47 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#48 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#49 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#50 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#51 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#52 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\SwapExceptionHandler.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#53 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\SwapExceptionHandler->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#54 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#55 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(799): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#56 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#57 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(740): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#58 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#59 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(190): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#60 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#61 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\DisableFloc.php(17): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#62 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\DisableFloc->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#63 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CheckMultisite.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#64 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CheckMultisite->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#65 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CheckComposerJsonScripts.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#66 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CheckComposerJsonScripts->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#67 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\PoweredByHeader.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#68 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\PoweredByHeader->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#69 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\barryvdh\\laravel-debugbar\\src\\Middleware\\InjectDebugbar.php(66): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#70 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#71 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#72 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#73 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#74 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#75 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#76 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#77 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#78 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#79 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#80 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#81 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#82 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#83 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#84 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#85 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#86 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#87 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#88 C:\\Users\\adrian\\Desktop\\Enea\\enea\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#89 {main}
"}

Reading this I thougth that as the error says I could have duplicated entries but looking the table of entries in my database I dont see any duplicates, moreover, I use the following command to see a diagnose of the Stache in my aplication and returns me: Command: php please stache:doctor

[✓] No duplicate IDs detected.
[✓] No unconfigured indexes.
 Indexes are created on demand through regular site usage.
 You could consider trying again after browsing your site.

Its true that in my table of entries have many lines with the same order because many users where adding products at the same time, thats why I supposed that this error is related with the Stache.

Image that shows how many entries have the same "order" value: image

ryanmitchell commented 9 months ago

Can you paste the result of php please support:details so I can understand your environment set up?

Kapkam commented 9 months ago

Sure, here they are

Environment
Application Name: Statamic
Laravel Version: 9.52.10
PHP Version: 8.1.13
Composer Version: 2.3.5
Environment: local
Debug Mode: ENABLED
URL: localhost
Maintenance Mode: OFF

Cache
Config: NOT CACHED
Events: NOT CACHED
Routes: NOT CACHED
Views: CACHED

Drivers
Broadcasting: log
Cache: statamic
Database: mysql
Logs: stack / single
Mail: smtp
Queue: sync
Session: file

Statamic
Addons: 2
Antlers: runtime
Stache Watcher: Enabled
Static Caching: Disabled
Version: 4.9.2 PRO

Statamic Addons
jacksleight/statamic-bard-texstyle: 3.1.3
statamic/eloquent-driver: 2.3.1

By the way if I comment the hack that I mention before it pop ups me the error of the array_flip() function because of the null that it recieves.

ryanmitchell commented 9 months ago

Did you miss out the Statamic Eloquent Driver block? Thats what I was really wanting to see... eg mine is:

Statamic Eloquent Driver
Asset Containers: file
Assets: file
Blueprints: file
Collection Trees: file
Collections: file
Entries: eloquent
Forms: eloquent
Global Sets: file
Global Variables: eloquent
Navigation Trees: file
Navigations: eloquent
Revisions: eloquent
Taxonomies: eloquent
Terms: eloquent
jasonvarga commented 9 months ago

Please try updating to the latest versions of Statamic and Eloquent Driver before submitting issues, as your problems may have been fixed in newer versions already.

Kapkam commented 9 months ago

ok, so I will try to update all and see if the error persists or not

Kapkam commented 9 months ago

It updates me but It gives me this error in the console after the update: image

Kapkam commented 9 months ago

I try to delete all the content of the "entries" from the collection that give me problems to reorder and now it gives me an error when I try to add an entry in that collection. This is the LOG:

[2023-10-10 13:04:07] local.ERROR: Trying to access array offset on value of type null {"userId":"0abe4b69-f7a9-44b6-9e23-60b16bdf6efc","exception":"[object] (ErrorException(code: 0): Trying to access array offset on value of type null at C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\CollectionStructure.php:110)
[stacktrace]
#0 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Bootstrap\\HandleExceptions.php(270): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(2, 'Trying to acces...', 'C:\\\\Users\\\\adrian...', 110)
#1 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\CollectionStructure.php(110): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}(2, 'Trying to acces...', 'C:\\\\Users\\\\adrian...', 110)
#2 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\Traits\\EnumeratesValues.php(779): Statamic\\Structures\\CollectionStructure->Statamic\\Structures\\{closure}(NULL, 11)
#3 [internal function]: Illuminate\\Support\\Collection->Illuminate\\Support\\Traits\\{closure}(NULL, 11)
#4 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\Arr.php(830): array_filter(Array, Object(Closure), 1)
#5 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\Collection.php(382): Illuminate\\Support\\Arr::where(Array, Object(Closure))
#6 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Collections\\Traits\\EnumeratesValues.php(781): Illuminate\\Support\\Collection->filter(Object(Closure))
#7 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\CollectionStructure.php(111): Illuminate\\Support\\Collection->reject(Object(Closure))
#8 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\CollectionStructure.php(83): Statamic\\Structures\\CollectionStructure->removeEntryReferencesFromTree(Array, Object(Illuminate\\Support\\Collection))
#9 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(51): Statamic\\Structures\\CollectionStructure->validateTree(Array, 'es')
#10 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\spatie\\blink\\src\\Blink.php(306): Statamic\\Structures\\Tree->Statamic\\Structures\\{closure}()
#11 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\Blink.php(18): Spatie\\Blink\\Blink->once('structure-produ...', Object(Closure))
#12 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Facades\\Facade.php(338): Statamic\\Support\\Blink->__call('once', Array)
#13 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(52): Illuminate\\Support\\Facades\\Facade::__callStatic('once', Array)
#14 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\FluentGetterSetter.php(115): Statamic\\Structures\\Tree->Statamic\\Structures\\{closure}(Array)
#15 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\FluentGetterSetter.php(93): Statamic\\Support\\FluentGetterSetter->runGetterLogic()
#16 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(54): Statamic\\Support\\FluentGetterSetter->args(Array)
#17 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(98): Statamic\\Structures\\Tree->tree()
#18 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(123): Statamic\\Structures\\Tree->pages()
#19 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\CollectionStructure.php(33): Statamic\\Structures\\Tree->flattenedPages()
#20 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\spatie\\blink\\src\\Blink.php(306): Statamic\\Structures\\CollectionStructure->Statamic\\Structures\\{closure}()
#21 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\Blink.php(18): Spatie\\Blink\\Blink->once('collection-stru...', Object(Closure))
#22 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Facades\\Facade.php(338): Statamic\\Support\\Blink->__call('once', Array)
#23 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\CollectionStructure.php(34): Illuminate\\Support\\Facades\\Facade::__callStatic('once', Array)
#24 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\CollectionStructure.php(43): Statamic\\Structures\\CollectionStructure->flattenedPages(Object(Statamic\\Eloquent\\Entries\\Entry))
#25 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Entries\\Entry.php(798): Statamic\\Structures\\CollectionStructure->entryUri(Object(Statamic\\Eloquent\\Entries\\Entry))
#26 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Entries\\Entry.php(100): Statamic\\Entries\\Entry->uri()
#27 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Entries\\Entry.php(44): Statamic\\Eloquent\\Entries\\Entry::makeModelFromContract(Object(Statamic\\Eloquent\\Entries\\Entry))
#28 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Entries\\EntryRepository.php(54): Statamic\\Eloquent\\Entries\\Entry->toModel()
#29 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Facades\\Facade.php(338): Statamic\\Eloquent\\Entries\\EntryRepository->save(Object(Statamic\\Eloquent\\Entries\\Entry))
#30 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Entries\\Entry.php(330): Illuminate\\Support\\Facades\\Facade::__callStatic('save', Array)
#31 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Controllers\\CP\\Collections\\EntriesController.php(394): Statamic\\Entries\\Entry->save()
#32 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): Statamic\\Http\\Controllers\\CP\\Collections\\EntriesController->store(Object(Illuminate\\Http\\Request), Object(Statamic\\Eloquent\\Collections\\Collection), Object(Statamic\\Sites\\Site))
#33 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction('store', Array)
#34 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Statamic\\Http\\Controllers\\CP\\Collections\\EntriesController), 'store')
#35 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController()
#36 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(798): Illuminate\\Routing\\Route->run()
#37 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#38 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\DeleteTemporaryFileUploads.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#39 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\DeleteTemporaryFileUploads->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#40 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\CountUsers.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#41 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\CountUsers->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#42 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootUtilities.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#43 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootUtilities->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#44 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootPreferences.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#45 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootPreferences->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#46 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootPermissions.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#47 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootPermissions->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#48 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\Localize.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#49 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\Localize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#50 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\Authorize.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#51 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\Authorize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#52 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\AddToasts.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#53 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\AddToasts->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#54 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\AuthGuard.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#55 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\AuthGuard->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#56 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\ContactOutpost.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#57 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\ContactOutpost->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#58 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#59 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#60 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#61 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#62 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#63 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#64 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#65 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))
#66 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#67 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#68 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#69 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#70 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#71 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\SwapExceptionHandler.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#72 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\SwapExceptionHandler->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#73 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#74 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(799): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#75 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#76 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(740): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#77 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#78 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(190): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#79 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#80 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\StopImpersonating.php(12): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#81 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\StopImpersonating->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#82 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\DisableFloc.php(17): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#83 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\DisableFloc->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#84 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CheckMultisite.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#85 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CheckMultisite->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#86 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CheckComposerJsonScripts.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#87 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CheckComposerJsonScripts->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#88 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\PoweredByHeader.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#89 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\PoweredByHeader->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#90 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\barryvdh\\laravel-debugbar\\src\\Middleware\\InjectDebugbar.php(66): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#91 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#92 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#93 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#94 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#95 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#96 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#97 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#98 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#99 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#100 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#101 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#102 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#103 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#104 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#105 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#106 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#107 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#108 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#109 C:\\Users\\adrian\\Desktop\\Enea\\enea\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#110 {main}
"}
ryanmitchell commented 9 months ago

@Kapkam how did you delete them? It looks to me like their IDs are still in the collection structure.

Kapkam commented 9 months ago

I have deleted it using a database manager, I mean, I did not use Statamic manager for it.

And how can ia delete those IDs that are still in the collection struture??

This new problem may be because there is some other collection that keeps referring to one of those "ghost" IDs?

ryanmitchell commented 9 months ago

@Kapkam there is a trees table that will contain a row with handle of the collection handle and type of collection. If you blank the tree (set it to []) it should be ok.

Kapkam commented 9 months ago

I have restored the data of the table "entries" to try to delete the content of the handle in question of the table "trees", which apparently is the one that keeps the order of the lists, and now with the handle of "productos" in the table "trees" set to "[]" I hit reorder and it keeps telling me that there is a duplicate entry.

And the value of "productos" in the "trees" table is: image

Kapkam commented 9 months ago

this is the log now:


[2023-10-10 13:22:06] local.ERROR: Duplicate entry [178] in [productos] collection's structure. {"userId":"0abe4b69-f7a9-44b6-9e23-60b16bdf6efc","exception":"[object] (Exception(code: 0): Duplicate entry [178] in [productos] collection's structure. at C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\CollectionStructure.php:72)
[stacktrace]
#0 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(51): Statamic\\Structures\\CollectionStructure->validateTree(Array, 'es')
#1 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\spatie\\blink\\src\\Blink.php(306): Statamic\\Structures\\Tree->Statamic\\Structures\\{closure}()
#2 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\Blink.php(18): Spatie\\Blink\\Blink->once('structure-produ...', Object(Closure))
#3 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Facades\\Facade.php(338): Statamic\\Support\\Blink->__call('once', Array)
#4 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(52): Illuminate\\Support\\Facades\\Facade::__callStatic('once', Array)
#5 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\FluentGetterSetter.php(115): Statamic\\Structures\\Tree->Statamic\\Structures\\{closure}(Array)
#6 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\FluentGetterSetter.php(93): Statamic\\Support\\FluentGetterSetter->runGetterLogic()
#7 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(54): Statamic\\Support\\FluentGetterSetter->args(Array)
#8 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Structures\\CollectionTree.php(37): Statamic\\Structures\\Tree->tree()
#9 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Structures\\CollectionTree.php(25): Statamic\\Eloquent\\Structures\\CollectionTree::makeModelFromContract(Object(Statamic\\Eloquent\\Structures\\CollectionTree))
#10 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Structures\\CollectionTreeRepository.php(25): Statamic\\Eloquent\\Structures\\CollectionTree->toModel()
#11 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(164): Statamic\\Eloquent\\Structures\\CollectionTreeRepository->save(Object(Statamic\\Eloquent\\Structures\\CollectionTree))
#12 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Controllers\\CP\\Collections\\ReorderEntriesController.php(46): Statamic\\Structures\\Tree->save()
#13 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): Statamic\\Http\\Controllers\\CP\\Collections\\ReorderEntriesController->__invoke(Object(Illuminate\\Http\\Request), Object(Statamic\\Eloquent\\Collections\\Collection))
#14 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction('__invoke', Array)
#15 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Statamic\\Http\\Controllers\\CP\\Collections\\ReorderEntriesController), '__invoke')
#16 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController()
#17 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(798): Illuminate\\Routing\\Route->run()
#18 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#19 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\DeleteTemporaryFileUploads.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#20 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\DeleteTemporaryFileUploads->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#21 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\CountUsers.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#22 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\CountUsers->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#23 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootUtilities.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#24 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootUtilities->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#25 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootPreferences.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#26 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootPreferences->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#27 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootPermissions.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#28 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootPermissions->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#29 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\Localize.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#30 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\Localize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#31 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\Authorize.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#32 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\Authorize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#33 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\AddToasts.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#34 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\AddToasts->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#35 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\AuthGuard.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#36 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\AuthGuard->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#37 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\ContactOutpost.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#38 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\ContactOutpost->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#39 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#40 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#41 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#42 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#43 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#44 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#45 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#46 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))
#47 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#48 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#49 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#50 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#51 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#52 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\SwapExceptionHandler.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#53 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\SwapExceptionHandler->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#54 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#55 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(799): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#56 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#57 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(740): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#58 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#59 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(190): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#60 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#61 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\StopImpersonating.php(12): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#62 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\StopImpersonating->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#63 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\DisableFloc.php(17): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#64 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\DisableFloc->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#65 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CheckMultisite.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#66 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CheckMultisite->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#67 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CheckComposerJsonScripts.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#68 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CheckComposerJsonScripts->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#69 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\PoweredByHeader.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#70 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\PoweredByHeader->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#71 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\barryvdh\\laravel-debugbar\\src\\Middleware\\InjectDebugbar.php(66): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#72 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#73 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#74 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#75 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#76 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#77 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#78 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#79 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#80 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#81 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#82 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#83 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#84 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#85 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#86 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#87 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#88 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#89 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#90 C:\\Users\\adrian\\Desktop\\Enea\\enea\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#91 {main}
"}
ryanmitchell commented 9 months ago

Are you definitely using eloquent for the tree structures? It's possible to have a split config so it would be worth confirming you arent doing that. Did you try clearing your cache (or even your stache?).

Kapkam commented 9 months ago

In fact this project was started by someone else and I'm taking it up again, I don't know if there is file where to check what you say, as far as I understand if we are using eloquent for the tree structure.

What I can assure you is that after doing the "trees" table step I went from the manager to "Utilities" > "Cache Manager" > "Clear All". image

ryanmitchell commented 9 months ago

Yeah I can see now from the logs that you are using eloquent collection trees. I think you need to check the database tables for id 178 and see where you can find a duplicate of it in either the entries or trees table.

Kapkam commented 9 months ago

we have already found a solution for our problem, but I think there is still a bug in reorder functionality.

Apparently after initializing the "handle" of the table "trees" to "[]" and verifying that there was not a duplicate in the table "entries", of the collection that gave us problems, and in the list show up to 500 elements (we only have 85 products, so it is practically is to show all) the reordering works correctly.

But we can confirm that it fails if in the list we show only 50 items and we reorder among those 50 items. Here is the LOG when I reorder showing 50 elements in the list:

[2023-10-11 12:31:18] local.ERROR: Duplicate entry [177] in [productos] collection's structure. {"userId":"0abe4b69-f7a9-44b6-9e23-60b16bdf6efc","exception":"[object] (Exception(code: 0): Duplicate entry [177] in [productos] collection's structure. at C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\CollectionStructure.php:72)
[stacktrace]
#0 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(51): Statamic\\Structures\\CollectionStructure->validateTree(Array, 'es')
#1 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\spatie\\blink\\src\\Blink.php(306): Statamic\\Structures\\Tree->Statamic\\Structures\\{closure}()
#2 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\Blink.php(18): Spatie\\Blink\\Blink->once('structure-produ...', Object(Closure))
#3 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Support\\Facades\\Facade.php(338): Statamic\\Support\\Blink->__call('once', Array)
#4 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(52): Illuminate\\Support\\Facades\\Facade::__callStatic('once', Array)
#5 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\FluentGetterSetter.php(115): Statamic\\Structures\\Tree->Statamic\\Structures\\{closure}(Array)
#6 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Support\\FluentGetterSetter.php(93): Statamic\\Support\\FluentGetterSetter->runGetterLogic()
#7 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(54): Statamic\\Support\\FluentGetterSetter->args(Array)
#8 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Structures\\CollectionTree.php(37): Statamic\\Structures\\Tree->tree()
#9 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Structures\\CollectionTree.php(25): Statamic\\Eloquent\\Structures\\CollectionTree::makeModelFromContract(Object(Statamic\\Eloquent\\Structures\\CollectionTree))
#10 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\eloquent-driver\\src\\Structures\\CollectionTreeRepository.php(25): Statamic\\Eloquent\\Structures\\CollectionTree->toModel()
#11 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Structures\\Tree.php(164): Statamic\\Eloquent\\Structures\\CollectionTreeRepository->save(Object(Statamic\\Eloquent\\Structures\\CollectionTree))
#12 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Controllers\\CP\\Collections\\ReorderEntriesController.php(46): Statamic\\Structures\\Tree->save()
#13 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): Statamic\\Http\\Controllers\\CP\\Collections\\ReorderEntriesController->__invoke(Object(Illuminate\\Http\\Request), Object(Statamic\\Eloquent\\Collections\\Collection))
#14 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction('__invoke', Array)
#15 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Statamic\\Http\\Controllers\\CP\\Collections\\ReorderEntriesController), '__invoke')
#16 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController()
#17 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(798): Illuminate\\Routing\\Route->run()
#18 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#19 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\DeleteTemporaryFileUploads.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#20 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\DeleteTemporaryFileUploads->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#21 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\CountUsers.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#22 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\CountUsers->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#23 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootUtilities.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#24 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootUtilities->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#25 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootPreferences.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#26 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootPreferences->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#27 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\BootPermissions.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#28 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\BootPermissions->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#29 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\Localize.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#30 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\Localize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#31 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\Authorize.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#32 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\Authorize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#33 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\AddToasts.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#34 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\AddToasts->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#35 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\AuthGuard.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#36 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\AuthGuard->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#37 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CP\\ContactOutpost.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#38 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CP\\ContactOutpost->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#39 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#40 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#41 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#42 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#43 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#44 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#45 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#46 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))
#47 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#48 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#49 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#50 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#51 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#52 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\SwapExceptionHandler.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#53 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\SwapExceptionHandler->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#54 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#55 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(799): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#56 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#57 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(740): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#58 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#59 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(190): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#60 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#61 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\StopImpersonating.php(12): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#62 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\StopImpersonating->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#63 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\DisableFloc.php(17): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#64 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\DisableFloc->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#65 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CheckMultisite.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#66 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CheckMultisite->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#67 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\CheckComposerJsonScripts.php(14): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#68 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\CheckComposerJsonScripts->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#69 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\statamic\\cms\\src\\Http\\Middleware\\PoweredByHeader.php(18): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#70 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Statamic\\Http\\Middleware\\PoweredByHeader->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#71 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\barryvdh\\laravel-debugbar\\src\\Middleware\\InjectDebugbar.php(66): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#72 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#73 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#74 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#75 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#76 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#77 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#78 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#79 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#80 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#81 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#82 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#83 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(38): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#84 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#85 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#86 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#87 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#88 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#89 C:\\Users\\adrian\\Desktop\\Enea\\enea\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#90 C:\\Users\\adrian\\Desktop\\Enea\\enea\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#91 {main}
"}
Kapkam commented 9 months ago

I know that the error says i have a duplicate entry but when I reorder showing all the elements it works correctly

ryanmitchell commented 9 months ago

Does this only happen when you move the entry across the pages (ie from page 1 to page 2), or does it happen even if you move it on the same page?

Kapkam commented 9 months ago

The error occurs when you list 50 elements from the total, and without making any changes you click in "save".

If I make any change also throws the error. The key is to show less elements than the total.

ryanmitchell commented 9 months ago

I remember that the same thing happens when using the Stache driver, so Im not sure the issue specific to this driver. We'll get a look into it and come back to you.

ryanmitchell commented 9 months ago

I just ran a quick test on a new ordered collection config as follows:

title: 'Testing'
sites:
  - en
propagate: false
template: default
layout: layout
revisions: false
sort_dir: asc
date_behavior:
  past: public
  future: private
preview_targets:
  -
    label: Entry
    url: '{permalink}'
    refresh: true
structure:
  root: false

When I go to the CP and switch into 'tree' view, there is no pagination. So I'm not able to create the conditions to recreate your issue.

Kapkam commented 9 months ago

Ok in my CP in a "test" colection, that I have just create, I eneable "ordering" feature and put the "Max Depth" to 1, and it appears me the button "Reorder".

I dont use ".yml" files so I can't show you here the configuration like you did but I can add a screen shot: image

ryanmitchell commented 9 months ago

I set my max depth to 1 to ensure we have the same settings but on a new collection I'm not seeing the same issue. I can update the order without any errors.

I tried a variety of different configurations - file based collections, entries and trees, file based collections, eloquent trees and entires, file based collections, trees and eloquent entries. All worked without and issue for me.

Did you try creating a new collection and starting over?

Kapkam commented 9 months ago

I upload you this little video that shows how I reproduce the error in the CP:

https://github.com/statamic/eloquent-driver/assets/38344363/601389c5-3085-49b4-a75e-3886da749201

sorry for the watermark of the video 😆

ryanmitchell commented 9 months ago

Yep - I have the same set up but no error... here's my eloquent-driver.php config for the relevant portions:

    'collections' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Collections\CollectionModel::class,
        'update_entry_order_queue' => 'default',
    ],

    'collection_trees' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Structures\TreeModel::class,
        'tree'   => \Statamic\Eloquent\Structures\CollectionTree::class,
    ],

    'entries' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Entries\UuidEntryModel::class,
        'entry'  => \Statamic\Eloquent\Entries\Entry::class,
    ],

happy to take a look at your site directly if you want to look me up on Discord and give me access.

Kapkam commented 9 months ago

I notice that I have some differences in the eloquent-driver.php, I dont have the section "collection_trees" and in the "entries" i have "EntryModel" instead of "UuidEntryModel":

return [

    'connection'   => env('STATAMIC_ELOQUENT_CONNECTION', ''),
    'table_prefix' => env('STATAMIC_ELOQUENT_PREFIX', ''),

    'assets' => [
        'driver'          => 'eloquent',
        'container_model' => \Statamic\Eloquent\Assets\AssetContainerModel::class,
        'model'           => \Statamic\Eloquent\Assets\AssetModel::class,
    ],

    'blueprints' => [
        'driver'          => 'eloquent',
        'blueprint_model' => \Statamic\Eloquent\Fields\BlueprintModel::class,
        'fieldset_model'  => \Statamic\Eloquent\Fields\FieldsetModel::class,
    ],

    'collections' => [
        'driver'     => 'eloquent',
        'model'      => \Statamic\Eloquent\Collections\CollectionModel::class,
        'tree'       => \Statamic\Eloquent\Structures\CollectionTree::class,
        'tree_model' => \Statamic\Eloquent\Structures\TreeModel::class,
    ],

    'entries' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Entries\EntryModel::class,
        'entry'  => \Statamic\Eloquent\Entries\Entry::class,
    ],

    'forms' => [
        'driver'           => 'eloquent',
        'model'            => \Statamic\Eloquent\Forms\FormModel::class,
        'submission_model' => \Statamic\Eloquent\Forms\SubmissionModel::class,
    ],

    'global_sets' => [
        'driver'          => 'eloquent',
        'model'           => \Statamic\Eloquent\Globals\GlobalSetModel::class,
        'variables_model' => \Statamic\Eloquent\Globals\VariablesModel::class,
    ],

    'navigations' => [
        'driver'     => 'eloquent',
        'model'      => \Statamic\Eloquent\Structures\NavModel::class,
        'tree'       => \Statamic\Eloquent\Structures\NavTree::class,
        'tree_model' => \Statamic\Eloquent\Structures\TreeModel::class,
    ],

    'revisions' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Revisions\RevisionModel::class,
    ],

    'taxonomies' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Taxonomies\TaxonomyModel::class,
    ],

    'terms' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Taxonomies\TermModel::class,
    ],
];

I don't know if that could be the problem

ryanmitchell commented 9 months ago

Try adding in collection trees to see if it helps, it may not, but worth a try

Kapkam commented 9 months ago

Its still throws me the error, I can't give you access to the repo. I will try to providde you all you need. My eloquent-driver.php:

<?php

return [

    'connection'   => env('STATAMIC_ELOQUENT_CONNECTION', ''),
    'table_prefix' => env('STATAMIC_ELOQUENT_PREFIX', ''),

    'assets' => [
        'driver'          => 'eloquent',
        'container_model' => \Statamic\Eloquent\Assets\AssetContainerModel::class,
        'model'           => \Statamic\Eloquent\Assets\AssetModel::class,
    ],

    'blueprints' => [
        'driver'          => 'eloquent',
        'blueprint_model' => \Statamic\Eloquent\Fields\BlueprintModel::class,
        'fieldset_model'  => \Statamic\Eloquent\Fields\FieldsetModel::class,
    ],

    'collections' => [
        'driver'     => 'eloquent',
        'model'      => \Statamic\Eloquent\Collections\CollectionModel::class,
        'update_entry_order_queue' => 'default',
    ],

    'collection_trees' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Structures\TreeModel::class,
        'tree'   => \Statamic\Eloquent\Structures\CollectionTree::class,
    ],

    'entries' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Entries\UuidEntryModel::class,
        'entry'  => \Statamic\Eloquent\Entries\Entry::class,
    ],

    'forms' => [
        'driver'           => 'eloquent',
        'model'            => \Statamic\Eloquent\Forms\FormModel::class,
        'submission_model' => \Statamic\Eloquent\Forms\SubmissionModel::class,
    ],

    'global_sets' => [
        'driver'          => 'eloquent',
        'model'           => \Statamic\Eloquent\Globals\GlobalSetModel::class,
        'variables_model' => \Statamic\Eloquent\Globals\VariablesModel::class,
    ],

    'navigations' => [
        'driver'     => 'eloquent',
        'model'      => \Statamic\Eloquent\Structures\NavModel::class,
        'tree'       => \Statamic\Eloquent\Structures\NavTree::class,
        'tree_model' => \Statamic\Eloquent\Structures\TreeModel::class,
    ],

    'revisions' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Revisions\RevisionModel::class,
    ],

    'taxonomies' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Taxonomies\TaxonomyModel::class,
    ],

    'terms' => [
        'driver' => 'eloquent',
        'model'  => \Statamic\Eloquent\Taxonomies\TermModel::class,
    ],
];

I updated Statamic with the folowing command: composer update statamic/cms --with-dependencies

The output of "php please support:details":

Environment
Application Name: Statamic
Laravel Version: 9.52.16
PHP Version: 8.1.13
Composer Version: 2.3.5
Environment: local
Debug Mode: ENABLED
URL: localhost
Maintenance Mode: OFF

Cache
Config: NOT CACHED
Events: NOT CACHED
Routes: NOT CACHED
Views: CACHED

Drivers
Broadcasting: log
Cache: statamic
Database: mysql
Logs: stack / single
Mail: smtp
Queue: sync
Session: file

Statamic
Addons: 2
Antlers: runtime
Stache Watcher: Enabled
Static Caching: Disabled
Version: 4.28.0 PRO

Statamic Addons
jacksleight/statamic-bard-texstyle: 3.1.3
statamic/eloquent-driver: 2.8.0

Statamic Eloquent Driver
Asset Containers: file
Assets: eloquent
Blueprints: eloquent
Collection Trees: eloquent
Collections: eloquent
Entries: eloquent
Forms: eloquent
Global Sets: eloquent
Global Variables: file
Navigation Trees: file
Navigations: eloquent
Revisions: eloquent
Taxonomies: eloquent
Terms: eloquent
ryanmitchell commented 9 months ago

If you were using EntryModel you definitely shouldn't switch to using UUIDEntryModel - thats a bad idea.

Unfortunately I'm a bit stuck as I can't see the issue. Would you be comfortable giving on of the core team access to the code?

Kapkam commented 9 months ago

I could prepare a copy of the repo and clean it but i will need a cople of days. I can notify you here with the link to the repo or via Discord, at your convenience.