20 Dec 2006 14:46
sql problem creating mrbs_users for db authentication
Leon White <badfunkstripe <at> gmail.com>
2006-12-20 13:46:35 GMT
2006-12-20 13:46:35 GMT
Hi and thanks for creating mrbs, we will be using this for all local websites for SoccaFive, a 5-on-5 football variant for children. I am currently working on the first implementation, which can be seen under the 'Platz buchen' link at
http://www.soccafivearena-martinsried.de
I decided to implement db authentication, but by following the instructions in the AUTHENTICATION file, i was consistently getting an SQL error about a bad default value for 'id' when creating the mrbs_users table. I was able to resolve this problem by changing relevant line in the database creation command in edit_users.php from
CREATE TABLE $tbl_users (id int DEFAULT '0' NOT NULL auto_increment, name varchar(30), password varchar(40), email varchar(75), PRIMARY KEY (id));
to the following:
CREATE TABLE $tbl_users (id int NOT NULL auto_increment, name varchar(30), password varchar(40), email varchar(75), PRIMARY KEY (id));
so basically i just took the DEFAULT '0' out, as '0' is not a valid value for 'id' as the primary key. now i don't know jack about SQL but is this the right way to fix this? should this be changed in the actual release? it seems like a pretty silly bug to me, but if im wrong please dont spank me with flyswats but explain what it is about my configuration that was preventing the normal setup routine to work. I am using MySQL 4.1.7-nt with PHP 4.3.11 and IIS.
Cheers and thanks again for making mrbs so cool,
Leon
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ mrbs-general mailing list mrbs-general <at> lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mrbs-general
RSS Feed