Icy Phoenix

Old Support Topics - Problems in Memberlist.

JANU1535 [ Sat 23 Jun, 2007 15:34 ]
Post subject: Problems in Memberlist.

Hello people.
I have some problems in memberlist.
In my website:
www.januweb.com

In the first page, I see this:

You can see that single 5 users leave, and my forum has 349 registered user.

The first user I am, but the 4 following ones, are the 4 last ones registered in the forum.
You watch that the list of users has 7 pages.

If pass from front page to any other, I see the following thing:

Here no longer it leaves nothing, single rare things, this happens in the rest of the pages of the list of users.

I add more information.
This problem is happening since I updated to icy phoenix
Previously he was phpBB XS 2.

Some suggestion?
Thanks.

hpl [ Sat 23 Jun, 2007 15:36 ]
Post subject: Re: Problems in Memberlist.

try to sincronize User in DB tools of ACP

JANU1535 [ Sat 23 Jun, 2007 15:39 ]
Post subject: Re: Problems in Memberlist.

That I did it yesterday from phpMyaAmin and it did not work.
Now I have done it from the ACP and it does not work either.

Thanks hpl.

Mighty Gorgon [ Wed 27 Jun, 2007 01:50 ]
Post subject: Re: Problems in Memberlist.

JANU1535, you are not the first having this problem.

It could be a corrupted users table... or simply a memory problem.

In few days I'll release a new beta... you can test with this and let me know if the problem is solved... otherwise we will try to understand the reason.

Try also to load the memberlist in Quick Mode from the select box on top of page.

JANU1535 [ Wed 27 Jun, 2007 02:57 ]
Post subject: Re: Problems in Memberlist.

Mighty Gorgon wrote: [View Post]
It could be a corrupted users table... or simply a memory problem.

After repairing the table in phpmyadmin, to the few seconds, it returns to me to indicate that there is remainder to repair again.

Mighty Gorgon wrote: [View Post]
In few days I'll release a new beta... you can test with this and let me know if the problem is solved... otherwise we will try to understand the reason.

Good.
I will test it and already I will inform as the topic goes.

Mighty Gorgon wrote: [View Post]
Try also to load the memberlist in Quick Mode from the select box on top of page.

No, it does not work, it continues happening the same either.

Now I finish observing, that the users who have registered themselves after registering themselves working with Icy Phoenix if they show.
And the users who tapeworm of the XS are those that does not leave, with the exception of usuary number one.
Therefore I think that Icy Phoenix can be an error in the file of update of the XS to Icy Phoenix.

Thank you MG.

Mighty Gorgon [ Wed 27 Jun, 2007 03:11 ]
Post subject: Re: Problems in Memberlist.

It is really strange... do you have some custom profile fields?

Can you try to send me your users table in a zip file please?

You can erase the email field if you wish.

JANU1535 [ Wed 27 Jun, 2007 03:14 ]
Post subject: Re: Problems in Memberlist.

Mighty Gorgon wrote: [View Post]
It is really strange... do you have some custom profile fields?

No.
I have the default fields only.

Mighty Gorgon wrote: [View Post]
Can you try to send me your users table in a zip file please?

Ok.
Right now I do it.

Mighty Gorgon wrote: [View Post]
You can erase the email field if you wish.

No problem.
I trust you.

Greets.

Mighty Gorgon [ Tue 03 Jul, 2007 23:47 ]
Post subject: Re: Problems in Memberlist.

JANU, currently I find no reasons why that memberlist is not showing up... I've rewritten the main sql in memberlist.php, I'll give you a new file soon to test and check if the problem disappears.

Please wait a couple of days and I'll give you the file.

JANU1535 [ Tue 03 Jul, 2007 23:49 ]
Post subject: Re: Problems in Memberlist.

Very good MG.
I will wait for the news on the file
Thanks again.

Greets.

kognos [ Mon 09 Jul, 2007 16:49 ]
Post subject: Re: Problems In Memberlist.

MG, I have exactly the same problem.

I did upgrade from PHPBBPlus 1.52. But I'm sure that I saw all the users in that list right after the upgrade.

I my case, I have 175 users but I can see only myself, a user registrared on Dic 2005, and a user registrared a few days ago (after the upgrade).

Also, I tried all the recomendations you previously made, but with the same results as JANU.

Let me know if you will offer a memberlist.php file before the beta release, because I use that list a lot. (please)

Mighty Gorgon [ Thu 26 Jul, 2007 00:34 ]
Post subject: Re: Problems in Memberlist.

Janu did you test memberlist from latest dev package?

If it is working fine we can try to give the file to kognos... even if something is coded differntly from older Icy Phoenix versions.

JANU1535 [ Thu 26 Jul, 2007 00:44 ]
Post subject: Re: Problems in Memberlist.

I test it.
I have upload the data of the table of users and workes good.
Nevertheless, tomorrow I will return to test and I comment definitively the result.

Greets.

JANU1535 [ Sun 05 Aug, 2007 17:16 ]
Post subject: Re: Problems in Memberlist.

Hello again.

I request excuses by the delay.
I had to format the hard disk and it did not have long time.

Well.
I have made a parallel copy of my forum with 1.1.0.15 in another directory.
And have come to update to the last version of development of Icy Phoenix.

The result, has been satisfactory, the users in the list of members see all.
See here.
http://www.januweb.org/foro/memberlist.php

Good work MG.
For the next version this topic will be solved.

Greets.

JANU1535 [ Sun 12 Aug, 2007 21:31 ]
Post subject: Re: Problems in Memberlist.

Incredible !!!!

The problem have been solved of mysterious form.
See here:
http://www.januweb.com/foro/memberlist.php

I do not understand anything… has been fixed.
Greets.

