7
« 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
Show Posts
