phpBB.nl

Nederlandstalige phpBB Support
https://www.phpbb.nl/forums/

mod filebase 2.0.0 RC3

https://www.phpbb.nl/forums/viewtopic.php?f=53&t=42946

Pagina 1 van 1

mod filebase 2.0.0 RC3

Geplaatst: 07 feb 2008, 22:05
door J.P.
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

Re: mod filebase 2.0.0 RC3

Geplaatst: 07 feb 2008, 22:31
door 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`;

Re: mod filebase 2.0.0 RC3

Geplaatst: 07 feb 2008, 23:26
door 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'
);

Re: mod filebase 2.0.0 RC3

Geplaatst: 08 feb 2008, 02:40
door BetaDevil
Dat is al goed :roll:

Re: mod filebase 2.0.0 RC3

Geplaatst: 08 feb 2008, 11:30
door 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...

Re: mod filebase 2.0.0 RC3

Geplaatst: 08 feb 2008, 14:19
door BetaDevil
Als er fouten ontstaan dan moet je ze aanpassen.

Re: mod filebase 2.0.0 RC3

Geplaatst: 08 feb 2008, 15:20
door 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

Re: mod filebase 2.0.0 RC3

Geplaatst: 08 feb 2008, 15:33
door 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 :roll:

Re: mod filebase 2.0.0 RC3

Geplaatst: 08 feb 2008, 15:41
door 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...
Alle tijden zijn UTC+01:00
Pagina 1 van 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/