kognos [ Mon 13 Aug, 2007 02:44 ]
Post subject: Re: Problems In Memberlist.

FINALLY I FOUND THE PROBLEM !!!!!!!!!!!!!!! WOOHOO!!!!!!!!!!!

MG, I did duplicate the situation. The problem appears to be related to the selected style in the user profile.

Duplicating the error:

Try to set the Icy Phoenix Style to all users by default. And then go check the member list. All them will appear like magic!!

Each member that has set other style in his profile than the Icy Phoenix will not appear in the member list.

Try it and let me know.

[Added]:

I checked the memberlist.php and saw that the query used to call all the users is joined with the theme table

Check this out:

Code: [Hide] [Select]

if ($board_config['inactive_users_memberlists'] == true)

{

	$sql = "SELECT u.*, t.*

		FROM " . USERS_TABLE . " u, " . THEMES_TABLE . " t

		WHERE u.user_id <> " . ANONYMOUS . "

		AND t.themes_id = u.user_style

		$where_sql

		$alpha_where

		ORDER BY $order_by";

}

else

{

	$sql = "SELECT u.*, t.*

		FROM " . USERS_TABLE . " u, " . THEMES_TABLE . " t

		WHERE u.user_id <> " . ANONYMOUS . "

		AND t.themes_id = u.user_style

		AND user_active = 1

		$where_sql

		$alpha_where

		ORDER BY $order_by";

}

I really dont know the reason for including the themes table but MG or the other contributors may see more than me on this.

I hope the solution be somewhere here guys, so this nightmare can end.

kognos [ Mon 13 Aug, 2007 03:06 ]
Post subject: Re: Problems In Memberlist.

Ok, I will tell what I did.

I verify all the code to find a need of any theme_table field but I did not find anything, so I decide to eliminate the join of the theme_table and know I can see all my members no matter what style the have set.

This is the resulting query in the memberlist.php:

Code: [Hide]

if ($board_config['inactive_users_memberlists'] == true)
 
{
 
	$sql = "SELECT u.*
 
		FROM " . USERS_TABLE . " u
 
		WHERE u.user_id <> " . ANONYMOUS . "
 
		$where_sql
 
		$alpha_where
 
		ORDER BY $order_by";
 
}
 
else
 
{
 
	$sql = "SELECT u.*
 
		FROM " . USERS_TABLE . " u
 
		WHERE u.user_id <> " . ANONYMOUS . "
 
		AND user_active = 1
 
		$where_sql
 
		$alpha_where
 
		ORDER BY $order_by";
 
}

Try it and let me know.

Zuker [ Wed 15 Aug, 2007 06:55 ]
Post subject: Re: Problems in Memberlist.

I do not understand what it's your point

if it's necesary, explain me in spanish

kognos [ Thu 16 Aug, 2007 04:59 ]
Post subject: Re: Problems In Memberlist.

Gracias por tu interes Zuker.

Muchos se quejan de que aparentemente hay un problema en la pagina de memberlist.php que hace que solo se vean algunos usuarios y no todos. Y ni caso no es la excepcion.

Con el tiempo note que cada vez se podian ver mas usuarios en la lista. A la misma vez yo entraba de vez en cuando al ACP para arreglar los estilos por defecto, porque por alguna razon, aunque yo defina un estilo por defecto para todos los usuarios y seleccione que los usuarios no puedan cambiar esto, siempre aparecian uno que otro usuario con el estilo por defecto de Icy Phoenix.

Un dia, justo despues de volver a arreglar lo de los estilos y poner mi estilo por defecto para todos, cuando sali, fui a la lista de miembros a buscar un miembro que yo sabia que se estaba viendo en la lista incompleta, me di cuenta que ya no aparecia ningun miembro. La lista estaba vacia.

Esto me dio mala espina y fui al ACP y defini el estilo por defecto de Icy Phoenix pra todos los miembros. Luego, cuando fui a la lista, todos los miembros estaban ahi. Ahora se podian ver todos. Asi que entendi que tenia que ver algo con los estilos.

Fui al codigo php de la pagina y me note de que en el query que busca a los miembros en la BD, hace un join entre la tabla de usuarios y la de los estilos. Yo busque todo el codigo y no vi ninguna variable que leyera algun campo la tabla de los estilios, asi que pense que probablemente ese join se usaba en alguna version antigua de Icy Phoenix, asi que elimine la tabla de los estilos del query y decidi probar definiendo de nuevo mi estilo para todos los usuarios y cuando volvi a la lista, bingo!. Todos losmismbros estaban ahi.

Asi que conclui que el problema era que el join con la tabla de estilos traia solamente los miembros que tuvieran el estilo por defecto.

En mis port anteriores de este tema muestro el query antes y despues y como ahora todo me va bien sin ningun problema.

Zuker [ Thu 16 Aug, 2007 17:17 ]
Post subject: Re: Problems in Memberlist.

I understand:)

Anyway, that problem it's already fixed in next version of IP.
Thanks for your time

Greets

JANU1535 [ Sun 19 Aug, 2007 16:42 ]
Post subject: Re: Problems in Memberlist.

Already as it solves the problem without giving account me.

It is necessary to do the following thing.
ACP - Styles & Templates - Styles Management - Default Style - switch all users to this style

I made it touch, because when updating of XS to Icy Phoenix.
I put to ignore the style of the user, so that nobody had problems.

Thus, that the error that we had at the outset, comes from the migration.
I suppose perhaps that the solution helps MG to find the “small problem”

Greetsss !!!

Mighty Gorgon [ Tue 21 Aug, 2007 16:07 ]
Post subject: Re: Problems in Memberlist.

Thanks JANU1535, I'll check.