Upgrading log system... Unsuccessful!

Started by DrilLer, January 11, 2006, 12:03:56 PM

Previous topic - Next topic

DrilLer

кто что подскажет ?? :(

Upgrading log system... Unsuccessful!

This query:
UPDATE smf_log_boards
SET ID_MSG = IF(logTime BETWEEN AND 1077782427, 2630, IF(logTime <= 1079285708, 2631, IF(logTime <= 1084212697, 2632, IF(logTime <= 1084213676, 2633, IF(logTime <= 1084633617, 2634, IF(logTime <= 1084647852, 2635, IF(logTime <= 1084647955, 2636, IF(logTime <= 1085908608, 2637, IF(logTime <= 1085924406, 2638, IF(logTime <= 1085924756, 2639, IF(logTime <= 1085931183, 2640, 0)))))))))))
WHERE logTime BETWEEN AND 1085931184
AND ID_MSG = 0;
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 'AND 1077782427, 2630, IF(logTime <= 1079285708, 2631, IF(logTime

Oldiesmann

Michael Eshom
Christian Metal Fans

Advertisement: