How do I change from to unique to non unique?

[Guest]

I keep getting 1062 duplicate entry errors when using an SSL connection, but not when SSL is set to false (some of you may have seen me request info before! :) ).

 

Anyway I can't seem to rectify this problem so I guess 1 way around this would be to make the sessions value NON unique.

 

Can someone tell me how you change this in PHP admin please?

 

cheers.

 

Chris H

[OceanRanch]

Hi Chris,

 

I've been following your plight on this one and it really is a tough one. Let me chime in with a few comments and maybe it will generate further discussion.

 

First to your current question regarding the unique/non-unique field in the database.

 

The sesskey field in the sessions table is currently set as the "primary" key. Primary keys by definition are unique, so you can't just change the sesskey to non-unique.

 

You could drop the primary key and add an index (non-unique) on the sesskey field. You can do this in PhpMyAdmin quite easily by just bring up the sessions table and performing the action "drop" on the primary key and then adding an index on column 1.

 

Another alternative is not store your sessions in mysql but as a normal file within your domain (not in /tmp if you are in a shared environment). In that manner, the duplicate session should just be written over the existing one.

 

Backup the database via osCommerce first just in case.

 

HTH

Tom

[♥ecartz]

This only happens with the World Pay page? I would check that the page is written correctly. Which contribution is it? I see three for World Pay.

 

Why is it trying to insert into the session table? Shouldn't it be updating instead?

 

Hth,

Matt