Elxis CMS Forum

Support => General => Topic started by: bianco2k on May 23, 2009, 19:26:52

Title: Problem with the user list (in administrator) after upgrade to elxis 2009
Post by: bianco2k on May 23, 2009, 19:26:52

hello everyone, I have a problem with the users list.

my users list disappears after I click on the second page and disappears until do not log in again....

thanks in advance at all

Title: Re: Problem with the user list (in administrator) after upgrade to elxis 2009
Post by: webgift on May 23, 2009, 19:45:07

You must do this...
*** DATABASE ***
A new column has been added to table #__users. You have to create this column manually.

Go to your database manager (phpmyadmin if your database is mysql, pgmyadmin if it is postgresql, or to your oracle database manager).

Execute the following SQL commands (for mySQL databases):

ALTER TABLE `elx_users` ADD COLUMN `expires` datetime NOT NULL default '2060-01-01 00:00:00' AFTER `signature`;

UPDATE `elx_softdisk` SET `sdvalue` = '2009.0' WHERE `sdname` = 'ELXIS_VERSION';

UPDATE `elx_softdisk` SET `sdvalue` = '2009.0' WHERE `sdname` = 'ELXIS_DBVERSION';

UPDATE `elx_softdisk` SET `sdvalue` = UNIX_TIMESTAMP() WHERE `sdname` = 'ELXIS_LASTUP';

Note: Replace "elx_" with your own database table prefix if it is different.


!! IMPORTANT !!
If you dont update your database Elxis won't function properly!

Title: Re: Problem with the user list (in administrator) after upgrade to elxis 2009
Post by: bianco2k on May 23, 2009, 19:50:52

has been updated but the problem persists

Title: Re: Problem with the user list (in administrator) after upgrade to elxis 2009
Post by: anacon on May 23, 2009, 21:53:36

I have the same problem when i make update 2008.1 to 2009 and i have archive problem i can see all archive on back end but i cant see archive on frond end.

Title: Re: Problem with the user list (in administrator) after upgrade to elxis 2009
Post by: datahell on May 23, 2009, 22:38:49

bianco2k if you wish send me username/password to your site FTP and to Elxis administration to check/fix this for you. I am sure you have missed something.

Title: Re: Problem with the user list (in administrator) after upgrade to elxis 2009
Post by: jimmyz on May 24, 2009, 08:52:45

Gendlemen, I think this happens when one patches elxis by hand... I'm almost sure some file(s) must have been missed. If I were you, I'd use the backup I have, to restore all files to previus state (version) and try this https://forum.elxis.org/index.php?topic=3435.0 (https://forum.elxis.org/index.php?topic=3435.0), if I had putty-ssh.
Cheers!

Title: Re: Problem with the user list (in administrator) after upgrade to elxis 2009
Post by: bianco2k on May 24, 2009, 14:19:41

does not work in any way  :'(

first whitout click or search any user
(http://www.progettandovacanze.com/filez/first.jpg)

After click to next or on number or end,or use the filter
(http://www.progettandovacanze.com/filez/imm2.jpg)

Title: Re: Problem with the user list (in administrator) after upgrade to elxis 2009
Post by: datahell on May 24, 2009, 14:57:23

Oh, you mean in Elxis administration! You should have make this clear. I checked Elxis front-end... I will check it again. Please wait.

Title: Re: Problem with the user list (in administrator) after upgrade to elxis 2009
Post by: datahell on May 24, 2009, 15:04:45

OK, I tested it. No problem found!

What happens to you is that the Group (Gruppo in Italian) filter is being triggered. If you notice in your second screen shot the Group column's filter icon is red. Click the red icon, select -All - (-Tutti- in Italian) and then you will be able to see all users and navigation will work just fine. ;)

Title: Re: Problem with the user list (in administrator) after upgrade to elxis 2009
Post by: bianco2k on May 24, 2009, 15:12:06

ah vary nice,  I not thought, sorry for the trouble, I'm very stupid  :D

many thanks