Author Topic: Please help: Frontpage Database Error  (Read 4640 times)

0 Members and 1 Guest are viewing this topic.

Offline elle

  • Pre-Newbie
  • Posts: 2
    • View Profile
Please help: Frontpage Database Error
« on: March 22, 2005, 06:57:44 PM »
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.

Quote
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.

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: Please help: Frontpage Database Error
« Reply #1 on: March 23, 2005, 01:15:15 AM »
try to repair users table through phpmyadmin or such, or/and contact your hoster.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline Chris

  • 4images Moderator
  • 4images Guru
  • *****
  • Posts: 4.487
  • Did u ever stop to think and then forget to start?
    • View Profile
Re: Please help: Frontpage Database Error
« Reply #2 on: March 23, 2005, 01:44:15 AM »
At a SHELL command prompt you can use
Code: [Select]
perror 145to print the error code message which gets you
Code: [Select]
MySQL error:  145 = Table was marked as crashed and should be repaired

Offline elle

  • Pre-Newbie
  • Posts: 2
    • View Profile
Re: Please help: Frontpage Database Error
« Reply #3 on: March 23, 2005, 05:47:35 AM »
try to repair users table through phpmyadmin or such, or/and contact your hoster.

Emailed my host days ago and I still haven't gotten a responce so I'm going to try the first and hopefully it doesn't mess anything up. Thank you for replying.

At a SHELL command prompt you can use
Code: [Select]
perror 145to print the error code message which gets you
Code: [Select]
MySQL error:  145 = Table was marked as crashed and should be repaired

Unfortunatly I don't have shell access to the site or anything like that... atleast I don't think so. I appreciate you replying. Actually strike that .....does that mean the table crashed and I should repair it? .....And how would I go about doing that? I pretty much have access to cpanel and ftp and thats it.

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: Please help: Frontpage Database Error
« Reply #4 on: March 23, 2005, 07:10:03 AM »
as I mentioned above, u can repair tables from phpmyadmin or any other mysql managers ;)
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)