Install

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!
Locked
Loki
Registered User
Posts: 12
Joined: Mon Sep 15, 2003 8:43 pm
Location: Tivoli, New York
Contact:

Install

Post by Loki »

I know there is no support so those of you who have come here to say so don't. Just, if some1 out of the kindest of their heart would answer.

I used to be able to install these things, but now i can't

Code: Select all

Fatal installation error
A fatal and unrecoverable database error has occured. This may be because the specified user does not have appropriate rights to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.
c:\web\phpBB22-CVS_200310262300\phpBB2\install\install.php [ 1069 ]
SQL : CREATE TABLE phpbb_groups ( group_id mediumint(8) NOT NULL auto_increment, group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) DEFAULT '' NOT NULL, group_display tinyint(1) DEFAULT '0' NOT NULL, group_avatar varchar(100) DEFAULT '' NOT NULL, group_avatar_type tinyint(4) DEFAULT '0' NOT NULL, group_avatar_width tinyint(4 UNSIGNED DEFAULT '0' NOT NULL, group_avatar_height tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, group_rank smallint(5) DEFAULT '-1' NOT NULL, group_colour varchar(6) DEFAULT '' NOT NULL, group_chgpass smallint(6) DEFAULT '0' NOT NULL, group_description varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (group_id) )
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNSIGNED DEFAULT '0' NOT NULL, group_avatar_height tinyint(4

RyanThaDude29
Registered User
Posts: 90
Joined: Tue Apr 15, 2003 5:46 am
Location: Northwest Indiana
Contact:

Re: Install

Post by RyanThaDude29 »

" target="_blank

User avatar
Arty
Former Team Member
Posts: 985
Joined: Wed Mar 06, 2002 2:36 pm
Location: Mars
Contact:

Re: Install

Post by Arty »

Loki wrote:I know there is no support
Then why are you posting question?

btw, your signature that "detects" browser is buggy - i'm using Opera, not IE.

Trek
Registered User
Posts: 376
Joined: Mon Jan 14, 2002 6:58 pm
Location: UK
Contact:

Re: Install

Post by Trek »

Can Opera not set to say it's IE, instead of Opera? I thought it could?
Miguel
http://community.34sp.com" target="_blank
http://www.miguel.me.uk" target="_blank | http://www.sfcommand.co.uk" target="_blank | http://www.ssdg.org.uk" target="_blank
Hardware: The parts of a computer system that can be kicked

Jackal05
Registered User
Posts: 80
Joined: Sat Oct 25, 2003 11:28 pm
Location: Nowhere of nowhere
Contact:

Re: Install

Post by Jackal05 »

I had a similiar problem.
Open Up phpBB2\install\schemas\mysql_schema.sql
Find:

Code: Select all

group_avatar_width tinyint(4 UNSIGNED DEFAULT '0' NOT NULL,
and replace it with:

Code: Select all

group_avatar_width tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
That should solve your problem. :)
I had some problems during installation that was one. ;)
"There are two groups of people, the hunters and the hunted."
-Anonymous

[ My Home | http://www.jackaldesigns.com/ ]
[ Current Project | http://www.jackaldesigns.com/Projects/G ... /index.php ]

User avatar
SHS`
Registered User
Posts: 1628
Joined: Wed Jul 04, 2001 9:13 am
Location: The Boonies, Hong Kong
Contact:

Re: Install

Post by SHS` »

Unsupported means unsupported, directly (team members/developers) or by proxy (users).

It states very cleary... ionly use CVS if you have good SQL & PHP knowledge... which I'm afraid to say you haven't, as the SQL error told you what needed to be fixed.

Also, please don't post fixes, as the schemas change... and whatever code/SQL you paste here may very be completely incorrect at a later date.
Jonathan “SHS`” Stanley • 史德信
phpBB™ 3.1.x, Bug/Security trackers
phpBB™ Bertie Bear 3.0 — prosilver Edition!Asking Questions The Smart Way

Locked