sessions to big

[klevans2015]

Just a general question, I have some 400 + categories but need more to the normally book qty of categories its about 3000 ish, when I have all categories in, the session key blob is too big and I have a mysql warning. Is there anyway to remove category info from sessions blob that stores in the database ? so the sessions are not huge

400 + cats

0x6332566A64584A7064486C556232746C626E787A4F6A4D794F6949354D5755314E444A694E6A6B 775932513359545669595755784F4756684E5449314D3259784E6A41355A534937624746755A3356 685A325638637A6F334F694A6C626D647361584E6F496A74735957356E6457466E5A584E66615752 38637A6F784F694978496A74735957356E6457466E5A584E665932396B5A58787A4F6A4936496D56 75496A747A5A57786C5933526C5A46396962336838637A6F784D7A6F69593239755A6D6C6E64584A 6864476C7662694937614852746246396C5A476C3062334A6663484A6C5A6D56795A57356A5A5639 7A6447463064584E38637A6F304F694A4F54303546496A74685A473170626C39705A48787A4F6A45 36496A45694F77########

3000 + cats

0x6332566A64584A7064486C556232746C626E787A4F6A4D794F6949354D575A6C4F5441785A444A 6A4D545A6C593251334E5459794E4455345A4441344F5455324E6A6B77595349375933567A644739 745A584A7A58326876633352665957526B636D567A6333787A4F6A51784F694A6F62334E304F4445 744D5451344C544D334C5445334D693570626931685A4752794C6D4A306233426C626E6476636D78 6B4C6D4E76625349375932467964456C4566484D364D446F69496A746A59584A30664538364D5449 36496E4E6F623342776157356E51324679644349364D54493665334D364F446F6959323975644756 7564484D694F3245364D44703766584D364E546F6964473930595777694F326B364D44747A4F6A59 36496E646C6157646F6443493761546F774F334D364E6A6F695932467964456C45496A744F4F334D 364D544936496D4E76626E526C626E526664486C775A534937596A6F774F334D364D546736496D5A 795A5756666332687063484270626D64666158526C6253493761546F774F334D364D6A4136496D5A 795A5756666332687063484270626D6466643256705A326830496A74704F6A4137637A6F784F546F 695A6E4A6C5A56397A61476C7763476C755A313977636D6C6A5A53493761546F774F334D364D5451 36496D5276643235736232466B58324E7664573530496A74704F6A4137637A6F794D6A6F69644739 3059577866596D566D62334A6C5832527063324E76645735306379493761546F774F334D364D6A49 36496D52706333427359586C665A475669645764666257567A6332466E5A584D694F3249364D4474 7A4F6A497A4F694A6D6247466E5832523163477870593246305A5639746332647A58334E6C644349 37596A6F774F33316A6147566A61313932595778705A48787A4F6A5136496E5279645755694F3235 68646D6C6E5958527062323538547A6F784E7A6F69626D46326157646864476C76626B6870633352 76636E6B694F6A493665334D364E446F69634746306143493759546F784F6E74704F6A413759546F 304F6E747A4F6A5136496E42685A3255694F334D364E546F696157356B5A5867694F334D364E446F 696257396B5A534937637A6F324F694A4F54303554553077694F334D364D7A6F695A325630496A74 684F6A41366533317A4F6A5136496E4276633351694F3245364D44703766583139637A6F344F694A 7A626D4677633268766443493759546F774F6E743966577868626D64315957646C66484D364E7A6F 695A57356E62476C7A61434937624746755A3356685A32567A58326C6B66484D364D546F694D5349 37624746755A3356685A32567A58324E765A475638637A6F794F694A6C6269493759335679636D56 7559336C38637A6F7A4F694A48516C41694F3352765A47463558326C7A66484D364D544136496A49 774D5459744D5445744D6A4D694F3356775A4746305A55563463476C79595852706232357A664749 364D54746A5958526C5A32397965563930636D566C664538364D6A4136496C4E70625842735A554E 686447566E62334A705A584E55636D566C496A6F344F6E747A4F6A457A4F694A6A5958526C5A3239 7965563930636D566C496A74684F6A517A4D7A703761546F784F3245364E7A7037637A6F304F694A 755957316C496A747A4F6A45794F694A42636D4E6F6158526C59335231636D55694F334D364F546F 69634746795A57353058326C6B496A747A4F6A4536496A41694F334D364E446F6963474630614349 3759546F784F6E74704F6A4137637A6F784F694978496A7439637A6F344F694A7A64574A66593246 306379493759546F784E54703761546F774F334D364D6A6F694D7A59694F326B364D54747A4F6A49 36496A4D33496A74704F6A4937637A6F794F6949794E69493761546F7A4F334D364D6A6F694D7A4D 694F326B364E44747A4F6A4936496A4930496A74704F6A5537637A6F794F6949794E53493761546F 324F334D364D6A6F694D6A4D694F326B364E7A747A4F6A4936496A4935496A74704F6A6737637A6F 794F6949794F43493761546F354F334D364D6A6F694D7A41694F326B364D544137637A6F794F6949 7A4D53493761546F784D54747A4F6A4936496A4D79496A74704F6A45794F334D364D6A6F694D6A63 694F326B364D544D37637A6F794F69497A4E43493761546F784E44747A4F6A4936496A4D31496A74 39637A6F7A4F694A7A645749694F334D364E7A6F696147467A58334E3159694937637A6F314F694A 6A5547463061434937637A6F784F694978496A747A4F6A5536496D35515958526F496A747A4F6A45 36496A45694F3331704F6A413759546F304F6E747A4F6A6736496E4E31596C396A5958527A496A74 684F6A49324F6E74704F6A4137637A6F784F694978496A74704F6A4537637A6F784F694979496A74 704F6A4937637A6F304F6949784D445131496A74704F6A4D37637A6F784F69497A496A74704F6A51 37637A6F784F694930496A74704F6A5537637A6F784F694931496A74704F6A5937637A6F784F6949 32496A74704F6A6337637A6F304F6949784D445178496A74704F6A6737637A6F784F694933496A74 704F6A6B37637A6F784F694934496A74704F6A45774F334D364D546F694F53493761546F784D5474 7A4F6A4936496A4577496A74704F6A45794F334D364D6A6F694D5445694F326B364D544D37637A6F 794F6949784D69493761546F784E44747A4F6A4936496A457A496A74704F6A45314F334D364D6A6F 694D5451694F326B364D545937637A6F794F6949784E53493761546F784E7A747A4F6A4936496A45 32496A74704F6A45344F334D364D6A6F694D5463694F326B364D546B37637A6F304F6949784D444D 77496A74704F6A49774F334D364D6A6F694D5467694F326B364D6A4537637A6F794F6949784F5349 3761546F794D6A747A4F6A4936496A4977496A74704F6A497A4F334D364D6A6F694D6A45694F326B 364D6A5137637A6F794F6949794D69493761546F794E54747A4F6A5136496A45774D6A6B694F3331 7A4F6A4D36496E4E3159694937637A6F334F694A6F59584E6663335669496A747A4F6A5536496D4E 515958526F496A74704F6A4137637A6F314F694A75554746306143493761546F774F3331704F6A49 3759546F334F6E747A4F6A5136496D3568625755694F334D364D7A6F6951584A30496A747A4F6A6B 36496E4268636D5675644639705A434937637A6F784F694977496A747A4F6A5136496E4268644767 694F3245364D54703761546F774F334D364D546F694D69493766584D364F446F696333566958324E 6864484D694F3245364D7A633665326B364D44747A4F6A4936496A5133496A74704F6A4537637A6F 794F6949304F43493761546F794F334D364D6A6F694E7A41694F326B364D7A747A4F6A4936496A55 35496A74704F6A5137637A6F794F6949314D79493761546F314F334D364D6A6F694E6A45694F326B 364E6A747A4F6A4936496A6378496A74704F6A6337637A6F794F6949324D69493761546F344F334D 364D6A6F694E5441694F326B364F54747A4F6A4936496A597A496A74704F6A45774F334D364D6A6F 694E6A51694F326B364D544537637A6F794F6949304D53493761546F784D6A747A4F6A4936496A51 79496A74704F6A457A4F334D364D6A6F694E444D694F326B364D545137637A6F794F6949334D6949 3761546F784E54747A4F6A4936496A5130496A74704F6A45324F334D364D6A6F694E6A55694F326B 364D546337637A6F794F6949304F53493761546F784F44747A4F6A4936496A637A496A74704F6A45 354F334D364D6A6F694E4455694F326B364D6A4137637A6F794F69497A4F53493761546F794D5474 7A4F6A4936496A6330496A74704F6A49794F334D364D6A6F694E4459694F326B364D6A4D37637A6F 794F6949314D53493761546F794E44747A4F6A4936496A5932496A74704F6A49314F334D364D6A6F 694E5449694F326B364D6A5937637A6F794F6949334E53493761546F794E7A747A4F6A4936496A59 77496A74704F6A49344F334D364D6A6F694E7A59694F326B364D6A6B37637A6F794F6949314E4349 3761546F7A4D44747A4F6A4936496A5933496A74704F6A4D784F334D364D6A6F694E5455694F326B 364D7A4937637A6F794F6949324F43493761546F7A4D7A747A4F6A4936496A5532496A74704F6A4D 304F334D364D6A6F694E5463694F326B364D7A5537637A6F794F6949324F53493761546F7A4E6A74 7A4F6A4936496A5177496A7439637A6F7A4F694A7A645749694F334D364E7A6F696147467A58334E 3159694937637A6F314F694A6A5547463061434937637A6F784F694979496A747A4F6A5536496D35 515958526F496A747A4F6A4536496A49694F3331704F6A45774E44553759546F334F6E747A4F6A51 36496D3568625755694F334D364D6A6B36496B4A70623264795958426F6553416D595731774F7942 4264585276596D6C765A334A6863476835496A747A4F6A6B36496E4268636D5675644639705A4349 37637A6F784F694977496A747A4F6A5136496E4268644767694F3245364D54703761546F774F334D 364E446F694D5441304E53493766584D364F446F696333566958324E6864484D694F3245364D7A51 3665326B364D44747A4F6A5136496A45774E6A6B694F326B364D54747A4F6A5136496A45774E4463 694F326B364D6A747A4F6A5136496A45774E446B694F326B364D7A747A4F6A5136496A45774E5441 694F326B364E44747A4F6A5136496A45774E7A41694F326B364E54747A4F6A5136496A45774E7A55 694F326B364E6A747A4F6A5136496A45774E4467694F326B364E7A747A4F6A5136496A45774E7A45 694F326B364F44747A4F6A5136496A45774E6A55694F326B364F54747A4F6A5136496A45774E5445 694F326B364D544137637A6F304F6949784D446332496A74704F6A45784F334D364E446F694D5441 304E69493761546F784D6A747A4F6A5136496A45774E5449694F326B364D544D37637A6F304F6949 784D44637A496A74704F6A45304F334D364E446F694D5441324E69493761546F784E54747A4F6A51 36496A45774E7A63694F326B364D545937637A6F304F6949784D44557A496A74704F6A45334F334D 364E446F694D5441324D79493761546F784F44747A4F6A5136496A45774E5451694F326B364D546B 37637A6F304F6949784D446330496A74704F6A49774F334D364E446F694D5441334F53493761546F 794D54747A4F6A5136496A45774E7A49694F326B364D6A4937637A6F304F6949784D445531496A74 704F6A497A4F334D364E446F694D5441314E69493761546F794E44747A4F6A5136496A45774E5463 694F326B364D6A5537637A6F304F6949784D445534496A74704F6A49324F334D364E446F694D5441 324E43493761546F794E7A747A4F6A5136496A45774E546B694F326B364D6A6737637A6F304F6949 784D445977496A74704F6A49354F334D364E446F694D5441324D53493761546F7A4D44747A4F6A51 36496A45774E7A67694F326B364D7A4537637A6F304F6949784D445933496A74704F6A4D794F334D 364E446F694D5441324D69493761546F7A4D7A747A4F6A5136496A45774E6A67694F33317A4F6A4D 36496E4E3159694937637A6F334F694A6F59584E6663335669496A747A4F6A5536496D4E51595852 6F496A747A4F6A5136496A45774E4455694F334D364E546F69626C4268644767694F334D364E446F 694D5441304E53493766576B364D7A74684F6A633665334D364E446F69626D46745A534937637A6F 794D446F69516E567A6157356C63334D674A694246593239756232317059334D694F334D364F546F 69634746795A57353058326C6B496A747A4F6A4536496A41694F334D364E446F6963474630614349 3759546F784F6E74704F6A4137637A6F784F69497A496A7439637A6F344F694A7A64574A66593246 306379493759546F344F6E74704F6A4137637A6F794F6949344D43493761546F784F334D364D6A6F 694F4445694F326B364D6A747A4F6A4936496A677A496A74704F6A4D37637A6F794F6949334E7949 3761546F304F334D364D6A6F694F4451694F326B364E54747A4F6A4936496A6335496A74704F6A59 37637A6F794F6949344D69493761546F334F334D364D6A6F694E7A67694F33317A4F6A4D36496E4E 3159694937637A6F334F694A6F59584E6663335669496A747A4F6A5536496D4E515958526F496A74 7A4F6A4536496A4D694F334D364E546F69626C4268644767694F334D364D546F694D79493766576B 364E4474684F6A633665334D364E446F69626D46745A534937637A6F354F694A4462323177645852 6C636E4D694F334D364F546F69634746795A57353058326C6B496A747A4F6A4536496A41694F334D 364E446F69634746306143493759546F784F6E74704F6A4137637A6F784F694930496A7439637A6F 344F694A7A64574A66593246306379493759546F784D54703761546F774F334D364D6A6F694F5451 694F326B364D54747A4F6A4936496A6733496A74704F6A4937637A6F794F6949354D69493761546F 7A4F334D364D6A6F694F4455694F326B364E44747A4F6A4936496A6B31496A74704F6A5537637A6F 794F6949354D53493761546F324F334D364D6A6F694F4459694F326B364E7A747A4F6A4936496A67 35496A74704F6A6737637A6F794F6949344F43493761546F354F334D364D6A6F694F5441694F326B 364D544137637A6F794F6949354D79493766584D364D7A6F6963335669496A747A4F6A6336496D68 686331397A645749694F334D364E546F6959314268644767694F334D364D546F694E434937637A6F 314F694A755547463061434937637A6F784F694930496A743961546F314F3245364E7A7037637A6F 304F694A755957316C496A747A4F6A5936496B526C63326C6E62694937637A6F354F694A7759584A 6C626E5266615751694F334D364D546F694D434937637A6F304F694A775958526F496A74684F6A45 3665326B364D44747A4F6A4536496A55694F33317A4F6A6736496E4E31596C396A5958527A496A74 684F6A45304F6E74704F6A4137637A6F794F6949354E79493761546F784F334D364D6A6F694F5467 694F326B364D6A747A4F6A4936496A6B35496A74704F6A4D37637A6F7A4F6949784D4441694F326B 364E44747A4F6A4D36496A45774D53493761546F314F334D364D7A6F694D544179496A74704F6A59 37637A6F794F6949354E69493761546F334F334D364D7A6F694D54417A496A74704F6A6737637A6F 7A4F6949784D4451694F326B364F54747A4F6A4D36496A45774E53493761546F784D44747A4F6A4D 36496A45774E69493761546F784D54747A4F6A4D36496A45774E79493761546F784D6A747A4F6A4D 36496A45774F43493761546F784D7A747A4F6A4D36496A45774F53493766584D364D7A6F69633356 69496A747A4 ect etc etc etc

the blob is evern to big to put in here about 236134 Chartres in length
you can see the issue.

Any help would be cool

[carlwhat]

have you thought about altering the table?

ALTER TABLE `sessions`
CHANGE `value` `value` longblob NOT NULL AFTER `expiry`;

and what version of Zen Cart are you using?

[klevans2015]

Yep already altered table still no effect

get this in the log "Got a packet bigger than 'max_allowed_packet' bytes" the bytes are massive so wanted to find away round this as I don`t think they will alter the max_allowed_packet to more then 16Mb but still if this is passing over 16Mb as a session size each time is a little much don`t you think.

The full length of a session key I just checked was 524,726 that`s a lot of character`s

Just wanted to find a way to leave the cat info out of the sessions as its not really needed from what I would think as a working model for a store ?

[mc12345678]

And ZC version/PHP version?

[klevans2015]

sorry its v1.5.5b running PHP version: 5.6.27

[mc12345678]

sorry its v1.5.5b running PHP version: 5.6.27

What plugins/mods are applied? Template alterations? By short review don't see how categories even come into play with a default zc store. Does the same issue occur if temporarily use a default (plain) template?

[torvista]

I have no idea about your problem, but I have 2210 categories and the session blob in my sessions table is between 288 B and 2.8 KiB.

[DrByte]

get this in the log "Got a packet bigger than 'max_allowed_packet' bytes" the bytes are massive so wanted to find away round this as I don`t think they will alter the max_allowed_packet to more then 16Mb but still if this is passing over 16Mb as a session size each time is a little much don`t you think.

The full length of a session key I just checked was 524,726 that`s a lot of character`s

524,726 characters is nowhere close to 16Mb.

"max_allowed_packet" is not the same as session size.

Just wanted to find a way to leave the cat info out of the sessions as its not really needed from what I would think as a working model for a store ?

I'm curious what about your store is inserting the category data into the sessions in the first place.

[klevans2015]

That`s the only thing changed was the Cat info I went from 432 Cats to over 3k of cats and that`s when I had the error, I put the table back to old cats and the error goes and the blobs are small again.

Ruining tableau_1_6_6 as skin only mod added is Sphinx i modded the search to work with this other than that nothing added.

But as I put the cats to 3192 I get 524,726 characters Blobs when I put it to 452 I get 530 characters Blobs.



Log info from error also a warning is displayed on the webpage when I go to a item "Warning MySQL error"

[23-Nov-2016 10:48:54 Europe/London] Request URI: /, IP address: **.***.**.***
#1 trigger_error() called at [/var/www/vhosts/jazmin-books.co.uk/httpdocs/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/var/www/vhosts/jazmin-books.co.uk/httpdocs/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/var/www/vhosts/jazmin-books.co.uk/httpdocs/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/var/www/vhosts/jazmin-books.co.uk/httpdocs/includes/functions/sessions.php:69]
#5 _sess_write()
#6 session_write_close() called at [/var/www/vhosts/jazmin-books.co.uk/httpdocs/includes/application_bottom.php:16]
#7 require(/var/www/vhosts/jazmin-books.co.uk/httpdocs/includes/application_bottom.php) called at [/var/www/vhosts/jazmin-books.co.uk/httpdocs/index.php:105]

