Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sessions


frankl

Recommended Posts

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! :thumbsup:

Link to comment
Share on other sites

@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

Link to comment
Share on other sites

Interesting. I'm now clueless...as usual :wacko:.   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

Link to comment
Share on other sites

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! :thumbsup:

Link to comment
Share on other sites

What are the differents between datatable charsets and what are the database engines? Try to switch to file in configuration.php

:blink:
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

@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! :thumbsup:

Link to comment
Share on other sites

@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

@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);

 

:blink:
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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...