I've had an error in my entire gallery for the last couple of days and I have no idea how to fix it. I've searched around but can't find the answer so any help would be appreciated. Here's the link to the gallery:
http://nicole-richie.com/gallery and as you can see the whole entire top page is filled with a database error. I get an error when I go and try to login to the admin panel as well. There's ALOT of pictures in this gallery and I think losing them all and having to start all over would kill me. Any suggestions? Thanks.
DB Error: Bad SQL Query: SELECT u.user_id, u.user_level, u.user_name, u.user_invisible, s.session_user_id, s.session_lastaction, s.session_ip FROM 4images_users u, 4images_sessions s WHERE u.user_id = s.session_user_id AND (s.session_lastaction >= 1111513769 OR u.user_lastaction >= 1111513769) ORDER BY u.user_id ASC, s.session_ip ASC
Can't open file: '4images_users.MYI'. (errno: 145)
DB Error: Bad SQL Query: SELECT DISTINCT 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 i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY RAND()
Can't open file: '4images_users.MYI'. (errno: 145)
DB Error: Bad SQL Query: SELECT 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, 403, 395, 204, 54, 239, 261, 273, 299, 169, 200, 346, 201, 236, 238, 424, 176, 156, 164, 296, 153, 167, 123, 131, 141, 2, 249, 250, 116, 185, 389, 390, 267, 252, 206, 209, 256, 198, 342, 430, 10, 26, 360, 214, 244, 31, 223, 226, 11, 229, 388, 55, 38, 1, 266, 423, 177, 154, 165, 297, 142, 124, 132, 186, 251, 349, 242, 184, 74, 275, 265, 216, 270, 219, 245, 269, 422, 243, 367, 343, 14, 380, 361, 241, 240, 32, 161, 12, 431, 48, 224, 227, 27, 210, 15, 28, 40, 125, 133, 260, 33, 330, 215, 56, 217, 351, 222, 253, 187, 52, 234, 170, 339, 174, 225, 228, 344, 233, 381, 341, 263, 274, 3, 372, 13, 272, 374, 57, 58, 34, 188, 368, 386, 126, 134, 425, 30, 235, 350, 353, 376, 429, 205, 220, 254, 340, 203, 255, 4, 409, 231, 16, 51, 202, 262, 421, 168, 49, 246, 59, 213, 35, 382, 127, 135, 426, 348, 189, 356, 357, 211, 17, 391, 221, 257, 358, 363, 199, 345, 8, 60, 347, 128, 136, 427, 407, 370, 18, 190, 352, 5, 405, 247, 355, 207, 232, 384, 362, 50, 61, 129, 137, 191, 377, 218, 378, 359, 387, 248, 208, 6, 369, 375, 383, 417, 419, 192, 20, 212, 130, 138, 62, 371, 406, 393, 404, 379, 410, 7, 392, 397, 63, 411, 21, 139, 45, 29, 158, 428, 193, 412, 414, 64, 140, 194, 160, 237, 398, 67, 197, 415, 399, 172, 259, 279, 338, 196, 68, 173, 418, 354, 400, 66, 69, 385, 420, 401, 373, 413, 23, 408, 70, 24, 71, 25, 394, 72, 73, 396, 178, 402, 76, 179, 80, 180, 81, 183, 75, 82, 182, 84, 85, 77, 86, 79, 87, 307, 92, 309, 93, 94, 83, 96, 99, 100, 416, 102, 88, 103, 89, 104, 106, 107, 302, 110, 312, 112, 95, 308, 114, 322, 298, 323, 97, 115, 314, 333, 148, 329, 117, 311, 316, 119, 332, 325, 157, 295, 166, 306, 294, 175, 324, 280, 282, 105, 283, 284, 285, 108, 286, 109, 287, 288, 289, 290, 113, 291, 310, 313, 292, 293, 318, 320, 321, 118, 152, 326, 143, 328, 155, 144, 336, 171, 145, 337, 276, 146, 364, 277, 147, 278, 300, 301, 303, 304, 305, 315, 317, 319, 327, 331, 334, 335, 365, 366) ORDER BY i.image_date DESC LIMIT 3
Can't open file: '4images_users.MYI'. (errno: 145)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /chroot/home/lovesit/public_html/photos/includes/db_mysql.php on line 116
^^ That's the error I get on the main page.