bitte um hilfe bei DEBUG MODE

mario8 · Beitrag von **mario8** » 16.11.2004 23:41

hallo leute,

wer kann mir bei dieser fehlermeldung helfen?

Failed obtaining category access control lists

DEBUG MODE

SQL Error : 1054 Unknown column 'a.auth_edit_file' in 'field list'

SELECT a.cat_id, a.group_id, a.auth_view, a.auth_read, a.auth_view_file, a.auth_edit_file, a.auth_delete_file, a.auth_upload, a.auth_download, a.auth_rate, a.auth_email, a.auth_view_comment, a.auth_post_comment, a.auth_edit_comment, a.auth_delete_comment, a.auth_mod, a.auth_search, a.auth_stats, a.auth_toplist, a.auth_viewall FROM phpbb_pa_auth a, phpbb_user_group ug WHERE ug.user_id = 2 AND ug.user_pending = 0 AND a.group_id = ug.group_id

Line : 508
File : /var/www/web74/html/phpBB2/pafiledb/includes/functions_pafiledb.php

danke und grüsse
mario

Beitrag von **Markus67** » 17.11.2004 00:00

Hi ...

im Downloadpaket gibt es im Verzeichnis paFileDB/docs/ eine Datei ...
pafiledb_installer.php.
Die musst du in den Forumroot hochladen (da wo auch memberlist.php ist) und im Browser aufrufen, damit die Datenbank entsprechend erweitert wird.

Es sollte eine Meldung "successfull" oder so ähnlich erscheinen ... danach kannst du die Datei wieder löschen und die Fehlermeldung sollte weg sein.

Markus

mario8 · Beitrag von **mario8** » 17.11.2004 09:03

hallo Markus67,

danke für deine antwort. ich habe die pafiledb_installer.php bis jetzt immer über den folgenden pfad ausgeführt:

/html/phpBB2/pafiledb/docs/pafiledb_installer.php

wenn ich die datei über das root verzeichniss ausführe bekomme ich folgende meldung:

Code: Alles auswählen

Warning: main(): Unable to access ./../../extension.inc in /var/www/web74/html/phpBB2/pafiledb_installer.php on line 5

Warning: main(./../../extension.inc): failed to open stream: No such file or directory in /var/www/web74/html/phpBB2/pafiledb_installer.php on line 5

Warning: main(): Failed opening './../../extension.inc' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/web74/html/phpBB2/pafiledb_installer.php on line 5

Warning: main(): Unable to access ./../../common. in /var/www/web74/html/phpBB2/pafiledb_installer.php on line 6

Warning: main(./../../common.): failed to open stream: No such file or directory in /var/www/web74/html/phpBB2/pafiledb_installer.php on line 6

Warning: main(): Failed opening './../../common.' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/web74/html/phpBB2/pafiledb_installer.php on line 6

Fatal error: Call to undefined function: session_pagestart() in /var/www/web74/html/phpBB2/pafiledb_installer.php on line 11

für normal müsste ich die änderung der datenbank auch über phpmyadmin ausführen können oder ?

wenn ich über phpmyadmin die pafiledb_mysql.sql ausführe bekomme ich folgende meldung:

Code: Alles auswählen

