Go Back    Forum > Digital Publishing / Web Sites > Website and Server Troubleshooting

Reply
 
LinkBack Thread Tools
  #1  
01-10-2010, 08:40 AM
JonathanEntertainment's Avatar
JonathanEntertainment JonathanEntertainment is offline
Premium Member
 
Join Date: Jun 2005
Location: North Carolina
Posts: 77
Thanked 0 Times in 0 Posts
So recently I had to restore database using a backup and as I was going through some old post in the forum I noticed people that are members of the site underneath there usernames it says Guest.... Is there a way to relink the post to the username ?

Example:
http://www.rangerprops.com/showpost....38&postcount=5

Member Info:
User: bandai1983 (id: 413)

Figured I would check here before hitting the VB sites for help ....

Last edited by JonathanEntertainment; 01-10-2010 at 08:43 AM.
Reply With Quote
Someday, 12:01 PM
admin's Avatar
Ads / Sponsors
 
Join Date: ∞
Posts: 42
Thanks: ∞
Thanked 42 Times in 42 Posts
  #2  
01-10-2010, 09:16 AM
admin's Avatar
admin admin is offline
Site Staff | Web Development
 
Join Date: Jul 2003
Posts: 4,310
Thanked 654 Times in 457 Posts
You'll have to go through the database and re-link the posts to the names manually. .... at least that's the only way I'm aware of.

I've done this before, using SQLyog. Get it at http://esd.element5.com/affiliate.ht...www.webyog.com if you don't have it already. Using myPhpAdmin is ridiculous, useless crap compared to SQLyog.

This isn't as hard as you may think -- I sorted the posts by IP address in the db table, and was able to cross-reference the IPs to most members. In your case, it might be even easier than that, as the username appears to still be intact. You'll just add the correct user ID into the table, instead of the default ID given to a guest (or lack of ID, I forget now -- been a few years since I had to do this).

The forum was rather small at the time, which I think yours is too, so it's not too awful. It took me maybe 30 minutes for several dozen users, a few hundred threads (few thousand posts).

Mine was due to an import of a damaged phpBB board.

Some of the most damaged threads were dumped, and some orphaned posts were thrown into a "random" thread (later deleted, I believe).

vBulletin.com support won't help you much, I bet. There may be better help over at vBulletin.org for something like this. vB.com tends to say "read the book" while vB.org is willing to talk about mods/plugins/etc.

By the time you read all kinds of stuff at vB.com/vB.org however, you could probably have just done the manual method in the same amount of time.

The bigger issue here is you don't have a good backup (or backup method). Look into that. I use SQLyog for backups. (Also have server cloning to intranet-only system at the datacenter, firewalled from web access.)

- Did this site help you? Then upgrade to Premium Member and show your support!
- Also: Like Us on Facebook for special DVD/Blu-ray news and deals!
Reply With Quote
The following users thank admin for this useful post: JonathanEntertainment (01-10-2010)
  #3  
01-10-2010, 01:27 PM
JonathanEntertainment's Avatar
JonathanEntertainment JonathanEntertainment is offline
Premium Member
 
Join Date: Jun 2005
Location: North Carolina
Posts: 77
Thanked 0 Times in 0 Posts
As I am still fairly new to alot of the vbulletin database were would I find the correct table for this? I am not too familiar with the way the database it setup just yet. I am downloading that program now. My host does database backup but it seems it is lame with a restriction on size for the import which seems to me having to get them to re-import the backups.

yea I have noticed all the ones that this happened from are still in tact. Believe it or not this came from a ipb database.. I imported a old database posts and stuff from when this forum used to be on a free site.

Your also right on the vb.com part usually it tells you to pay someone to take care of this for you... another useful site is vbteam.info from time to time.

Also installed that program but I get the following error:

"http://www.webyog.com/faq/content/23/17/en/error-no-2005-unknown-mysql-server-host.html?highlight=webserver"

I put in the same address I do to connect the databases to the forum script..

Edit

nvm not going to be able to use this software it seems..
http://www.webyog.com/forums//index.php?showtopic=4738
but either way back on topic which table in the database should I look for to correc this?

Edit

