phpBB România

forumul phpBB in limba romana. Opinii, implementari, ajutor, instructiuni si download.
https://phpbb3.ro/community/

nu stiu ce e asta...dupa ce am bagat reputation mod

https://phpbb3.ro/community/viewtopic.php?t=5312

Pagina 1 din 2

nu stiu ce e asta...dupa ce am bagat reputation mod

Scris: 04-Noi-2006, 21:03:18
de Skyler

Cod: Selectaţi tot

phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'xzone_1g.CONFIG_TABLE' doesn't exist

SELECT * FROM CONFIG_TABLE

Line : 215
File : common.php
s-a dus forumul.

Scris: 04-Noi-2006, 21:07:11
de Etherfast
Reputation MOD are niste parti SQL in MOD-ul in cauza, sau niste fisiere php care creaza niste tabele in baza de date. Trebuie sa creezi acele tabele, pe care nu le-ai creat.

Scris: 04-Noi-2006, 21:20:48
de Skyler
Deci, eu trebuie sa fac un nou table cu numele CONFIG_TABLE in baza de date xzone_1g? ca asa se numeste baza de date...xzone_1g

Scris: 04-Noi-2006, 21:24:59
de Etherfast
Nu tu personal. Ai o instructiune in fisierul .mod sau ai un fisier .php in arhiva mod-ului care fix asta face pentru tine, dar trebuie sa-l executi in prealabil :)

Scris: 04-Noi-2006, 21:25:42
de Skyler

Cod: Selectaţi tot

# 
# STEP 3/3: Updating the database
# 
Run:
	reputation_mod_install_db_v100.php
	reputation_mod_install_users_v100.php
Then delete them!
aceeasi eroare si cand vreau sa rulez unul din cele 2. nu ma pricep prea bine la mysql si......cam asta e

Scris: 04-Noi-2006, 21:34:17
de Etherfast
Si zici ca ai rulat ambele fisiere in browser? Gen http://site.ro/admin/mods/reputation_mo ... b_v100.php ?
Ce eroare iti da? Nu are cum sa-ti dea aceeasi eroare.

Scris: 04-Noi-2006, 21:40:51
de Skyler
daca rulez http://www.xzone.1gb.at/f2/admin/mods/r ... b_v100.php
sau
http://www.xzone.1gb.at/f2/admin/mods/r ... b_v100.php

imi da eroarea asta

Cod: Selectaţi tot

Warning: include() [function.include]: Unable to access ./extension.inc in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 8

Warning: include(./extension.inc) [function.include]: failed to open stream: No such file or directory in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 8

Warning: include() [function.include]: Failed opening './extension.inc' for inclusion (include_path='.:./includes:../includes:/users/common') in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 8

Warning: include() [function.include]: Unable to access ./common. in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 9

Warning: include(./common.) [function.include]: failed to open stream: No such file or directory in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 9

Warning: include() [function.include]: Failed opening './common.' for inclusion (include_path='.:./includes:../includes:/users/common') in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 9

Fatal error: Call to undefined function session_pagestart() in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 11
daca rulez
http://www.xzone.1gb.at/f2/reputation_m ... b_v100.php
apare ce am spus mai sus. incearca si tu

Scris: 04-Noi-2006, 21:49:30
de Etherfast
http://www.xzone.1gb.at/f2/reputation_m ... b_v100.php
In acest fisier, nu trebuie sa configurezi cateva detalii referitoare la baza de date, cumva?

Scris: 04-Noi-2006, 21:58:40
de Skyler
nu spune nimic in install.txt vrei o copie a codului? nu e mare.

Cod: Selectaţi tot

<?php
//copyright © 2004 IdleVoid & brustverein
//copyright © 2003 Volodymy (CLowN) Skoryk
//this update template copyright © 2006 Anton Granik

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);

if( !$userdata['session_logged_in'] )
{
   $header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
   header($header_location . append_sid("login.$phpEx?redirect=reputation_mod_install_db_v100.$phpEx", true));
   exit;
}

if( $userdata['user_level'] != ADMIN )
{
   message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}

$page_title = 'Setting the database for Reputation Mod v.1.0.0 by Anton Granik';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

echo '<table>';
echo '<tr><th>Setting the database for Reputation Mod v.1.0.0 by Anton Granik</th></tr><tr><td><span><ul>';

