Jump to content
Sign in to follow this  
Lots Moore

Can 2 administrators use the Admin at the same time?

Recommended Posts

Posted (edited)

Is it possible for 2 admins to be adding different products on 2 seperate computers at the same time without creating problems? Same store too.

Thank you :)

Edited by Lots Moore

Share this post


Link to post
Share on other sites

It is actually slightly more complicated than a simple yes or no but for all practical purposes, you shouldnt have problems.

CubeCart is not written to use row level locking although if the table uses InnoDB (rather than MYISAM) then row level locking is used automatically.

Share this post


Link to post
Share on other sites
1 hour ago, Lots Moore said:

Is it possible for 2 admins to be adding different products on 2 seperate computers at the same time without creating problems? Same store too.

Thank you :)

Ian is wrong. Logging in with the same staff account will kick out the other staff member who will need to login again thus kicking the other out. It's a security feature to prevent session hijacking. You'll need an account for each staff member. 

  • Thanks 1

Share this post


Link to post
Share on other sites

No, I am not wrong as you are just repeating what I originally said !!

1 hour ago, havenswift-hosting said:

Yes that should be OK - two admins should always be using different logins though

It is very clear that I said they should be using different logins !

@Lots Moore then asked about possible database issues, so I answered that as well

Share this post


Link to post
Share on other sites
3 hours ago, havenswift-hosting said:

but for all practical purposes, you shouldnt have problems

It shouldn't be possible "at the same time". Calm down Ian! LOL

Share this post


Link to post
Share on other sites

My 2-pence...

I routinely log in to my installation of CubeCart from two computers using the same admin account. I also routinely log in from the same computer using two different browsers.

As long as the cookie is different (thus separate sessions are maintained and session hijacking is thwarted) I have, have had, and expect to continue to have, absolutely no problems with multiple logins using the same admin account.

Share this post


Link to post
Share on other sites
19 minutes ago, bsmither said:

My 2-pence...

I routinely log in to my installation of CubeCart from two computers using the same admin account. I also routinely log in from the same computer using two different browsers.

As long as the cookie is different (thus separate sessions are maintained and session hijacking is thwarted) I have, have had, and expect to continue to have, absolutely no problems with multiple logins using the same admin account.

Agreed that will work but not at the same time. If you login on computer A then login on computer B the next page load on computer A will show the login screen.

That's all I'm trying to say. I agree that in theory as Ian said it should work but in reality it won't (or at least shouldn't). It's supposed to prevent session hijacking.

Share this post


Link to post
Share on other sites
38 minutes ago, Al Brookbanks said:

I agree that in theory as Ian said it should work

The whole point of my last answer is that I never said that !! Read it again - I very clearly said that two admins should always be using two DIFFERENT logins - so really not sure why you keep saying that what I said was wrong.  As the OP didnt go into any detail, I initially said that as long as they are doing that (using two different logins), then there should be no problems - it was only when he mentioned the database that I then replied with a little detail about database locking

Share this post


Link to post
Share on other sites
11 hours ago, havenswift-hosting said:

but for all practical purposes, you shouldnt have problems

Yes you said that but you also said that "you shouldn't have problems". All I'm saying is that you WILL. 🤣

Share this post


Link to post
Share on other sites

I give up !   As I have explained multiple times there are other "possible" problems such as database locking that are completely separate and to which I was referring - this was on the assumption which I CLEARLY stated that they should always be using different admin logins 

Share this post


Link to post
Share on other sites

Hahaha. I'm humbly sorry I got the wrong end of the stick. Don't give up... Have a beer. 🍻

Share this post


Link to post
Share on other sites

Would "database locking" actually effect everyone? I mean, lock a row and no one but the database connection making that transaction that locked it gets to do anything with it? Everyone else needs to wait.

So, as I see it, queries (transactions) made by different admin accounts will still have to wait until the row lock is released.

Share this post


Link to post
Share on other sites

MyISAM by default (and the way that CubeCart is written) locks the whole table so a far worse situation - imagine a situation on a busy site taking lots of orders with 2, 4 or 8 admin users updating orders and stock and you can imagine what would happen.  InnoDB by default locks at row level so a much better situation but still locked by the database connection making that transaction as you say.

New CubeCart stores are created with most tables as InnoDB now (the reason that some were left as MyISAM was that full text searches wouldnt work on InnoDB but that was fixed all the way back in MySQL 5.6.4 so to my mind every table should now be InnoDB.

Older sites (not even that long ago) were created with all tables using MyISAM and upgrades unfortunately do not change this

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...