Need help cant read post after transfering to new server
 

hello ,
i recently transfer my forum to new server . everything seems to okay except i cant read post .threads are showing up but when i click on any thread the post does not shows up
this is the error i am having when i click to any thread :

No Thread specified. If you followed a valid link, please notify the administrator

please help me in this thanks
waiting for reply
bye

Did you repair/optimize your database after importing it? Have you tried updating any of the counters since the move?

Can you post an example link to where this error message is occurring?

i have tried to optimize it nothing happenes .any more suggestion please

Sounds like you lost the content of your post table on the import...

Do you have access to phpmyadmin or something similar where you can browse the database and see if the post table is filled with the appropriate data?

yes i do have access to the phpmyadmin .but how can i see the post table there ?

Navigate to your database for the VB setup. Then click on the post table, and click the browse tab.

its shows up there like userid,ip,and other stuff including users text message too. any suggestion

How did you move to the new server?
How was the backup created?
How was the backup restored?

A link to your board might help troubleshooting this.

i download the backup in my pc with the format gzip format and then upload it to the new server in via backup>restor mysql data base and done then upload the forum file .i cant put link here .link is pm to ya
waiting for ur reply

That doesn't explain how it was created.

See the following on how to backup/restore. Also ensure that both new and old database use the same Character Set.

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

one thing i obeserve is my sql file is 38.8 mb and database after restore is 29.8 mb .is that okay ?

hello,

i have import database when i do it its original size is 38.2 but when i import it its shows sometime 29.2 mb or sometimes 32.1 mb

error i m getting is that
when i open my forum its open with no problem all things there username working stats showing ,threads showing and also reply also ther written 3 replies or 4 replies in the topic when i click on the topic nothing there and this message comes :

No Thread specified. If you followed a valid link, please notify the administrator

or in somepost no post ther eno messge there nothing . just create thread or close thread and below reply box thatz it


here is the link :

http://208.43.28.29/~pakidil/forum/index.php

one thing i check in phpmyadmin in post .all posts are there .but can not view on forum
please need help
waiting for reply

Have you gone to Admin CP > Maintenance > Repair / Optimize Tables and tried to repair/optimize any of the tables? Or Admin CP > Maintenance > Update Counters > Rebuild Thread Information ?

yes i tried but nothing happenes. this is wots comes in CP > Maintenance > Repair / Optimize Tables and tried to repair/optimize any of the tables

Data Length Index Length Overhead
post 813.2 KB 663.0 KB 0

How did you backup/restore your database?

Threads on same topic merged.

So, you saw the page which showed the table above and then you checked all the boxes and hit Repair/Optimize on the bottom of the screen? Did you do that a couple of times until all the tables said they were up-to-date?

yeah all update the intresting part is when i click on members profile any of my member and click on find all post by him .then posts are showing from there only.

--------------- Added [DATE]1217517586[/DATE] at [TIME]1217517586[/TIME] ---------------

i ask the guy to whom i got the hosting .he said to me that upload database in account by ftp .he said that he didnt download database to his computer from my hosting account .he just move it to the server directly so no internet speed issue ?

Have you run anything under Maintenance > Update Counters ?

yeah rebulild thread information and post information

This only tells us how he moved the backup file from 1 server to the other. It does not tell us how the backup file was created nor how it was restored.

okay get your point here is the full detail

3 months ago i have backup my forum from phpmyadmin in to my pc .it was in .gz format. my forum got hack and everything was deleted .so i have change the hosting and get the new one .
then my hosting provider ask me to move my backup.sql in to his hosting server using ftp . i did it .then from his part he just use some command mysql dataname something to make it up .

my backup.sql file was 38.2 mb after he has moved to the server its size is 32.1mb .post are not showing only for few members like only 2 or 3 members post can be view in the forum and the rest of the member's post cant be view erorr is coming .

i tried to check up the table .went to phpmyadmin click on post and all the post there does exit and i can see it there but not on vbulletin
any help please ? or if i didnt make it clear let me know please

A backup from phpMyAdmin is not the most reliable. But as we can not make a new backup anymore, i guess that is what we will need to work with. You can ignore the difference in size, most likely the difference between Windows/Linux.

The best option to troubleshoot this would be to open a Support Ticket, so one of our support staff can have a look at the database.