Ihr SQL-Befehl wurde erfolgreich ausgeführt.  
SQL-Befehl: 
# phpMyAdmin MySQL-Dump
# version 2.3.0-rc2
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jul 05, 2003 at 08:14 PM
# Server version: 4.00.01
# PHP Version: 4.2.2
# Database : `main`
# --------------------------------------------------------
#
# Table structure for table `phpbb_pa_cat`
#
CREATE TABLE phpbb_pa_cat(
cat_id int( 10 ) NOT NULL AUTO_INCREMENT ,
cat_name text,
cat_desc text,
cat_parent int( 50 ) default NULL ,
parents_data text NOT NULL ,
cat_order int( 50 ) default NULL ,
cat_allow_file tinyint( 2 ) NOT NULL default '0',
cat_files mediumint( 8 ) NOT NULL default '-1',
cat_last_file_id mediumint( 8 ) unsigned NOT NULL default '0',
cat_last_file_name varchar( 255 ) NOT NULL default '',
cat_last_file_time INT( 50 ) UNSIGNED DEFAULT '0' NOT NULL ,
auth_view tinyint( 2 ) NOT NULL default '0',
auth_read tinyint( 2 ) NOT NULL default '0',
auth_view_file tinyint( 2 ) NOT NULL default '0',
auth_upload tinyint( 2 ) NOT NULL default '0',
auth_download tinyint( 2 ) NOT NULL default '0',
auth_rate tinyint( 2 ) NOT NULL default '0',
auth_email tinyint( 2 ) NOT NULL default '0',
auth_view_comment tinyint( 2 ) NOT NULL default '0',
auth_post_comment tinyint( 2 ) NOT NULL default '0',
auth_edit_comment tinyint( 2 ) NOT NULL default '0',
auth_delete_comment tinyint( 2 ) NOT NULL default '0',
PRIMARY KEY ( cat_id ) 
) TYPE = MYISAM ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
# --------------------------------------------------------
INSERT INTO phpbb_pa_cat
VALUES ( 1, 'My Category', '', 0, '', 1, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) ;# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_cat
VALUES ( 2, 'Test Cagegory', 'Just a test category', 1, '', 2, 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) ;# Betroffene Datensätze: 1
CREATE TABLE phpbb_pa_auth(
group_id mediumint( 8 ) DEFAULT '0' NOT NULL ,
cat_id smallint( 5 ) UNSIGNED DEFAULT '0' NOT NULL ,
auth_view tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_read tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_view_file tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_upload tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_download tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_rate tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_email tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_view_comment tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_post_comment tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_edit_comment tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_delete_comment tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_mod tinyint( 1 ) DEFAULT '0' NOT NULL ,
auth_search tinyint( 1 ) DEFAULT '1' NOT NULL ,
auth_stats tinyint( 1 ) DEFAULT '1' NOT NULL ,
auth_toplist tinyint( 1 ) DEFAULT '1' NOT NULL ,
auth_viewall tinyint( 1 ) DEFAULT '1' NOT NULL ,
KEY group_id( group_id ) ,
KEY cat_id( cat_id ) 
);# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
#
# Table structure for table `phpbb_pa_comments`
#
CREATE TABLE phpbb_pa_comments(
comments_id int( 10 ) NOT NULL AUTO_INCREMENT ,
file_id int( 10 ) NOT NULL default '0',
comments_text text NOT NULL ,
comments_title text NOT NULL ,
comments_time int( 50 ) NOT NULL default '0',
comment_bbcode_uid varchar( 10 ) default NULL ,
poster_id mediumint( 8 ) NOT NULL default '0',
PRIMARY KEY ( comments_id ) ,
KEY comments_id( comments_id ) ,
FULLTEXT KEY comment_bbcode_uid( comment_bbcode_uid ) 
) TYPE = MYISAM ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
# --------------------------------------------------------
#
# Table structure for table `phpbb_pa_config`
#
CREATE TABLE phpbb_pa_config(
config_name varchar( 255 ) NOT NULL default '',
config_value varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( config_name ) 
) TYPE = MYISAM ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
# --------------------------------------------------------
#
# Table structure for table `phpbb_pa_custom`
#
CREATE TABLE phpbb_pa_custom(
custom_id int( 50 ) NOT NULL AUTO_INCREMENT ,
custom_name text NOT NULL ,
custom_description text NOT NULL ,
DATA text NOT NULL ,
field_order int( 20 ) NOT NULL default '0',
field_type tinyint( 2 ) NOT NULL default '0',
regex varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( custom_id ) 
) TYPE = MYISAM ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
# --------------------------------------------------------
#
# Table structure for table `phpbb_pa_customdata`
#
CREATE TABLE phpbb_pa_customdata(
customdata_file int( 50 ) NOT NULL default '0',
customdata_custom int( 50 ) NOT NULL default '0',
DATA text NOT NULL 
) TYPE = MYISAM ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
# --------------------------------------------------------
#
# Table structure for table `phpbb_pa_download_info`
#
CREATE TABLE phpbb_pa_download_info(
file_id mediumint( 8 ) NOT NULL default '0',
user_id mediumint( 8 ) NOT NULL default '0',
downloader_ip varchar( 8 ) NOT NULL default '',
downloader_os varchar( 255 ) NOT NULL default '',
downloader_browser varchar( 255 ) NOT NULL default '',
browser_version varchar( 255 ) NOT NULL default ''
) TYPE = MYISAM ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
# --------------------------------------------------------
#
# Table structure for table `phpbb_pa_files`
#
CREATE TABLE phpbb_pa_files(
file_id int( 10 ) NOT NULL AUTO_INCREMENT ,
user_id mediumint( 8 ) NOT NULL default '0',
poster_ip varchar( 8 ) NOT NULL default '',
file_name text,
file_size int( 20 ) NOT NULL default '0',
unique_name varchar( 255 ) NOT NULL default '',
real_name VARCHAR( 255 ) NOT NULL ,
file_dir VARCHAR( 255 ) NOT NULL ,
file_desc text,
file_creator text,
file_version text,
file_longdesc text,
file_ssurl text,
file_sshot_link tinyint( 2 ) NOT NULL default '0',
file_dlurl text,
file_time int( 50 ) default NULL ,
file_update_time int( 50 ) NOT NULL default '0',
file_catid int( 10 ) default NULL ,
file_posticon text,
file_license int( 10 ) default NULL ,
file_dls int( 10 ) default NULL ,
file_last int( 50 ) default NULL ,
file_pin int( 2 ) default NULL ,
file_docsurl text,
file_approved TINYINT( 1 ) DEFAULT '1' NOT NULL ,
file_broken TINYINT( 1 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( file_id ) 
) TYPE = MYISAM ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
# --------------------------------------------------------
#
# Table structure for table `phpbb_pa_license`
#
CREATE TABLE phpbb_pa_license(
license_id int( 10 ) NOT NULL AUTO_INCREMENT ,
license_name text,
license_text text,
PRIMARY KEY ( license_id ) 
) TYPE = MYISAM ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
# --------------------------------------------------------
CREATE TABLE phpbb_pa_mirrors(
mirror_id mediumint( 8 ) NOT NULL AUTO_INCREMENT ,
file_id int( 10 ) NOT NULL ,
unique_name varchar( 255 ) NOT NULL default '',
file_dir VARCHAR( 255 ) NOT NULL ,
file_dlurl varchar( 255 ) NOT NULL default '',
mirror_location VARCHAR( 255 ) NOT NULL default '',
PRIMARY KEY ( mirror_id ) ,
KEY file_id( file_id ) 
) TYPE = MYISAM ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
#
# Table structure for table `phpbb_pa_votes`
#
CREATE TABLE phpbb_pa_votes(
user_id mediumint( 8 ) NOT NULL default '0',
votes_ip varchar( 50 ) NOT NULL default '0',
votes_file int( 50 ) NOT NULL default '0',
rate_point tinyint( 3 ) unsigned NOT NULL default '0',
voter_os varchar( 255 ) NOT NULL default '',
voter_browser varchar( 255 ) NOT NULL default '',
browser_version varchar( 8 ) NOT NULL default '',
KEY user_id( user_id ) 
) TYPE = MYISAM ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Zeilen).
INSERT INTO phpbb_pa_config
VALUES (
'allow_comment_images', '0'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'no_comment_image_message', '[No image please]'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'allow_smilies', '1'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'allow_comment_links', '1'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'no_comment_link_message', '[No links please]'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'settings_disable', '0'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'allow_html', '1'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'allow_bbcode', '1'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'settings_topnumber', '10'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'settings_newdays', '1'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'settings_stats', ''
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'settings_viewall', '1'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'settings_dbname', 'Download Database'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'settings_dbdescription', ''
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'max_comment_chars', '5000'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'tpl_php', '0'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'settings_file_page', '20'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'hotlink_prevent', '1'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'hotlink_allowed', ''
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'sort_method', 'file_time'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config
VALUES (
'sort_order', 'DESC'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config( config_name, config_value ) 
VALUES (
'auth_search', '0'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config( config_name, config_value ) 
VALUES (
'auth_stats', '0'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config( config_name, config_value ) 
VALUES (
'auth_toplist', '0'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config( config_name, config_value ) 
VALUES (
'auth_viewall', '0'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config( config_name, config_value ) 
VALUES (
'max_file_size', '262144'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config( config_name, config_value ) 
VALUES (
'upload_dir', 'pafiledb/uploads/'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config( config_name, config_value ) 
VALUES (
'screenshots_dir', 'pafiledb/images/screenshots/'
);# Betroffene Datensätze: 1
INSERT INTO phpbb_pa_config( config_name, config_value ) 
VALUES (
'forbidden_extensions', 'php, php3, php4, phtml, pl, asp, aspx, cgi'
);# Betroffene Datensätze: 1

das ganze funktioniert aber trozdem nicht. ich würde mich wirklich freuen wenn ihr mir helfen könnt.

danke und grüsse
mario

Beitrag von **Markus67** » 17.11.2004 10:03

Hi ...

ich habe jetzt nochmal nachgesehen ... also die Datei ist im Ordner pafiledb/docs/ und wird dort auch aufgerufen ...

Die Datei rufst du dann folgendermaßen auf:
http://www.domain.de/phpBB2/pafiledb/do ... taller.php

Welche Meldung kommt dann ?

Markus

mario8 · Beitrag von **mario8** » 17.11.2004 10:52

hallo Markus67,

hab es so gemacht wie du gesagt hast und hab nach der installation diese meldung bekommen:

hab jedoch immer noch die gleiche fehlermeldung

Code: Alles auswählen

Installing PaFileDB for phpBB2 
 

Running :: CREATE TABLE phpbb_pa_cat ( cat_id int(10) NOT NULL auto_increment, cat_name text, cat_desc text, cat_parent int(50) default NULL, parents_data text NOT NULL, cat_order int(50) default NULL, cat_allow_file tinyint(2) NOT NULL default '0', cat_files mediumint(8) NOT NULL default '-1', cat_last_file_id mediumint(8) unsigned NOT NULL default '0', cat_last_file_name varchar(255) NOT NULL default '', cat_last_file_time INT(50) UNSIGNED DEFAULT '0' NOT NULL, auth_view tinyint(2) NOT NULL default '0', auth_read tinyint(2) NOT NULL default '0', auth_view_file tinyint(2) NOT NULL default '0', auth_upload tinyint(2) NOT NULL default '0', auth_download tinyint(2) NOT NULL default '0', auth_rate tinyint(2) NOT NULL default '0', auth_email tinyint(2) NOT NULL default '0', auth_view_comment tinyint(2) NOT NULL default '0', auth_post_comment tinyint(2) NOT NULL default '0', auth_edit_comment tinyint(2) NOT NULL default '0', auth_delete_comment tinyint(2) NOT NULL default '0', PRIMARY KEY (cat_id) ) TYPE=MyISAM -> COMPLETED

Running :: INSERT INTO phpbb_pa_cat VALUES (1, 'My Category', '', 0, '', 1, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) -> COMPLETED

Running :: INSERT INTO phpbb_pa_cat VALUES (2, 'Test Cagegory', 'Just a test category', 1, '', 2, 1, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) -> COMPLETED

Running :: CREATE TABLE phpbb_pa_auth ( group_id mediumint(8) DEFAULT '0' NOT NULL, cat_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, auth_view tinyint(1) DEFAULT '0' NOT NULL, auth_read tinyint(1) DEFAULT '0' NOT NULL, auth_view_file tinyint(1) DEFAULT '0' NOT NULL, auth_upload tinyint(1) DEFAULT '0' NOT NULL, auth_download tinyint(1) DEFAULT '0' NOT NULL, auth_rate tinyint(1) DEFAULT '0' NOT NULL, auth_email tinyint(1) DEFAULT '0' NOT NULL, auth_view_comment tinyint(1) DEFAULT '0' NOT NULL, auth_post_comment tinyint(1) DEFAULT '0' NOT NULL, auth_edit_comment tinyint(1) DEFAULT '0' NOT NULL, auth_delete_comment tinyint(1) DEFAULT '0' NOT NULL, auth_mod tinyint(1) DEFAULT '0' NOT NULL, auth_search tinyint(1) DEFAULT '1' NOT NULL, auth_stats tinyint(1) DEFAULT '1' NOT NULL, auth_toplist tinyint(1) DEFAULT '1' NOT NULL, auth_viewall tinyint(1) DEFAULT '1' NOT NULL, KEY group_id (group_id), KEY cat_id (cat_id) ) -> COMPLETED

Running :: CREATE TABLE phpbb_pa_comments ( comments_id int(10) NOT NULL auto_increment, file_id int(10) NOT NULL default '0', comments_text text NOT NULL, comments_title text NOT NULL, comments_time int(50) NOT NULL default '0', comment_bbcode_uid varchar(10) default NULL, poster_id mediumint(8) NOT NULL default '0', PRIMARY KEY (comments_id), KEY comments_id (comments_id), FULLTEXT KEY comment_bbcode_uid (comment_bbcode_uid) ) TYPE=MyISAM -> COMPLETED

Running :: CREATE TABLE phpbb_pa_config ( config_name varchar(255) NOT NULL default '', config_value varchar(255) NOT NULL default '', PRIMARY KEY (config_name) ) TYPE=MyISAM -> COMPLETED

Running :: CREATE TABLE phpbb_pa_custom ( custom_id int(50) NOT NULL auto_increment, custom_name text NOT NULL, custom_description text NOT NULL, data text NOT NULL, field_order int(20) NOT NULL default '0', field_type tinyint(2) NOT NULL default '0', regex varchar(255) NOT NULL default '', PRIMARY KEY (custom_id) ) TYPE=MyISAM -> COMPLETED

Running :: CREATE TABLE phpbb_pa_customdata ( customdata_file int(50) NOT NULL default '0', customdata_custom int(50) NOT NULL default '0', data text NOT NULL ) TYPE=MyISAM -> COMPLETED

Running :: CREATE TABLE phpbb_pa_download_info ( file_id mediumint(8) NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', downloader_ip varchar(8) NOT NULL default '', downloader_os varchar(255) NOT NULL default '', downloader_browser varchar(255) NOT NULL default '', browser_version varchar(255) NOT NULL default '' ) TYPE=MyISAM -> COMPLETED

Running :: CREATE TABLE phpbb_pa_files ( file_id int(10) NOT NULL auto_increment, user_id mediumint(8) NOT NULL default '0', poster_ip varchar(8) NOT NULL default '', file_name text, file_size int(20) NOT NULL default '0', unique_name varchar(255) NOT NULL default '', real_name VARCHAR(255) NOT NULL, file_dir VARCHAR(255) NOT NULL, file_desc text, file_creator text, file_version text, file_longdesc text, file_ssurl text, file_sshot_link tinyint(2) NOT NULL default '0', file_dlurl text, file_time int(50) default NULL, file_update_time int(50) NOT NULL default '0', file_catid int(10) default NULL, file_posticon text, file_license int(10) default NULL, file_dls int(10) default NULL, file_last int(50) default NULL, file_pin int(2) default NULL, file_docsurl text, file_approved TINYINT(1) DEFAULT '1' NOT NULL, file_broken TINYINT(1) DEFAULT '0' NOT NULL, PRIMARY KEY (file_id) ) TYPE=MyISAM -> COMPLETED

Running :: CREATE TABLE phpbb_pa_license ( license_id int(10) NOT NULL auto_increment, license_name text, license_text text, PRIMARY KEY (license_id) ) TYPE=MyISAM -> COMPLETED

Running :: CREATE TABLE phpbb_pa_mirrors ( mirror_id mediumint(8) NOT NULL auto_increment, file_id int(10) NOT NULL, unique_name varchar(255) NOT NULL default '', file_dir VARCHAR(255) NOT NULL, file_dlurl varchar(255) NOT NULL default '', mirror_location VARCHAR(255) NOT NULL default '', PRIMARY KEY (mirror_id), KEY file_id (file_id) ) TYPE=MyISAM -> COMPLETED

Running :: CREATE TABLE phpbb_pa_votes ( user_id mediumint(8) NOT NULL default '0', votes_ip varchar(50) NOT NULL default '0', votes_file int(50) NOT NULL default '0', rate_point tinyint(3) unsigned NOT NULL default '0', voter_os varchar(255) NOT NULL default '', voter_browser varchar(255) NOT NULL default '', browser_version varchar(8) NOT NULL default '', KEY user_id (user_id) ) TYPE=MyISAM -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('allow_comment_images', '0') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('no_comment_image_message', '[No image please]') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('allow_smilies', '1') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('allow_comment_links', '1') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('no_comment_link_message', '[No links please]') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('settings_disable', '0') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('allow_html', '1') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('allow_bbcode', '1') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('settings_topnumber', '10') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('settings_newdays', '1') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('settings_stats', '') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('settings_viewall', '1') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('settings_dbname', 'Download Database') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('settings_dbdescription', '') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('max_comment_chars', '5000') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('tpl_php', '0') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('settings_file_page', '20') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('hotlink_prevent', '1') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('hotlink_allowed', '') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('sort_method', 'file_time') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config VALUES ('sort_order', 'DESC') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_search','0') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_stats','0') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_toplist','0') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('auth_viewall','0') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('max_file_size','262144') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('upload_dir','pafiledb/uploads/') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('screenshots_dir','pafiledb/images/screenshots/') -> COMPLETED

Running :: INSERT INTO phpbb_pa_config (config_name, config_value) VALUES ('forbidden_extensions','php, php3, php4, phtml, pl, asp, aspx, cgi') -> COMPLETED


COMPLETE!

Pafiledb Tables generated successfully.

NOW DELETE THIS FILE

Beitrag von **Markus67** » 17.11.2004 10:54

Hi ...

Das war schonmal erfolgreich

Code: Alles auswählen

Pafiledb Tables generated successfully.

Die Datei kannst du jetzt löschen.

Hast du auch die constants.php entsprechend der Anleitung angepasst ?

Markus

mario8 · Beitrag von **mario8** » 17.11.2004 12:02

hallo Markus67,

ja alle datein sind schon angepasst

Beitrag von **Markus67** » 17.11.2004 12:33

Hi ...

verlinke mal bitte die constants.php als txt-Datei.
KB:datei

Markus

mario8 · Beitrag von **mario8** » 17.11.2004 22:26

hallo Markus67,

konnte leider die constants.txt nicht früher hochladen da ich bis jetzt in der arbeit war.

constants.txt

grüsse
mario

Beitrag von **Markus67** » 17.11.2004 22:37

Hi ...

die stimmt auch .... welchen Prefix haben eigentlich deine ganzen anderen Tabellen in der Datenbank ... phpbb_ ?

Markus