Problem making new forums and users

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
User avatar
Freelance
Registered User
Posts: 73
Joined: Wed Oct 18, 2006 6:33 am
Location: W.Vl., Belgium

Problem making new forums and users

Post by Freelance »

Don't know if this is the right place buth I've got 2 problems in the latest CVS.
I can't register new users and I can't add new forums or category's.

With both functions I get an sql-error

When trying to register :

Code: Select all

Field 'user_interests' doesn't have a default value [1364]
When trying to add a forum (trough ACP) :

Code: Select all

Field 'forum_parents' doesn't have a default value [1364]
Anyone knows what the problem could be ?
Sh*t Can Happen !!!
[Building a large project based on phpBB3 - Progress 15%]
[IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII]

Ectoman
Registered User
Posts: 192
Joined: Sat Dec 15, 2001 3:53 pm
Location: Denver CO
Contact:

Re: Problem making new forums and users

Post by Ectoman »

I used the new CVS from today, and had no problems making a hundred forums.

User avatar
Freelance
Registered User
Posts: 73
Joined: Wed Oct 18, 2006 6:33 am
Location: W.Vl., Belgium

Re: Problem making new forums and users

Post by Freelance »

then I guess there most be a problem with my mysql server setup.
Anyone got an idea ??
Sh*t Can Happen !!!
[Building a large project based on phpBB3 - Progress 15%]
[IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII]

User avatar
Freelance
Registered User
Posts: 73
Joined: Wed Oct 18, 2006 6:33 am
Location: W.Vl., Belgium

Re: Problem making new forums and users

Post by Freelance »

I'm going to reinstall my server soft and see what that does
Sh*t Can Happen !!!
[Building a large project based on phpBB3 - Progress 15%]
[IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII]

User avatar
Acyd Burn
Posts: 1838
Joined: Tue Oct 08, 2002 5:18 pm
Location: Behind You
Contact:

Re: Problem making new forums and users

Post by Acyd Burn »

I would report it to the bug tracker and give your exact mysql version (if mysql5 if it is in strict mode or not) as well as the full error message (including the backtrace).

Image

User avatar
Freelance
Registered User
Posts: 73
Joined: Wed Oct 18, 2006 6:33 am
Location: W.Vl., Belgium

Re: Problem making new forums and users

Post by Freelance »

apperently phpBB3.0 isn't compatible with the latest server builds
I guess the problem is the mysql-server.

I reinstalled the server to version 5.0.18nt and everything seems to work fine now.
the version was 5.0.26nt community
Sh*t Can Happen !!!
[Building a large project based on phpBB3 - Progress 15%]
[IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII]

User avatar
Freelance
Registered User
Posts: 73
Joined: Wed Oct 18, 2006 6:33 am
Location: W.Vl., Belgium

Re: Problem making new forums and users

Post by Freelance »

about the backtrace ...

I guess it's to late now since I don't get the error message anymore :(
Sh*t Can Happen !!!
[Building a large project based on phpBB3 - Progress 15%]
[IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII]

User avatar
Acyd Burn
Posts: 1838
Joined: Tue Oct 08, 2002 5:18 pm
Location: Behind You
Contact:

Re: Problem making new forums and users

Post by Acyd Burn »

you had strict mode enabled?

Image

User avatar
Freelance
Registered User
Posts: 73
Joined: Wed Oct 18, 2006 6:33 am
Location: W.Vl., Belgium

Re: Problem making new forums and users

Post by Freelance »

I had it installed with the standard options.
And I can't find any mode selection anywhere.
Sorry , guess I can't help you any further
Sh*t Can Happen !!!
[Building a large project based on phpBB3 - Progress 15%]
[IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII]

moondream
Registered User
Posts: 33
Joined: Tue Aug 19, 2003 1:27 pm

Re: Problem making new forums and users

Post by moondream »

Freelance wrote: apperently phpBB3.0 isn't compatible with the latest server builds
I guess the problem is the mysql-server.

I reinstalled the server to version 5.0.18nt and everything seems to work fine now.
the version was 5.0.26nt community


Im running here with mysql-5.0.26-r1 (gentoo ebuild) without any problems so it might be a platform or configuration problem

Post Reply