Seite 1 von 3

Color_Groups

Verfasst: 28.08.2005 18:55
von access
Hallo,


ich habe bzw. wollte mir Color Groups einbauen. Ich habe die Version 2.0.17 vom Forum. Ich hoffe ich habe das richtig geschrieben.

Ich habe es auf den Server geladen. Und wenn ich im Admin bereich bin, und darauf will, steht folgentes:

Error querying the users table.

DEBUG MODE

SQL Error : 1146 Table 'db124242683.COLOR_GROUPS_TABLE' doesn't exist

SELECT group_id, group_name FROM COLOR_GROUPS_TABLE

Line : 145
File : admin_color_groups.php


Was tue ich jetzt?

Danke :-)

Verfasst: 28.08.2005 18:57
von steffi1977
hast die install datei ausgeführt ???

Verfasst: 29.08.2005 00:46
von access
Hm... da finde ich keine Install.php datei :(

Verfasst: 29.08.2005 00:48
von Clone
Es müsste eine nivisec_install.php geben. Die musst du ausführen.

Verfasst: 29.08.2005 00:51
von S2B
Dieser Fehler liegt an den Veränderungen an der includes/constants.php, die Konstante für die Tabelle fehlt. :wink: Hast du die Anweisungen aus der Anleitung komplett durchgeführt?

Auf jeden Fall musst du trotzdem die nivisec_install.php ausführen.

Verfasst: 29.08.2005 01:34
von access
Jetzt kommt das hier... was soll ich den da ändern? User_Tabelle? Und wo mach ich das? Ich weiss auch gar nicht mehr so richtig wie ich die Tabelle genannt habe.

Your phpBB version is found to work with this mod.


Found phpbb root path at ./.
Using sql queue list file nivisec_schema/install.sql.
Found php version 4.3.10.
Found phpbb version 2.0.17.


[FAILED] :: CREATE TABLE `phpbb2mysqlcolor_groups` ( `group_id` mediumint(8) unsigned NOT NULL auto_increment, `group_name` varchar(255) NOT NULL default '', `group_color` varchar(50) NOT NULL default '', PRIMARY KEY (`group_id`), UNIQUE KEY `group_name` (`group_name`) ) TYPE=MyISAM
Reason:Table 'phpbb2mysqlcolor_groups' already exists
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.

[FAILED] :: ALTER TABLE `phpbb2mysqlusers` ADD `user_color_group` MEDIUMINT UNSIGNED NOT NULL
Reason:Duplicate column name 'user_color_group'
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.

[FAILED] :: ALTER TABLE `phpbb2mysqlcolor_groups` ADD `hidden` TINYINT( 1 ) DEFAULT '0' NOT NULL
Reason:Duplicate column name 'hidden'
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.

[FAILED] :: ALTER TABLE `phpbb2mysqlcolor_groups` ADD `order_num` MEDIUMINT NOT NULL
Reason:Duplicate column name 'order_num'
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.

[FAILED] :: ALTER TABLE `phpbb2mysqlgroups` ADD `group_color_group` MEDIUMINT UNSIGNED NOT NULL
Reason:Duplicate column name 'group_color_group'
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.


Please delete this file (nivisec_install.php) and nivisec_schema/*.* for security reasons!

Verfasst: 29.08.2005 01:48
von S2B
Da steht doch schon alles da, die Tabellen existieren schon (du hast also die Datei schon ausgeführt) und du sollst die Datei wieder vom Webspace löschen. :wink:

Hast du jetzt mal die Veränderungen in der constants.php überprüft?

Verfasst: 29.08.2005 01:55
von access
Sorry wenn ich soviel Frage :-)

Aber wo finde ich die datei constants.php und was soll ich da überprüfen? Also ich habe nun die zwei datan gelöscht wie ich es machen sollte.

Wenn ich in den Admin Bereich gehe steht da wieder Fehler beim Zugriff auf die User-Tabelle.

DEBUG MODE

SQL Error : 1146 Table 'db124242683.COLOR_GROUPS_TABLE' doesn't exist

SELECT group_id, group_name FROM COLOR_GROUPS_TABLE

Line : 145
File : admin_color_groups.php

Verfasst: 29.08.2005 09:44
von Markus67
Hi ...

die constants.php findest du im Ordner includes.

Diese Änderung muss gem. der Install.txt dort gemacht werden ....

Code: Alles auswählen

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/constants.php

# 
#-----[ FIND ]------------------------------------------ 
#
define('CATEGORIES_TABLE', $table_prefix.'categories');

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#
define('COLOR_GROUPS_TABLE', $table_prefix.'color_groups');
Markus

Verfasst: 29.08.2005 16:48
von access
hm... also ich habe die datei gefunden... und habe auch das in der install gemacht..

<?php
/***************************************************************************
* constants.php
* -------------------
* begin : Saturday', Feb 13', 2001
* copyright : ('C) 2001 The phpBB Group
* email : support@phpbb.com
*
* $Id: constants.php,v 1.47.2.5 2004/11/18 17:49:42 acydburn Exp $
*
*
***************************************************************************/

/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License', or
* ('at your option) any later version.
*
***************************************************************************/

if ( !defined('IN_PHPBB') )
{
die("Hacking attempt");
}

// Debug Level
//define('DEBUG', 1); // Debugging on
define('DEBUG', 1); // Debugging off


// User Levels <- Do not change the values of USER or ADMIN
define('DELETED', -1);
define('ANONYMOUS', -1);

define('USER', 0);
define('ADMIN', 1);
define('MOD', 2);


// User related
define('USER_ACTIVATION_NONE', 0);
define('USER_ACTIVATION_SELF', 1);
define('USER_ACTIVATION_ADMIN', 2);

define('USER_AVATAR_NONE', 0);
define('USER_AVATAR_UPLOAD', 1);
define('USER_AVATAR_REMOTE', 2);
define('USER_AVATAR_GALLERY', 3);


// Group settings
define('GROUP_OPEN', 0);
define('GROUP_CLOSED', 1);
define('GROUP_HIDDEN', 2);


// Forum state
define('FORUM_UNLOCKED', 0);
define('FORUM_LOCKED', 1);


// Topic status
define('TOPIC_UNLOCKED', 0);
define('TOPIC_LOCKED', 1);
define('TOPIC_MOVED', 2);
define('TOPIC_WATCH_NOTIFIED', 1);
define('TOPIC_WATCH_UN_NOTIFIED', 0);


// Topic types
define('POST_NORMAL', 0);
define('POST_STICKY', 1);
define('POST_ANNOUNCE', 2);
define('POST_GLOBAL_ANNOUNCE', 3);


// SQL codes
define('BEGIN_TRANSACTION', 1);
define('END_TRANSACTION', 2);


// Error codes
define('GENERAL_MESSAGE', 200);
define('GENERAL_ERROR', 202);
define('CRITICAL_MESSAGE', 203);
define('CRITICAL_ERROR', 204);


// Private messaging
define('PRIVMSGS_READ_MAIL', 0);
define('PRIVMSGS_NEW_MAIL', 1);
define('PRIVMSGS_SENT_MAIL', 2);
define('PRIVMSGS_SAVED_IN_MAIL', 3);
define('PRIVMSGS_SAVED_OUT_MAIL', 4);
define('PRIVMSGS_UNREAD_MAIL', 5);


// URL PARAMETERS
define('POST_TOPIC_URL', 't');
define('POST_CAT_URL', 'c');
define('POST_FORUM_URL', 'f');
define('POST_USERS_URL', 'u');
define('POST_POST_URL', 'p');
define('POST_GROUPS_URL', 'g');

// Session parameters
define('SESSION_METHOD_COOKIE', 100);
define('SESSION_METHOD_GET', 101);


// Page numbers for session handling
define('PAGE_INDEX', 0);
define('PAGE_LOGIN', -1);
define('PAGE_SEARCH', -2);
define('PAGE_REGISTER', -3);
define('PAGE_PROFILE', -4);
define('PAGE_VIEWONLINE', -6);
define('PAGE_VIEWMEMBERS', -7);
define('PAGE_FAQ', -8);
define('PAGE_POSTING', -9);
define('PAGE_PRIVMSGS', -10);
define('PAGE_GROUPCP', -11);
define('PAGE_TOPIC_OFFSET', 5000);


// Auth settings
define('AUTH_LIST_ALL', 0);
define('AUTH_ALL', 0);

define('AUTH_REG', 1);
define('AUTH_ACL', 2);
define('AUTH_MOD', 3);
define('AUTH_ADMIN', 5);

define('AUTH_VIEW', 1);
define('AUTH_READ', 2);
define('AUTH_POST', 3);
define('AUTH_REPLY', 4);
define('AUTH_EDIT', 5);
define('AUTH_DELETE', 6);
define('AUTH_ANNOUNCE', 7);
define('AUTH_STICKY', 8);
define('AUTH_POLLCREATE', 9);
define('AUTH_VOTE', 10);
define('AUTH_ATTACH', 11);


// Table names
define('CONFIRM_TABLE', $table_prefix.'confirm');
define('AUTH_ACCESS_TABLE', $table_prefix.'auth_access');
define('BANLIST_TABLE', $table_prefix.'banlist');
define('CATEGORIES_TABLE', $table_prefix.'categories');
define('CONFIG_TABLE', $table_prefix.'config');
define('DISALLOW_TABLE', $table_prefix.'disallow');
define('FORUMS_TABLE', $table_prefix.'forums');
define('GROUPS_TABLE', $table_prefix.'groups');
define('POSTS_TABLE', $table_prefix.'posts');
define('POSTS_TEXT_TABLE', $table_prefix.'posts_text');
define('PRIVMSGS_TABLE', $table_prefix.'privmsgs');
define('PRIVMSGS_TEXT_TABLE', $table_prefix.'privmsgs_text');
define('PRIVMSGS_IGNORE_TABLE', $table_prefix.'privmsgs_ignore');
define('PRUNE_TABLE', $table_prefix.'forum_prune');
define('RANKS_TABLE', $table_prefix.'ranks');
define('SEARCH_TABLE', $table_prefix.'search_results');
define('SEARCH_WORD_TABLE', $table_prefix.'search_wordlist');
define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch');
define('SESSIONS_TABLE', $table_prefix.'sessions');
define('SMILIES_TABLE', $table_prefix.'smilies');
define('THEMES_TABLE', $table_prefix.'themes');
define('THEMES_NAME_TABLE', $table_prefix.'themes_name');
define('TOPICS_TABLE', $table_prefix.'topics');
define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');
define('USER_GROUP_TABLE', $table_prefix.'user_group');
define('USERS_TABLE', $table_prefix.'users');
define('WORDS_TABLE', $table_prefix.'words');
define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

?>