VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: webzight on March 05, 2017, 16:45:48 PM

Title: VM Logigng Me Out of Joomla !!!!!
Post by: webzight on March 05, 2017, 16:45:48 PM
{removed} is going on here?

WHY am I being logged out of Joomla! randomly anytime I do ANYTHING now in VM!

I cannot do updates to the users, the shopping cart wipes all data when I login as a registered shopper

Trying update the Categories and kept being logged out of Joomla! when I tried to SAVE anything!

I have no problems it seems with VM if I only have 1 or 2 products but when I load up a 1700 line item product list everything seems to go to {removed}

AGAIN {removed} is going here???

Joomla! 3.6.5 VirtueMart 3.0.18  PHP 7.0
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: AH on March 05, 2017, 17:36:35 PM
Please refrain from inferred profanity.  :)

I have no idea why any of this is happening but starters for 10 include:-

Did this work before
What have you changed
Do you have cache turned on
Is this on live or test site

QuoteI have no problems it seems with VM if I only have 1 or 2 products but when I load up a 1700 line item product list everything seems to go to

What are you trying to do - which page/function
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: GJC Web Design on March 05, 2017, 18:50:45 PM
QuoteI have no problems it seems with VM if I only have 1 or 2 products but when I load up a 1700 line item product list everything seems to go to

do u mean 1700 products?

If so I assume your session storage runs out of space and the session is corrupted so your login fails

Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: Milbo on March 07, 2017, 10:05:42 AM
Maybe he enabled the joomla debug plugin with all lights on?
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: webzight on March 07, 2017, 18:59:44 PM
GJC  - It is actually 1562 SKU's or "Products" with 86 Categories!
Milbo - DEBUG is OFF, CACHE is OFF!

Any other Joomla! function seems to work but when I start working with the VM Categories for instance, when I go to save certain things, I get logged out of Joomla!, but the LOGOUT does NOT close the Joomla! SESSION and when I have been logged out by VM and then LOGIN again a NEW Administrator session is created and I can have as many of these as I am logged out and logged back in again! This is REALLY not COOL!

I have the same VM shopping cart installed and WORKING on two other sites using the same version of Joomla, the SAME Templates, VM and PHP with NO PROBLEMS! Yet they don't have 1561 SKU's and 86 Categories  :-\
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: webzight on March 07, 2017, 19:29:15 PM
For ALL,

I have completely stripped out VM, EVERYTHING, ALL Database tables (yes even the associations), ALL Plugins, Modules, Components, EVERYTHING!

Reloaded VM from scratch and loaded the 1556 item Product Data Base!

Everything started out fine until I started working on the Product Categories and associated Products, then the nasty LOGOUT issues started!  :(

I have most everything reconfigured and after spending hours screaming at VM for LOGGING me out, I have the Product Categories setup, BUT they still don't work right!

For instance, I cannot reset an image for one Category as the application consistently logs me out when I try to SAVE the data on that particular Category but will work with another one, also I cannot now create a new category without being logged out!

I only post this in HOPE that someone else has had this experience and knows the SOLUTION to this problem!

For now VM sits in the background on the site (http://CambriaProducts.com) totally USELESS!

Latest Version of Joomla!, Latest Version of VM, PHP 7  :-\
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: Milbo on March 07, 2017, 20:08:51 PM
The number of SKUs is irrelevant. There are vm stores with more than 120k products. 86 categories is a lot. But should also work. In special, when you use the vm3.0.19.9, because there we use ajax to load the category tree. You can also check the session table of joomla and set the field data to "Mediumtext"-

How deep is your category tree, btw?
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: webzight on March 07, 2017, 23:00:56 PM
Milbo

"You can also check the session table of joomla and set the field data to "Mediumtext" "
It is already set to that  ???

"How deep is your category tree, btw?"
Is at most 3 levels for a few categories, the rest one to two!
There are only seven top categories!
ALSO VM will NOT let me CREATE any NEW Product Categories, NONE!
It logs me out immediately when I try to do so!
Now someone please tell me what is up with that craziness!  :o

GJC
"If so I assume your session storage runs out of space and the session is corrupted so your login fails"
That is a new one on me!
Where do I access that variable to check or even reset same, if it exists  ???

Have attached screen shot of what is happening every time I am force logged out of Joomla and Log right back again!
If I log back out BEFORE being forced out by using VM it clears all the other open sessions!
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: GJC Web Design on March 08, 2017, 00:38:19 AM
Quote"If so I assume your session storage runs out of space and the session is corrupted so your login fails"
That is a new one on me!

In std. Joomla the session is stored in the #__sessions table..  the field has a max size and the session info can grow to quite large sizes.
If it runs out of room it is truncated and destroyed (the encrypted mangled data won't decrypt)

I remember this happening on the frontend with huge numbers of products in the cart on a site

QuoteYou can also check the session table of joomla and set the field data to "Mediumtext"-
Think std is mediumtext.. but as Max asks.. it is more about pin pointing why the session fails.. is it because of its size

also what happens if u set the Joomla Session Handler to PHP in the global Config?

Also read suggestions here:  http://www.itoctopus.com/how-to-optimize-joomlas-session-table if it is the session that is corrupted
I fixed the FE problem by doing this

Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: AH on March 08, 2017, 09:14:25 AM
Just to sum up your issue

You have products and categories (in volumes no greater than many stores)

You are trying to do some basic edits in the admin page

Joomla is logging you out

It has nothing to do with adding products to the cart in the front end.


IMHO - Delete your session table in the dbase
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: Milbo on March 08, 2017, 09:18:13 AM
yeh let set it to MEMORY . I like the idea to add this as optimisation tool. I think all the time that db for session is odd.
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: Milbo on March 08, 2017, 09:18:59 AM
Quote from: AH on March 08, 2017, 09:14:25 AM

IMHO - Delete your session table in the dbase

You mean empty it, not delete, or?
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: AH on March 08, 2017, 11:53:08 AM
I mean - try and delete the table - it might be a corruption?
Title: Re: VM Logigng Me Out of Joomla !!!!!
Post by: webzight on March 08, 2017, 19:30:09 PM
Milbo -
"yeh let set it to MEMORY . I like the idea to add this as optimisation tool. I think all the time that db for session is odd"
I guess you mean PHP in reference to MEMORY, which I did once and it did not seem to stop the issue, BUT I tried a SECOND TIME and it now WORKS as advertised  8)

AH -
"Delete your session table in the dbase"
Yes I already tired that after doing some digging around the web to find out exactly what the SESSIONS package really does and HOW it does what it does, very interesting stuff BTW  :o
Wasn't aware that one could use SESSIONS as a cracker/hi-jacker path for instance :o

GJC -
"In std. Joomla the session is stored in the #__sessions table..  the field has a max size and the session info can grow to quite large sizes.
If it runs out of room it is truncated and destroyed (the encrypted mangled data won't decrypt)

I remember this happening on the frontend with huge numbers of products in the cart on a site"

Thanks for the enlightening info  8)
I did try resetting the #__sessions table and increasing DATA to LONGTEXT to no avail  :-[
It seems the real issue, for now, lies with the 'time' the application interacts with the PHP/Apache server and the Database thus causing Joomla to say "Good-Bye" and logging me out  :'(
Though it could be what you experienced also, even with the DATA set to LONGTEXT  8)

ALL -
Changng to PHP also cleared up another issue that I was going to squawk about in that the CART was not saving the USER DATA, and would not a new user be created from the frontens or backend  :o  VERY Annoying  ::)

Fingers crossed for now and hoping this holds together as I take the VM Cart live for the first time in years on this site  8)