We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
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`))
The text was updated successfully, but these errors were encountered:
Try returning an array instead of returning a collection. ->get()->toArray()
->get()->toArray()
Sorry, something went wrong.
No branches or pull requests
try to cache any model using db cache
Ex:
Error:
The text was updated successfully, but these errors were encountered: