11
veaglarwen
Re: only half of my users are showing up after upgrade
  • 2005/12/4 10:32

  • veaglarwen

  • Just popping in

  • Posts: 28

  • Since: 2004/12/2


okay that worked. which columns should not be in the xoops_users?

12
Mithrandir
Re: only half of my users are showing up after upgrade

it worked? xoops_user_profile now has all 2000+ rows?

If so, then we'll need to remove the columns that are now in xoops_user_profile:

ALTER TABLE xoops_users
DROP `user_icq`,
DROP `user_from`,
DROP `user_sig`,
DROP `user_viewemail`,
DROP `user_aim`,
DROP `user_yim`,
DROP `user_msnm`,
DROP `user_occ`,
DROP `url`,
DROP `bio`,
DROP `user_intrest`,
DROP `umode`,
DROP `uorder`,
DROP `notify_method`,
DROP `notify_mode`,
DROP `user_regdate`,
DROP `posts`,
DROP `attachsig`,
DROP `timezone_offset`,
DROP `user_mailok`,
DROP `theme`,
DROP `actkey`,
DROP `last_login`
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

13
veaglarwen
Re: only half of my users are showing up after upgrade
  • 2005/12/4 10:35

  • veaglarwen

  • Just popping in

  • Posts: 28

  • Since: 2004/12/2


yes, 2973 rows now.

I'll run the alter code now.

14
veaglarwen
Re: only half of my users are showing up after upgrade
  • 2005/12/4 10:41

  • veaglarwen

  • Just popping in

  • Posts: 28

  • Since: 2004/12/2


Okay, ran the alter code. Is there anything else I need to do?

15
Mithrandir
Re: only half of my users are showing up after upgrade

check with admin -> find users that all are found
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

16
veaglarwen
Re: only half of my users are showing up after upgrade
  • 2005/12/4 10:47

  • veaglarwen

  • Just popping in

  • Posts: 28

  • Since: 2004/12/2


Find Users
(Active Users: 2402 Inactive Users: 572)

That's what admin->find users reports. It looks like its working now.

My only other installation problem that I've ran into is my user menu block not displaying. Do you have time to assist with that one too?

17
Mithrandir
Re: only half of my users are showing up after upgrade

It exists and is set visible and accessible to registered users?

Does it show up in MySQL/Blocks debug window?
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

18
veaglarwen
Re: only half of my users are showing up after upgrade
  • 2005/12/4 11:17

  • veaglarwen

  • Just popping in

  • Posts: 28

  • Since: 2004/12/2


Yes, it it exists in the admin panel. Its set to show on the left hand column, and the groups have it turned on for registered, webmaster, and a custom group I have set.

The block doesn't show up in the debug:

Blocks
Main Menu
: (3 QueriesNo Cache
Themes
: (1 QueriesNo Cache
Custom Block
: (2 QueriesNo Cache
Custom Block
: (2 QueriesNo Cache
Custom Block
: (2 QueriesNo Cache
Polls
: (4 QueriesNo Cache
Custom Block
: (2 QueriesNo Cache
Custom Block
: (2 QueriesNo Cache
Partners
: (3 QueriesNo Cache
Waiting Contents
: (12 QueriesNo Cache
Who
's Online: (13 Queries) No Cache
Stats Counter: (10 Queries) No Cache
Total: 12 blocks

Execution Time
XOOPS took 0.20849919319153 seconds to load.

Extra

19
Mithrandir
Re: only half of my users are showing up after upgrade

Quote:
Main Menu: (3 Queries) No Cache
Themes: (1 Queries) No Cache
Custom Block: (2 Queries) No Cache
Custom Block: (2 Queries) No Cache
Custom Block: (2 Queries) No Cache
Polls: (4 Queries) No Cache
Custom Block: (2 Queries) No Cache
Custom Block: (2 Queries) No Cache
Partners: (3 Queries) No Cache
Waiting Contents: (12 Queries) No Cache
Who's Online: (13 Queries) No Cache
Stats Counter: (10 Queries) No Cache

User menu is not listed.

Are you sure you've set it to be visible on all pages? Or just the page in question.
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

20
veaglarwen
Re: only half of my users are showing up after upgrade
  • 2005/12/4 11:23

  • veaglarwen

  • Just popping in

  • Posts: 28

  • Since: 2004/12/2


Its set to go to the left side on all frontside pages.

I was, earlier, having similar issues with other blocks that were on the right side, but found that setting them to another value and then back to the value I wanted worked. That isn't working for this block, unfortunately.

edit: in the database, under the options field, it has this: a:0:{}

Is that helpful?

Login

Who's Online

293 user(s) are online (221 user(s) are browsing Support Forums)


Members: 0


Guests: 293


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits