Log actions mod - db_update.php

[megeo]

La log action mod nu merge log_actions_db_update.php
scrie "phpBB : Eroare primejdioasã

Could not connect to the database"

HELPPP!!
numele bazei de date la mine ii phpbb_

[Sharakuza]

pt a te conecta la o baza de date nu este necesar numele

vezi in instructiune de instalare exact ce trebuie sa faci

pt a te conecta la o baza de date e nevoie de hostul acesteia, numele acesteia si parola acesteia

la tine nu este numele "phpbb_" , acesta fiind structura tabelelor din baza de date

[megeo]

dar fisierul acela nu ar trebui acesat simplu din browser
se instaleaza si apoi ii serg?

Cod: Selectaţi tot

	switch ( SQL_LAYER )
	{
		case 'mysql':
		case 'mysql4':
			$sql[] = "CREATE TABLE " . LOGS_TABLE . " (
				id_log MEDIUMINT(10) NOT NULL DEFAULT '0' AUTO_INCREMENT,
				mode VARCHAR(50) NULL DEFAULT '', 
				topic_id MEDIUMINT(10) NULL DEFAULT '0',
				user_id MEDIUMINT(8) NULL DEFAULT '0',
				username VARCHAR(255) NULL DEFAULT '',
				user_ip CHAR(8) DEFAULT '0' NOT NULL,
				time INT(11) NULL DEFAULT '0',
				PRIMARY KEY (id_log))";

			$sql[] = "CREATE TABLE " . LOGS_CONFIG_TABLE . " (
				config_name varchar(255) NOT NULL,
				config_value varchar(255) NOT NULL,
				PRIMARY KEY (config_name))";

			$sql[] = "INSERT INTO " . LOGS_CONFIG_TABLE . " (
				config_name, config_value)
				VALUES ('all_admin', 0)";

			$sql[] = "ALTER TABLE " . USERS_TABLE . "
				ADD user_view_log TINYINT NOT NULL DEFAULT '0'";
			break;
		
		 case 'postgresql':
			$sql[] = "CREATE TABLE " . LOGS_TABLE . " (
				id_log SERIAL NOT NULL PRIMARY KEY,
				mode VARCHAR(50) DEFAULT '',
				topic_id INT4 DEFAULT 0,
				user_id INT4 DEFAULT 0,
				username VARCHAR(255) DEFAULT '',
				user_ip CHAR(8) DEFAULT '0' NOT NULL,
				time INT4 DEFAULT 0 )";

			$sql[] = "CREATE TABLE " . LOGS_CONFIG_TABLE . " (
				config_name varchar(255) NOT NULL PRIMARY KEY,
				config_value varchar(255) NOT NULL )";

			$sql[] = "INSERT INTO " . LOGS_CONFIG_TABLE . " (
				config_name, config_value )
				VALUES ( 'all_admin', 0 )";

			$sql[] = "ALTER TABLE " . USERS_TABLE . "
				ADD user_view_log INT2 NOT NULL DEFAULT 0";
			break;

cred ca asta ar trebui rulat. din phpmyadmin da eroare. probabil trebuie adaptat cumva, iar eu nu stiu

[megeo]

pentru cel ce a mutat topicul la 3.0:

EU FOLOSESC UN PHPBB 2.0.21
so, move it back!

[Marian96]

dar ia uita-te in fisierul log_Actions_db_update.php ce scrie acolo ruleaza
in casuta .sql

[megeo]

am incercat si da eroare
am copiat

Cod: Selectaţi tot

"CREATE TABLE " . LOGS_TABLE . " (
            id_log MEDIUMINT(10) NOT NULL DEFAULT '0' AUTO_INCREMENT,
            mode VARCHAR(50) NULL DEFAULT '',
            topic_id MEDIUMINT(10) NULL DEFAULT '0',
            user_id MEDIUMINT(8) NULL DEFAULT '0',
            username VARCHAR(255) NULL DEFAULT '',
            user_ip CHAR(8) DEFAULT '0' NOT NULL,
            time INT(11) NULL DEFAULT '0',
            PRIMARY KEY (id_log))"; 

de ex si da eroare

[Marian96]

doar atata era?

[megeo]

atata

Cod: Selectaţi tot

switch ( SQL_LAYER )
   {
      case 'mysql':
      case 'mysql4':
         $sql[] = "CREATE TABLE " . LOGS_TABLE . " (
            id_log MEDIUMINT(10) NOT NULL DEFAULT '0' AUTO_INCREMENT,
            mode VARCHAR(50) NULL DEFAULT '',
            topic_id MEDIUMINT(10) NULL DEFAULT '0',
            user_id MEDIUMINT(8) NULL DEFAULT '0',
            username VARCHAR(255) NULL DEFAULT '',
            user_ip CHAR(8) DEFAULT '0' NOT NULL,
            time INT(11) NULL DEFAULT '0',
            PRIMARY KEY (id_log))";

         $sql[] = "CREATE TABLE " . LOGS_CONFIG_TABLE . " (
            config_name varchar(255) NOT NULL,
            config_value varchar(255) NOT NULL,
            PRIMARY KEY (config_name))";

         $sql[] = "INSERT INTO " . LOGS_CONFIG_TABLE . " (
            config_name, config_value)
            VALUES ('all_admin', 0)";

         $sql[] = "ALTER TABLE " . USERS_TABLE . "
            ADD user_view_log TINYINT NOT NULL DEFAULT '0'";
         break;
      
       case 'postgresql':
         $sql[] = "CREATE TABLE " . LOGS_TABLE . " (
            id_log SERIAL NOT NULL PRIMARY KEY,
            mode VARCHAR(50) DEFAULT '',
            topic_id INT4 DEFAULT 0,
            user_id INT4 DEFAULT 0,
            username VARCHAR(255) DEFAULT '',
            user_ip CHAR(8) DEFAULT '0' NOT NULL,
            time INT4 DEFAULT 0 )";

         $sql[] = "CREATE TABLE " . LOGS_CONFIG_TABLE . " (
            config_name varchar(255) NOT NULL PRIMARY KEY,
            config_value varchar(255) NOT NULL )";

         $sql[] = "INSERT INTO " . LOGS_CONFIG_TABLE . " (
            config_name, config_value )
            VALUES ( 'all_admin', 0 )";

         $sql[] = "ALTER TABLE " . USERS_TABLE . "
            ADD user_view_log INT2 NOT NULL DEFAULT 0";
         break;

dar daca nu a mers prima, ce sa zic

[Marian96]

pai pune una odata alta odata

[megeo]

da erori