Author Topic: Edit Character page crashed  (Read 2000 times)

Janrith

  • Minion
  • **
  • Posts: 25
Edit Character page crashed
« on: December 21, 2008, 02:32:13 AM »
Clicking the "Edit Character" option for any of my toons is resulting in the following PHP error:

Code: [Select]
A Database Error Occurred
Error Number: 145

Table './cohcit/supergroups' is marked as crashed and should be repaired

SELECT characters.*, archetypes.archetype_name, origins.origin_name, servers.server_name, primaries.primary_name, secondaries.secondary_name, supergroups.supergroup_name, `bio_text` as `char_bio`, characters.hide_experience AS `char_hide_experience`, characters.hide_influence AS `char_hide_influence`, tn_users.hide_experience, tn_users.hide_influence, (SELECT count(bbc_id) FROM badges_by_char RIGHT JOIN `badges` ON badges.badge_id = badges_by_char.badge_id WHERE validation = 1 AND badges_by_char.char_id = characters.char_id AND (badges.game_id = characters.game_id OR badges.game_id = 99)) AS verified_count, (SELECT count(bbc_id) FROM badges_by_char RIGHT JOIN `badges` ON badges.badge_id = badges_by_char.badge_id WHERE validation = 0 AND badges_by_char.char_id = characters.char_id AND (badges.game_id = characters.game_id OR badges.game_id = 99)) AS unverified_count, (SELECT titles.title_name FROM titles WHERE title_id = common_title_id) AS common_title, (SELECT titles.title_name FROM titles WHERE title_id = origin_title_id) AS origin_title, (SELECT tn_users.realname FROM cohtitan.tn_users WHERE tn_users.tu_key = characters.tu_key) AS pilot, (IF (custom_img=1, concat("http://avatars.cohtitan.com/custom/characters/",characters.char_id,"_200.png"),"")) AS avatar FROM (`characters`) LEFT JOIN `archetypes` ON characters.archetype_id = archetypes.archetype_id LEFT JOIN `origins` ON characters.origin_id = origins.origin_id LEFT JOIN `servers` ON characters.server_id = servers.server_id LEFT JOIN `primaries` ON characters.primary_id = primaries.primary_id LEFT JOIN `secondaries` ON characters.secondary_id = secondaries.secondary_id LEFT JOIN `supergroups` ON characters.supergroup_id = supergroups.supergroup_id LEFT JOIN `characters_bio` ON characters.char_id = characters_bio.char_id LEFT JOIN cohtitan.tn_users ON characters.tu_key = tn_users.tu_key WHERE characters.tu_key = '964' AND characters.char_id = '132024'

Steiner

  • Elite Boss
  • *****
  • Posts: 1,602
    • Steinerd.com
Re: Edit Character page crashed
« Reply #1 on: December 21, 2008, 03:52:06 PM »
It was our server...
We went over our allowed space usage and it crashed out a lot of our databases.

Fixed now.
~Steinerd