Joomla! Discussion Forums

Hello all. I'm totaly green with cmss mySQL and all that thing. But finally I tried to learn something about it and I installed mySQL 5.0.15, php4.4.1 and Joomla 1.0.4 on my PC. All instal process goes welll until i tried to add new user from admin pan.
Joomla succesfully added user to my database ( i've checked ) but i don't see it in admin user managment panel.

When i tried to register new user from front page I get error message:

mosuser::store failed
Field 'params' doesn't have a defaults value SQL=INSERT INTO jos_users ( 'id','name','username','email','password','usertyp e','block','gid','registerDate','activation') VALUES ( some 10 vars)

but in my DB when I've checked with DESCRIBE jos_users I have 13:
'id','name','username','email','password','usertyp e','block','sendEmail','gid','registerDate','lastvisitDate','activation','params'.
So a question is why Joomla installed like this, and If this is right or not?

Another thing which doesn't work on my PC is adding section from admin pan. Adding section page is howed ok, but when i click Apply or Save button I get another error message:
Fatal error: Call to undefined function: geterrormsg() in d:\inetpub\wwwroot\test\administrator\components\c om_sections\admin.sections.php on line 298.

I've tried on Polish Joomla forum, but as far no response so please help fresh, newbie Joomla user, with no idea how to fix this.

Have a nice day to you all.

I'm looking for an answer to this as well, though my error is slightly different.  I've seen another post saying the problem is due to changes with mysql 5 but so far I haven't found when a patch to address the problems might be released.

Yes on polish joomla forum someone wrote to me that my mySQL db is much to fresh for joomla, so I really had to downgrade my mySQL to 4.

Then almost all problems gone.

Remember about setting password for user with old_password.

set password for 'user'@'host' = old_password('password')

Good luck.

I'm very new to the joomla world.  In face joomla got me to install apache 2, php 5 and mysql 5.

My J installed but when I tried to add virtuemart, it got some errors about params and such.
I then tried adding sections and categories and got some errors with that as well, sounded like what you're experiencing.

I was about to downgrade but I ran the mysql server instance wizard and checked the settings. In there I turned the Strict option off.  And now everything is peachy. 
This setting is also in the mysql administrator under startup variables > Advanced > SQL Mode

I don't how you'd have to get that set in a host environment.

ndb02, you rock! I think that fixed all my problems with mysql 5.

Thanks man, all the niggly problems I was having went away after doing what you said. 

U ROCK!!!! all my problems have been solved...chea 

"You know it's hard out here for a Pimp..."
3-6 Mafia

Any ideas how to do this on a WAMP installation?