ammo007 Posted October 28, 2008 Share Posted October 28, 2008 MySQL-Client-Version: 5.0.51b mistake in the user_id following error code i get: General Error SQL ERROR [ mysql4 ] Field 'user_id' doesn't have a default value [1364] Sry, i dont know anything about that, my webmaster is in the hospital and i cant reach him, i have there a forum and now, noone can register . Log in seems be Okay. I want to see if I can solve the problems, and deleted by a mistake forum_id : So when i click now newest post I get following message: SQL ERROR [ mysql4 ] Unknown column 'fa.forum_id' in 'on clause' [1054] SQL SELECT f.forum_id, f.forum_name, f.parent_id, f.forum_type, f.right_id, f.forum_password, fa.user_id FROM phpbb_forums f LEFT JOIN phpbb_forums_access fa ON (fa.forum_id = f.forum_id AND fa.session_id = '61febfaa810dbe6897077276a63175be') ORDER BY f.left_id BACKTRACE FILE: includes/db/mysql.php LINE: 158 CALL: dbal->sql_error() FILE: search.php LINE: 164 CALL: dbal_mysql->sql_query() I need urgently help, also it wld ne nice when i can find someone who is interested to be a standard webmaster for our site .. Thanks in advance Brgds Quote Link to comment https://forums.phpfreaks.com/topic/130423-general-error-default-value/ Share on other sites More sharing options...
revraz Posted October 28, 2008 Share Posted October 28, 2008 In your DB, check and make sure the field user_id is set to Auto Increment. On this error Unknown column 'fa.forum_id' in 'on clause' [1054 It means the field forum_id does not exist in table fa. Quote Link to comment https://forums.phpfreaks.com/topic/130423-general-error-default-value/#findComment-676575 Share on other sites More sharing options...
ammo007 Posted October 28, 2008 Author Share Posted October 28, 2008 Thanks a lot, how i can fill the forum_id again the field, I write down all things but dont know where i can insert it ? Quote Link to comment https://forums.phpfreaks.com/topic/130423-general-error-default-value/#findComment-676605 Share on other sites More sharing options...
revraz Posted October 28, 2008 Share Posted October 28, 2008 Add the field to the fa table using phpmyadmin. Quote Link to comment https://forums.phpfreaks.com/topic/130423-general-error-default-value/#findComment-676612 Share on other sites More sharing options...
ammo007 Posted October 28, 2008 Author Share Posted October 28, 2008 Sry, i cant programm and dont understand a lot of, cauz my webmaster is in the hospital, is theres a chance to talk with you via msn, skype, icq ?? Quote Link to comment https://forums.phpfreaks.com/topic/130423-general-error-default-value/#findComment-676617 Share on other sites More sharing options...
revraz Posted October 28, 2008 Share Posted October 28, 2008 I don't use any of those, sorry. Quote Link to comment https://forums.phpfreaks.com/topic/130423-general-error-default-value/#findComment-676623 Share on other sites More sharing options...
ammo007 Posted October 28, 2008 Author Share Posted October 28, 2008 Its okay...anything else, cauz when i open phpmyadmin, i try to fill anew table, and he say to me table already exicst, also i have change thet to auto_increment and still not possible to register . Im totally confused, so when u have an idea how i can reach u, and if u are wuilling to help me, it wld be relly nice thanks in advance Quote Link to comment https://forums.phpfreaks.com/topic/130423-general-error-default-value/#findComment-676627 Share on other sites More sharing options...
fenway Posted October 30, 2008 Share Posted October 30, 2008 Could you post the table structures? Quote Link to comment https://forums.phpfreaks.com/topic/130423-general-error-default-value/#findComment-678524 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.