mod filebase 2.0.0 RC3

[J.P.]

• Modificatie & Versie:
  Directe link naar de modificatie:http://www.startrekguide.com/community/ ... &sk=t&sd=a
  Adres van je forum: http://www.palmans.net/~fordmondeoclub/phpBB3/index.php
  phpBB versie:
  Heb je onlangs een andere modificatie of stijl geïnstalleerd?
  
  Wat is het probleem?

Ik probeer een files mod te installeren maar als ik onderstaande doe krijg ik de fout...

Wanneer ik deze tabl probeer in te voeren

Code:
CREATE TABLE `phpbb_filebase_cats` (
`id` int(5) unsigned NOT NULL auto_increment,
`name` varchar(40) NOT NULL,
`text` text NOT NULL,
`what` int(1) NOT NULL,
`sup` int(5) NOT NULL,
`active` tinyint(1) NOT NULL default '1',
`ordered` INT( 3 ) NOT NULL,
PRIMARY KEY (`name`, `sup`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


Dan krijg ik

Fout

SQL-query :

CREATE TABLE `phpbb_filebase_cats` (

`id` int( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`name` varchar( 40 ) NOT NULL ,
`text` text NOT NULL ,
`what` int( 1 ) NOT NULL ,
`sup` int( 5 ) NOT NULL ,
`active` tinyint( 1 ) NOT NULL default '1',
`ordered` INT( 3 ) NOT NULL ,
PRIMARY KEY ( `name` , `sup` ) ,
KEY `id` ( `id` )
)ENGINE = MYISAM DEFAULT CHARSET = utf8

MySQL retourneerde:


#1064 - 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 'DEFAULT CHARSET = utf8' at line 9

[BetaDevil]

Code: Selecteer alles

CREATE TABLE `phpbb_filebase_cats` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `name` varchar(40) NOT NULL,
  `text` text NOT NULL,
  `what` int(1) NOT NULL,
  `sup` int(5) NOT NULL,
  `active` tinyint(1) NOT NULL default '1',
  `ordered` INT( 3 ) NOT NULL,
  PRIMARY KEY  (`name`, `sup`),
  KEY `id` (`id`)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;

[J.P.]

Het wordt een beetje verwarrend, daarom voeg ik de text maar even toe.
Aangezien ze niet allemaal diezelfde regel hebben weet ik niet of ze allemaal met dezelfde regel vervangen kunnen worden.

Hier komt die, zou je hem voor mij willen aanpassen?
Alvast vriendelijk bedankt...

Code: Selecteer alles

INSERT INTO `phpbb_config` VALUES (0x66696c65626173655f616c6c6f77656473697a65, 0x34, 0);
INSERT INTO `phpbb_config` ( `config_name` , `config_value` , `is_dynamic` )
VALUES (
'filebase_statistics', '1', '0'
);

INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (NULL, 0x755f766965775f66696c6562617365, 1, 0, 0);
INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (NULL, 0x755f6d616e6167655f66696c6562617365, 1, 0, 0);
INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (NULL, 0x755f75706c6f61645f66696c6562617365, 1, 0, 0);

CREATE TABLE `phpbb_filebase` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `name` varchar(200) NOT NULL,
  `type` varchar(20) NOT NULL,
  `size` int(8) NOT NULL,
  `downloads` int(5) NOT NULL default '0',
  `cat` int(3) NOT NULL,
  `datum` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `fullname` varchar(100) NOT NULL,
  `defekt` tinyint(1) NOT NULL default '0',
  `ok` tinyint(1) NOT NULL default '0',
  `uploader` varchar( 50 ) NOT NULL,
  `password` VARCHAR( 32 ) NOT NULL,
  `approved` TINYINT( 1 ) NOT NULL DEFAULT '1',
  `server` INT( 3 ) NOT NULL DEFAULT '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `phpbb_filebase_cats` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `name` varchar(40) NOT NULL,
  `text` text NOT NULL,
  `what` int(1) NOT NULL,
  `sup` int(5) NOT NULL,
  `active` tinyint(1) NOT NULL default '1',
  `ordered` INT( 3 ) NOT NULL,
  PRIMARY KEY  (`name`, `sup`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `phpbb_filebase_types` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `type` varchar(10) NOT NULL,
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`type`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `phpbb_filebase_uf` (
  `id` int(3) unsigned NOT NULL auto_increment,
  `name` varchar(100) collate utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`name`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

CREATE TABLE `phpbb_filebase_uf_data` (
`field_id` INT( 3 ) UNSIGNED NOT NULL ,
`file_id` INT( 5 ) UNSIGNED NOT NULL ,
`value` VARCHAR( 200 ) NOT NULL ,
PRIMARY KEY ( `field_id` , `file_id` )
) TYPE = MYISAM CHARACTER SET utf8 ;

CREATE TABLE `phpbb_filebase_comments` (
`id` INT( 6 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`author` VARCHAR( 60 ) NOT NULL ,
`comment` TEXT NOT NULL ,
`time` INT( 40 ) NOT NULL ,
`file_id` INT( 5 ) NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = MYISAM CHARACTER SET utf8 ;

CREATE TABLE `phpbb_filebase_rating` (
`file_id` INT( 5 ) NOT NULL ,
`user_id` INT( 5 ) NOT NULL ,
`rating` INT( 1 ) NOT NULL ,
PRIMARY KEY ( `file_id` , `user_id` )
) TYPE = MYISAM CHARACTER SET utf8 ;

INSERT INTO `phpbb_config` ( `config_name` , `config_value` , `is_dynamic` )
VALUES (
'filebase_dateformat', '1', '0'
);

INSERT INTO `phpbb_config` (
`config_name` ,
`config_value` ,
`is_dynamic`
)
VALUES (
'filebase_order', '1', '1'
);

INSERT INTO `phpbb_config` (
`config_name` ,
`config_value` ,
`is_dynamic`
)
VALUES (
'filebase_update', '0', '1'
);

INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES
('filebase_target', '1', 0);

INSERT INTO `phpbb_config` (
`config_name` ,
`config_value` ,
`is_dynamic`
)
VALUES (
'filebase_password', '1', '1'
);

CREATE TABLE `phpbb_filebase_quota` (
  `id` mediumint(5) unsigned NOT NULL auto_increment,
  `user_id` mediumint(8) NOT NULL,
  `allowedsize` mediumint(5) NOT NULL default '0',
  `uploadedsize` mediumint(5) NOT NULL default '0',
  `allowedamount` mediumint(4) NOT NULL default '0',
  `uploadedamount` mediumint(4) NOT NULL default '0',
  `kind` tinyint(1) NOT NULL default '0',
  `u_or_g` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_id`,`u_or_g`),
  KEY `id` (`id`)
) ENGINE=MyISAM CHARACTER SET utf8 ;

 CREATE TABLE `phpbb_filebase_server` (
`id` INT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 255 ) NOT NULL ,
`f_path` VARCHAR( 100 ) NOT NULL ,
`p_path` VARCHAR( 100 ) NOT NULL ,
`username` VARCHAR( 100 ) NOT NULL ,
`password` VARCHAR( 100 ) NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 ;

INSERT INTO `phpbb_filebase_server` (`id`, `name`, `f_path`, `p_path`, `username`, `password`) VALUES
(NULL, '', '', '', '', '');

DELETE FROM `phpbb_filebase_server`;

INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES
(NULL, 'u_comment_filebase', 1, 0, 0),
(NULL, 'u_download_filebase', 1, 0, 0),
(NULL, 'u_password_filebase', 1, 0, 0);

INSERT INTO `phpbb_acl_options` (
`auth_option_id` ,
`auth_option` ,
`is_global` ,
`is_local` ,
`founder_only`
)
VALUES (
NULL , 'u_approve_filebase', '1', '0', '0'
);

[BetaDevil]

Dat is al goed

[J.P.]

Dat is raar want met dat stukje kreeg ik die foutmeilding...
Er staan 3 soorten met die utf8 in

Code: Selecteer alles

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

) ENGINE = MYISAM CHARACTER SET utf8 ;

) TYPE = MYISAM CHARACTER SET utf8 ;

Moeten ze allemaal aangepast worden? en zoja welke moet wat worden...

[BetaDevil]

Als er fouten ontstaan dan moet je ze aanpassen.

[J.P.]

Tuurlijk als je fouten krijgt dat ze aangepast moeten worden.
Maar dan moet je welweten hoe.

Ik probeer ze nu 1 voor 1 maar de eesrte krijg ik weer een foutmelding

Dit voerde ik in.

Code: Selecteer alles

CREATE  TABLE  `phpbb_filebase` (  `id` int( 5  ) unsigned NOT  NULL  AUTO_INCREMENT ,
 `name` varchar( 200  )  NOT  NULL ,
 `type` varchar( 20  )  NOT  NULL ,
 `size` int( 8  )  NOT  NULL ,
 `downloads` int( 5  )  NOT  NULL default  '0',
 `cat` int( 3  )  NOT  NULL ,
 `datum` timestamp NOT  NULL default CURRENT_TIMESTAMP,
 `fullname` varchar( 100  )  NOT  NULL ,
 `defekt` tinyint( 1  )  NOT  NULL default  '0',
 `ok` tinyint( 1  )  NOT  NULL default  '0',
 `uploader` varchar( 50  )  NOT  NULL ,
 `password` VARCHAR( 32  )  NOT  NULL ,
 `approved` TINYINT( 1  )  NOT  NULL DEFAULT  '1',
 `server` INT( 3  )  NOT  NULL DEFAULT  '1',
 PRIMARY  KEY (  `id`  )  ) CHARACTER  SET  `utf8` COLLATE `utf8_bin` 

En dit is de fout

Fout

SQL-query :

CREATE TABLE `phpbb_filebase` (

`id` int( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`name` varchar( 200 ) NOT NULL ,
`type` varchar( 20 ) NOT NULL ,
`size` int( 8 ) NOT NULL ,
`downloads` int( 5 ) NOT NULL default '0',
`cat` int( 3 ) NOT NULL ,
`datum` timestamp NOT NULL defaultCURRENT_TIMESTAMP,
`fullname` varchar( 100 ) NOT NULL ,
`defekt` tinyint( 1 ) NOT NULL default '0',
`ok` tinyint( 1 ) NOT NULL default '0',
`uploader` varchar( 50 ) NOT NULL ,
`password` VARCHAR( 32 ) NOT NULL ,
`approved` TINYINT( 1 ) NOT NULL DEFAULT '1',
`server` INT( 3 ) NOT NULL DEFAULT '1',
PRIMARY KEY ( `id` )
) CHARACTER SET `utf8` COLLATE `utf8_bin`

MySQL retourneerde:


#1064 - 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 'defaultCURRENT_TIMESTAMP,
`fullname` varchar( 100 ) NOT NUL

Update...
De onderste deden het allemaal maar degene met

Code: Selecteer alles

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

doen het niet

[BetaDevil]

Je kijkt niet naar de foutmelding...
Zoals ik ook al op STG zei, waarschijnlijk ook tegen jouw,
Krijg je dit: `datum` timestamp NOT NULL defaultCURRENT_TIMESTAMP, in je SQL
Maar het moet: `datum` timestamp NOT NULL default CURRENT_TIMESTAMP, zijn

[J.P.]

Het spijt mij maar ik voer het op de goede manier in maar als ik de foutmelding krijg dan zet die hem aan elkaar...