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 Link to comment https://forums.phpfreaks.com/topic/62614-im-getting-this-error-running-my-phpfox-site/ 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. Link to comment https://forums.phpfreaks.com/topic/62614-im-getting-this-error-running-my-phpfox-site/#findComment-312089 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.