I am facing a problem after converting phpbb 3.0.11 to smf 2.0.4
The images from external servers cannot be displayed and have double http like http://http//i255.photobucket.com/albums/hh148/tuanoh/matrixbk7ul.png
Could you plz help
Regards
Rizwan
Welcome to SMF,
When you use the [img][/img] tags in posts now do they still exhibit the same issue? In other words, is the issue only prevalent for converted posts?
In converted threads/posts
No new posts created yet
there may have been some complication from the conversion...
Find one of the problem posts. Get the ID
In the database, open the smf_messages table and find that ID
in a post here (using code tags), post the contents of the body column for that row...
Below is content of body column of a post
Below is content of body column of a post
[img]http://i255.photobucket.com/albums/hh148/tuanoh/matrixbk7ul.png[/img]
[b]Windows 7 Ultimate x86 FINAL MSDN For All Main[/b]
Windows OS | Year: 2011 | Version: 7.3 | All Main | Language: ENG | Platform: 32 bit | 2.77 GB
DVD ISO | Bootable
Windows 7 is the easiest, fastest, and most engaging version of Windows yet. Better ways to find and manage files, like Jump Lists and improved taskbar previews, help you speed through everyday tasks. Faster and more reliable performance means your PC just works the way you want it to. And great features like HomeGroup and Windows Touch make new things possible. Get to know Windows 7, and see how it can simplify just about everything you do with your PC.
System Requirements and Info:
If you want to run Windows 7 on your PC, here's what it takes:
*1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
*1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
*16 GB available hard disk space (32-bit) or 20 GB (64-bit)
*DirectX 9 graphics device with WDDM 1.0 or higher driver[/quote]
[img]http://i255.photobucket.com/albums/hh148/tuanoh/ghost72.jpg[/img]
Is the databae utf-8?
Is your forum in utf-8?
I don't know
Where can I check that
in phpmyadmin... (for the database)
and the smf language settings (for smf)
In PHPmyAdmin latin1_swedish_ci under collation heading
and
in Forum Language setting is ISO-8859-1 as character set
I think that is your problem...
http://
is UTF8 for http://
So... you have two options.
1- convert those UTF-8 entities to normal entities throughout the database
2- convert your database and forum to UTF-8
Can you check... what collation was your phpbb database?
if that was UTF-8, then that is your problem... and solution #2 is best....
PHP DB is utf8_bin
and now how can I convert DB and Forum to utf8_bin
forum is the easy bit.... there is an option in maintenance, I think.....
the database - you have to change the collation for each and every table and column.
I think there is a command, but I am not certain.
I have changed the tables and DB to utf8_bin and Language to utf8_bin
and also run the maintenance task which convert to utf8
But the double http problem still persist
hrm....
confirm that the contents of that body post remain the same?
If so, then I think you may have to do option #1
UPDATE smf_messages SET body=REPLACE(body, ':', ':');
UPDATE smf_messages SET body=REPLACE(body, '.', '.');
Thanks a lot
It is solved now