PDA

View Full Version : Couple issues



tokenyank
Sat 30th Jul '05, 6:49am
Well, I finally took the plunge and converted from IPB2 to vB3.0.8


The import went fine but I seem to be having a problem with aa couple things.


First, a user who shows up in the admincp as she is supposed to and appears in the mysql schema like everyone else, shows up on the forums itself as a 'guest'.

I've tried to edit her profile via admincp, I've used all the maintaince tools of the admincp, clean/opti the database, and even tried to edit the db table manually through phpmyadmin and she is still showing up as a guest.

Is there a way that I can fix her account so that she has all her posts and what not once I go live again? She is/was a moderator on my IPB board so there are quite alot of posts I'd like to recover from being doomed from being read as being authored by a 'guest'!


My other issue is that all my user sigs seem to have imported as html (weird considering IPB uses BB code too)... Is there an easy(ish) way to strip the sigs of all the users as I really don't fancy manually editing the sigs of 1000+ members.


The guest issue is the most important and needs to be fixed ASAP, the sig one can wait a couple days! :D


Thanks in advance and I look forward to a successful vB career!


EDIT TO ADD:
In case it helps diagnose the problem. In the admincp and in the table itself via phpmyadmin, the user in question has a userid of 198. But, where her posts appear on the board as guest, if you edit the post as admin, her username becomes a link again (it doesn't in the postview), her userid appears to be 0. I've searched the table in phpmyadmin but there isn't a userid0. How do I get the board to 'see' her as 198 when the database and the admincp already does?


EDIT TO ADD2:
Here are some screenshots of what I mean: (I apologise for the white space but I lost a harddrive last night and only had MSpaint to get these screen shots...)

Username as in postview:
http://www.mumsonline.net/vbtech/clem_guest.JPG

Username once in edit with userid visible in status bar:
http://www.mumsonline.net/vbtech/clem_userid0.JPG

User in adminCP:
http://www.mumsonline.net/vbtech/clem_admincp.JPG

User's table in phpmyadmin:
http://www.mumsonline.net/vbtech/clem_phpmyadmin.JPG

tokenyank
Sat 30th Jul '05, 10:23am
ok, never mind about the guest issue... I downloaded the database and search/replaced username:clementine/userid:0 with username:clementine/userid:198 and then re-imported the database... The seems to have worked but probably a very long winded way of doing something... I'm sure if I knew how to do querries properly, it probably could have been done with one line... But, oh well, it's fixed and that's all I care about at the minute!

But, the signitures are still a problem... Is there an easy way to strip all sigs out of the database?

Thanks again for your replies, in advance! ;)

Jerry
Sat 30th Jul '05, 2:33pm
To remove ALL signatures use this SQL :



UPDATE usertextfield SET signature ='';

tokenyank
Sat 30th Jul '05, 3:55pm
fantastic!

Thank you very much!

Still ironing out the little issues, but on the whole, everything went pretty well! Very happy customer! :D