Leon White | 20 Dec 2006 14:46
Picon

sql problem creating mrbs_users for db authentication

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

Gmane