$sql = array();
$sql[] = "	CREATE TABLE `" . $table_prefix . "reputation` (
			`user_id` mediumint(8) NOT NULL default '0',
			`user_id_2` mediumint(8) NOT NULL default '0',
			`post_id` mediumint(8) NOT NULL default '0',
			`rep_sum` FLOAT NOT NULL default '0',
			`rep_neg` tinyint(1) NOT NULL default '0',
			`rep_comment` varchar(200) NOT NULL default '',
			`rep_time` int(11) NOT NULL default '0',
			KEY `user_id` (`user_id`)
			) TYPE=MyISAM;";
$sql[] = "	CREATE TABLE `" . $table_prefix . "reputation_config` (
	  		`config_name` VARCHAR( 255 ) NOT NULL ,
			`config_value` VARCHAR( 255 ) NOT NULL 
			) TYPE=MyISAM;";
$sql[] = "	ALTER TABLE `" . $table_prefix . "users` ADD `user_reputation` FLOAT DEFAULT '0' NOT NULL";
$sql[] = "	ALTER TABLE `" . $table_prefix . "users` ADD `user_rep_last_time` INT( 11 ) NOT NULL AFTER `user_reputation`";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('posts_to_earn', '50')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('rep_disable', '0')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('days_to_earn', '30')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('flood_control_time', '30')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('graphic_version', '1')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal4_to_earn', '10')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal3_to_earn', '50')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal2_to_earn', '100')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal1_to_earn', '200')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('given_rep_to_earn', '20')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('show_stats_to_mods', '0')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('repsum_limit', '0')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('pm_notify', '1')";
$sql[] = "	INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('default_amount', '0')";

$errors = 0;
for( $i = 0; $i <count>sql_query ($sql[$i]) )
   {
      $error = $db->sql_error();
      echo '<li>' . $sql[$i] . '<br> +++ <font><b>Error:</b></font> ' . $error['message'] . '</li><br>';
   }
   else
   {
      echo '<li>' . $sql[$i] . '<br> +++ <font><b>Successfull</b></font></li><br>';
   }
}

if ($errors == 0)
echo '<tr><th>Finish</th></tr><tr><td><span>Now run <a href="reputation_mod_install_users_v100.php">reputation_mod_install_users_v100.php</a> to create reputations for users with default settings. Or go to the admin panel -> reputation and change the config values according to what you want on your board and run the file after that.</span></td></tr></table>';

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>
o sterg dupa ce o vezi

Scris: 04-Noi-2006, 23:00:25
de Etherfast

Cod: Selectaţi tot

CREATE TABLE `" . $table_prefix . "reputation` (
         `user_id` mediumint(8) NOT NULL default '0',
         `user_id_2` mediumint(8) NOT NULL default '0',
         `post_id` mediumint(8) NOT NULL default '0',
         `rep_sum` FLOAT NOT NULL default '0',
         `rep_neg` tinyint(1) NOT NULL default '0',
         `rep_comment` varchar(200) NOT NULL default '',
         `rep_time` int(11) NOT NULL default '0',
         KEY `user_id` (`user_id`)
         ) TYPE=MyISAM;";
CREATE TABLE `" . $table_prefix . "reputation_config` (
           `config_name` VARCHAR( 255 ) NOT NULL ,
         `config_value` VARCHAR( 255 ) NOT NULL
         ) TYPE=MyISAM;";
ALTER TABLE `" . $table_prefix . "users` ADD `user_reputation` FLOAT DEFAULT '0' NOT NULL";
ALTER TABLE `" . $table_prefix . "users` ADD `user_rep_last_time` INT( 11 ) NOT NULL AFTER `user_reputation`";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('posts_to_earn', '50')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('rep_disable', '0')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('days_to_earn', '30')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('flood_control_time', '30')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('graphic_version', '1')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal4_to_earn', '10')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal3_to_earn', '50')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal2_to_earn', '100')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal1_to_earn', '200')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('given_rep_to_earn', '20')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('show_stats_to_mods', '0')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('repsum_limit', '0')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('pm_notify', '1')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('default_amount', '0')";
Executa asta ca SQL query in phpMyAdmin.

Nu stiu ce sa-ti zic in momentul de fata, nu am acces sa instalez nimic de unde sunt eu acum. Faza e ca e clar ca nu-si face update la baza de date cum trebuie.
Vezi poate trebuie sa executi fisierul ala dintr-o anumita locatie.
Ora este UTC+03:00
Pagina 1 din 2

Furnizat de phpBB® Forum Software © phpBB Limited

Translation/Traducere: phpBB România