Double http Problem after converting from PHPBB 3.0.11

[rizwan65]

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 [nofollow]

Could you plz help
Regards
Rizwan

[Colin]

Welcome to SMF,

When you use the

Code Select Expand

[img][/img] tags in posts now do they still exhibit the same issue? In other words, is the issue only prevalent for converted posts?

[rizwan65]

In converted threads/posts
No new posts created yet

[Kindred]

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...

[rizwan65]

Below is content of body column of a post

Code Select Expand



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]




[Kindred]

Is the databae utf-8?

Is your forum in utf-8?

[rizwan65]

I don't know
Where can I check that

[Kindred]

in phpmyadmin... (for the database)

and the smf language settings (for smf)

[rizwan65]

In PHPmyAdmin latin1_swedish_ci under collation heading
and
in Forum Language setting is ISO-8859-1 as character set

[Kindred]

I think that is your problem...

Code Select Expand


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....

[rizwan65]

PHP DB is utf8_bin

and now how can I convert DB and Forum to utf8_bin

[Kindred]

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.

[rizwan65]

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

[Kindred]

hrm....


confirm that the contents of that body post remain the same?

If so, then I think you may have to do option #1

Code Select Expand


UPDATE smf_messages SET body=REPLACE(body, ':', ':');
UPDATE smf_messages SET body=REPLACE(body, '.', '.');


[rizwan65]

Thanks a lot
It is solved now