nickthrolson Posted July 31, 2007 Share Posted July 31, 2007 i recently dicoverd my website was all messed up due to a MYSQL ERROR i get this on the home page im kinda a newb to phpadmin i also tried to repair the database and optimize it home page error MYSQL ERROR: Unknown column 'user' in 'field list' Query: SELECT `user`,`title`,`time`,`id` FROM `forum_post` ORDER BY `time` DESC LIMIT 0,5 profile error MYSQL ERROR: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay Query: SELECT u.* ,t.bg_color, t.bg_img, t.bg_main, t.color_main, t.link_on, t.link_hover, t.username_bg, t.username_color, t.top_menu, t.top_text, t.mainmenu4, t.mainmenu4_txt, t.border2, t.border2_txt, t.bottom, t.bottom_txt, t.nav1_bg, t.nav1_a_bg, t.nav1_a_txt, t.nav1_a2_bg, t.nav1_a2_txt, t.nav2_a_bg, t.nav2_a_txt, t.nav2_a2_bg, t.nav2_a2_txt, t.nav2_sqr, t.cmt_bg, t.cmt_txt, t.cmt2_bg, t.cmt2_txt, t.menu_bg, t.menu_a, t.menu_a_txt, t.menu2_a, t.menu2_a_txt, t.css FROM user AS u ,template AS t WHERE u.user = 'admin' AND t.user = u.user Quote Link to comment Share on other sites More sharing options...
fenway Posted July 31, 2007 Share Posted July 31, 2007 Really?!? Check the MAX_JOIN_SIZE (with SHOW VARIABLES), and run the EXPLAIN. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.