after alot of looking and correcting i was able to get that program to work and I found the table and it works thanks alot!
Reply With Quote
  #4  
01-10-2010, 08:54 PM
admin's Avatar
admin admin is offline
Site Staff | Web Development
 
Join Date: Jul 2003
Posts: 4,310
Thanked 654 Times in 457 Posts
I've been offline all day long.

Although you seem to have found the solution on which table to edit, I'll repeat it here for the use of others that may find this topic...

vbulletin-sqlyog.jpg

You want to edit the table prefix_post, I believe. The prefix is whatever you've setup your forum to use in the .\includes\config.php -- it'll be obvious once SQLyog is open. It sounds like you lost the userid column in your backup and reload. Another possible issue is that you have data missing in either prefix_thread of even prefix_user. Just match up the usernames to the correct user ID.

I'm curious what exactly you ended up doing, and if it fixed all the problems.

The connectivity issues sound odd. Aside from firewalling the allowed IP range for access (which is what I use), I don't see how powweb could block you from accessing the database. --- And even if that were the case, I'd suggest finding a better host, that would be completely unacceptable.

I'm also curious what old free site your posts were imported from. I want to scrap a proboards site into phpBB, and then convert that to vB, eventually. More of a learning experience than the value of the old posts.

Backup the db regularly with SQLyog, right-click on the database name (the first entry underneath user@IP and go to Backup/Export, and "Backup Database As SQL Dump". Don't rely on the host or phpMyAdmin in your control panels.



- Did this site help you? Then upgrade to Premium Member and show your support!
- Also: Like Us on Facebook for special DVD/Blu-ray news and deals!
Reply With Quote
  #5  
01-10-2010, 10:09 PM
JonathanEntertainment's Avatar
JonathanEntertainment JonathanEntertainment is offline
Premium Member
 
Join Date: Jun 2005
Location: North Carolina
Posts: 77
Thanked 0 Times in 0 Posts
Yea I am going to start using this... I ended up having to set it up using the tunneling method other that the normal log in procedure.

This is the link to the very first board for this a while back...
http://z10.invisionfree.com/PR_RPF/i...ct=Reg&CODE=00
Reply With Quote
  #6  
01-10-2010, 10:14 PM
admin's Avatar
admin admin is offline
Site Staff | Web Development
 
Join Date: Jul 2003
Posts: 4,310
Thanked 654 Times in 457 Posts
Yes, tunneling works quite well on many of those cheap hosts. I had to remove the damaged phpBB board from a cheap Yahoo hosted account for a customer.

- Did this site help you? Then upgrade to Premium Member and show your support!
- Also: Like Us on Facebook for special DVD/Blu-ray news and deals!
Reply With Quote
  #7  
01-11-2010, 07:36 AM
JonathanEntertainment's Avatar
JonathanEntertainment JonathanEntertainment is offline
Premium Member
 
Join Date: Jun 2005
Location: North Carolina
Posts: 77
Thanked 0 Times in 0 Posts
I am not sure what my host rank is to be honest I have had them for so long...

www.powweb.com

I pay per year on mine..
Reply With Quote
  #8  
01-11-2010, 07:57 AM
admin's Avatar
admin admin is offline
Site Staff | Web Development
 
Join Date: Jul 2003
Posts: 4,310
Thanked 654 Times in 457 Posts
Powweb is one of several hosts that are really large AND seem to get a lot of complaints. Not as many as some of the other "unlimited" cheap hosts, but problems all the same.

If you're a website owner, you should really be a member of WebHostingTalk.com forums and login in once a week to see what the "pulse" of the industry is like. I visit regularly. This complaint thread about powweb isn't even a month old yet: http://www.webhostingtalk.com/showth...=powweb&page=2

As far as host suggestions go,
  • EuroVPS has excellent hosting packages available, from shared to dedicated. Very knowlegdable and FAAAAAST support staff!
  • FutureHosting has great VPS packages. Wonderful/helpful support and sales staff.
  • For a budget shared host that "doesn't suck" consider Pronet. I test hosts from time to time, and I've kept the accounts at those three.
All of them give great support, competitive pricing. (Worth noting: I've not needed much support from Pronet to date, not using that account heavily.)

- Did this site help you? Then upgrade to Premium Member and show your support!
- Also: Like Us on Facebook for special DVD/Blu-ray news and deals!
Reply With Quote
  #9  
01-11-2010, 07:57 AM
admin's Avatar
admin admin is offline
Site Staff | Web Development
 
Join Date: Jul 2003
Posts: 4,310
Thanked 654 Times in 457 Posts
This might also be worth noting: -- from http://www.webhostingtalk.com/showth...=powweb&page=2 --

Quote:
Brands Owned by Endurance International Group Inc. (formerly known as Caird Corporation and founded as BizLand Inc.)

AccountSupport http://www.accountsupport.com/
Apollo Hosting http://www.apollohosting.com/
BizLand http://www.bizland.com/
BlueDomino http://www.bluedomino.com/
DomainHost http://www.domainhost.com/
Dot 5 Hosting http://www.dot5hosting.com/
easyCGI http://www.easycgi.com/
eHost http://www.ehost.com/
EntryHost http://www.entryhost.com/
FatCow http://www.fatcow.com/
FreeYellow http://www.freeyellow.com/
Globat.com http://www.globat.com/
HostCentric http://www.hostcentric.com/
HostYourSite http://www.hostyoursite.com/
HyperMart http://www.hypermart.net/
ImOutDoors http://www.imoutdoorshosting.com/
iPage http://www.ipage.com/
IPOWER http://www.ipower.com/
IPOWERWEB http://www.ipowerweb.com/
Net//Works! Hosting http://www.networkshosting.com/
PowWeb http://www.powweb.com/
PureHost http://www.purehost.com/
ReadyHosting http://www.readyhosting.com/
StartLogic http://www.startlogic.com/
USAnetHosting http://www.usanethosting.com/
VirtualAve http://www.virtualave.net/
Webstrike Solutions http://www.webstrikesolutions.com/
Xeran Technologies http://www.xeran.com/
So changing to "another host" may not actually be a different. I would have to guess some fo them have differnt staff, however. I know that iPage is pretty decent, and easyCGI has a decent reputation -- whereas Globat and a couple of the others are often often cursed when mentioned.

I guess the note here is to be aware of who you're dealing with.

- Did this site help you? Then upgrade to Premium Member and show your support!
- Also: Like Us on Facebook for special DVD/Blu-ray news and deals!
Reply With Quote
  #10  
01-11-2010, 09:30 AM
JonathanEntertainment's Avatar
JonathanEntertainment JonathanEntertainment is offline
Premium Member
 
Join Date: Jun 2005
Location: North Carolina
Posts: 77
Thanked 0 Times in 0 Posts
Will look into IPage and see what I can decide.

Also what I did as I just re-read this thread...

Accesed the Database via the program and found the Table "posts" and found that alot of the user's had the user id "0" then as you stated above I went in and manually set them to the user id that Vbulletin had them set for... once I did that for a couple of them just to verify that is was working I saved what I had changed and then went to a page on the forum were I saw some of the posts and went to the specific ones I changed and wola it was restored back to the user!
Reply With Quote
  #11  
01-11-2010, 12:36 PM
admin's Avatar
admin admin is offline
Site Staff | Web Development
 
Join Date: Jul 2003
Posts: 4,310
Thanked 654 Times in 457 Posts
If you do change hosts to one suggested by staff at this site, please use the links found here: http://www.digitalfaq.com/forum/show...-com-1528.html -- cost for you is the same, but we get a tiny commission on the sale, which is used to help upkeep this site.

Copy paste from the most recent update (list of hosts only):

Quote:
Thanks!

- Did this site help you? Then upgrade to Premium Member and show your support!
- Also: Like Us on Facebook for special DVD/Blu-ray news and deals!
Reply With Quote
Reply




Similar Threads
Thread Thread Starter Forum Replies Last Post
Photo forum test post admin Photo Cameras: Buying & Shooting 0 03-27-2007 11:59 PM
TV suggestions? MOTUfan Videography: Cameras, TVs and Players 9 10-21-2005 04:18 PM
Why post here instead of a free forum? admin General Discussion 0 02-13-2004 12:19 AM




 
All times are GMT -5. The time now is 03:55 AM