Everyone a Site Admin in Forums...

Hangin' Around Joined: Jan 11, 2004 Posts: 37

3 hours later and I'm unable to find exact problem such as mine:

I upraded from 7.3 regular phpnuke to RN 2.02 and so far everything works good.

Except that users rank have been reversed.

I previously as a site admin now no longer... everyone else is a site admin now.

I added myself as site admin and I get my site admin rank back with no problems.

What I'm hoping for that is there is a script that will allow me to update all users (thousands of them) to be "demoted" accordingly to their number of posts.

Insights would be appreciated.

Posted: Sun Feb 26, 2006 1:34 am

Argh!

I looked into users rank admin via forums and found:

Site Admin - Yes Edit Delete
Newbie 1 No Edit Delete
Visitor 3 No Edit Delete
A regular 100 No Edit Delete
Pre-Veteran 500 No Edit Delete
Veteran 1000 No Edit Delete

I'm thinking, site admin shouldn't be in there... so I went ahead and deleted Site admin... ('course I made backup of database)

Now everyone isn't a site admin.

However, a different set of problem has been spotted that was overlooked by me. (keep in mind I already ran 'Fix Group' by Chatserv before doing this and updated hundreds to a group, but didn't solve the Site Admin problem. I also tried repairing database to no avail)

I notice that everyone's posts are set to 0 or 1... I mean the numbers of posts that everyone has posted are gone. (which is shown to everyone under usernames in the upper left area of a post)

I had hundreds of posts made but now I'm down to O. I made a test post and then it counts to 1... as if I'm starting all over again.

Shed any lights on it? I will continue to play around with it.

registered · Posted: Sun Feb 26, 2006 2:03 am

Any data in the user_posts field for your users?

Posted: Sun Feb 26, 2006 2:33 am

I just checked, good enough, most of them have 0 assigned to the users...

Now I know what the users_posts field is for... learned so much last few days.

I've attempted to find a way to just export the users_posts field so I could use that to import into my current database. I'm not able to figure that one out, yet. Can this even be done?

I do not know why it was not imported over to the new database.

Posted: Sun Feb 26, 2006 2:36 am

Uh oh...

I don't know what I did but I selected users_post field and was curious and clicked on Index button and then it says:

An index has been added on user_posts (Query took 0.8328 sec)
SQL query:
ALTER TABLE `nuke_users` ADD INDEX ( `user_posts` )

I didn't mean to alter the table or anything! I do not know what Index do but hopefully nothing disasterous... ?

I'm still trying to figure out exporting the users_posts field.

Posted: Sun Feb 26, 2006 2:41 am

There doesn't seem to be any easy way to export just the user_posts field.

Please advice.

Posted: Sun Feb 26, 2006 5:22 am

Well, I just emptied out nuke_users table and imported everything from old database (it does have user_posts with proper number of posts in it) to this current database.

It still does not work, I'm stumped by this one as to why it isn't posting over to it.

Posted: Sun Feb 26, 2006 4:11 pm

Odd. Are both user_posts fields the same type?

(Note: index'ing a field isn't necessary here. It is only useful to speed up queries. It not likely someone will be querying your table based on post count)

Posted: Sun Feb 26, 2006 4:21 pm

Can you tell me what you mean by the same type?

I just compared both tables between older and new database and they're the exact same field set ups...

Good, I didn't mess it up by clicking on that Index button, when it said 'Alter' that freaked me out.

Are you saying there is no way to export JUST the field into another field on another database?

Hmm...

Posted: Sun Feb 26, 2006 4:32 pm

Same variable type.

I don't see a way to export just one column. It isn't a spreadsheet.
The database is dependent on all the data in the row to match

Posted: Sun Feb 26, 2006 4:37 pm

Ohhh right, that makes sense! Duh me.

Same variable type... sorry still dont know all database "language"...

Is it as in myisam and innodb type?

I am purely relying on whatever common sense I've got left over.

Posted: Sun Feb 26, 2006 10:59 pm

No.. what is listed under TYPE? Is it an INT?

Posted: Sun Feb 26, 2006 11:03 pm

It shows as, "user_posts int(10)" so I suppose this is a INT.

What does that tell you?

Thank you for being patient with me.

Posted: Wed Mar 01, 2006 2:32 am

Ok, I get the feeling this is a difficult one to overcome... I've had the Your Account deactivated ever since because I'm hoping to find a fix for this.

I feel this may take some time to find out the fix for it so I'm trying to figure out how I may be able to allow new sign ups and members posts while searching for fix. So that it does not disrupt the posts info while preserving the posts count from last database...

I'm thinking maybe mark the last members database so that I can always import over the posts counts while preserving new members signups?

I'll try heading over to nukecops to see if anyone has the faintest idea.

Thank you.

I'll be sure to report back if I happen to be referred to a fix to this problem.

Other than that, it is running very smoothly with thanks to RN.

Posted: Wed Mar 01, 2006 3:09 am

One more last thing!

Perhaps table structure should be looked at too? Anything out of ordinary?

Quote:

CREATE TABLE `nuke_users` (
`user_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
`femail` varchar(255) NOT NULL default '',
`user_website` varchar(255) NOT NULL default '',
`user_avatar` varchar(255) NOT NULL default '',
`user_regdate` varchar(20) NOT NULL default '',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_interests` varchar(150) NOT NULL default '',
`user_sig` varchar(255) default NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(1 Cool

default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`user_password` varchar(40) NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`theme` varchar(255) NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`user_posts` int(10) NOT NULL default '0',
`user_attachsig` int(2) NOT NULL default '0',
`user_rank` int(10) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`newsletter` int(1) NOT NULL default '0',
`broadcast` tinyint(1) NOT NULL default '1',
`popmeson` tinyint(1) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_timezone` tinyint(4) NOT NULL default '10',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) NOT NULL default 'english',
`user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '0',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_avatar_type` tinyint(4) NOT NULL default '3',
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`points` int(10) default '0',
`last_ip` varchar(15) NOT NULL default '0',
PRIMARY KEY (`user_id`),
KEY `uid` (`user_id`),
KEY `uname` (`username`),
KEY `user_occ` (`user_occ`),
KEY `user_session_time` (`user_session_time`),
KEY `user_posts` (`user_posts`)
) TYPE=MyISAM AUTO_INCREMENT=7079 ;

Posted: Wed Mar 01, 2006 3:42 am

Well, this was freak of accident scenario...

I've fixed the problem... by accident!

I simply got curious and determined... For some reason I was curious about 'Complete inserts' making sense 'cuz it indicated COMPLETE...

So, I tried that and got it to import everything including users_posts field over to new database.

It worked!

However, I'm still on the caution to see if I find any other faults.

Thought I might keep you updated as well.