Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Failed to cache model with point #131

Closed
Saifallak opened this issue Nov 24, 2024 · 1 comment
Closed

Failed to cache model with point #131

Saifallak opened this issue Nov 24, 2024 · 1 comment

Comments

@Saifallak
Copy link

try to cache any model using db cache

Ex:

    function get_cached_branches(): Collection
    {
        return Cache::remember(key: (new Branch())->getForEverCachedKey(), ttl: (new Branch)->getForEverCachedTTL(), callback: function () {
            return Branch::query()
                ->active()
                ->ordered()
                ->get();
        });
    }

Error:

SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\x8A\x8E\xE4\xF2\x9BK...' for column 'value' at row 1 (Connection: mysql, SQL: insert into `cache` (`expiration`, `key`, `value`) values (1732464735, branches-for-ever-cached-key, O:39:"Illuminate\Database\Eloquent\Collection":2:{s:8:"*items";a:4:{i:0;O:17:"App\Models\Branch":32:{s:13:"*connection";s:5:"mysql";s:8:"*table";s:8:"branches";s:13:"*primaryKey";s:2:"id";s:10:"*keyType";s:3:"int";s:12:"incrementing";b:1;s:7:"*with";a:0:{}s:12:"*withCount";a:0:{}s:19:"preventsLazyLoading";b:0;s:10:"*perPage";i:15;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;s:28:"*escapeWhenCastingToString";b:0;s:13:"*attributes";a:13:{s:2:"id";i:1;s:4:"name";s:45:"{"ar": "فرع دبي", "en": "Dubai Branch"}";s:7:"address";s:214:"{"ar": "القوز، شارع 7 رقم 14 – منطقة القوز الصناعية 3، دبي، الإمارات العربية المتحدة", "en": "Al Quoz, 14 7 St. – Al Quoz Industrial Zone 3 Dubai, UAE"}";s:7:"city_id";i:2;s:7:"area_id";i:19;s:8:"location";s:25:"��r����K@�)�3 9@";s:6:"phones";s:33:"["+971544090401", "+97143399443"]";s:9:"timeslots";s:330:"["09:00-09:30", "09:30-10:00", "10:00-10:30", "10:30-11:00", "11:00-11:30", "11:30-12:00", "12:00-12:30", "12:30-01:00", "01:00-01:30", "01:30-02:00", "02:00-02:30", "02:30-03:00", "03:00-03:30", "03:30-04:00", "04:00-04:30", "04:30-05:00", "05:00-05:30", "05:30-06:00", "06:00-06:30", "06:30-07:00", "07:00-07:30", "07:30-08:00"]";s:8:"weekdays";s:68:"["Saturday", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday"]";s:9:"is_active";i:1;s:12:"order_column";i:1;s:10:"created_at";s:19:"2024-11-24 16:02:54";s:10:"updated_at";s:19:"2024-11-24 16:02:54";}s:11:"*original";a:13:{s:2:"id";i:1;s:4:"name";s:45:"{"ar": "فرع دبي", "en": "Dubai Branch"}";s:7:"address";s:214:"{"ar": "القوز، شارع 7 رقم 14 – منطقة القوز الصناعية 3، دبي، الإمارات العربية المتحدة", "en": "Al Quoz, 14 7 St. – Al Quoz Industrial Zone 3 Dubai, UAE"}";s:7:"city_id";i:2;s:7:"area_id";i:19;s:8:"location";s:25:"��r����K@�)�3 9@";s:6:"phones";s:33:"["+971544090401", "+97143399443"]";s:9:"timeslots";s:330:"["09:00-09:30", "09:30-10:00", "10:00-10:30", "10:30-11:00", "11:00-11:30", "11:30-12:00", "12:00-12:30", "12:30-01:00", "01:00-01:30", "01:30-02:00", "02:00-02:30", "02:30-03:00", "03:00-03:30", "03:30-04:00", "04:00-04:30", "04:30-05:00", "05:00-05:30", "05:30-06:00", "06:00-06:30", "06:30-07:00", "07:00-07:30", "07:30-08:00"]";s:8:"weekdays";s:68:"["Saturday", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday"]";s:9:"is_active";i:1;s:12:"order_column";i:1;s:10:"created_at";s:19:"2024-11-24 16:02:54";s:10:"updated_at";s:19:"2024-11-24 16:02:54";}s:10:"*changes";a:0:{}s:8:"*casts";a:4:{s:6:"phones";s:5:"array";s:9:"timeslots";s:5:"array";s:8:"weekdays";s:5:"array";s:8:"location";s:41:"MatanYadaev\EloquentSpatial\Objects\Point";}s:17:"*classCastCache";a:0:{}s:21:"*attributeCastCache";a:0:{}s:13:"*dateFormat";N;s:10:"*appends";a:0:{}s:19:"*dispatchesEvents";a:0:{}s:14:"*observables";a:0:{}s:12:"*relations";a:0:{}s:10:"*touches";a:0:{}s:10:"timestamps";b:1;s:13:"usesUniqueIds";b:0;s:9:"*hidden";a:0:{}s:10:"*visible";a:0:{}s:11:"*fillable";a:8:{i:0;s:4:"name";i:1;s:7:"address";i:2;s:7:"city_id";i:3;s:7:"area_id";i:4;s:8:"location";i:5;s:6:"phones";i:6;s:9:"timeslots";i:7;s:8:"weekdays";}s:10:"*guarded";a:1:{i:0;s:1:"*";}s:12:"translatable";a:2:{i:0;s:4:"name";i:1;s:7:"address";}s:20:"*translationLocale";N;}i:1;O:17:"App\Models\Branch":32:{s:13:"*connection";s:5:"mysql";s:8:"*table";s:8:"branches";s:13:"*primaryKey";s:2:"id";s:10:"*keyType";s:3:"int";s:12:"incrementing";b:1;s:7:"*with";a:0:{}s:12:"*withCount";a:0:{}s:19:"preventsLazyLoading";b:0;s:10:"*perPage";i:15;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;s:28:"*escapeWhenCastingToString";b:0;s:13:"*attributes";a:13:{s:2:"id";i:2;s:4:"name";s:56:"{"ar": "فرع الفجيرة", "en": "Fujairah Branch"}";s:7:"address";s:232:"{"ar": "منطقة الحيل الصناعية، مقابل المعسكر العسكري، الفجيرة، الإمارات العربية المتحدة", "en": "Al Hail Industrial Area, Opposite to Military Camp, Fujairah, UAE"}";s:7:"city_id";i:6;s:7:"area_id";i:38;s:8:"location";s:25:"�����)�$L@8��d��9@";s:6:"phones";s:33:"["+971549942244", "+97142229979"]";s:9:"timeslots";s:330:"["09:00-09:30", "09:30-10:00", "10:00-10:30", "10:30-11:00", "11:00-11:30", "11:30-12:00", "12:00-12:30", "12:30-01:00", "01:00-01:30", "01:30-02:00", "02:00-02:30", "02:30-03:00", "03:00-03:30", "03:30-04:00", "04:00-04:30", "04:30-05:00", "05:00-05:30", "05:30-06:00", "06:00-06:30", "06:30-07:00", "07:00-07:30", "07:30-08:00"]";s:8:"weekdays";s:68:"["Saturday", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday"]";s:9:"is_active";i:1;s:12:"order_column";i:2;s:10:"created_at";s:19:"2024-11-24 16:02:54";s:10:"updated_at";s:19:"2024-11-24 16:02:54";}s:11:"*original";a:13:{s:2:"id";i:2;s:4:"name";s:56:"{"ar": "فرع الفجيرة", "en": "Fujairah Branch"}";s:7:"address";s:232:"{"ar": "منطقة الحيل الصناعية، مقابل المعسكر العسكري، الفجيرة، الإمارات العربية المتحدة", "en": "Al Hail Industrial Area, Opposite to Military Camp, Fujairah, UAE"}";s:7:"city_id";i:6;s:7:"area_id";i:38;s:8:"location";s:25:"�����)�$L@8��d��9@";s:6:"phones";s:33:"["+971549942244", "+97142229979"]";s:9:"timeslots";s:330:"["09:00-09:30", "09:30-10:00", "10:00-10:30", "10:30-11:00", "11:00-11:30", "11:30-12:00", "12:00-12:30", "12:30-01:00", "01:00-01:30", "01:30-02:00", "02:00-02:30", "02:30-03:00", "03:00-03:30", "03:30-04:00", "04:00-04:30", "04:30-05:00", "05:00-05:30", "05:30-06:00", "06:00-06:30", "06:30-07:00", "07:00-07:30", "07:30-08:00"]";s:8:"weekdays";s:68:"["Saturday", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday"]";s:9:"is_active";i:1;s:12:"order_column";i:2;s:10:"created_at";s:19:"2024-11-24 16:02:54";s:10:"updated_at";s:19:"2024-11-24 16:02:54";}s:10:"*changes";a:0:{}s:8:"*casts";a:4:{s:6:"phones";s:5:"array";s:9:"timeslots";s:5:"array";s:8:"weekdays";s:5:"array";s:8:"location";s:41:"MatanYadaev\EloquentSpatial\Objects\Point";}s:17:"*classCastCache";a:0:{}s:21:"*attributeCastCache";a:0:{}s:13:"*dateFormat";N;s:10:"*appends";a:0:{}s:19:"*dispatchesEvents";a:0:{}s:14:"*observables";a:0:{}s:12:"*relations";a:0:{}s:10:"*touches";a:0:{}s:10:"timestamps";b:1;s:13:"usesUniqueIds";b:0;s:9:"*hidden";a:0:{}s:10:"*visible";a:0:{}s:11:"*fillable";a:8:{i:0;s:4:"name";i:1;s:7:"address";i:2;s:7:"city_id";i:3;s:7:"area_id";i:4;s:8:"location";i:5;s:6:"phones";i:6;s:9:"timeslots";i:7;s:8:"weekdays";}s:10:"*guarded";a:1:{i:0;s:1:"*";}s:12:"translatable";a:2:{i:0;s:4:"name";i:1;s:7:"address";}s:20:"*translationLocale";N;}i:2;O:17:"App\Models\Branch":32:{s:13:"*connection";s:5:"mysql";s:8:"*table";s:8:"branches";s:13:"*primaryKey";s:2:"id";s:10:"*keyType";s:3:"int";s:12:"incrementing";b:1;s:7:"*with";a:0:{}s:12:"*withCount";a:0:{}s:19:"preventsLazyLoading";b:0;s:10:"*perPage";i:15;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;s:28:"*escapeWhenCastingToString";b:0;s:13:"*attributes";a:13:{s:2:"id";i:3;s:4:"name";s:67:"{"ar": "فرع رأس الخيمة", "en": "Ras Al Khaimah Branch"}";s:7:"address";s:166:"{"ar": "شارع محمد بن سالم، رأس الخيمة، الإمارات العربية المتحدة.", "en": "Mohammed Bin Salem St., Ras Al Khaimah, UAE"}";s:7:"city_id";i:7;s:7:"area_id";i:42;s:8:"location";s:25:"����eS��K@ �º�9@";s:6:"phones";s:33:"["+971504090461", "+97172212122"]";s:9:"timeslots";s:330:"["09:00-09:30", "09:30-10:00", "10:00-10:30", "10:30-11:00", "11:00-11:30", "11:30-12:00", "12:00-12:30", "12:30-01:00", "01:00-01:30", "01:30-02:00", "02:00-02:30", "02:30-03:00", "03:00-03:30", "03:30-04:00", "04:00-04:30", "04:30-05:00", "05:00-05:30", "05:30-06:00", "06:00-06:30", "06:30-07:00", "07:00-07:30", "07:30-08:00"]";s:8:"weekdays";s:68:"["Saturday", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday"]";s:9:"is_active";i:1;s:12:"order_column";i:3;s:10:"created_at";s:19:"2024-11-24 16:02:54";s:10:"updated_at";s:19:"2024-11-24 16:02:54";}s:11:"*original";a:13:{s:2:"id";i:3;s:4:"name";s:67:"{"ar": "فرع رأس الخيمة", "en": "Ras Al Khaimah Branch"}";s:7:"address";s:166:"{"ar": "شارع محمد بن سالم، رأس الخيمة، الإمارات العربية المتحدة.", "en": "Mohammed Bin Salem St., Ras Al Khaimah, UAE"}";s:7:"city_id";i:7;s:7:"area_id";i:42;s:8:"location";s:25:"����eS��K@ �º�9@";s:6:"phones";s:33:"["+971504090461", "+97172212122"]";s:9:"timeslots";s:330:"["09:00-09:30", "09:30-10:00", "10:00-10:30", "10:30-11:00", "11:00-11:30", "11:30-12:00", "12:00-12:30", "12:30-01:00", "01:00-01:30", "01:30-02:00", "02:00-02:30", "02:30-03:00", "03:00-03:30", "03:30-04:00", "04:00-04:30", "04:30-05:00", "05:00-05:30", "05:30-06:00", "06:00-06:30", "06:30-07:00", "07:00-07:30", "07:30-08:00"]";s:8:"weekdays";s:68:"["Saturday", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday"]";s:9:"is_active";i:1;s:12:"order_column";i:3;s:10:"created_at";s:19:"2024-11-24 16:02:54";s:10:"updated_at";s:19:"2024-11-24 16:02:54";}s:10:"*changes";a:0:{}s:8:"*casts";a:4:{s:6:"phones";s:5:"array";s:9:"timeslots";s:5:"array";s:8:"weekdays";s:5:"array";s:8:"location";s:41:"MatanYadaev\EloquentSpatial\Objects\Point";}s:17:"*classCastCache";a:0:{}s:21:"*attributeCastCache";a:0:{}s:13:"*dateFormat";N;s:10:"*appends";a:0:{}s:19:"*dispatchesEvents";a:0:{}s:14:"*observables";a:0:{}s:12:"*relations";a:0:{}s:10:"*touches";a:0:{}s:10:"timestamps";b:1;s:13:"usesUniqueIds";b:0;s:9:"*hidden";a:0:{}s:10:"*visible";a:0:{}s:11:"*fillable";a:8:{i:0;s:4:"name";i:1;s:7:"address";i:2;s:7:"city_id";i:3;s:7:"area_id";i:4;s:8:"location";i:5;s:6:"phones";i:6;s:9:"timeslots";i:7;s:8:"weekdays";}s:10:"*guarded";a:1:{i:0;s:1:"*";}s:12:"translatable";a:2:{i:0;s:4:"name";i:1;s:7:"address";}s:20:"*translationLocale";N;}i:3;O:17:"App\Models\Branch":32:{s:13:"*connection";s:5:"mysql";s:8:"*table";s:8:"branches";s:13:"*primaryKey";s:2:"id";s:10:"*keyType";s:3:"int";s:12:"incrementing";b:1;s:7:"*with";a:0:{}s:12:"*withCount";a:0:{}s:19:"preventsLazyLoading";b:0;s:10:"*perPage";i:15;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;s:28:"*escapeWhenCastingToString";b:0;s:13:"*attributes";a:13:{s:2:"id";i:4;s:4:"name";s:62:"{"ar": "فرع الخوانج", "en": "Ras Al Khaimah Branch"}";s:7:"address";s:151:"{"ar": "مول مردف أفينيو – الطابق الأرضي 1، مردف، دبي.", "en": "Mirdif Avenue Mall – Basement 1 Mirdif – Dubai"}";s:7:"city_id";i:2;s:7:"area_id";i:14;s:8:"location";s:25:"��|�o�^�K@.���;9@";s:6:"phones";s:32:"["+971504090461", "+9714334850"]";s:9:"timeslots";s:330:"["09:00-09:30", "09:30-10:00", "10:00-10:30", "10:30-11:00", "11:00-11:30", "11:30-12:00", "12:00-12:30", "12:30-01:00", "01:00-01:30", "01:30-02:00", "02:00-02:30", "02:30-03:00", "03:00-03:30", "03:30-04:00", "04:00-04:30", "04:30-05:00", "05:00-05:30", "05:30-06:00", "06:00-06:30", "06:30-07:00", "07:00-07:30", "07:30-08:00"]";s:8:"weekdays";s:68:"["Saturday", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday"]";s:9:"is_active";i:1;s:12:"order_column";i:4;s:10:"created_at";s:19:"2024-11-24 16:02:54";s:10:"updated_at";s:19:"2024-11-24 16:02:54";}s:11:"*original";a:13:{s:2:"id";i:4;s:4:"name";s:62:"{"ar": "فرع الخوانج", "en": "Ras Al Khaimah Branch"}";s:7:"address";s:151:"{"ar": "مول مردف أفينيو – الطابق الأرضي 1، مردف، دبي.", "en": "Mirdif Avenue Mall – Basement 1 Mirdif – Dubai"}";s:7:"city_id";i:2;s:7:"area_id";i:14;s:8:"location";s:25:"��|�o�^�K@.���;9@";s:6:"phones";s:32:"["+971504090461", "+9714334850"]";s:9:"timeslots";s:330:"["09:00-09:30", "09:30-10:00", "10:00-10:30", "10:30-11:00", "11:00-11:30", "11:30-12:00", "12:00-12:30", "12:30-01:00", "01:00-01:30", "01:30-02:00", "02:00-02:30", "02:30-03:00", "03:00-03:30", "03:30-04:00", "04:00-04:30", "04:30-05:00", "05:00-05:30", "05:30-06:00", "06:00-06:30", "06:30-07:00", "07:00-07:30", "07:30-08:00"]";s:8:"weekdays";s:68:"["Saturday", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday"]";s:9:"is_active";i:1;s:12:"order_column";i:4;s:10:"created_at";s:19:"2024-11-24 16:02:54";s:10:"updated_at";s:19:"2024-11-24 16:02:54";}s:10:"*changes";a:0:{}s:8:"*casts";a:4:{s:6:"phones";s:5:"array";s:9:"timeslots";s:5:"array";s:8:"weekdays";s:5:"array";s:8:"location";s:41:"MatanYadaev\EloquentSpatial\Objects\Point";}s:17:"*classCastCache";a:0:{}s:21:"*attributeCastCache";a:0:{}s:13:"*dateFormat";N;s:10:"*appends";a:0:{}s:19:"*dispatchesEvents";a:0:{}s:14:"*observables";a:0:{}s:12:"*relations";a:0:{}s:10:"*touches";a:0:{}s:10:"timestamps";b:1;s:13:"usesUniqueIds";b:0;s:9:"*hidden";a:0:{}s:10:"*visible";a:0:{}s:11:"*fillable";a:8:{i:0;s:4:"name";i:1;s:7:"address";i:2;s:7:"city_id";i:3;s:7:"area_id";i:4;s:8:"location";i:5;s:6:"phones";i:6;s:9:"timeslots";i:7;s:8:"weekdays";}s:10:"*guarded";a:1:{i:0;s:1:"*";}s:12:"translatable";a:2:{i:0;s:4:"name";i:1;s:7:"address";}s:20:"*translationLocale";N;}}s:28:"*escapeWhenCastingToString";b:0;}) on duplicate key update `expiration` = values(`expiration`), `key` = values(`key`), `value` = values(`value`))
@MatanYadaev
Copy link
Owner

Try returning an array instead of returning a collection. ->get()->toArray()

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants