1.1 RC2 installation error / Undefined variable: db_name in upgrade.php....

Started by JuhaS14, March 12, 2006, 12:15:30 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

JuhaS14

March 12, 2006, 12:15:30 PM Last Edit: March 12, 2006, 06:05:13 PM by JuhaS14
Upgrading...
Updating and creating indexes... Successful.
Reorganizing configuration settings... Successful.
Installing new default theme... Successful.
Adding and updating member data... Successful.
Updating holidays and calendar... Successful.
Adding custom message icons... Successful.
Adding package servers... Successful.
Cleaning up database... Successful.
Converting avatar permissions... Successful.
Adjusting uploadable avatars... Successful.
Updating thumbnails... Successful.
Updating ban system... Successful.
Updating permissions... Successful.
Updating search cache... Successful.
Upgrading log system...
Notice: Undefined variable: db_name in /var/www/forum/upgrade.php on line 1216
Unsuccessful!

This query:
UPDATE yabbse_log_boards
SET ID_MSG = IF(logTime BETWEEN 1018123457 AND 1016638224, 7802, IF(logTime <= 1016643080, 7803, IF(logTime <= 1016650255, 7804, IF(logTime <= 1016661898, 7805, IF(logTime <= 1016662453, 7806, IF(logTime <= 1016662802, 7807, IF(logTime <= 1016669345, 7808, IF(logTime <= 1016700945, 7809, IF(logTime <= 1016705337, 7810, IF(logTime <= 1016710517, 7811, IF(logTime <= 1016716217, 7812, IF(logTime <= 1017430457, 7813, IF(logTime <= 1017775670, 7588, IF(logTime <= 1017780059, 7589, IF(logTime <= 1017835822, 7590, IF(logTime <= 1017837040, 7591, IF(logTime <= 1017843378, 7592, IF(logTime <= 1017859562, 7593, IF(logTime <= 1017861023, 7594, IF(logTime <= 1017866539, 7595, IF(logTime <= 1017866890, 7596, IF(logTime <= 1017874792, 7597, IF(logTime <= 1018117142, 7598, IF(logTime <= 1018244172, 7599, IF(logTime <= 1018459458, 7836, IF(logTime <= 1019827392, 7851, IF(logTime <= 1019830332, 7852, IF(logTime <= 1020031532, 7853, IF(logTime <= 1020056785, 7854, IF(logTime <= 1020061664, 7855, IF(logTime <= 1020085208, 7856, IF(logTime <= 1020088079, 7857, IF(logTime <= 1020146831, 7858, IF(logTime <= 1020150568, 7859, IF(logTime <= 1020182255, 7860, IF(logTime <= 1020272545, 7600, IF(logTime <= 1020273518, 7814, IF(logTime <= 1020278271, 7837, IF(logTime <= 1020284109, 7601, IF(logTime <= 1020284606, 7815, IF(logTime <= 1020691866, 7602, IF(logTime <= 1020693604, 7603, IF(logTime <= 1020693793, 7832, IF(logTime <= 1020766718, 7604, IF(logTime <= 1020767151, 7816, IF(logTime <= 1020769245, 7817, IF(logTime <= 1020862452, 7833, IF(logTime <= 1020864083, 7834, IF(logTime <= 1020867390, 7835, IF(logTime <= 1021040038, 7605, IF(logTime <= 1021054378, 7606, IF(logTime <= 1021122354, 7607, IF(logTime <= 1021123165, 7822, IF(logTime <= 1021260998, 7823, IF(logTime <= 1021289480, 7824, IF(logTime <= 1021414959, 7825, IF(logTime <= 1021417957, 7826, IF(logTime <= 1021452689, 7818, IF(logTime <= 1021453307, 7819, IF(logTime <= 1021482355, 7820, IF(logTime <= 1021524047, 7821, IF(logTime <= 1022445708, 7608, IF(logTime <= 1022870181, 7609, IF(logTime <= 1024659107, 7946, IF(logTime <= 1024694705, 7947, IF(logTime <= 1024827980, 7948, IF(logTime <= 1024856098, 7949, IF(logTime <= 1024902222, 7950, IF(logTime <= 1024903673, 7951, IF(logTime <= 1024942270, 7952, IF(logTime <= 1024943903, 7953, IF(logTime <= 1025181155, 7954, IF(logTime <= 1025259305, 7955, IF(logTime <= 1025282811, 7668, IF(logTime <= 1025283354, 7669, IF(logTime <= 1025284052, 7670, IF(logTime <= 1025284299, 7671, IF(logTime <= 1025339794, 7956, IF(logTime <= 1025343681, 7957, IF(logTime <= 1025381707, 7672, IF(logTime <= 1025450618, 7673, IF(logTime <= 1025462639, 7674, IF(logTime <= 1025504344, 7675, IF(logTime <= 1025535239, 7958, IF(logTime <= 1025536792, 7959, IF(logTime <= 1025549166, 7960, IF(logTime <= 1025619357, 7961, IF(logTime <= 1025627687, 7962, IF(logTime <= 1026024261, 7736, IF(logTime <= 1026026783, 7737, IF(logTime <= 1026052592, 7738, IF(logTime <= 1026053998, 7739, IF(logTime <= 1026054342, 7740, IF(logTime <= 1026055853, 7741, IF(logTime <= 1026057748, 7742, IF(logTime <= 1026058289, 7743, IF(logTime <= 1026068879, 7744, IF(logTime <= 1026106309, 7745, IF(logTime <= 1026128589, 7746, IF(logTime <= 1026141389, 7758, IF(logTime <= 1026143071, 7759, IF(logTime <= 1026151519, 7760, IF(logTime <= 1026189756, 7747, IF(logTime <= 1026245362, 7748, IF(logTime <= 1026246071, 7749, IF(logTime <= 1026274773, 7750, IF(logTime <= 1026415915, 7942, IF(logTime <= 1026459110, 7943, IF(logTime <= 1026466448, 7944, IF(logTime <= 1026767279, 7761, IF(logTime <= 1026770687, 7762, IF(logTime <= 1026844529, 7763, IF(logTime <= 1027353143, 7754, IF(logTime <= 1027358199, 7755, IF(logTime <= 1027362770, 7756, IF(logTime <= 1027591980, 7621, IF(logTime <= 1027624654, 7622, IF(logTime <= 1027676249, 7623, IF(logTime <= 1027678079, 7624, IF(logTime <= 1027704746, 7757, IF(logTime <= 1027710663, 7625, IF(logTime <= 1027711398, 7626, IF(logTime <= 1027712168, 7627, IF(logTime <= 1027712945, 7628, IF(logTime <= 1027776542, 7629, IF(logTime <= 1027848051, 7751, IF(logTime <= 1027855517, 7752, IF(logTime <= 1027895171, 7753, IF(logTime <= 1027943523, 7680, IF(logTime <= 1027944170, 7681, IF(logTime <= 1027944570, 7682, IF(logTime <= 1027944873, 7683, IF(logTime <= 1027945006, 7684, IF(logTime <= 1027945306, 7685, IF(logTime <= 1027945433, 7686, IF(logTime <= 1027945470, 7687, IF(logTime <= 1027945908, 7688, IF(logTime <= 1027946554, 7689, IF(logTime <= 1027964993, 7690, IF(logTime <= 1027974925, 7691, IF(logTime <= 1028003847, 7692, IF(logTime <= 1028003908, 7693, IF(logTime <= 1028005225, 7694, IF(logTime <= 1028006178, 7695, IF(logTime <= 1028016434, 7696, IF(logTime <= 1028016917, 7697, IF(logTime <= 1028023443, 7698, IF(logTime <= 1028024075, 7699, IF(logTime <= 1028024301, 7700, IF(logTime <= 1028024423, 7701, IF(logTime <= 1028024679, 7702, IF(logTime <= 1028024895, 7703, IF(logTime <= 1028025094, 7705, IF(logTime <= 1028025144, 7706, IF(logTime <= 1028025708, 7707, IF(logTime <= 1028025842, 7708, IF(logTime <= 1028025919, 7709, IF(logTime <= 1028026507, 7710, IF(logTime <= 1028026874, 7711, IF(logTime <= 1028027508, 7712, IF(logTime <= 1028027959, 7713, IF(logTime <= 1028029447, 7714, IF(logTime <= 1028029892, 7715, IF(logTime <= 1028031367, 7716, IF(logTime <= 1028031412, 7717, IF(logTime <= 1028112965, 7718, IF(logTime <= 1028116032, 7719, IF(logTime <= 1028116408, 7720, IF(logTime <= 1028117390, 7721, IF(logTime <= 1028117869, 7722, IF(logTime <= 1028118867, 7723, IF(logTime <= 1028118966, 7724, IF(logTime <= 1028119148, 7725, IF(logTime <= 1028121172, 7726, IF(logTime <= 1028124239, 7727, IF(logTime <= 1028129623, 7728, IF(logTime <= 1028134402, 7729, IF(logTime <= 1028142547, 7730, IF(logTime <= 1028188193, 7570, IF(logTime <= 1028190546, 7731, IF(logTime <= 1028192196, 7732, IF(logTime <= 1028192476, 7733, IF(logTime <= 1028210302, 7571, IF(logTime <= 1028263315, 7572, IF(logTime <= 1028364791, 7573, IF(logTime <= 1028394339, 7734, IF(logTime <= 1028394491, 7574, IF(logTime <= 1028394667, 7735, IF(logTime <= 1028880258, 7575, IF(logTime <= 1028916547, 7576, IF(logTime <= 1029324289, 7963, IF(logTime <= 1029328104, 7964, IF(logTime <= 1029332510, 7965, IF(logTime <= 1029609604, 7917, IF(logTime <= 1029611957, 7918, IF(logTime <= 1029614202, 7919, IF(logTime <= 1029927133, 7577, IF(logTime <= 1029927610, 7676, IF(logTime <= 1029938669, 7578, IF(logTime <= 1030013869, 7966, IF(logTime <= 1030015244, 7967, IF(logTime <= 1030015546, 7968, IF(logTime <= 1030098655, 7969, IF(logTime <= 1030105273, 7970, IF(logTime <= 1030122103, 7610, IF(logTime <= 1030126149, 7971, IF(logTime <= 1030126467, 7612, IF(logTime <= 1030127297, 7613, IF(logTime <= 1030186443, 7973, IF(logTime <= 1030186846, 7677, IF(logTime <= 1030192922, 7974, IF(logTime <= 1030216113, 7678, IF(logTime <= 1030216293, 7614, IF(logTime <= 1030219915, 7975, IF(logTime <= 1030220008, 7976, IF(logTime <= 1030220158, 7977, IF(logTime <= 1030221708, 7978, IF(logTime <= 1030265966, 7615, IF(logTime <= 1030300658, 7616, IF(logTime <= 1030301364, 7617, IF(logTime <= 1030347182, 7679, IF(logTime <= 1030352827, 7979, IF(logTime <= 1030356551, 7980, IF(logTime <= 1030361647, 7981, IF(logTime <= 1030362112, 7982, IF(logTime <= 1030363892, 7983, IF(logTime <= 1030364680, 7984, IF(logTime <= 1030365074, 7985, IF(logTime <= 1030382024, 7649, IF(logTime <= 1030421911, 7650, IF(logTime <= 1030432897, 7986, IF(logTime <= 1030439314, 7987, IF(logTime <= 1030445704, 7988, IF(logTime <= 1030470844, 7618, IF(logTime <= 1030630472, 7989, IF(logTime <= 1030638296, 7990, IF(logTime <= 1030639643, 7991, IF(logTime <= 1030639906, 7992, IF(logTime <= 1030640504, 7993, IF(logTime <= 1030643949, 7994, IF(logTime <= 1030825694, 7995, IF(logTime <= 1030826064, 7996, IF(logTime <= 1030844340, 7997, IF(logTime <= 1030867928, 7998, IF(logTime <= 1030869515, 7999, IF(logTime <= 1030874663, 7907, IF(logTime <= 1030885475, 8000, IF(logTime <= 1030894973, 7651, IF(logTime <= 1030901631, 7652, IF(logTime <= 1030902842, 7908, IF(logTime <= 1030902956, 7909, IF(logTime <= 1030946187, 7653, IF(logTime <= 1030974927, 7654, IF(logTime <= 1031144122, 7664, IF(logTime <= 1031148966, 7665, IF(logTime <= 1031163202, 7666, IF(logTime <= 1031205774, 7667, IF(logTime <= 1031327027, 7655, IF(logTime <= 1031328489, 7656, IF(logTime <= 1031337428, 7657, IF(logTime <= 1031346475, 7924, IF(logTime <= 1031347259, 7925, IF(logTime <= 1031383031, 7658, IF(logTime <= 1031386500, 7945, IF(logTime <= 1031388109, 7878, IF(logTime <= 1031393469, 7879, IF(logTime <= 1031394275, 7880, IF(logTime <= 1031394383, 7926, IF(logTime <= 1031396861, 7927, IF(logTime <= 1031397003, 7881, IF(logTime <= 1031403617, 7659, IF(logTime <= 1031407852, 7660, IF(logTime <= 1031408483, 7661, IF(logTime <= 1031409727, 7662, IF(logTime <= 1031478308, 7663, IF(logTime <= 1031493113, 7935, IF(logTime <= 1031496038, 7936, IF(logTime <= 1031498163, 7937, IF(logTime <= 1031503320, 7938, IF(logTime <= 1031565914, 7630, IF(logTime <= 1031566787, 7939, IF(logTime <= 1031573101, 7882, IF(logTime <= 1031573556, 7883, IF(logTime <= 1031574065, 7940, IF(logTime <= 1031574170, 7884, IF(logTime <= 1031574999, 7941, IF(logTime <= 1031575225, 7885, IF(logTime <= 1031591608, 7886, IF(logTime <= 1031595551, 7928, IF(logTime <= 1031596857, 7887, IF(logTime <= 1031648360, 7929, IF(logTime <= 1031650706, 7930, IF(logTime <= 1031661260, 7634, IF(logTime <= 1031672543, 7931, IF(logTime <= 1031672558, 7635, IF(logTime <= 1031672780, 7631, IF(logTime <= 1031679842, 7933, IF(logTime <= 1031737856, 7932, IF(logTime <= 1031738148, 7910, IF(logTime <= 1031900081, 7911, IF(logTime <= 1031905740, 7912, IF(logTime <= 1031908035, 7913, IF(logTime <= 1031911079, 7579, IF(logTime <= 1031911329, 7636, IF(logTime <= 1031920063, 7580, IF(logTime <= 1031925925, 7581, IF(logTime <= 1032078103, 7582, IF(logTime <= 1032127393, 7914, IF(logTime <= 1032128088, 7920, IF(logTime <= 1032156709, 7583, IF(logTime <= 1032156792, 7584, IF(logTime <= 1032160009, 7921, IF(logTime <= 1032179055, 7585, IF(logTime <= 1032201141, 7586, IF(logTime <= 1032246557, 7632, IF(logTime <= 1032262918, 7633, IF(logTime <= 1032377076, 7915, IF(logTime <= 1032378792, 7916, IF(logTime <= 1032504640, 7906, IF(logTime <= 1032519375, 7888, IF(logTime <= 1032524476, 7889, IF(logTime <= 1032525250, 7890, IF(logTime <= 1032532698, 7891, IF(logTime <= 1032591795, 7892, IF(logTime <= 1032610141, 7619, IF(logTime <= 1032611079, 7620, IF(logTime <= 1032715080, 7896, IF(logTime <= 1032716366, 7863, IF(logTime <= 1032716653, 7864, IF(logTime <= 1032716761, 7897, IF(logTime <= 1032717802, 7861, IF(logTime <= 1032719152, 7865, IF(logTime <= 1032719528, 7898, IF(logTime <= 1032721088, 7899, IF(logTime <= 1032721147, 7866, IF(logTime <= 1032723045, 7900, IF(logTime <= 1032723369, 7901, IF(logTime <= 1032781310, 7893, IF(logTime <= 1032781776, 7587, IF(logTime <= 1032798669, 7902, IF(logTime <= 1032799004, 7867, IF(logTime <= 1032818128, 7894, IF(logTime <= 1032853394, 7868, IF(logTime <= 1032873728, 7869, IF(logTime <= 1032879789, 7875, IF(logTime <= 1032888489, 7876, IF(logTime <= 1032888919, 7870, IF(logTime <= 1032893684, 7871, IF(logTime <= 1032894664, 7877, IF(logTime <= 1032896110, 7872, IF(logTime <= 1032896340, 7873, IF(logTime <= 1032899427, 7874, IF(logTime <= 1032946888, 7862, 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
WHERE logTime BETWEEN 1018123457 AND 1032946889
AND ID_MSG = 0;
Caused the error:
Lost connection to MySQL server during query

---

could someone help?

JuhaS14

#1
March 12, 2006, 12:41:34 PM Last Edit: March 12, 2006, 06:06:49 PM by JuhaS14
I try this:

DELETE FROM yabbse_log_boards;

didn't help me.

hints?

This is new server, so there should be something wrong in mysql/php/apache -settings too, here is status.php:

http://62.142.250.88/forum/status.php

JuhaS14

#2
March 12, 2006, 03:43:34 PM
I just tried to run that SQL-query in mysql console and get same error:

ERROR 2013 (HY000): Lost connection to MySQL server during query

scotbuff

#3
March 16, 2006, 11:18:08 AM Last Edit: March 16, 2006, 11:26:23 AM by scotbuff
I am getting this same error.  Any ideas?
Code Select
Upgrading...
Updating Settings.php... Successful.
Updating and creating indexes... Successful.
Reorganizing configuration settings... Successful.
Installing new default theme... Successful.
Adding and updating member data... Successful.
Updating holidays and calendar... Successful.
Adding custom message icons... Successful.
Adding package servers... Successful.
Cleaning up database... Successful.
Converting avatar permissions... Successful.
Adjusting uploadable avatars... Successful.
Updating thumbnails... Successful.
Updating ban system... Successful.
Updating permissions... Successful.
Updating search cache... Successful.
Upgrading log system...
Notice: Undefined variable: db_name in /srv/www/htdocs/devforum/upgrade.php on line 1216
Unsuccessful!
This query:

    UPDATE unixteam_log_boards
    SET ID_MSG = IF(logTime BETWEEN 1 AND 1049747487, 3, IF(logTime <= 1049747618, 4, IF(logTime <= 1049809363, 6, IF(logTime <= 1049830345, 7, IF(logTime <= 1049831254, 8, IF(logTime <= 1049832752, 9, IF(logTime <= 1050091960, 14, IF(logTime <= 1051017604, 15, IF(logTime <= 1051106168, 16, IF(logTime <= 1051187385, 17, IF(logTime <= 1051187887, 18, IF(logTime <= 1051188762, 19, IF(logTime <= 1051189396, 20, IF(logTime <= 1051189434, 21, IF(logTime <= 1051189461, 22, IF(logTime <= 1051189593, 23, IF(logTime <= 1051189820, 24, IF(logTime <= 1051189963, 25, IF(logTime <= 1051190232, 26, IF(logTime <= 1051190502, 27, IF(logTime <= 1051191809, 28, IF(logTime <= 1051191969, 29, IF(logTime <= 1051193890, 30, IF(logTime <= 1051194231, 31, IF(logTime <= 1051194526, 32, IF(logTime <= 1051194909, 33, IF(logTime <= 1051195422, 34, IF(logTime <= 1051196218, 35, IF(logTime <= 1051196542, 36, IF(logTime <= 1051196781, 37, IF(logTime <= 1051197022, 38, IF(logTime <= 1051197243, 39, IF(logTime <= 1051197482, 40, IF(logTime <= 1051198235, 41, IF(logTime <= 1051200191, 42, IF(logTime <= 1051200639, 43, IF(logTime <= 1051200862, 44, IF(logTime <= 1051201072, 45, IF(logTime <= 1051201510, 46, IF(logTime <= 1051808157, 49, IF(logTime <= 1052300127, 52, IF(logTime <= 1052310124, 53, IF(logTime <= 1052844828, 54, IF(logTime <= 1052920757, 55, IF(logTime <= 1054560941, 56, IF(logTime <= 1054655673, 57, IF(logTime <= 1055254923, 58, IF(logTime <= 1055267630, 59, IF(logTime <= 1055333514, 60, IF(logTime <= 1055881779, 62, IF(logTime <= 1056049252, 63, IF(logTime <= 1056370144, 64, IF(logTime <= 1057696203, 67, IF(logTime <= 1059402428, 88, IF(logTime <= 1059422480, 89, IF(logTime <= 1059677651, 90, IF(logTime <= 1059909326, 92, IF(logTime <= 1060074905, 99, IF(logTime <= 1060177582, 100, IF(logTime <= 1060181263, 101, IF(logTime <= 1060868450, 102, IF(logTime <= 1061217485, 106, IF(logTime <= 1061217928, 107, IF(logTime <= 1061218357, 108, IF(logTime <= 1061218853, 109, IF(logTime <= 1061219070, 110, IF(logTime <= 1061219384, 111, IF(logTime <= 1061226147, 112, IF(logTime <= 1061390610, 116, IF(logTime <= 1061480036, 118, IF(logTime <= 1061988505, 119, IF(logTime <= 1062004062, 120, IF(logTime <= 1062006559, 121, IF(logTime <= 1062073420, 125, IF(logTime <= 1062083280, 126, IF(logTime <= 1062097223, 128, IF(logTime <= 1063212965, 129, IF(logTime <= 1063373697, 130, IF(logTime <= 1063632386, 132, IF(logTime <= 1063638510, 133, IF(logTime <= 1063640093, 134, IF(logTime <= 1065010314, 136, IF(logTime <= 1065431352, 144, IF(logTime <= 1065431434, 145, IF(logTime <= 1065431655, 146, IF(logTime <= 1065431813, 147, IF(logTime <= 1065453744, 148, IF(logTime <= 1065611695, 149, IF(logTime <= 1065611911, 150, IF(logTime <= 1065622769, 152, IF(logTime <= 1066832197, 154, IF(logTime <= 1066999879, 156, IF(logTime <= 1067353003, 157, IF(logTime <= 1067450935, 158, IF(logTime <= 1067889106, 162, IF(logTime <= 1068234805, 163, IF(logTime <= 1068718384, 168, IF(logTime <= 1068725156, 172, IF(logTime <= 1068816975, 176, IF(logTime <= 1068819382, 177, IF(logTime <= 1068821130, 178, IF(logTime <= 1068831176, 180, IF(logTime <= 1069238721, 183, IF(logTime <= 1069240107, 184, IF(logTime <= 1069258104, 186, IF(logTime <= 1069774892, 187, IF(logTime <= 1069777703, 188, IF(logTime <= 1069795503, 189, IF(logTime <= 1069796387, 190, IF(logTime <= 1069801089, 191, IF(logTime <= 1070389212, 192, IF(logTime <= 1070392038, 193, IF(logTime <= 1070402577, 194, IF(logTime <= 1070549078, 195, IF(logTime <= 1070551037, 196, IF(logTime <= 1070633754, 198, IF(logTime <= 1071154582, 199, IF(logTime <= 1071239533, 200, IF(logTime <= 1071241696, 201, IF(logTime <= 1071252308, 202, IF(logTime <= 1071595057, 203, IF(logTime <= 1071610641, 204, IF(logTime <= 1071611662, 205, IF(logTime <= 1071612021, 206, IF(logTime <= 1071612303, 207, IF(logTime <= 1072723966, 209, IF(logTime <= 1072877255, 210, IF(logTime <= 1073333194, 214, IF(logTime <= 1073481012, 216, IF(logTime <= 1073484981, 217, IF(logTime <= 1073995428, 219, IF(logTime <= 1074285844, 233, IF(logTime <= 1074785567, 234, IF(logTime <= 1075124438, 235, IF(logTime <= 1075822857, 237, IF(logTime <= 1075996202, 238, IF(logTime <= 1076338742, 239, IF(logTime <= 1076592051, 240, IF(logTime <= 1076625062, 241, IF(logTime <= 1076672487, 242, IF(logTime <= 1076685688, 243, IF(logTime <= 1077134219, 244, IF(logTime <= 1077289855, 245, IF(logTime <= 1077817724, 246, IF(logTime <= 1077897733, 248, IF(logTime <= 1078775751, 250, IF(logTime <= 1078794709, 251, IF(logTime <= 1078841813, 252, IF(logTime <= 1078866062, 253, IF(logTime <= 1079122584, 255, IF(logTime <= 1079294414, 256, IF(logTime <= 1079363769, 257, IF(logTime <= 1079447119, 258, IF(logTime <= 1079561788, 259, IF(logTime <= 1080128268, 260, IF(logTime <= 1080140877, 262, IF(logTime <= 1080222395, 263, IF(logTime <= 1080660491, 264, IF(logTime <= 1080833453, 265, IF(logTime <= 1081345534, 275, IF(logTime <= 1081346879, 276, IF(logTime <= 1081458108, 277, IF(logTime <= 1082031296, 278, IF(logTime <= 1082117754, 279, IF(logTime <= 1082142877, 280, IF(logTime <= 1082149789, 281, IF(logTime <= 1082470672, 282, IF(logTime <= 1083087607, 285, IF(logTime <= 1084196301, 325, IF(logTime <= 1084356858, 326, IF(logTime <= 1084446532, 327, IF(logTime <= 1084538100, 328, IF(logTime <= 1084803547, 329, IF(logTime <= 1084968637, 330, IF(logTime <= 1084992500, 331, IF(logTime <= 1086094411, 335, IF(logTime <= 1086104004, 336, IF(logTime <= 1086696447, 338, IF(logTime <= 1086797439, 339, IF(logTime <= 1086960738, 340, IF(logTime <= 1087485018, 341, IF(logTime <= 1087915492, 342, IF(logTime <= 1088090281, 343, IF(logTime <= 1089293638, 344, IF(logTime <= 1089637775, 345, IF(logTime <= 1089709999, 346, IF(logTime <= 1089714684, 350, IF(logTime <= 1089716032, 351, IF(logTime <= 1089725465, 352, IF(logTime <= 1089727635, 353, IF(logTime <= 1089800277, 364, IF(logTime <= 1089801106, 365, IF(logTime <= 1089801498, 366, IF(logTime <= 1089801621, 367, IF(logTime <= 1089801692, 368, IF(logTime <= 1089801751, 369, IF(logTime <= 1089801808, 370, IF(logTime <= 1089801850, 371, IF(logTime <= 1089899290, 383, IF(logTime <= 1089905206, 385, IF(logTime <= 1089971539, 391, IF(logTime <= 1089975656, 398, IF(logTime <= 1090419688, 399, IF(logTime <= 1090494212, 403, IF(logTime <= 1091192835, 413, IF(logTime <= 1091195895, 414, IF(logTime <= 1091213807, 415, IF(logTime <= 1091796662, 417, IF(logTime <= 1092216528, 418, IF(logTime <= 1092658094, 419, IF(logTime <= 1092840063, 420, IF(logTime <= 1093267885, 428, IF(logTime <= 1093962346, 430, IF(logTime <= 1094048654, 431, IF(logTime <= 1094208680, 433, IF(logTime <= 1094217103, 434, IF(logTime <= 1094588244, 435, IF(logTime <= 1095080908, 436, IF(logTime <= 1095256556, 437, IF(logTime <= 1095411433, 439, IF(logTime <= 1095428731, 440, IF(logTime <= 1095780016, 441, IF(logTime <= 1095781351, 442, IF(logTime <= 1096299376, 445, IF(logTime <= 1096364851, 447, IF(logTime <= 1096364908, 448, IF(logTime <= 1096366794, 449, IF(logTime <= 1096548077, 451, IF(logTime <= 1096548125, 452, IF(logTime <= 1096559258, 453, IF(logTime <= 1096884831, 454, IF(logTime <= 1096896531, 455, IF(logTime <= 1096997646, 457, IF(logTime <= 1097238258, 458, IF(logTime <= 1097677139, 459, IF(logTime <= 1097847415, 460, IF(logTime <= 1097856136, 461, IF(logTime <= 1098287507, 465, IF(logTime <= 1100013940, 467, IF(logTime <= 1100434354, 468, IF(logTime <= 1101047732, 469, IF(logTime <= 1101146840, 470, IF(logTime <= 1101747658, 472, IF(logTime <= 1101748105, 473, IF(logTime <= 1101748499, 474, IF(logTime <= 1101825911, 475, IF(logTime <= 1102013433, 476, IF(logTime <= 1102942924, 481, IF(logTime <= 1102951159, 485, IF(logTime <= 1102952848, 486, 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
    WHERE logTime BETWEEN 1 AND 1102952849
    AND ID_MSG = 0;

Caused the error:

    Lost connection to MySQL server during query

JuhaS14

#4
March 19, 2006, 11:42:17 PM
Well I resolve this.

The problem was only with Mysql 5.xxxx, when I downgrade to Mysql 4.xxxx it's works fine. I update forum with mysql 4.x and then upgrade 5.x and now its works fine.

JayBachatero

#5
March 25, 2006, 12:44:07 AM
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert
Print
Go Up Pages1
User actions
Advertisement: