install with mysql 5.0.15

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
LuPiNOOoO
Registered User
Posts: 2
Joined: Thu Nov 17, 2005 1:48 pm

install with mysql 5.0.15

Post by LuPiNOOoO » Thu Nov 17, 2005 1:54 pm

hi, i try to install phpbb2 with mysql 5.0.15 but i when the install is run i have this error:
Field 'bbcode_uid' doesn't have a default value

Soluzion?

wanted
Registered User
Posts: 11
Joined: Wed Aug 20, 2003 12:40 pm
Location: Demon's Island
Contact:

Post by wanted » Thu Nov 17, 2005 3:01 pm

I have the same problem. I have installed phpBB 2.0.18 on Apache 2.0.55, Php 5.0.5 and MySQL 5.0.15.

LuPiNOOoO
Registered User
Posts: 2
Joined: Thu Nov 17, 2005 1:48 pm

Post by LuPiNOOoO » Thu Nov 17, 2005 8:10 pm

what is the soluzion for this problem???

AcousticJames
Registered User
Posts: 970
Joined: Wed Jul 13, 2005 5:59 am
Location: St. Cloud, MN
Contact:

Post by AcousticJames » Thu Nov 17, 2005 8:16 pm

phpBB does not work well with either PHP 5.x or MySQL 5.x. Downgrade to 4.x versions of both PHP and MySQL.

cooch
Registered User
Posts: 81
Joined: Tue May 13, 2003 5:38 pm

Post by cooch » Thu Nov 17, 2005 8:41 pm

AcousticJames wrote: phpBB does not work well with either PHP 5.x or MySQL 5.x. Downgrade to 4.x versions of both PHP and MySQL.


WHich is a non-trivial recommendation - however correct. If you have a system (or are using a host) that is configured for 5.xx of both PHP and mySQL, 'downgrading' is a dauting task, and in some cases (especially for hosted systems) not possible.

wanted
Registered User
Posts: 11
Joined: Wed Aug 20, 2003 12:40 pm
Location: Demon's Island
Contact:

Post by wanted » Thu Nov 17, 2005 8:50 pm

I have a question. In future the phpBB will be rendered compatible with the new version of MySQL (now 5.0.15) or not?

Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham » Thu Nov 17, 2005 8:52 pm

It is already compatable with mysql 5 - providing you are running it in it's default mode and have not changed it into one of it's more obscure configurations (there are changes to deal with that in CVS if you really feel you must run it in one of those configurations)
"So Long, and Thanks for All the Fish"

phpBB Useful Links: Knowledge Base | Userguide | Forum Search | MOD Database | Styles Database
My Links: Blog!

wanted
Registered User
Posts: 11
Joined: Wed Aug 20, 2003 12:40 pm
Location: Demon's Island
Contact:

Post by wanted » Thu Nov 17, 2005 9:03 pm

I installed (for test) the phpBB on my webserver (windows platform :( ).

I configure PHP 5 with extension mysqli.dll (not mysql.dll) but when install phpBB will be return an error message that the db not supported by phpBB.

In the installation page i have specified a MySQL 4.X database type.

Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham » Thu Nov 17, 2005 9:07 pm

And that's the problem - you need to use the mysql extension. We do not support mysqli on phpBB 2.0.x
"So Long, and Thanks for All the Fish"

phpBB Useful Links: Knowledge Base | Userguide | Forum Search | MOD Database | Styles Database
My Links: Blog!

wanted
Registered User
Posts: 11
Joined: Wed Aug 20, 2003 12:40 pm
Location: Demon's Island
Contact:

Post by wanted » Thu Nov 17, 2005 9:35 pm

I have supposed that the extension right to install was mysql.dll.

Thank you very very much. :D

But during the installation of phpBB 2.0.18 i receive an error:

"bbcode_uid has not a default values"

I resolved this error with this changes:

OPEN install/shemas/mysql_schema.sql

FIND:

Code: Select all

# --------------------------------------------------------
#
# Table structure for table 'phpbb_posts_text'
#
CREATE TABLE phpbb_posts_text (
   post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   bbcode_uid char(10) NOT NULL,
   post_subject char(60),
   post_text text,
   PRIMARY KEY (post_id)
);
AND REPLACE WITH:

Code: Select all

# --------------------------------------------------------
#
# Table structure for table 'phpbb_posts_text'
#
CREATE TABLE phpbb_posts_text (
   post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   bbcode_uid char(10) DEFAULT '0' NOT NULL,
   post_subject char(60),
   post_text text,
   PRIMARY KEY (post_id)
);

Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham » Thu Nov 17, 2005 9:45 pm

Which tells me that you are not running it in the default configuration ;)

That issue is already patched in CVS as noted, but running in that configuration is liable to cause issues with a lot of applications
"So Long, and Thanks for All the Fish"

phpBB Useful Links: Knowledge Base | Userguide | Forum Search | MOD Database | Styles Database
My Links: Blog!

Defeatable
Registered User
Posts: 1
Joined: Fri Nov 18, 2005 9:56 pm

Post by Defeatable » Fri Nov 18, 2005 9:57 pm

Graham wrote: Which tells me that you are not running it in the default configuration ;)

That issue is already patched in CVS as noted, but running in that configuration is liable to cause issues with a lot of applications


Not exactly true, I'm having the same problem with the defaul install.

Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham » Fri Nov 18, 2005 10:07 pm

Well in that case someone is shipping packages that differ from what mysql themselves say is the default configuration.

The setting in question is called sql_mode and this is only an issue if one of 2 out of the possible values are set and according to the manual by default none is set

[quote=The mysql manual]....The default value is empty (no modes set)....[/quote]
"So Long, and Thanks for All the Fish"

phpBB Useful Links: Knowledge Base | Userguide | Forum Search | MOD Database | Styles Database
My Links: Blog!

Locked

Return to “2.0.x Support Forum”