Upgrade to SMF 1.1.3 from 1.0.9

[mpMS]

SMF Version: SMF 1.0.9
Can I upgrade my SMF 1.0.0 to 1.1.3 directly?

[Herman's Mixen]

yes you can use the upgrade package 

http://www.simplemachines.org/download/index.php?thanks;filename=smf_1-1-3_upgrade.zip

[mpMS]

yes you can use the upgrade package 

http://www.simplemachines.org/download/index.php?thanks;filename=smf_1-1-3_upgrade.zip

Any instruction that I may follow?

[Herman's Mixen]

upload all files from that package to your host and overwrite them all
in this package there is no settings.php or settings_bak.php
so leave those alone !!

after uploading run http://www.domain.ext/forum_location/upgrade.php

after that remove upgrade.php

[mpMS]

have tried it and I encounter problem:

Updating and creating indexes... Unsuccessful!

This query:
ALTER TABLE smf_tel_smileys
ORDER BY LENGTH(code) DESC;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LENGTH(code) DESC' at line 2

what does it mean?

[mpMS]

Any update? I just restore my previous version to make the forum usable. What do I need to do with this problem?

[shadow82x]

have tried it and I encounter problem:

Updating and creating indexes... Unsuccessful!

This query:
ALTER TABLE smf_tel_smileys
ORDER BY LENGTH(code) DESC;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LENGTH(code) DESC' at line 2

what does it mean?

Looks like that error can be caused by your host

[mpMS]

so what do I need to do? Any recommended actions?

[shadow82x]

I would ask your host. Do you have any mods installed?

[mpMS]

I would ask your host. Do you have any mods installed?

Here is the list from my package manager:

Mod Name Version   
1. SMF 1.0.9 and 1.1 RC3-1 Security Patch 1.0.8/1.1 RC3
2. SMF Gallery Lite 1.7.6 

Does this have an effect on the system?

[shadow82x]

No those shouldn't I would ask your host

[mpMS]

No those shouldn't I would ask your host

What is the information you need?

[SubSane]

A helpful user called Kreos posted this:

OK.... i ave resolved
open upgrade_1-1.sql

sobstitute this string:

ALTER TABLE {$db_prefix}smileys
ORDER BY LENGTH(code) DESC;

with:

ALTER TABLE {$db_prefix}smileys ;

[mpMS]

A helpful user called Kreos posted this:

OK.... i ave resolved
open upgrade_1-1.sql

sobstitute this string:

ALTER TABLE {$db_prefix}smileys
ORDER BY LENGTH(code) DESC;

with:

ALTER TABLE {$db_prefix}smileys ;

Shall I update the upgrade_1-1.sql or the upgrade_1-0.sql? remember I am using 1.0.9 .

Need your advice

[Sarge]

Shall I update the upgrade_1-1.sql or the upgrade_1-0.sql? remember I am using 1.0.9 .

Why not modify both?

[mpMS]

Already modified the 1-1 and run again the upgrade. receive a new error:

Upgrading...
Upgrading log system... Unsuccessful!

This query:
UPDATE smf_tel_log_boards
SET ID_MSG = IF(logTime BETWEEN 1 AND 1159575753, 1, IF(logTime <= 1159577624, 2, IF(logTime <= 1159579108, 3, IF(logTime <= 1159579211, 4, IF(logTime <= 1159585872, 5, IF(logTime <= 1159585942, 6, IF(logTime <= 1159757510, 7, IF(logTime <= 1159776727, 8, IF(logTime <= 1159778567, 9, IF(logTime <= 1159848722, 10, IF(logTime <= 1159862743, 11, IF(logTime <= 1160035684, 12, IF(logTime <= 1160591503, 13, IF(logTime <= 1160591745, 14, IF(logTime <= 1160607471, 15, IF(logTime <= 1160679383, 16, IF(logTime <= 1160679646, 17, IF(logTime <= 1160933608, 18, IF(logTime <= 1162841004, 19, IF(logTime <= 1162841152, 20, IF(logTime <= 1162841214, 21, IF(logTime <= 1162842289, 22, IF(logTime <= 1162929655, 23, IF(logTime <= 1162931874, 24, IF(logTime <= 1162947768, 25, IF(logTime <= 1163098358, 26, IF(logTime <= 1163106562, 27, IF(logTime <= 1163107362, 28, IF(logTime <= 1163199627, 29, IF(logTime <= 1163355292, 30, IF(logTime <= 1163356747, 31, IF(logTime <= 1163359663, 32, IF(logTime <= 1163359784, 33, IF(logTime <= 1163434445, 34, IF(logTime <= 1163454423, 35, IF(logTime <= 1163959805, 36, IF(logTime <= 1163961703, 37, IF(logTime <= 1163962465, 38, IF(logTime <= 1164061679, 39, IF(logTime <= 1164065400, 40, IF(logTime <= 1164066683, 41, IF(logTime <= 1164066758, 42, IF(logTime <= 1164143092, 43, IF(logTime <= 1164219607, 44, IF(logTime <= 1164241318, 45, IF(logTime <= 1164242343, 46, IF(logTime <= 1164242498, 47, IF(logTime <= 1164386895, 48, IF(logTime <= 1164387559, 49, IF(logTime <= 1164388152, 50, IF(logTime <= 1164399910, 51, IF(logTime <= 1164400458, 52, IF(logTime <= 1164557231, 53, IF(logTime <= 1164561915, 54, IF(logTime <= 1164580385, 55, IF(logTime <= 1164580774, 56, IF(logTime <= 1164587943, 57, IF(logTime <= 1164588755, 58, IF(logTime <= 1164588806, 59, IF(logTime <= 1164733229, 60, IF(logTime <= 1164733262, 61, IF(logTime <= 1164749260, 62, IF(logTime <= 1164749820, 63, IF(logTime <= 1164750927, 64, IF(logTime <= 1164994927, 65, IF(logTime <= 1165010303, 66, IF(logTime <= 1165173739, 67, IF(logTime <= 1165174395, 68, IF(logTime <= 1165180828, 69, IF(logTime <= 1165182363, 70, IF(logTime <= 1165188513, 71, IF(logTime <= 1165193848, 72, IF(logTime <= 1165193878, 73, IF(logTime <= 1165346593, 74, IF(logTime <= 1165346903, 75, IF(logTime <= 1165356699, 76, IF(logTime <= 1165363446, 77, IF(logTime <= 1165445687, 78, IF(logTime <= 1165446468, 79, IF(logTime <= 1165447051, 80, IF(logTime <= 1165453525, 81, IF(logTime <= 1165453784, 82, IF(logTime <= 1165863451, 83, IF(logTime <= 1165870600, 84, IF(logTime <= 1165969979, 85, IF(logTime <= 1165972209, 86, IF(logTime <= 1166026651, 87, IF(logTime <= 1166027688, 88, IF(logTime <= 1166028588, 89, IF(logTime <= 1166053309, 90, IF(logTime <= 1166547605, 91, IF(logTime <= 1166549978, 92, IF(logTime <= 1166550711, 93, IF(logTime <= 1166550990, 94, IF(logTime <= 1166551408, 95, IF(logTime <= 1166554214, 96, IF(logTime <= 1166557396, 97, IF(logTime <= 1166557552, 98, IF(logTime <= 1166558034, 99, IF(logTime <= 1166641565, 100, IF(logTime <= 1167693728, 101, IF(logTime <= 1167784917, 102, IF(logTime <= 1167936401, 103, IF(logTime <= 1168015098, 104, IF(logTime <= 1168186179, 105, IF(logTime <= 1168214838, 106, IF(logTime <= 1168359760, 107, IF(logTime <= 1168385178, 108, IF(logTime <= 1168387600, 109, IF(logTime <= 1168791545, 110, IF(logTime <= 1168811534, 111, IF(logTime <= 1168814344, 112, IF(logTime <= 1169145776, 113, IF(logTime <= 1169163484, 114, IF(logTime <= 1169567870, 115, IF(logTime <= 1169567943, 116, IF(logTime <= 1169747261, 117, IF(logTime <= 1169751086, 118, IF(logTime <= 1169762702, 119, IF(logTime <= 1169764464, 120, IF(logTime <= 1170365426, 121, IF(logTime <= 1170365730, 122, IF(logTime <= 1170368890, 123, IF(logTime <= 1170369586, 124, IF(logTime <= 1170371014, 125, IF(logTime <= 1170397422, 126, IF(logTime <= 1170606238, 127, IF(logTime <= 1170608570, 128, IF(logTime <= 1170627414, 129, IF(logTime <= 1170802700, 130, IF(logTime <= 1170803131, 131, IF(logTime <= 1170803984, 132, IF(logTime <= 1170807405, 133, IF(logTime <= 1170809112, 134, IF(logTime <= 1170810252, 135, IF(logTime <= 1170867841, 136, IF(logTime <= 1170874054, 137, IF(logTime <= 1170875103, 138, IF(logTime <= 1170876036, 139, IF(logTime <= 1170896647, 140, IF(logTime <= 1170898049, 141, IF(logTime <= 1170898085, 142, IF(logTime <= 1170943144, 143, IF(logTime <= 1170950446, 144, IF(logTime <= 1171062381, 145, IF(logTime <= 1171142452, 146, IF(logTime <= 1171210035, 147, IF(logTime <= 1171211218, 148, IF(logTime <= 1171292580, 149, IF(logTime <= 1171300912, 150, IF(logTime <= 1171304182, 151, IF(logTime <= 1171316849, 152, IF(logTime <= 1171317580, 153, IF(logTime <= 1171317941, 154, IF(logTime <= 1171318158, 155, IF(logTime <= 1171318303, 156, IF(logTime <= 1171331348, 157, IF(logTime <= 1171382570, 158, IF(logTime <= 1171918236, 159, IF(logTime <= 1171919649, 160, IF(logTime <= 1171993895, 161, IF(logTime <= 1172018842, 162, IF(logTime <= 1172019180, 163, IF(logTime <= 1172019894, 164, IF(logTime <= 1172081926, 165, IF(logTime <= 1172083968, 166, IF(logTime <= 1172153643, 167, IF(logTime <= 1172159964, 168, IF(logTime <= 1172160038, 169, IF(logTime <= 1172191053, 170, IF(logTime <= 1172206968, 171, IF(logTime <= 1172246252, 172, IF(logTime <= 1172264834, 173, IF(logTime <= 1172266454, 174, IF(logTime <= 1172286537, 175, IF(logTime <= 1172419701, 176, IF(logTime <= 1172419960, 177, IF(logTime <= 1172517937, 178, IF(logTime <= 1172518275, 179, IF(logTime <= 1172518346, 180, IF(logTime <= 1172522125, 181, IF(logTime <= 1172525838, 182, IF(logTime <= 1172537187, 183, IF(logTime <= 1172593583, 184, IF(logTime <= 1172594459, 185, IF(logTime <= 1172613882, 186, IF(logTime <= 1172614442, 187, IF(logTime <= 1172615425, 188, IF(logTime <= 1172615443, 189, IF(logTime <= 1172713137, 190, IF(logTime <= 1172765467, 191, IF(logTime <= 1172855239, 192, IF(logTime <= 1173025711, 193, IF(logTime <= 1173027264, 194, IF(logTime <= 1173117670, 195, IF(logTime <= 1173138766, 196, IF(logTime <= 1173197009, 197, IF(logTime <= 1173197417, 198, IF(logTime <= 1173216601, 199, IF(logTime <= 1173218622, 200, IF(logTime <= 1173220012, 201, IF(logTime <= 1173220020, 202, IF(logTime <= 1173220203, 203, IF(logTime <= 1173221154, 204, IF(logTime <= 1173285002, 205, IF(logTime <= 1173285797, 206, IF(logTime <= 1173289325, 207, IF(logTime <= 1173289499, 208, IF(logTime <= 1173289857, 209, IF(logTime <= 1173290043, 210, IF(logTime <= 1173290388, 211, IF(logTime <= 1173313849, 212, IF(logTime <= 1173314208, 213, IF(logTime <= 1173474956, 214, IF(logTime <= 1173474974, 215, IF(logTime <= 1173536184, 216, IF(logTime <= 1173629220, 217, IF(logTime <= 1173629565, 218, IF(logTime <= 1173632976, 219, IF(logTime <= 1173633011, 220, IF(logTime <= 1173633448, 221, IF(logTime <= 1173633491, 222, IF(logTime <= 1173634033, 223, IF(logTime <= 1173634255, 224, IF(logTime <= 1173634327, 225, IF(logTime <= 1173634612, 226, IF(logTime <= 1173636114, 227, IF(logTime <= 1173636672, 228, IF(logTime <= 1173648023, 229, IF(logTime <= 1173648838, 230, IF(logTime <= 1173649819, 231, IF(logTime <= 1173649874, 232, IF(logTime <= 1173654006, 233, IF(logTime <= 1173655226, 234, IF(logTime <= 1173824894, 235, IF(logTime <= 1173825147, 236, IF(logTime <= 1173825181, 237, IF(logTime <= 1173890926, 238, IF(logTime <= 1173900460, 239, IF(logTime <= 1173900911, 240, IF(logTime <= 1173984172, 241, IF(logTime <= 1173985102, 242, IF(logTime <= 1173995738, 243, IF(logTime <= 1173996735, 244, IF(logTime <= 1174247239, 245, IF(logTime <= 1174248104, 246, IF(logTime <= 1174257580, 247, IF(logTime <= 1174316794, 248, IF(logTime <= 1174332666, 249, IF(logTime <= 1174344301, 250, IF(logTime <= 1174407166, 251, IF(logTime <= 1174407497, 252, IF(logTime <= 1174408731, 253, IF(logTime <= 1174409637, 254, IF(logTime <= 1174409748, 255, IF(logTime <= 1174834691, 256, IF(logTime <= 1174837187, 257, IF(logTime <= 1174935243, 258, IF(logTime <= 1174935473, 259, IF(logTime <= 1174944236, 260, IF(logTime <= 1174944526, 261, IF(logTime <= 1175019147, 262, IF(logTime <= 1175019355, 263, IF(logTime <= 1175030050, 264, IF(logTime <= 1175032331, 265, IF(logTime <= 1175037148, 266, IF(logTime <= 1175037699, 267, IF(logTime <= 1175043900, 268, IF(logTime <= 1175044695, 269, IF(logTime <= 1175097022, 270, IF(logTime <= 1175097218, 271, IF(logTime <= 1175097739, 272, IF(logTime <= 1175184260, 273, IF(logTime <= 1175185478, 274, IF(logTime <= 1175190907, 275, IF(logTime <= 1175191590, 276, IF(logTime <= 1175446852, 277, IF(logTime <= 1175448935, 278, IF(logTime <= 1175449658, 279, IF(logTime <= 1175450585, 280, IF(logTime <= 1175451395, 281, IF(logTime <= 1175453059, 282, IF(logTime <= 1175465252, 283, IF(logTime <= 1175466124, 284, IF(logTime <= 1175467762, 285, IF(logTime <= 1175468165, 286, IF(logTime <= 1175529721, 287, IF(logTime <= 1175541558, 288, IF(logTime <= 1175542020, 289, IF(logTime <= 1175559385, 290, IF(logTime <= 1175559631, 291, IF(logTime <= 1175565722, 292, IF(logTime <= 1175615836, 293, IF(logTime <= 1175620581, 294, IF(logTime <= 1175621265, 295, IF(logTime <= 1176157577, 296, IF(logTime <= 1176158552, 297, IF(logTime <= 1176238838, 298, IF(logTime <= 1176242768, 299, IF(logTime <= 1176243030, 300, 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
WHERE logTime BETWEEN 1 AND 1176243031
AND ID_MSG = 0;
Caused the error:
Thread stack overrun: 119084 bytes used of a 131072 byte stack, and 12000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

[Sarge]

I think (although I'm not sure) that it has to do with limitations set by your host. Contact them and point them to your last post above.

[mpMS]

Sorry sarge, I am new to mysql 

Can you help me what to do on mysql? How to increase thread stack on mysql?

[Sarge]

What version of MySQL is installed on the server?

If it is 5.0.22 or 5.0.32, I just found a confirmed bug report for them:
http://bugs.mysql.com/bug.php?id=21476

Verified on Linux using BK sources.

It is only repeatable with thread_stack value closed to really needed.

Ask your host to increase thread_stack and/or upgrade MySQL.

[mpMS]

What version of MySQL is installed on the server?

If it is 5.0.22 or 5.0.32, I just found a confirmed bug report for them:
http://bugs.mysql.com/bug.php?id=21476

Verified on Linux using BK sources.

It is only repeatable with thread_stack value closed to really needed.

Ask your host to increase thread_stack and/or upgrade MySQL.

Can you help me how to do this?