Lots Moore Posted June 15, 2019 Share Posted June 15, 2019 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 Link to comment Share on other sites More sharing options...
havenswift-hosting Posted June 15, 2019 Share Posted June 15, 2019 Yes that should be OK - two admins should always be using different logins though Link to comment Share on other sites More sharing options...
Lots Moore Posted June 15, 2019 Author Share Posted June 15, 2019 Thank you, I did try it a couple of times but was worried that it may mess with the Dara base or similar. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted June 15, 2019 Share Posted June 15, 2019 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. Link to comment Share on other sites More sharing options...
Al Brookbanks Posted June 15, 2019 Share Posted June 15, 2019 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. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted June 15, 2019 Share Posted June 15, 2019 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 Link to comment Share on other sites More sharing options...
Al Brookbanks Posted June 15, 2019 Share Posted June 15, 2019 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 Link to comment Share on other sites More sharing options...
bsmither Posted June 15, 2019 Share Posted June 15, 2019 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. Link to comment Share on other sites More sharing options...
Al Brookbanks Posted June 15, 2019 Share Posted June 15, 2019 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. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted June 15, 2019 Share Posted June 15, 2019 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 Link to comment Share on other sites More sharing options...
Al Brookbanks Posted June 15, 2019 Share Posted June 15, 2019 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. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted June 15, 2019 Share Posted June 15, 2019 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 Link to comment Share on other sites More sharing options...
Al Brookbanks Posted June 15, 2019 Share Posted June 15, 2019 Hahaha. I'm humbly sorry I got the wrong end of the stick. Don't give up... Have a beer. Link to comment Share on other sites More sharing options...
bsmither Posted June 15, 2019 Share Posted June 15, 2019 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. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted June 15, 2019 Share Posted June 15, 2019 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.