4images Forum & Community
4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: yellows on September 10, 2009, 02:34:01 AM
-
DB Error: Bad SQL Query: SELECT IF(i.image_date >= 1250814501,RAND()+1,1) as random_no, i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 100, 130, 239, 282, 243, 394, 46, 73, 326, 50, 116, 51, 535, 26, 234, 165, 345, 95, 33, 205, 166, 145, 53, 162, 317, 123, 505, 225, 453, 359, 510, 403, 48, 246, 241, 127, 107, 333, 513, 227, 349, 283, 286, 443, 503, 252, 212, 507, 158, 462, 322, 441, 332, 449, 268, 232, 198, 368, 531, 425, 293, 405, 72, 373, 167, 518, 486, 489, 344, 456, 381, 220, 418, 242, 387, 2, 23, 139, 258, 375, 203, 356, 150, 140, 193, 458, 363, 534, 498, 101, 285, 279, 401, 244, 74, 163, 6, 269, 151, 354, 264, 461, 34, 96, 318, 146, 247, 117, 141, 467, 27, 1, 556, 382, 108, 124, 187, 506, 284, 287, 296, 235, 374, 527, 473, 311, 63, 442, 251, 521, 47, 532, 221, 131, 24, 159, 204, 67, 392, 350, 69, 508, 536, 254, 334, 431, 426, 422, 435, 233, 323, 256, 49, 128, 402, 75, 289, 267, 509, 160, 421, 35, 412, 226, 207, 102, 335, 152, 147, 7, 501, 328, 383, 97, 164, 248, 291, 28, 482, 125, 260, 312, 64, 109, 522, 475, 430, 3, 367, 329, 432, 436, 515, 351, 237, 557, 25, 427, 132, 118, 142, 129, 416, 433, 466, 188, 404, 76, 133, 231, 483, 533, 36, 271, 263, 8, 119, 148, 153, 255, 336, 496, 512, 313, 110, 558, 98, 126, 4, 476, 29, 450, 428, 103, 516, 250, 471, 161, 395, 190, 143, 490, 562, 288, 77, 54, 547, 134, 386, 540, 280, 9, 154, 292, 273, 120, 37, 440, 429, 529, 337, 459, 240, 99, 111, 149, 439, 30, 302, 500, 104, 339, 484, 144, 179, 274, 52, 78, 365, 135, 295, 38, 465, 10, 155, 541, 494, 338, 492, 314, 68, 278, 563, 121, 31, 173, 202, 105, 112, 180, 275, 213, 369, 294, 552, 56, 79, 340, 39, 11, 218, 156, 495, 523, 136, 342, 564, 113, 32, 122, 196, 106, 168, 566, 170, 80, 297, 324, 40, 370, 12, 364, 249, 321, 537, 341, 137, 114, 346, 517, 175, 157, 219, 463, 55, 81, 59, 13, 41, 257, 366, 360, 553, 545, 300, 414, 138, 115, 169, 444, 177, 301, 82, 415, 60, 42, 361, 14, 549, 480, 423, 303, 481, 83, 209, 15, 43, 372, 174, 447, 389, 181, 424, 304, 519, 455, 16, 44, 66, 491, 84, 176, 261, 546, 305, 17, 85, 437, 457, 45, 514, 390, 192, 445, 262, 524, 185, 306, 18, 86, 460, 438, 551, 194, 211, 470, 201, 307, 477, 446, 469, 560, 87, 19, 474, 487, 511, 57, 210, 497, 65, 88, 20, 281, 525, 214, 58, 89, 22, 236, 310, 178, 90, 316, 184, 91, 200, 61, 343, 92, 352, 208, 62, 93, 217, 362, 94, 182, 228, 420, 183, 229, 448, 396, 186, 478, 230, 308, 189, 526, 197, 315, 530, 195, 206, 542, 327, 371, 543, 216, 544, 376, 222, 223, 561, 377, 378, 224, 70, 379, 245, 384, 253, 71, 385, 320, 388, 330, 215, 399, 502, 400, 528, 406, 407, 238, 408, 355, 259, 409, 309, 410, 454, 411, 331, 468, 413, 417, 451, 270, 272, 391, 452, 434, 479, 276, 520, 565, 319, 485, 325, 493, 548, 347, 554, 357, 358, 567, 393, 397, 398, 472, 499, 504, 538, 539, 550, 555, 559) ORDER BY random_no DESC, RAND(), i.image_date DESC LIMIT 6
Unknown column 'i.user_id' in 'on clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sexymal/public_html/Galeries/includes/db_mysql.php on line 116
i just changed servers and have no idea why this error is coming up, please help
James
-
Unknown column 'i.user_id' in 'on clause' (http://www.4homepages.de/forum/index.php?topic=22668.0)
-
many thanks :)