frankl Posted October 25, 2017 Share Posted October 25, 2017 I'm wondering how sessions are stored in the osCommerce database Running osC2.3.4.1 Edge I'm looking at the 'value' column in the sessions table On my first store, every session is saved in the database like this sessiontoken|s:32:"c396b922a522bxxxxxx65dc2421d1f";cart|O:12:"shoppingCart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;} whereas on my second store sessions are saved like this uW36Mgev5bKV7Mc9H7ffnZwkxWSQEMECfefUZNQz8HahAg1gAxM4kSo99oow6m2-SZe7rWH3VAOQq92wiITy3vcPDjwnP-2VSxxxvOavsN6jasHLwVckR8vxyPq99xWZtgtOUiHEKoLZqpLUT2yIo7Ts9b5YZtM_AeAB8gAO5WcQ. The reason I ask is that on the second store some (only some) customers can't get past the checkout shipping page, it just keeps looping back and I'm wondering if it's sessions that are causing the problem. osCommerce user since 2003! Link to comment Share on other sites More sharing options...
Dan Cole Posted October 25, 2017 Share Posted October 25, 2017 @frankl Frank are you saying that both stores are running on osC2.3.4.1 Edge or that the way sessions are stored has changed in osC2.3.4.1 Edge? Dan Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
frankl Posted October 25, 2017 Author Share Posted October 25, 2017 @Dan Cole Both stores are running on osC2.3.4.1 Edge osCommerce user since 2003! Link to comment Share on other sites More sharing options...
Dan Cole Posted October 25, 2017 Share Posted October 25, 2017 Is one or both HTTPS? Dan Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
frankl Posted October 25, 2017 Author Share Posted October 25, 2017 Both HTTPS osCommerce user since 2003! Link to comment Share on other sites More sharing options...
Dan Cole Posted October 25, 2017 Share Posted October 25, 2017 Interesting. I'm now clueless...as usual . I wonder what's different. Are your sessions settings the same in each store...any major differences in the config files? Hopefully questions will help, since I don't have any answers. Dan Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
frankl Posted October 25, 2017 Author Share Posted October 25, 2017 Codebase is identical as far as sessions go. Both stores define('STORE_SESSIONS', 'mysql'); Store 1 is running on PHP 7.1.10 Store 2 is running on PHP 5.6.31 Not sure if that makes a difference Store 1 Admin -> Configuration -> Sessions Session Directory /home/user/public_html/includes/work/ Force Cookie Use False Check SSL Session ID False Check User Agent False Check IP Address False Prevent Spider Sessions True Recreate Session True Store 2 Admin -> Configuration -> Sessions Session Directory /home/user/public_html/includes/work/ Force Cookie Use False Check SSL Session ID False Check User Agent False Check IP Address False Prevent Spider Sessions True Recreate Session True osCommerce user since 2003! Link to comment Share on other sites More sharing options...
tgely Posted October 25, 2017 Share Posted October 25, 2017 What are the differents between datatable charsets and what are the database engines? Try to switch to file in configuration.php osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
frankl Posted October 25, 2017 Author Share Posted October 25, 2017 @tgely Both are Storage Engine InnoDB Collation utf8_unicode_ci ROW_FORMAT COMPACT Switching to file format writes this to file in site 1 (which runs on PHP 7.1) example: sessiontoken|s:32:"d24265704xxxdbb6a3b495a7c873619";cart|O:12:"shoppingCart":4:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_type";b:0;} and writes this to file in site 2 (which runs on PHP 5.6) example: TC1P4FZNgFqx6DeGh7Z4tlsSkwrIlWa_qciqB8FQEyqyCUl49zkvl_BmM_Nq34ahMKTyvVlrB0cb3_TYpzs7kK2zKWxU0Pt6h58Gl51Y1q8BrmJrxZoHC94C4QMWr3f2oh4OG3Jjfcof8x-zam5ZjDHEMCx04IUuZIM0VIHUyYE4yyLooeT2-LdKIGlRDB8fupXzx03VQxssqmuLRp5UPL1oTAxxx8v-aans36zuc9o_kZFZJo_nEBD1XSYebq3hW3f6BXO_Y0RdfVXRTln5qQ_zpI8BT4rczCDQkTFJRWGw4WtbHBSLf3cMweAOcGop5gCjQ-7HMf8Y-H2cf1B5ME3L1d8yImxxfBQxeuQV3e8wpOj_NdfcXapPawEqFMWIoDbE3fMyVwZ4LNj4m37x_QzPnEfeRuFEY5pPtcMYE9KBq_y6WMjRmwcqTERvxxxdh5bm5UI293yM7c-irCftQVIZzgd8G_yK1GAJxroI5V4sAvV6feWwm6OIwZxl6NMk8M2I_LsQ7mg7Ie8JYhvs-V3ZXoF3U23bJILNU3ZMFDrkMcWURHs_tTWirctjJRBI_nLRF6_GY8Y-4NCavEjtXOal4WVJylLk5Co7QdJObfz0_GLXimy89ELRCOnEGJU0zZgxxOGASruMDMSMHzGqAQ0yaQqUx_j52V2UFrtCbwSGD_Fz-vjtKlKV2kikOYDFTM6hlbwC5O4xUSGhFYEvgHpfWKdxsbo1FApUUOZHxM_DZSB2dGiNeP1ai8-92B5aAyrHcM1cNRBf1VW9UPb3txn3t84rdLkFM763g48sQR6lli5HeXzRmzpDT0nDFLSahemJ-ClXOHpt8wksZEt4vP1hf-iBYsSLTHhrWb7i30ClTQXBAnry0UmBEWah8_i21NYsBt9acjuMk9B0BRoU4mD-jjXsLvRvXfhRLxzopHbjmar79vEoJAvF6Te5uuNLVC9fPMf-53_vNAIM_L3iAvKIDkR5Qzx205yPxFpO8yT4kbxWTc5QRT5nZxiJaZOTocT1ROsTOVpieFjjSUX9F9CRxgWxLJrwsr7ajgWny3dstPFhc2yJR2-l5_QNxljWNInclbCu0lHCwXm0grGT5DdfRAXwoGQ4PYiedhZg4rRAsmUvxne9gb-hCBc8r6yNzZ360EtrmH5xQ.. osCommerce user since 2003! Link to comment Share on other sites More sharing options...
burt Posted October 26, 2017 Share Posted October 26, 2017 @frankl They should be stored like your first example: sessiontoken|s:32:"d24265....... I have never seen a session stored in the other way, it looks like it's been encoded ? Could you see if both sites have the same file contents: /includes/functions/sessions.php Link to comment Share on other sites More sharing options...
tgely Posted October 26, 2017 Share Posted October 26, 2017 @frankl there could be encode decode conflict, but first could you debug the $_SESSION. Print out in template bottom to see something from encoded session. Its not a human readable format. print_r($_SESSION); osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.