convert to utf-8

[huski]

I am trying to upgrade from 3.4.7 to 4.0.13.1 

when the upgrade script sees my database is not utf-8, it tries to use the convert method within ip.board

Your community suite data or database configuration is saved in an encoding other than UTF-8. Before your site can be upgraded to the 4.0.0 Community Suite, we must convert the encoding to UTF-8.

as soon as it runs, the following error message shows up:

Error: include(/uploads/profile/photo-7388.jpg) [function.include]: failed to open stream: No such file or directory File: /home/xxx/public_html/conf_global.php(299) : runtime-created function Line: 1

i don't understand the error message, so have tried to manually convert the database using scripts online without any success. absolutely pulling my friggin' hair out.

i found someone else receiving the same error message when using the internal conversion, unfortunately there isn't a reply to his post:
https://community.invisionpower.com/blogs/entry/9625-ips-utf-8-database-converter/?do=findComment&comment=21609

does anyone know of what the problem is, or have a script that works, i'm stuck

thank you very much for any suggestions

[huski]

figured out the problem

for some strange reason, the utf8convert app does not seem compatible with hostgator's shared hosting, tried 2 different domains without luck. solution for me: export database, import to hostgator VPS, convert to UTF-8, then export and import back to the shared account. working fine now.

of course if you can manually convert to UTF-8, then the app would not show.

wasn't able to convert everything it seems, before.

[titcrunch]

you passed directly by the scipt for convert in utf 8 or this the upgrade process who say this ?

[SquirrelNuts]

I'm no wizard but it looks like it's looking for :

 

.../uploads/profile/photo-7388.jpg

I could be wrong. Either see if that file is there or out another image there under the same format and the same name and try running again. Worth a shot.

Edited October 15, 2015 by SquirrelNuts

[huski]

I'm no wizard but it looks like it's looking for :

 

.../uploads/profile/photo-7388.jpg

I could be wrong. Either see if that file is there or out another image there under the same format and the same name and try running again. Worth a shot.

thanks, i did try that without any change in error message

[SquirrelNuts]

Sorry I couldn't help mate.

[titcrunch]

just read :

Either see if that file is there or out another image there under the same format and the same name and try running again

[huski]

just read :

Either see if that file is there or out another image there under the same format and the same name and try running again

I have replaced that file with a verified image, and receive the same error message.  I do not understand why this upgrade script fails looking for a profile picture ??

Also have tried manually converting the database and its guts to utf8_unicode_ci, so it shouldn't even be going to the UTF-8 conversion step.

Thank you for any suggestions

 

[titcrunch]

just delete the file or the post who have this file and upgrade .... after you can remake this post or re-add this file

[huski]

just delete the file or the post who have this file and upgrade .... after you can remake this post or re-add this file

I have tried replacing the file, deleting the file. Also have searched the database for reference to this file, nothing is found. Upgraded just now from 3.4.7 to 3.4.8 without issue. But again, trying to upgrade to 4.0.13.1 it gives the same error looking for that file.

Where and why is the upgrade looking for this profile photo ?? This is crazy, the database is already utf8_unicode_ci, wtf is the deal. 

Thanks for ideas or suggestions

When I first began this a few days ago, ip.board was moved from /forums to the root / , everything was stable and working so I began the upgrade.

I still have /forums on the server and was going to delete those files after the upgrade. 

 

Just now, I downloaded all the files from my website and ran searchmonkey on my desktop to try and find what is looking for photo-7388.jpg during the upgrade. 

/admin/convertutf8/tmp/error_2015-10-14.cgi (142.5 KB Fri Oct 16 11:29:08 2015)
Line Number: 820
        1 => 'include(/uploads/profile/photo-7388.jpg) [<a href=\'function.include\'>function.include</a>]: failed to open stream: No such file or directory',
Line Number: 862
          'ps' => '/uploads/profile/photo-7388.jpg',
Line Number: 916
        2 => '/uploads/profile/photo-7388.jpg',
Line Number: 968
          2 => '%D/uploads/profile/photo-7388.jpg',
Line Number: 1067
   'message' => 'include(/uploads/profile/photo-7388.jpg) [<a href=\'function.include\'>function.include</a>]: failed to open stream: No such file or directory',

/forums/error_log (248.3 KB Fri Oct 16 12:54:29 2015)
Line Number: 322
[15-Oct-2015 16:42:25 UTC] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/santabar/public_html/forums/uploads/profile/photo-7388.jpg:228) in /home/santabar/public_html/forums/admin/sources/classes/output/formats/html/htmlOutput.php on line 114
Line Number: 323
[15-Oct-2015 16:42:25 UTC] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/santabar/public_html/forums/uploads/profile/photo-7388.jpg:228) in /home/santabar/public_html/forums/admin/sources/classes/output/formats/html/htmlOutput.php on line 127
Line Number: 324
[15-Oct-2015 16:42:25 UTC] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/santabar/public_html/forums/uploads/profile/photo-7388.jpg:228) in /home/santabar/public_html/forums/admin/sources/classes/output/formats/html/htmlOutput.php on line 136

Could the upgrade be looking for header information from /forums instead of / 
Have tried replacing /uploads/profile/photo-7388.jpg and /forums/uploads/profile/photo-7388.jpg and then running the upgrade but receive the same error. Maybe /forums could be upgraded to 4.0, then move the whole thing to root domain.

Maybe someone can make sense of these errors and give me some advise, thanks

 

 

[huski]

you passed directly by the scipt for convert in utf 8 or this the upgrade process who say this ?

when i try to upgrade it displays the error as soon as the convertutf8 stage starts

so i then manually changed the database to utf8, hoping to avoid that stage of the upgrade

however it continues to go to the convertutf8 stage and error out when looking for that file

 

[DavidPolak]

Get into your SQL tables and convert them to UTF-8

[huski]

I am still stuck on this conversion stage, all my databases are 10 years old and create the same similar error messages looking for a profile .jpg

Have tried everything, but can not get past this error message, any suggestions appreciated

[James]

The question(s) in this support topic have been answered and the topic author has resolved their issue. This topic is now closed. If you have other questions, please open a new topic.