[23-Nov-2016 10:48:54 Europe/London] PHP Fatal error: 1153:Got a packet bigger than 'max_allowed_packet' bytes :: insert into sessions (sesskey, expiry, `value`)
values ('4cekg0dojc9v8391vis1sha2k4', 1479899574, 'c2VjdXJpdHlUb2tlbnxzOjMyOiJmYTRkNGY2YjZmNWFjYTA0NjRj6MzoiMzY0IjtpOjI4O3M6MzoiMz Y1IjtpOjI5O3M6MzoiMzY2IjtpOjMwO3M6MzoiMzY3IjtpOjMxO3M6MzoiMzY4IjtpOjMyO3M6MzoiMz Y5IjtpOjMzO3M6MzoiMzcwIjtpOjM0O3M6MzoiMzcxIjtpOjM1O3M6MzoiMzcyIjtpOjM2O3M6MzoiMz czIjtpOjM3O3M6MzoiMzc0IjtpOjM4O3M6MzoiMzc1IjtpOjM5O3M6MzoiMzc2IjtpOjQwO3M6MzoiMz c3IjtpOjQxO3M6MzoiMzc4IjtpOjQyO3M6MzoiMzc5IjtpOjQzO3M6MzoiMzgwIjtpOjQ0O3M6MzoiMz gxIjtpOjQ1O3M6MzoiMzgyIjtpOjQ2O3M6MzoiMzgzIjtpOjQ3O3M6MzoiMzg0IjtpOjQ4O3M6MzoiMz g1IjtpOjQ5O3M6MzoiMzg2IjtpOjUwO3M6MzoiMzg3IjtpOjUxO3M6MzoiMzg4IjtpOjUyO3M6MzoiMz g5IjtpOjUzO3M6MzoiMzkwIjtpOjU0O3M6MzoiMzkxIjtpOjU1O3M6MzoiMzkyIjtpOjU2O3M6MzoiMz kzIjtpOjU3O3M6MzoiMzk0IjtpOjU4O3M6MzoiMzk1IjtpOjU5O3M6MzoiMzk2IjtpOjYwO3M6MzoiMz k3IjtpOjYxO3M6MzoiMzk4IjtpOjYyO3M6MzoiMzk5IjtpOjYzO3M6MzoiNDAwIjtpOjY0O3M6MzoiND AxIjtpOjY1O3M6MzoiNDAyIjtpOjY2O3M6MzoiNDAzIjtpOjY3O3M6MzoiNDA0IjtpOjY4O3M6MzoiND A1IjtpOjY5O3M6MzoiNDA2IjtpOjcwO3M6MzoiNDA3IjtpOjcxO3M6MzoiNDA4IjtpOjcyO3M6MzoiND A5IjtpOjczO3M6MzoiNDEwIjtpOjc0O3M6MzoiNDExIjtpOjc1O3M6MzoiNDEyIjtpOjc2O3M6MzoiND EzIjtpOjc3O3M6MzoiNDE0IjtpOjc4O3M6MzoiNDE1IjtpOjc5O3M6MzoiNDE2IjtpOjgwO3M6MzoiND E3IjtpOjgxO3M6MzoiNDE4IjtpOjgyO3M6MzoiNDE5Ijt9czozOiJzdWIiO3M6NzoiaGFzX3N1YiI7cz o1OiJjUGF0aCI7czoxOiI4IjtzOjU6Im5QYXRoIjtzOjE6IjgiO31pOjc7YTo3OntzOjQ6Im5hbWUiO3 M6ODoiQ29va2luZyAiO3M6OToicGFyZW50X2lkIjtzOjE6IjAiO3M6NDoicGF0aCI7YToxOntpOjA7cz oxOiI3Ijt9czo4OiJz**************************ETC ETC ETC')
ON DUPLICATE KEY UPDATE `value`='c2VjdXJpdHlUb2tlbnxzOjMyOiJmYTRkNGY2YjZmNWFjYTA0NjRjMTEwOGY0MWViNDc2NSI 7Y3VzdG9tZMjoiNDgiO2k6MTtzOjQ6IjE4OTciO31zOjM6InN1YiI7czo2OiJub19zdWIiO3M6NToiY1 BhdGgiO3M6NzoiNDhfMTg5NyI7czo1OiJuUGF0aCI7czo3OiI0OF8xODk3Ijt9aToxODk4O2E6Njp7cz o0OiJuYW1lIjtzOjEwOiJOYXZpZ2F0aW9uIjtzOjk6InBhcmVudF9pZCI7czoyOiI0OCI7czo0OiJwYX RoIjthOjI6e2k6MDtzOjI6IjQ4IjtpOjE7czo0OiIxODk4Ijt9czozOiJzdWIiO3M6Njoibm9fc3ViIj tzOjU6ImNQYXRoIjtzOjc6IjQ4XzE4OTgiO3M6NToiblBhdGgiO3M6NzoiNDhfMTg5OCI7fWk6MTg5OT thOjY6e3M6NDoibmFtZSI7czoyMToiUHVibGljIFRyYW5zcG9ydGF0aW9uIjtzOjk6InBhcmVudF9pZC I7czoyOiI0OCI7czo0OiJwYXRoIjthOjI6e2k6MDtzOjI6IjQ4IjtpOjE7czo0OiIxODk5Ijt9czozOi JzdWIiO3M6Njoibm9fc3ViIjtzOjU6ImNQYXRoIjtzOjc6IjQ4XzE4OTkiO3M6NToiblBhdGgiO3M6Nz oiNDhfMTg5OSI7fWk6MTkwMDthOjY6e3M6NDoibmFtZSI7czo5OiJSYWlscm9hZHMiO3M6OToicGFyZW 50X2lkIjtzOjI6IjQ4IjtzOjQ6InBhdGgiO2E6Mjp7aTowO3M6MjoiNDgiO2k6MTtzOjQ6IjE5MDAiO3 1zOjM6InN1YiI7czo2OiJub19zdWIiO3M6NToiY1BhdGgiO3M6NzoiNDhfMTkwMCI7czo1OiJuUGF0aC I7czo3OiI0OF8xOTAwIjt9aToxOTAxO2E6Njp7czo0OiJuYW1lIjtzOjIwOiJTaGlwcyAmIFNoaXBidW lsZGluZyI7czo5OiJwYXJlbnRfaWQiO3M6MjoiNDgiO3M6NDoicGF0aCI7YToyOntpOjA7czoyOiI0OC I7aToxO3M6NDoiMTkwMSI7fXM6Mzoic3ViIjtzOjY6Im5vX3N1YiI7czo1OiJjUGF0aCI7czo3OiI0OF 8xOTAxIjtzOjU6Im5QYXRoIjtzOjc6IjQ4XzE5MDEiO31pOjE5MzM7YTo2OntzOjQ6Im5hbWUiO3M6OT oiRXNwaW9uYWdlIjtzOjk6InBhcmVudF9pZCI7czoyOiI0OSI7czo0OiJwYXRoIjthOjI6e2k6MDtzOj I6IjQ5IjtpOjE7czo0OiIxOTMzIjt9czozOiJzdWIiO3M6Njoibm9fc3ViIjtzOjU6ImNQYXRoIjtzOj c6IjQ5XzE5MzMiO3M6NToiblBhdGgiO3M6NzoiNDlfMTkzMyI7fWk6MTkzNDthOjY6e3M6NDoibmFtZS I7czoxOToiSG9heGVzICYgRGVjZXB0aW9ucyI7czo5OiJwYXJlbnRfaWQiO3M6MjoiNDkiO3M6NDoicG F0aCI7YToyOntpOjA7czoyOiI0OSI7aToxO3M6NDoiMTkzNCI7fXM6Mzoic3ViIjtzOjY6Im5vX3N1Yi I7czo1OiJjUGF0aCI7czo3OiI0OV8xOTM0IjtzOjU6Im5QYXRoIjtzOjc6IjQ5XzE5MzQiO31pOjE5Mz U7YTo2OntzOjQ6Im5hbWUiO3M6NjoiTXVyZGVyIjtzOjk6InBhcmVudF9pZCI7czoyOiI0OSI7czo0Oi JwYXRoIjthOjI6e2k6MDtzOjI6IjQ5IjtpOjE7czo0OiIxOTM1Ijt9czozOiJzdWIiO3M6Njoibm9fc3 ViIjtzOjU6ImNQYXRoIjtzOjc6IjQ5XzE5MzUiO3M6NToiblBhdGgiO3M6NzoiNDlfMTkzNSI7fWk6MT kzNjthOjY6e3M6NDoibmFtZSI7czoxNToiT3JnYW5pemVkIENyaW1lIjtzOjk6InBhcmVudF9pZCI7cz oyOiI0OSI7czo0OiJwYXRoIjthOjI6e2k6MDtzOjI6IjQ5IjtpOjE7czo0OiIxOTM2Ijt9czozOiJzdW IiO3M6Njoibm9fc3ViIjtzOjU6ImNQYXRoIjtzOjc6IjQ5XzE5MzYiO3M6NToiblBhdGgiO3M6NzoiND lfMTkzNiI7fWk6MTkzNzthOjY6e3M6NDoibmFtZSI7czoxODoiV2hpdGUgQ29sbGFyIENyaW1lIjtzOj k6InBhcmVudF9pZCI7czoyOiI0OSI7czo0OiJwYXRoIjthOjI6e2k6MDtzOjI6IjQ5IjtpOjE7czo0Oi IxOTM3Ijt9czozOiJzdWIiO3M6Njoibm9fc3ViIjtzOjU6ImNQYXRoIjtzOjc6IjQ5XzE5MzciO3M6NT oiblBhdGgiO3M6NzoiNDlfMTkzNyI7fWk6MTkwMjthOjY6e3M6NDoibmFtZSI7czozMjoiQWR2ZW50dX JlwqBzZWXCoFNwZWNpYWwgSW50ZXJlc3QiO3M6OToicGFyZW50X2lkIjtzOjI6IjUwIjtzOjQ6InBhdG giO2E6Mjp7aTowO3M6MjoiNTAiO2k6MTtzOjQ6IjE5MDIiO31zOjM6InN1YiI7czo2OiJub19zdWIiO3 M6NToiY1BhdGgiO3M6NzoiNTBfMTkwMiI7czo1OiJuUGF0aCI7czo3OiI1MF8xOTAyIjt9aToxOTAzO2 E6Njp7czo0OiJuYW1lIjtzOjIzOiJBbXVzZW1lbnQgJiBUaGVtZSBQYXJrcyI7czo5OiJwYXJlbnRfaW QiO3M6MjoiNTAiO3M6NDoicGF0aCI7YToyOntpOjA7czoyOiI1MCI7aToxO3M6NDoiMTkwMyI7fXM6Mz oic3ViIjtzOjY6Im5vX3N1YiI7czo1OiJjUGF0aCI7czo3OiI1MF8xOTAzIjtzOjU6Im5QYXRoIjtzOj c6IjUwXzE5MDMiO31pOjE5MDQ7YTo2OntzOjQ6Im5hbWUiO3M6MzA6IkFudGFyY3RpY2HCoHNlZcKgUG 9sYXIgUmVnaW9ucyI7czo5OiJwYXJlbnRfaWQiO3M6MjoiNTAiO3M6NDoicGF0aCI7YToyOntpOjA7cz oyOiI1MCI7aToxO3M6NDoiMTkwNCI7fXM6Mzoic3ViIjtzOjY6Im5vX3N1YiI7czo1OiJjUGF0aCI7cz o3OiI1MF8xOTA0IjtzOjU6Im5QYXRoIjtzOjc6IjUwXzE5MDQiO31pOjE5MDU7YTo2OntzOjQ6Im5hbW UiO3M6MTk6IkF1c3RyYWxpYSAmIE9jZWFuaWEiO3M6OToicGFyZW50X2lkIjtzOjI6IjUwIjtzOjQ6In BhdGgiO2E6Mjp7aTowO3M6MjoiNTAiO2k6MTtzOjQ6IjE5MDUiO31zOjM6InN1YiI7czo2OiJub19zdW IiO3M6NToiY1BhdGgiO3M6NzoiNTBfMTkwNSI7czo1OiJuUGF0aCI7czo3OiI1MF8xOTA1Ijt9aToxOT A2O2E6Njp7czo0OiJuYW1lIjtzOjE1OiJCZWQgJiBCcmVha2Zhc3QiO3M6OToicGFyZW50X2lkIjtzOj I6IjUwIjtzOjQ6InBhdGgiO2E6Mjp7aTowO3M6MjoiNTAiO2k6MTtzOjQ6IjE5MDYiO31zOjM6InN1Yi I7czo2OiJub19zdWIiO3M6NToiY1BhdGgiO3M6NzoiNTBfMTkwNiI7czo1OiJuUGF0aCI7czo3OiI1MF 8xOTA2Ijt9aToxOTA3O2E6Njp7czo0OiJuYW1lIjtzOjY6IkJ1ZGdldCI7czo5OiJwYXJlbnRfaWQiO3 M6MjoiNTAiO3M6NDoicGF0aCI7YToyOntpOjA7czoyOiI1MCI7aToxO3M6NDoiMTkwNyI7fXM6Mzoic3 ViIjtzOjY6Im5vX3N1YiI7czo1OiJjUGF0aCI7czo3OiI1MF8xOTA3IjtzOjU6Im5QYXRoIjtzOjc6Ij UwXzE5MDciO31pOjE5MDg7YTo2OntzOjQ6Im5hbWUiO3M6MzQ6IkNhbXBncm91bmRzwqBzZWXCoFBhcm tzICYgQ2FtcGdyb3UiO3M6OToicGFyZW50X2lkIjtzOjI6IjUwIjtzOjQ6InBhdGgiO2E6Mjp7aTowO3 M6MjoiNTAiO2k6MTtzOjQ6IjE5MDgiO31zOjM6InN1YiI7czo2OiJub19zdWIiO3M6NToiY1BhdGgiO3 M6NzoiNTBfMTkwOCI7czo1OiJuUGF0aCI7czo3OiI1MF8xOTA4Ijt9aToxOTA5O2E6Njp7czo0OiJuYW 1lIjtzOjIzOiJDYXJpYmJlYW4gJiBXZXN0IEluZGllcyI7czo5OiJwYXJlbnRfaWQiO3M6MjoiNTAiO3 M6NDoicGF0aCI7YToyOntpOjA7czoyOiI1MCI7aToxO3M6NDoiMTkwOSI7fXM6Mzoic3ViIjtzOjY6Im 5vX3N1YiI7czo1OiJjUGF0aCI7czo3OiI1MF8xOTA5IjtzOjU6Im5QYXRoIjtzOjc6IjUwXzE5MDkiO3 1pOjE5MTA7YTo2OntzOjQ6Im5hbWUiO3M6MTU6IkNlbnRyYWwgQW1lcmljYSI7czo5OiJwYXJlbnRfaW QiO3M6MjoiNTAiO3M6NDoicGF0aCI7YToyOntpOjA7czoyOiI1MCI7aToxO3M6NDoiMTkxMCI7fXM6Mz oic3ViIjtzOjY6Im5vX3N1YiI7czo1OiJjUGF0aCI7czo3OiI1MF8xOTEwIjtzOjU6Im5QYXRoIjtzOj c6IjUwXzE5MTAiO31pOjE5MTE7YTo2OntzOjQ6Im5hbWUiO3M6NzoiQ3J1aXNlcyI7czo5OiJwYXJlbn RfaWQiO3M6MjoiNTAiO3M6NDoicGF0aCI7YToyOntpOjA7czoyOiI1MCI7aToxO3M6NDoiMTkxMSI7fX M6Mzoic3ViIjtzOjY6Im5vX3N1YiI7czo1OiJjUGF0aCI7czo3OiI1MF8xOTExIjtzOjU6Im5QYXRoIj tzOjc6IjUwXzE5MTEiO31pOjE5MTI7YTo2OntzOjQ6Im5hbWUiO3M6MjA6IkVzc2F5cyAmIFRyYXZlbG 9ndWVzIjtzOjk6InBhcmVudF9pZCI7czoyOiI1MCI7czo0OiJwYXRoIjthOjI6e2k6MDtzOjI6IjUwIj tpOjE7czo0OiIxOTEyIjt9czozOiJzdWIiO3M6Njoibm9fc3ViIjtzOjU6ImNQYXRoIjtzOjc6IjUwXz E5MTIiO3M6NToiblBhdGgiO3M6NzoiNTBfMTkxMiI7fWk6MTkxMzthOjY6e3M6NDoibmFtZSI7czozND oiRmFtaWx5IFRyYXZlbMKgc2VlwqBTcGVjaWFsIEludGVyZSI7czo5OiJwYXJlbnRfaWQiO3M6MjoiNT AiO3M6NDoicGF0aCI7YToyOntpOjA7czoyOiI1MCI7aToxO3M6NDoiMTkxMyI7fXM6Mzoic3ViIjtzOj Y6Im5vX3N1YiI7czo1OiJjUGF0aCI7czo3OiI1MF8xOTEzIjtzOjU6Im5QYXRoIjtzOjc6IjUwXzE5MT MiO31pOjE5MTQ7YTo2OntzOjQ6Im5hbWUiO3M6MjM6IkZvcm1lciBTb3ZpZXQgUmVwdWJsaWNzIjtzOj k6InBhcmVudF9pZCI7czoyOiI1MCI7czo0OiJwYXRoIjthOjI6e2k6MDtzOjI6IjUwIjtpOjE7czo0Oi IxOTE0Ijt9czozOiJzdWIiO3M6Njoibm9fc3ViIjtzOjU6ImNQYXRoIjtzOjc6IjUwXzE5MTQiO3M6NT oiblBhdGgiO3M6NzoiNTBfMTkxNCI7fWk6MTkxNTthOjY6e3M6NDoibmFtZSI7czoxMzoiSGlrZXMgJi BXYWxrcyI7czo5OiJwYXJlbnRfaWQiO3M6MjoiNTAiO3M6NDoicGF0aCI7YToyOntpOjA7czoyOiI1MC I7aToxO3M6NDoiMTkxNSI7fXM6Mzoic3ViIjtzOjY6Im5vX3N1YiI7czo1OiJjUGF0aCI7czo3OiI1MF 8xOTE1IjtzOjU6Im5QYXRoIjtzOjc6IjUwXzE5MTUiO31pOjE5MTY7YTo2OntzOjQ6Im5hbWUiO3M6Mj I6IkhvdGVscywgSW5ucyAmIEhvc3RlbHMiO3M6OToicGFyZW50X2lkIjtzOjI6IjUwIjtzOjQ6InBhdG giO2E6Mjp7aTowO3M6MjoiNTAiO2k6MTtzOjQ6IjE5MTYiO31zOjM6InN1YiI7czo2OiJub19zdWIiO3 M6NToiY1BhdGgiO3M6NzoiNTBfMTkxNiI7czo1OiJuUGF0aCI7czo3OiI1MF8xOTE2Ijt9aToxOTE3O2 E6Njp7czo0OiJuYW1lIjtzOjE5OiJNYXBzICYgUm9hZCBBdGxhc2VzIjtzOjk6InBhcmVudF9pZCI7cz oyOiI1MCI7czo0OiJwYXRoIjthOjI6e2k6MDtzOjI6IjUwIjtpOjE7czo0OiIxOTE3Ijt9czozOiJzdW IiO3M6Njoibm9fc3ViIjtzOjU6ImNQYXRoIjtzOjc6IjUwXzE5MTciO3M6NToiblBhdGgiO3M6NzoiNT BfMTkxNyI7fWk6MTkxODthOjY6e3M6NDoibmFtZSI7czo2OiJNZXhpY28iO3M6OToicGFyZW50X2lkIj tzOjI6IjUwIjtzOjQ6InBhdGgiO2E6Mjp7aTowO3M6MjoiNTAiO2k6MTtzOjQ6IjE5MTgiO31zOjM6In N1YiI7czo2OiJub19zdWIiO3M6NToiY1BhdGgiO3M6NzoiNTBfMTkxOCI7czo1OiJuUGF0aCI7czo3Oi I1MF8xOTE4Ijt9aToxOTE5O2E6Njp7czo0OiJuYW1lIjtzOjMyOiJNdXNldW1zLCBUb3VycywgUG9pbn RzIG9mIEludGVyZSI7czo5OiJwYXJlbnRfaWQiO3M6MjoiNTAiO3M6NDoicGF0aCI7YToyOntpOjA7cz oyOiI1MCI7aToxO3M6NDoiMTkxOSI7fXM6Mzoic3ViIjtzOjY6Im5vX3N1YiI7czo1OiJjUGF0aCI7cz o3OiI1MF8xOTE5IjtzOjU6Im5QYXRoIjtzOjc6IjUwXzE5MTkiO31pOjE5MjA7YTo2OntzOjQ6Im5hbW UiO3M6MzQ6Ik5hdGlvbmFsIFBhcmtzwqBzZWXCoFBhcmtzICYgQ2FtcGciO3M6OToicGFyZW50X2lkIj tzOjI6IjUwIjtzOjQ6InBhdGgiO2E6Mjp7aTowO3M6MjoiNTAiO2k6MTtzOjQ6IjE5MjAiO31zOjM6In N1YiI7czo2OiJub19zdWIiO3M6NToiY1BhdGgiO3M6NzoiNTBfMTkyMCI7czo1OiJuUGF0aCI7czo3Oi I1MF8xOTIwIjt9aToxOTIxO2E6Njp7czo0OiJuYW1lIjtzOjMzOiJPY2VhbmlhwqBzZWXCoEF1c3RyYW xpYSAmIE9jZWFuaWEiO3M6OToicGFyZW50X2lkIjtzOjI6IjUwIjtzOjQ6InBhdGgiO2E6Mjp7aTowO3 M6MjoiNTAiO2k6MTtzOjQ6IjE5MjEiO31zOjM6InN1YiI7czo2OiJub19zdWIiO3M6NToiY1BhdGgiO3 M6NzoiNTBfMTkyMSI7czo1OiJuUGF0aCI7czo3OiI1MF8xOTIxIjt9aToxOTIyO2E6Njp7czo0OiJuYW 1lIjtzOjE5OiJQYXJrcyAmIENhbXBncm91bmRzIjtzOjk6InBhcmVudF9pZCI7czoyOiI1MCI7czo0Oi JwYXRoIjthOjI6e2k6MDtzOjI6IjUwIjtpOjE7czo0OiIxOTIyIjt9czozOiJzdWIiO3M6Njoibm9fc3 ViIjtzOjU6ImNQYXRoIjtzOjc6IjUwXzE5MjIiO3M6NToiblBhdGgiO3M6NzoiNTBfMTkyMiI7fWk6MT kyMzthOjY6e3M6NDoibmFtZSI7czoxMDoiUGljdG9yaWFscyI7czo5OiJwYXJlbnRfaWQiO3M6MjoiNT AiO3M6NDoicGF0aCI7YToyOntpOjA7czoyOiI1MCI7aToxO3M6NDoiMTkyMyI7fXM6Mzoic3ViIjtzOj Y6Im5vX3N1YiI7czo1OiJjUGF0aCI7czo3OiI1MF8xOTIzIjtzOjU6Im5QYXRoIjtzOjc6IjUwXzE5Mj MiO31pOjE5MjQ7YTo2OntzOjQ6Im5hbWUiO3M6MTE6IlJhaWwgVHJhdmVsIjtzOjk6InBhcmVudF9pZC I7czoyOiI1MCI7czo0OiJwYXRoIjthOjI6e2k6MDtzOjI6IjUwIjtpOjE7czo0OiIxOTI0Ijt9czozOi JzdWIiO3M6Njoibm9fc3ViIjtzOjU6ImNQYXRoIjtzOjc6IjUwXzE5MjQiO3M6NToiblBhdGgiO3M6Nz oiNTBfMTkyNCI7fWk6MTkyNTthOjY6e3M6NDoibmFtZSI7czoxNDoiUmVzb3J0cyAmIFNwYXMiO3M6OT oicGFyZW50X2lkIjtzOjI6IjUwIjtzOjQ6InBhdGgiO2E6Mjp7aTowO3M6MjoiNTAiO2k6MTtzOjQ6Ij E5MjUiO31zOjM6InN1YiI7czo2OiJub19zdWIiO3M6NToiY1BhdGgiO3M6NzoiNTBfMTkyNSI7czo1Oi JuUGF0aCI7czo3OiI1MF8xOTI1Ijt9aToxOTI2O2E6Njp7czo0OiJuYW1lIjtzOjExOiJSZXN0YXVyYW 50cyI7czo5OiJwYXJlbnRfaWQiO3M6MjoiNTAiO3M6NDoicGF0aCI7YToyOntpOjA7czoyOiI1MCI7aT oxO3M6NDoiMTkyNiI7fXM6Mzoic3ViIjtzOjY6Im5vX3N1YiI7czo1OiJjUGF0aCI7czo3OiI1MF8xOT I2IjtzOjU6Im5QYXRoIjtzOjc6IjUwXzE5MjYiO31pOjE5Mjc7YTo2OntzOjQ6Im5hbWUiO3M6MTE6Il JvYWQgVHJhdmVsIjtzOjk6InBhcmVudF9pZCI7czoyOiI1MCI7czo0OiJwYXRoIjthOjI6e2k6MDtzOj I6IjUwIjtpOjE7czo0OiIxOTI3Ijt9czozOiJzdWIiO3M6Njoibm9fc3ViIjtzOjU6ImNQYXRoIjtzOj c6IjUwXzE5MjciO3M6NToiblBhdGgiO3M6NzoiNTBfMTkyNyI7fWk6MTkyODthOjY6e3M6NDoibmFtZS I7czo2OiJSdXNzaWEiO3M6OToicGFyZW50X2lkIjtzOjI6IjUwIjtzOjQ6InBhdGgiO2E6Mjp7aTowO3 M6MjoiNTAiO2k6MTtzOjQ6IjE5MjgiO31zOjM6InN1YiI7czo2OiJub19zdWIiO3M6NToiY1BhdGgiO3 M6NzoiNTBfMTkyOCI7czo1OiJuUGF0aCI7czo3OiI1MF8xOTI4Ijt9aToxOTI5O2E6Njp7czo0OiJuYW 1lIjtzOjg6IlNob3BwaW5nIjtzOjk6InBhcmVudF9pZCI7czoyOiI1MCI7czo0OiJwYXRoIjthOjI6e2 k6MDtzOjI6IjUwIjtpOjE7czo0OiIxOTI5Ijt9czozOiJzdWIiO3M6Njoibm9fc3ViIjtzOjU6ImNQYX RoIjtzOjc6IjUwXzE5MjkiO3M6NToiblBhdGgiO3M6NzoiNTBfMTkyOSI7fWk6MTkzMDthOjY6e3M6ND oibmFtZSI7czoxMzoiU291dGggQW1lcmljYSI7czo5OiJwYXJlbnRfaWQiO3M6MjoiNTAiO3M6NDoicG F0aCI7YToyOntpOjA7czoyOiI1MCI7aToxO3M6NDoiMTkzMCI7fXM6Mzoic3ViIjtzOjY6Im5vX3N1Yi I7czo1OiJjUGF0aCI7czo3OiI1MF8xOTMwIjtzOjU6Im5QYXRoIjtzOjc6IjUwXzE5MzAiO31pOjE5Mz E7YTo2OntzOjQ6Im5hbWUiO3M6MTY6IlNwZWNpYWwgSW50ZXJlc3QiO3M6OToicGFyZW50X2lkIjtzOj I6IjUwIjtzOjQ6InBhdGgiO2E6Mjp7aTowO3M6MjoiNTAiO2k6MTtzOjQ6IjE5MzEiO31zOjM6InN1Yi I7czo2OiJub19zdWIiO3M6NToiY1BhdGgiO3M6NzoiNTBfMTkzMSI7czo1OiJuUGF0aCI7czo3OiI1MF 8xOTMxIjt9aToxOTMyO2E6Njp7czo0OiJuYW1lIjtzOjM0OiJXZXN0IEluZGllc8Kgc2VlwqBDYXJpYm JlYW4gJiBXZXN0IjtzOjk6InBhcmVudF9pZCI7czoyOiI1MCI7czo0OiJwYXRoIjthOjI6e2k6MDtzOj I6IjUwIjtpOjE7czo0OiIxOTMyIjt9czozOiJzdWIiO3M6Njoibm9fc3ViIjtzOjU6ImNQYXRoIjtzOj c6IjUwXzE5MzIiO3M6NToiblBhdGgiO3M6NzoiNTBfMTkzMiI7fX1zOjIxOiJpc19kZWVwZXN0X2NhdH NfYnVpbHQiO2I6MDtzOjExOiJwYXJlbnRfaHRtbCI7czowOiIiO3M6MTA6ImNoaWxkX2h0bWwiO3M6MD oiIjtzOjEwOiJjdXJyZW50X2lkIjtpOi0xO3M6MTY6ImV4Y2VwdGlvbmFsX2xpc3QiO2E6MDp7fXM6Nj oibmV3X2lkIjtOO3M6MTE6ImlzX2F0dGFjaGVkIjtiOjA7fXNlc3Npb25fY291bnRlcnxiOjE7Y3VzdG 9tZXJzX2lwX2FkZHJlc3N8czoxMzoiODEuMTQ4LjM3LjE3MiI7 ************** ETC ETC ETC', expiry=1479899574 ==> (as called by) /var/www/vhosts/jazmin-books.co.uk/httpdocs/includes/functions/sessions.php on line 69 <== in /var/www/vhosts/jazmin-books.co.uk/httpdocs/includes/classes/db/mysql/query_factory.php on line 167

[klevans2015]

Got the error fixed now and kept the cats under 3k still huge session blobs but moving in the right direction cheers for fast answers