News:

Wondering if this will always be free?  See why free is better.

Main Menu

problema al actualizar la version

Started by yako200, August 20, 2006, 08:53:14 PM

Previous topic - Next topic

yako200

estoi intentando actualizar la verrison de my smf de la 107 a la 1-1rc2 y cuando esta haciendo el upgrade me sale este error

Thread stack overrun: 118796 bytes used of a 126976 byte stack, and 8192 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

el problema es que tengo darle mas valor a este comando del mysql thread_stack y no se como hacerlo puedo hacerlo mediante una consulta? y como por que he intentado un monton de cosas pero nada

gracias

Pedi que me borren

Si tenias mods instalados, deaparecen, y puede que la BD lo este llamando...verifica de tener 41 tablas que son las originales...
Y repara las tablas desde phpmyadmin..

yako200

a que te refieres con eso por que yo tengo el mkportal instalado y tengo 64 tablas y este es el error que me da al intentarlo, a que te refieres acuando dices que repare las tablas?

Upgrading log system... Unsuccessful!

This query:
UPDATE smf_log_boards
SET ID_MSG = IF(logTime BETWEEN 1 AND 1149289470, 5, IF(logTime <= 1149289810, 6, IF(logTime <= 1149290739, 7, IF(logTime <= 1149292580, 9, IF(logTime <= 1149293807, 10, IF(logTime <= 1149294039, 11, IF(logTime <= 1149370499, 12, IF(logTime <= 1149517128, 13, IF(logTime <= 1149598206, 14, IF(logTime <= 1149598480, 15, IF(logTime <= 1149602664, 16, IF(logTime <= 1149603839, 17, IF(logTime <= 1149604015, 18, IF(logTime <= 1149604207, 19, IF(logTime <= 1149607967, 20, IF(logTime <= 1149633117, 21, IF(logTime <= 1149635606, 22, IF(logTime <= 1149636374, 23, IF(logTime <= 1149637587, 24, IF(logTime <= 1149638384, 25, IF(logTime <= 1149638411, 26, IF(logTime <= 1149687957, 28, IF(logTime <= 1149690716, 30, IF(logTime <= 1149714302, 31, IF(logTime <= 1149714552, 32, IF(logTime <= 1149715486, 33, IF(logTime <= 1149723329, 34, IF(logTime <= 1149724653, 35, IF(logTime <= 1149726307, 36, IF(logTime <= 1149727738, 37, IF(logTime <= 1149728651, 38, IF(logTime <= 1149798388, 39, IF(logTime <= 1149799602, 40, IF(logTime <= 1149800219, 41, IF(logTime <= 1149955041, 45, IF(logTime <= 1149956934, 46, IF(logTime <= 1149961971, 47, IF(logTime <= 1150024090, 48, IF(logTime <= 1150037826, 49, IF(logTime <= 1150046261, 50, IF(logTime <= 1150053510, 51, IF(logTime <= 1150053582, 52, IF(logTime <= 1150063470, 53, IF(logTime <= 1150070828, 54, IF(logTime <= 1150076027, 55, IF(logTime <= 1150097037, 56, IF(logTime <= 1150097292, 57, IF(logTime <= 1150102663, 58, IF(logTime <= 1150118180, 59, IF(logTime <= 1150136831, 60, IF(logTime <= 1150138550, 61, IF(logTime <= 1150147981, 62, IF(logTime <= 1150148698, 63, IF(logTime <= 1150190328, 64, IF(logTime <= 1150212171, 65, IF(logTime <= 1150281094, 66, IF(logTime <= 1150322945, 67, IF(logTime <= 1150399537, 68, IF(logTime <= 1150770385, 70, IF(logTime <= 1150805902, 71, IF(logTime <= 1150920071, 72, IF(logTime <= 1151194724, 73, IF(logTime <= 1151236450, 75, IF(logTime <= 1151253131, 76, IF(logTime <= 1151319509, 77, IF(logTime <= 1151405077, 78, IF(logTime <= 1151589881, 79, IF(logTime <= 1151657003, 80, IF(logTime <= 1151706092, 81, IF(logTime <= 1151748064, 82, IF(logTime <= 1151748278, 83, IF(logTime <= 1151800845, 89, IF(logTime <= 1151801301, 90, IF(logTime <= 1151801375, 91, IF(logTime <= 1151801420, 92, IF(logTime <= 1151802324, 93, IF(logTime <= 1151828826, 94, IF(logTime <= 1151836055, 95, IF(logTime <= 1151942539, 96, IF(logTime <= 1151943121, 97, IF(logTime <= 1151943759, 98, IF(logTime <= 1152038265, 100, IF(logTime <= 1152184953, 101, IF(logTime <= 1152214698, 102, IF(logTime <= 1152216027, 103, IF(logTime <= 1152283681, 104, IF(logTime <= 1152357321, 105, IF(logTime <= 1152364322, 106, IF(logTime <= 1152367251, 107, IF(logTime <= 1152369133, 108, IF(logTime <= 1152389007, 109, IF(logTime <= 1152549942, 110, IF(logTime <= 1152569585, 111, IF(logTime <= 1153239318, 114, IF(logTime <= 1153242581, 115, IF(logTime <= 1153242692, 116, IF(logTime <= 1153243005, 117, IF(logTime <= 1153249485, 118, IF(logTime <= 1153298709, 119, IF(logTime <= 1153299050, 120, IF(logTime <= 1153299880, 121, IF(logTime <= 1153301989, 122, IF(logTime <= 1153304683, 123, IF(logTime <= 1153305480, 124, IF(logTime <= 1153305706, 125, IF(logTime <= 1153306019, 126, IF(logTime <= 1153309482, 127, IF(logTime <= 1153309529, 128, IF(logTime <= 1153309544, 129, IF(logTime <= 1153314857, 130, IF(logTime <= 1153315830, 131, IF(logTime <= 1153316046, 132, IF(logTime <= 1153316771, 133, IF(logTime <= 1153326731, 134, IF(logTime <= 1153327024, 135, IF(logTime <= 1153346939, 136, IF(logTime <= 1153399732, 137, IF(logTime <= 1153414060, 138, IF(logTime <= 1153427892, 139, IF(logTime <= 1153432661, 140, IF(logTime <= 1153434025, 141, IF(logTime <= 1153435108, 142, IF(logTime <= 1153436086, 143, IF(logTime <= 1153436163, 144, IF(logTime <= 1153436642, 145, IF(logTime <= 1153437289, 146, IF(logTime <= 1153438044, 147, IF(logTime <= 1153438086, 148, IF(logTime <= 1153438104, 149, IF(logTime <= 1153438130, 150, IF(logTime <= 1153438147, 151, IF(logTime <= 1153438168, 152, IF(logTime <= 1153438197, 153, IF(logTime <= 1153438215, 154, IF(logTime <= 1153438233, 155, IF(logTime <= 1153438254, 156, IF(logTime <= 1153438273, 157, IF(logTime <= 1153438331, 158, IF(logTime <= 1153438350, 159, IF(logTime <= 1153438365, 160, IF(logTime <= 1153438384, 161, IF(logTime <= 1153438402, 162, IF(logTime <= 1153438443, 163, IF(logTime <= 1153438468, 164, IF(logTime <= 1153438485, 165, IF(logTime <= 1153438515, 166, IF(logTime <= 1153438534, 167, IF(logTime <= 1153438554, 168, IF(logTime <= 1153438572, 169, IF(logTime <= 1153438580, 170, IF(logTime <= 1153438615, 171, IF(logTime <= 1153438673, 172, IF(logTime <= 1153438727, 173, IF(logTime <= 1153438738, 174, IF(logTime <= 1153438763, 175, IF(logTime <= 1153438778, 176, IF(logTime <= 1153438791, 177, IF(logTime <= 1153438818, 178, IF(logTime <= 1153438838, 179, IF(logTime <= 1153438892, 180, IF(logTime <= 1153438909, 181, IF(logTime <= 1153438928, 182, IF(logTime <= 1153438966, 183, IF(logTime <= 1153439659, 184, IF(logTime <= 1153442026, 186, IF(logTime <= 1153442251, 187, IF(logTime <= 1153532249, 188, IF(logTime <= 1153614854, 189, IF(logTime <= 1153617022, 190, IF(logTime <= 1153664252, 191, IF(logTime <= 1153679702, 192, IF(logTime <= 1153699015, 195, IF(logTime <= 1153701002, 197, IF(logTime <= 1153701739, 198, IF(logTime <= 1153702028, 199, IF(logTime <= 1153702470, 200, IF(logTime <= 1153722792, 202, IF(logTime <= 1153722881, 203, IF(logTime <= 1153728096, 205, IF(logTime <= 1153729902, 206, IF(logTime <= 1153734698, 207, IF(logTime <= 1153736193, 208, IF(logTime <= 1153739959, 209, IF(logTime <= 1153741622, 210, IF(logTime <= 1153773514, 211, IF(logTime <= 1153779818, 212, IF(logTime <= 1153805671, 213, IF(logTime <= 1153815082, 214, IF(logTime <= 1153815700, 215, IF(logTime <= 1153815885, 216, IF(logTime <= 1153816214, 217, IF(logTime <= 1153816267, 218, IF(logTime <= 1153818030, 219, IF(logTime <= 1153821628, 220, IF(logTime <= 1153824301, 221, IF(logTime <= 1153851380, 222, IF(logTime <= 1153855332, 223, IF(logTime <= 1153856034, 224, IF(logTime <= 1153863639, 225, IF(logTime <= 1153871422, 226, IF(logTime <= 1153881428, 227, IF(logTime <= 1153884376, 228, IF(logTime <= 1153899067, 229, IF(logTime <= 1153909101, 230, IF(logTime <= 1153909499, 231, IF(logTime <= 1153909526, 232, IF(logTime <= 1153910496, 233, IF(logTime <= 1153911647, 234, IF(logTime <= 1153912007, 235, IF(logTime <= 1153913297, 236, IF(logTime <= 1153913917, 237, IF(logTime <= 1153914714, 238, IF(logTime <= 1153915369, 239, IF(logTime <= 1153915910, 240, IF(logTime <= 1153915990, 241, IF(logTime <= 1153930955, 242, IF(logTime <= 1153931254, 243, IF(logTime <= 1153931411, 244, IF(logTime <= 1153934567, 245, IF(logTime <= 1153936979, 246, IF(logTime <= 1153939950, 247, IF(logTime <= 1153948167, 248, IF(logTime <= 1153964636, 249, IF(logTime <= 1153969677, 250, IF(logTime <= 1153983373, 251, IF(logTime <= 1153991893, 252, IF(logTime <= 1153995906, 253, IF(logTime <= 1153997033, 254, IF(logTime <= 1154011338, 255, IF(logTime <= 1154024444, 256, IF(logTime <= 1154027191, 257, IF(logTime <= 1154027335, 258, IF(logTime <= 1154031571, 259, IF(logTime <= 1154037523, 260, IF(logTime <= 1154040275, 261, IF(logTime <= 1154040528, 262, IF(logTime <= 1154042859, 264, IF(logTime <= 1154043405, 265, IF(logTime <= 1154043636, 266, IF(logTime <= 1154050701, 267, IF(logTime <= 1154068459, 268, IF(logTime <= 1154073013, 269, IF(logTime <= 1154074657, 270, IF(logTime <= 1154074725, 271, IF(logTime <= 1154075908, 272, IF(logTime <= 1154080773, 273, IF(logTime <= 1154086200, 274, IF(logTime <= 1154088491, 275, IF(logTime <= 1154093845, 276, IF(logTime <= 1154104552, 279, IF(logTime <= 1154104671, 280, IF(logTime <= 1154109033, 282, IF(logTime <= 1154133526, 283, IF(logTime <= 1154136030, 284, IF(logTime <= 1154167549, 285, IF(logTime <= 1154184905, 286, IF(logTime <= 1154188823, 287, IF(logTime <= 1154189916, 288, IF(logTime <= 1154190484, 289, IF(logTime <= 1154197083, 290, IF(logTime <= 1154201877, 291, IF(logTime <= 1154213738, 292, IF(logTime <= 1154214300, 293, IF(logTime <= 1154215184, 294, IF(logTime <= 1154219903, 295, IF(logTime <= 1154228808, 296, IF(logTime <= 1154253555, 297, IF(logTime <= 1154254122, 298, IF(logTime <= 1154258799, 299, IF(logTime <= 1154264989, 300, IF(logTime <= 1154277267, 301, IF(logTime <= 1154281759, 302, IF(logTime <= 1154286535, 303, IF(logTime <= 1154287894, 304, IF(logTime <= 1154290380, 305, IF(logTime <= 1154290666, 306, IF(logTime <= 1154290733, 307, IF(logTime <= 1154290777, 308, IF(logTime <= 1154290927, 309, IF(logTime <= 1154291025, 310, IF(logTime <= 1154294447, 311, IF(logTime <= 1154294725, 312, IF(logTime <= 1154299535, 314, IF(logTime <= 1154300367, 315, IF(logTime <= 1154301966, 316, IF(logTime <= 1154302657, 317, IF(logTime <= 1154303032, 318, IF(logTime <= 1154303166, 319, IF(logTime <= 1154303847, 320, IF(logTime <= 1154303848, 321, IF(logTime <= 1154304542, 322, IF(logTime <= 1154305201, 323, IF(logTime <= 1154306616, 324, IF(logTime <= 1154309931, 325, IF(logTime <= 1154338804, 326, IF(logTime <= 1154339034, 327, IF(logTime <= 1154342073, 328, IF(logTime <= 1154343396, 329, IF(logTime <= 1154344166, 330, IF(logTime <= 1154344671, 331, IF(logTime <= 1154347101, 332, IF(logTime <= 1154347208, 333, IF(logTime <= 1154349591, 334, IF(logTime <= 1154349799, 335, IF(logTime <= 1154350009, 336, IF(logTime <= 1154355206, 337, IF(logTime <= 1154370154, 338, IF(logTime <= 1154370365, 339, IF(logTime <= 1154375902, 341, IF(logTime <= 1154385403, 342, IF(logTime <= 1154416839, 344, IF(logTime <= 1154430463, 346, IF(logTime <= 1154431658, 347, IF(logTime <= 1154431816, 348, IF(logTime <= 1154435940, 350, IF(logTime <= 1154436599, 351, IF(logTime <= 1154436687, 352, IF(logTime <= 1154438853, 353, IF(logTime <= 1154439041, 354, IF(logTime <= 1154440359, 355, IF(logTime <= 1154440441, 356, IF(logTime <= 1154441013, 357, IF(logTime <= 1154441918, 358, IF(logTime <= 1154457772, 362, IF(logTime <= 1154458087, 363, IF(logTime <= 1154458105, 364, IF(logTime <= 1154458526, 365, IF(logTime <= 1154458841, 366, IF(logTime <= 1154458951, 367, IF(logTime <= 1154460207, 368, IF(logTime <= 1154460612, 369, IF(logTime <= 1154465818, 370, IF(logTime <= 1154466280, 371, IF(logTime <= 1154466820, 372, IF(logTime <= 1154467064, 373, IF(logTime <= 1154471511, 374, IF(logTime <= 1154477998, 375, IF(logTime <= 1154478209, 376, IF(logTime <= 1154478348, 377, IF(logTime <= 1154506672, 378, IF(logTime <= 1154513263, 379, IF(logTime <= 1154515694, 380, IF(logTime <= 1154517071, 381, IF(logTime <= 1154517681, 382, IF(logTime <= 1154520856, 383, IF(logTime <= 1154524443, 384, IF(logTime <= 1154527511, 385, IF(logTime <= 1154527583, 386, IF(logTime <= 1154530555, 387, IF(logTime <= 1154537174, 388, IF(logTime <= 1154537310, 389, IF(logTime <= 1154537629, 390, IF(logTime <= 1154539429, 391, IF(logTime <= 1154542125, 392, IF(logTime <= 1154542276, 393, IF(logTime <= 1154542708, 394, IF(logTime <= 1154542768, 395, IF(logTime <= 1154544049, 396, IF(logTime <= 1154544687, 397, IF(logTime <= 1154547243, 398, IF(logTime <= 1154554013, 400, IF(logTime <= 1154557770, 401, IF(logTime <= 1154558724, 402, IF(logTime <= 1154558776, 403, IF(logTime <= 1154558961, 404, IF(logTime <= 1154559266, 405, IF(logTime <= 1154559311, 406, IF(logTime <= 1154560251, 407, IF(logTime <= 1154585238, 409, IF(logTime <= 1154588666, 410, IF(logTime <= 1154591576, 411, IF(logTime <= 1154593797, 412, IF(logTime <= 1154594830, 413, IF(logTime <= 1154596263, 414, IF(logTime <= 1154596491, 415, IF(logTime <= 1154596830, 416, IF(logTime <= 1154597166, 417, IF(logTime <= 1154600425, 418, IF(logTime <= 1154600968, 419, IF(logTime <= 1154602770, 420, IF(logTime <= 1154602899, 421, IF(logTime <= 1154603012, 422, IF(logTime <= 1154603139, 423, IF(logTime <= 1154609208, 426, IF(logTime <= 1154611350, 427, IF(logTime <= 1154611966, 428, IF(logTime <= 1154615223, 429, IF(logTime <= 1154615556, 431, IF(logTime <= 1154615747, 432, IF(logTime <= 1154618248, 433, IF(logTime <= 1154618312, 434, IF(logTime <= 1154618796, 435, IF(logTime <= 1154620643, 436, IF(logTime <= 1154626708, 437, IF(logTime <= 1154626734, 438, IF(logTime <= 1154626823, 439, IF(logTime <= 1154630842, 441, IF(logTime <= 1154644365, 442, IF(logTime <= 1154645554, 443, IF(logTime <= 1154645934, 444, IF(logTime <= 1154646569, 445, IF(logTime <= 1154647472, 446, IF(logTime <= 1154648215, 447, IF(logTime <= 1154668087, 449, IF(logTime <= 1154676645, 450, IF(logTime <= 1154682894, 451, IF(logTime <= 1154688258, 452, IF(logTime <= 1154688608, 453, IF(logTime <= 1154693348, 454, IF(logTime <= 1154693585, 455, IF(logTime <= 1154694118, 456, IF(logTime <= 1154697467, 457, IF(logTime <= 1154699623, 458, IF(logTime <= 1154699731, 459, IF(logTime <= 1154699910, 460, IF(logTime <= 1154700281, 461, IF(logTime <= 1154700461, 462, IF(logTime <= 1154700594, 463, IF(logTime <= 1154700715, 464, IF(logTime <= 1154702032, 465, IF(logTime <= 1154702206, 466, IF(logTime <= 1154702310, 467, IF(logTime <= 1154703555, 468, IF(logTime <= 1154704391, 470, IF(logTime <= 1154712507, 471, IF(logTime <= 1154713704, 472, IF(logTime <= 1154713876, 473, IF(logTime <= 1154714530, 474, IF(logTime <= 1154718489, 475, IF(logTime <= 1154720616, 476, IF(logTime <= 1154725237, 477, IF(logTime <= 1154729169, 478, IF(logTime <= 1154733981, 479, IF(logTime <= 1154741083, 480, IF(logTime <= 1154763980, 481, IF(logTime <= 1154769999, 482, IF(logTime <= 1154771111, 483, IF(logTime <= 1154772164, 484, IF(logTime <= 1154773073, 485, IF(logTime <= 1154774463, 486, IF(logTime <= 1154775730, 487, IF(logTime <= 1154776358, 488, IF(logTime <= 1154776729, 489, IF(logTime <= 1154776802, 490, IF(logTime <= 1154778822, 491, IF(logTime <= 1154789714, 492, IF(logTime <= 1154791114, 493, IF(logTime <= 1154791235, 494, IF(logTime <= 1154791353, 495, IF(logTime <= 1154791510, 496, IF(logTime <= 1154794361, 497, IF(logTime <= 1154794669, 498, IF(logTime <= 1154795006, 499, IF(logTime <= 1154797452, 500, 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
WHERE logTime BETWEEN 1 AND 1154797453
AND ID_MSG = 0;
Caused the error:
Thread stack overrun: 118796 bytes used of a 126976 byte stack, and 8192 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

Pedi que me borren

A las tablas de Smf...el mkportal, es aparte.

"Reparar" y "optimizar" las tablas desde phpmyadmin.

Revisa aqui tambien:
http://www.simplemachines.org/community/index.php?topic=63330.0

yako200

Quote from: el bar ® on August 21, 2006, 05:15:06 PM
"Reparar" y "optimizar" las tablas desde phpmyadmin.

entonces lo que me quieres decir es que si las optimizo primero y luego las reparo no deberia de darme ese error?

Advertisement: