change domain name..?

[DilSe]

ok sir

now site is runing but database error is coming . but it's ok

i make backup : Admin> Forum Maintenance - Backup Database"
i have this file .. frome where i can again upload i have this zip file ..


Save the table structure.
Save the table data. (the important stuff.)

Compress the file with gzip.

now i want again upload this zip file but frome where...? plz help about this

[Norv]

What database errors are there?

[DilSe]

this error  sir


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 2, 2)' at line 3
File: /home/domin/public_html/Sources/MessageIndex.php
Line: 112

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.9, while your database is at version . The above error might possibly go away if you execute the latest version of upgrade.php. 



This error is coming  now i fix it is good..  all mod. is coming but not working same like "shout box" and "Full Top 10 Stats" "Ultimate Profile" and more..
how do i can change about this problem..?

and if sir you look this pic . last post show place is empty

[Norv]

Please post as attachement your MessageIndex.php file. It seems it has some modifications which are not correctly done.

[DilSe]

Please post as attachement your MessageIndex.php file. It seems it has some modifications which are not correctly done.

this is messageindex.php file

sir also my topic and post is not coming same .

[Norv]

I'm sorry, I don't see what the problem is. Is this the only error in the error log? The file MessageIndex.php is edited by mods, but I'm not sure what interferes with bad effect.
If nobody has a better idea, I would suggest you undo the modifications made that affect the file (like a mod about coloring links), uninstall them, then see if it works.
If it works, then install them again, one at the time, and tell all errors as they appear.

[DilSe]

I'm sorry, I don't see what the problem is. Is this the only error in the error log? The file MessageIndex.php is edited by mods, but I'm not sure what interferes with bad effect.
If nobody has a better idea, I would suggest you undo the modifications made that affect the file (like a mod about coloring links), uninstall them, then see if it works.
If it works, then install them again, one at the time, and tell all errors as they appear.

hmm sir this error I fix it

now  I have problem just my post and topic's it' not coming same
exp... my post's .100 but it iis coming now jus 15 and my topic
for exp.. 200 but it is coming 50 ... plz sir you help me about
this problem

[Norv]

I'm sorry, I don't understand the problem. Can you please show it in a screenshot or explain a little more?

[DilSe]

sir  you See on this attc. file

with old host  post and topic's

but now you See with new host it is not same

[N3RVE]

Perhaps, the backup wasn't restored completely?
Execute some of the Forum Maintenance options

• Find and Repair any Errors
• Recount all forum totals and statistics

-[n3rve]

[DilSe]

yes now i make it again
" Admin>Forum Maintenance - Backup Database"

with zip file .. when i upload in Database i get this error 

Code Select Expand

Error
SQL query:

INSERT INTO `SMFlog_search_subjects` (`word`, `ID_TOPIC`) VALUES ('woh', 1621), ('woh', 1796), ('wohi', 196), ('wohi', 2085), ('wohii-kalam-e-iqbal', 204), ('wohii-kalam-e-iqbal', 209), ('woman', 257), ('woman', 1033), ('woman', 1990), ('women', 1008), ('women', 1561), ('women', 1630), ('wonderful', 1548), ('wonders', 1486), ('word', 273), ('word', 294), ('word', 1833), ('words', 271), ('words', 1907), ('work', 676), ('work', 1673), ('works-then', 1480), ('works-then', 1493), ('works-then', 1556), ('world', 99), ('world', 336), ('world', 337), ('world', 339), ('world', 1008), ('world', 1121), ('world', 1122), ('world', 1326), ('world', 1427), ('world', 1452), ('world', 1453), ('world', 1483), ('world', 1484), ('world', 1486), ('world', 1510), ('world', 1630), ('world', 1633), ('world', 1719), ('would', 634), ('wrong', 1298), ('wts', 1016), ('wwe', 123), ('wwe', 731), ('wwe', 1631), ('ww[...]

MySQL said: 

#1062 - Duplicate entry '????-1844' for key 1



[Norv]

In the old database, select the SMFlog_search_subjects table, and from the Operations tab, empty it. (do not drop it)
Then, make a backup again, and try to restore it in the new database.

[DilSe]

sir know I make new backup database .... and  I upload my all file  smf folder  to new host smf folder ..
but when I smf folder to new host smf folder all file move .. nothing happened on new server  smf 1.1.9
and know I have my backup smf 1.1.10 ..

how do I can now sir ..plz

[ultide]

sir
i want to shift my forum...like


from http://www.1234.com/ [nofollow]   

to  http://www.1234.com/forums [nofollow]



which files do i need to move and what is the procedure....

[Norv]

Please upload also the repair_settings.php script to your new forum folder, and run it from the browser. (What is repair_settings.php?)
Check all it says, and make sure you enter the settings of the new forum. Then, save them.

Please check out this documentation to make sure you may have done all steps:
How do I move my SMF board to a different host?

[DilSe]

yes sir check this all steps.. and i make it same ..

first i download all smf folder on my PC.. and again i upload new host..     and next i make backup database and upload new  host database .... and run   "repair_settings.php"

when i run repair setting.. i make all information good.. and save setting..

and open my new site link... but i get this message .


and when i make new frish smf 1.1.10 upload it's working good...

[Norv]

It looks like your site has been hacked, by a defacer team, on the old host/location. By copying everything to the new host, you copy the hacked files as well.

I strongly recommend to delete the old SMF files from the new host, and instead of them, upload on the new host the files from the standard 1.1.10 installation package. (without install.php and install1-1.sql, and Settings.php, Settings.bak.php).
Then, check the forum: you should have a clean forum, on which you should choose the default theme, for starters. Then you can install everything again.

Alternatively: you could replace only index.php from the new forum folder, with index.php from the installation package, but it's not obvious whether other files may be affected and could perhaps do more harm in the future.
I advise you replace everything, then start reinstalling theme and mods.
The database (all posts, members, etc) will not be affected by the replacement of files, check and you will see.

EDIT:
you should notify your host about the defacement. Usually such hackers teams use hosts' vulnerabilities to hack sites, so they may have their server compromised.

[DilSe]

what you said i make it same sir and it's comback ..

but when i upload database .. i get this error

Error
SQL query:

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;



MySQL said: 

#1100 - Table 'time_zone_name' was not locked with LOCK TABLES

[Norv]

Please post the beginning of the backup file, here, until you get to the

Code Select Expand


/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

line.

EDIT: that, in case there are only ten lines or so, if there are more, then just post the first lines until you get to something about smf_attachments, anything about it (the first occurence of smf_attachments in the file). Please use your database prefix actually, instead of "smf_", for the name, so it's [your_prefix]attachments.

[DilSe]

Thanks for help ...

sir i find this code and delete this code .. and upload again .. database it's working .. and show section and topic's but when i click any topic nothing in side..