Changing DataBase to UTF8

[zurgenaboy]

whilst trying to convert my DB to UTF-8 I get this message:

ALTER TABLE smf_gallery_title_cache
CHANGE COLUMN title title blob NOT NULLApply Filter: Only show the errors from this file
File:smf/Sources/ManageMaintenance.php
Line: 666

line 666 is the last line in the code below:
      

Code Select Expand

// Change the columns to binary form.
$smcFunc['db_query']('', '
ALTER TABLE {raw:table_name}{raw:updates_blob}',
array(
'table_name' => $table_info['Name'],
'updates_blob' => substr($updates_blob, 0, -1),
)
);

What does it mean, and how can I get this to work please.

smf 2.0.11

[Kindred]

That's a mod specific table...    I think you may need to talk to that mod's author...  (in the support topic for that mod)

[zurgenaboy]

Thank you Kindred

[Illori]

whilst trying to convert my DB to UTF-8 I get this message:

ALTER TABLE smf_gallery_title_cache
CHANGE COLUMN title title blob NOT NULLApply Filter: Only show the errors from this file

right but that part is not a default table.

[zurgenaboy]

I have removed that mod and it still occurs, when I indeed, use the smf db function

[Illori]

unless you removed the tables used by that mod, uninstalling the mod has no effect on this.

[zurgenaboy]

I was just thinking about deleting the tables for that mod, but I have never done that before  (a couple of other mods that I have removed still remain in the db as well)

[zurgenaboy]

The reason for the change is that I am trying to create a backup db on another ip provider that has a control panel and there seems to be a problem with the db import.
I have been trying to sort this out since before Xmas:
this link explains the first problem:
http://www.simplemachines.org/community/index.php?topic=542216.0
Until I get one sorted out I cannot fix the other.

Thank you for your replies.