Small Errors after move

[anyoldcard]

On server A, I had SMF RC2 1.1 and a 128 meg database. Two things that I needed to do:

1. Move to a new server that will also mean a new domain
2. Upgrade the SMF RC2 1.1 to SMF 1.1.1

I thought it would be best to upgrade first. I then did a PHPAdmin dump of all the tables. I then installed SMF 1.1.1 on the new server B. Another question:

1. Should I have moved the newly upgraded program from server A, changed the pathnames and uploaded it to the new server A, move the database and then just connect to the "old/new" database on server B or just go with the way I did with the new install and then just move the database data after creating a new database on server B?

Small problems.

1. The avatars do not show up but the smilies do. The vatars do not even show in the prifile section. There is just an empty white area. I have checked all the pathnames and they seem to be correct. I have uploaded a file or two thinking maybe the FTP'er may have dropped some data with no luck.

2. Some threads (Two) do not have all the buttons like the "reply", Mark Read" etc... but only on my other networked computer. A man in New Jersey also said that he cannot see the buttons in some threads.

3. At the top of the forum where the private messages are, it says that I have 66 messages and it is blinking that I have one new message and it is empty when you click on the link. I deleted the table and copied in the new one one but all the same is still there. I sent a message to another computer and had them to send me one back and as soon as I opened it, the blinking stopped but it still says there are 66 messages. I also uploaded the files that have to do with this area but it made no difference.

I always have to enter the database one table and 1 set of database at a time. I paste at a time because when I try to upload a MSL file to the PHPAdmin it throws errors. Lots of duplication errors one at a time. Delete the row causing the problem, upload the MSL file and boom another error. Do I need to work the file before uploading it. Get rid of the rows that will throw the duplication errors?

I guess that is enough questions huh? Just trying learn and I have all the manuals, plus I study them faithfully. If anyone would be nice enough to tell me the best route to go so I do not spend more endless hours of trial and error. Well not that much but still more than neccessary if I had a few pointers. I do have the MySql for dummies and two PHP manuals plus the Sams 24 hour MySql manuals. Thanks for any help or direction, my old server will be due soon and I will have to pay hordes of money but I will go with a new empty database before I do that.

[Oldiesmann]

I would upgrade before you do the move, and use repair_settings.php (under "Tools" on the download page) to fix the paths.

For the avatars, double-check that the URLs (not just the paths) are also correct.

Not sure what could be causing the issue with the buttons/tabs.

To fix the PM issue, try going to Admin -> Forum Maintenance and clicking on "Recount all totals and statistics". That should give you the correct number of PMs.

To ensure you don't run into "Duplicate entry" errors when restoring the database, make sure you empty out all the tables before you upload the file. In the main phpMyAdmin window (where you see a list of all tables in the database), check the box at the bottom of the page (so it will select all tables), then choose "TRUNCATE" from the "With selected" list. After that you should be able to upload the file without any problems.

The best way to learn MySQL and PHP is to just read the online manuals and play around with them. It takes a while, but with enough practice, you can get used to them. That's how I learned (of course I've been working with PHP and MySQL for years now). The only book I have is the official MySQL Administrator's Handbook, but that goes well beyond the basics (clustering, master/slave configuration, foreign keys, differences between the various storage engines, etc.) and I wouldn't recommend that for a novice MySQL user.

[anyoldcard]

Thank you, I appreciate your taking the time to respond and with the easy to understand directions. What you gave me as info fixed everything except the buttons not showing up in the two threads.

The one command that says TRUNCATE on yours, says "empty" in the "with selected" area on mine and this will work as well.

Drop
Empty
Print View
Check Table
Optimize Table
Repair Table
Analyze Table

I think truncate would mean to lop off. Sometimes I just want to remove rows of data and can't. While in the structure window and it is showing each table, I have not figured out how to view ans edit the individual records. I know it's something minor and don't expect a SQL course for things that I need to be reading up on. Thank you, your help is genuinely appreciated.

[anyoldcard]

On the one problem that you could not help me with, I came up with a few things that maybe you might know more about.

This is the code from a computer that the reply and other buttons are not showing up:

Code Select Expand

<td class="mirrortab_back"><a href="http://www.ihostalot.com/ftforum/index.php?action=markasread;sa=board;board=4.0;sesc=345bc194c7a2842693c0dc3c285f410e" >Mark Read</a></td>
      <td class="mirrortab_last">&nbsp;</td>

Here is the code from the admin computer which does show the buttons and is not having posting problems:

<td class="mirrortab_back"><a href="http://www.ihostalot.com/ftforum/index.php?action=markasread;sa=board;board=4.0;sesc=67fd1ed5ae398a3431a5905d3f2f41b4" >Mark Read</a> &nbsp;|&nbsp; <a href="http://www.ihostalot.com/ftforum/index.php?action=notifyboard;sa=on;board=4.0;sesc=67fd1ed5ae398a3431a5905d3f2f41b4" onclick="return confirm('Are you sure you wish to enable notification of new topics for this board?');">Notify</a> &nbsp;|&nbsp; <a href="http://www.ihostalot.com/ftforum/index.php?action=post;board=4.0" >New Topic</a> &nbsp;|&nbsp; <a href="http://www.ihostalot.com/ftforum/index.php?action=post;board=4.0;poll" >Post new poll</a></td>
      <td class="mirrortab_last">&nbsp;</td>

The links are not there on the other computers. Could this possibly be a permissions problem? Do I need to re-upload all the data from the MySql database for that table? Or maybe reset all the permissions throught the admin. I tried that some with no success.

Also when I did a file check in the admin section, it said that the language files were all 1.1

Would this affect the buttons and why did it not upgrade with the rest?

Admin.english.php 1.1
Errors.english.php 1.1
Help.english.php 1.1 
Install.english.php 1.1
Login.english.php 1.1 
ManageBoards.english.php 1.1 
ManageCalendar.english.php 1.1 
ManageMembers.english.php 1.1 
ManagePermissions.english.php 1.1
ManageSmileys.english.php 1.1 
Manual.english.php 1.1
ModSettings.english.php 1.1 
Modifications.english.php 1.1 
Packages.english.php 1.1 
PersonalMessage.english.php 1.1
Post.english.php 1.1
Profile.english.php 1.1
Reports.english.php 1.1
Search.english.php 1.1 
Settings.english.php 1.1
Stats.english.php 1.1 
Themes.english.php 1.1
Who.english.php 1.1 
Wireless.english.php 1.1 
index.english.php 1.1

Any suggestions?
Thanks.

[anyoldcard]

I replace the board permissions data and the board permissions table and it works like a champ. Thanks you for all your help. I'm outa here.
Ron.