Software / code / prosody
Changeset
5712:177fe6978ba8
Merge 0.9->trunk
| author | Matthew Wild <mwild1@gmail.com> |
|---|---|
| date | Mon, 24 Jun 2013 18:29:04 +0100 |
| parents | 5710:e66bbfdf588e (current diff) 5711:254a9420e53d (diff) |
| children | 5713:5cf6dedf36f4 |
| files | |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/plugins/mod_storage_sql2.lua Thu Jun 20 21:47:38 2013 +0200 +++ b/plugins/mod_storage_sql2.lua Mon Jun 24 18:29:04 2013 +0100 @@ -85,7 +85,7 @@ module:log("warn", "Found %d columns in prosody table requiring encoding change, updating now...", n_bad_columns); local fix_column_query1 = "ALTER TABLE `prosody` CHANGE `%s` `%s` BLOB;"; local fix_column_query2 = "ALTER TABLE `prosody` CHANGE `%s` `%s` %s CHARACTER SET 'utf8' COLLATE 'utf8_bin';"; - for row in success:rows() do + for row in result:rows() do local column_name, column_type = unpack(row); engine:execute(fix_column_query1:format(column_name, column_name)); engine:execute(fix_column_query2:format(column_name, column_name, column_type));
