portal phpbb rewrité/errors?!

Consultez la formation URL Rewriting et sites dynamiques de WebRankInfo / Ranking Metrics


dyzon
WRInaute discret
WRInaute discret
 
Messages: 144
Inscription: 31 Jan 2006

portal phpbb rewrité/errors?!

Message le Mar Avr 11, 2006 23:48

phpBB : Critical Error

Could not query portal auth information

DEBUG MODE

SQL Error : 1052 Champ: 'user_pending' dans where clause est ambigu

SELECT ap.* FROM AUTH_PORTAL_TABLE ap LEFT JOIN phpbb_user_group ug ON ap.group_id=ug.group_id WHERE user_pending = 0 AND ug.user_id = -1 AND ap.auth_view=1;

Line : 162
File : portal.php

le fichier AUTH_PORTAL_TABLE
`user_pending` varchar (255) NOT NULL default '0',
`ap.auth_view` varchar (255) NOT NULL default '1',
` ug.user_id` varchar (255) NOT NULL default '-1',
mon fichier install portal:
CREATE TABLE phpbb_portal (
portal_name varchar(255) NOT NULL default '',
portal_value varchar(255) NOT NULL default '',
PRIMARY KEY (portal_name)
);

CREATE TABLE phpbb_portal_links (
link_id mediumint(8) NOT NULL auto_increment,
link_url varchar(100) NOT NULL default '',
link_text varchar(100) NOT NULL default '',
link_img varchar(100) NOT NULL default '',
link_imgwidth varchar(4) NOT NULL default '',
link_imgheight varchar(4) NOT NULL default '',
link_active tinyint(1) NOT NULL default '0',
UNIQUE KEY link_id (link_id)
);

CREATE TABLE phpbb_portal_mod (
mod_id mediumint(11) NOT NULL auto_increment,
mod_name varchar(100) NOT NULL default '',
mod_auth tinyint(1) unsigned NOT NULL default '0',
mod_type tinyint(1) NOT NULL default '0',
mod_table tinyint(1) NOT NULL default '0',
mod_title varchar(100) NOT NULL default '',
mod_source text NOT NULL,
KEY mod_id (mod_id)
);

CREATE TABLE phpbb_portal_page(
page_id MEDIUMINT(8) NOT NULL AUTO_INCREMENT,
page_desc VARCHAR(100) NOT NULL,
page_defaultsize TINYINT(1) NOT NULL DEFAULT '1',
page_col1width VARCHAR(10) NOT NULL,
page_col1unit VARCHAR(10) NOT NULL,
page_col2width VARCHAR(10) NOT NULL,
page_col2unit VARCHAR(10) NOT NULL,
page_col3width VARCHAR(10) NOT NULL,
page_col3unit VARCHAR(10) NOT NULL,
display_header TINYINT(1) NOT NULL default '-1',
KEY page_id (page_id)
);

CREATE TABLE phpbb_portal_struct (
struct_id mediumint(11) NOT NULL auto_increment,
page_id mediumint(8) NOT NULL default '0',
mod_id mediumint(11) NOT NULL default '0',
struct_col tinyint(1) NOT NULL default '0',
struct_order mediumint(8) NOT NULL default '0',
KEY struct_id (struct_id)
);

CREATE TABLE phpbb_portal_welcome (
welcome_msg text NOT NULL,
bbcode_uid varchar(10) NOT NULL default ''
);

CREATE TABLE `phpbb_auth_portal` (
`group_id` mediumint(9) NOT NULL default '0',
`mod_id` mediumint(9) NOT NULL default '0',
`auth_view` tinyint(1) NOT NULL default '0'
);

CREATE TABLE phpbb_portal_navig (
navlig_id mediumint(8) NOT NULL auto_increment,
navlig_type tinyint(1) NOT NULL default '0',
navlig_langkey varchar(50) NOT NULL default '',
navlig_texte varchar(100) NOT NULL default '',
navlig_url varchar(100) NOT NULL default '',
navlig_script varchar(100) NOT NULL default '',
navlig_icone tinyint(1) NOT NULL default '0',
navlig_imgkey varchar(50) NOT NULL default '',
navlig_iconeimg varchar(100) NOT NULL default '',
navlig_iconesize int(3) NOT NULL default '0',
navlig_order tinyint(1) NOT NULL default '0',
navlig_tab tinyint(1) NOT NULL default '0',
navlig_tabsize int(3) NOT NULL default '0',
navlig_auth tinyint(1) NOT NULL default '0',
menu_id mediumint(8) NOT NULL default '0',
navlig_cars varchar(10) NOT NULL default '',
PRIMARY KEY (navlig_id)
) TYPE=MyISAM;


CREATE TABLE phpbb_portal_navmen (
menu_id mediumint(8) NOT NULL auto_increment,
menu_desc varchar(100) NOT NULL default '',
PRIMARY KEY (menu_id)
) TYPE=MyISAM;


CREATE TABLE phpbb_portal_pagmen (
page_id mediumint(8) NOT NULL default '0',
menu_id mediumint(8) NOT NULL default '0',
UNIQUE KEY page_id (page_id)
) TYPE=MyISAM;

INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('welcome_text', 'Bienvenue sur la version de portail : <b>Gf-Portail</b>.<br/>Vous pouvez changer ce message dans la configuration générale du portail.<br/>Ce portail est entièrement <b>paramétrable</b> depuis l\'ACP.<br/>J\'espère qu\'il vous plaîra.<br/><i>Giefca</i>');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('number_of_news', '4');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('news_length', '200');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('news_forum', '1');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('poll_id', '');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('forum_header', '1');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('space_row', '3');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('space_col', '1');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('col1_size', '20');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('col1_unit', 'percent');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('col2_size', '60');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('col2_unit', 'percent');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('col3_size', '20');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('col3_unit', 'percent');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('bodyline', '1');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('head_out_bodyline', '0');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('foot_out_bodyline', '0');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('guest_avatar', '1');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('simple_welcome', '1');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('number_recent_topics', '10');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('scrolling_topics', '1');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('scroll_height', '200');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('scroll_up', '1');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('scroll_delay', '100');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('scroll_step', '2');
INSERT INTO phpbb_portal (portal_name, portal_value) VALUES ('default_struct', '1') ;

INSERT INTO phpbb_portal_links ( link_url, link_text, link_img, link_active ) VALUES ('http://www.phpbb.com', 'phpBB community', 'images/banner_phpbbcom.gif', 1);

INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'bienvenue');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'liens');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'login');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'menu');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'news');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'sondage');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'statistiques');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'welcome');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'whoisonline');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'entete');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'change_style');
INSERT INTO phpbb_portal_mod ( mod_name ) VALUES ( 'recent_topics');

INSERT INTO phpbb_portal_page (page_id, page_desc) VALUES(1, 'page principale');

INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 1, 2, 1);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 2, 1, 2);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 3, 3, 2);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 4, 1, 1);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 5, 2, 2);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 6, 1, 4);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 7, 1, 3);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 8, 3, 1);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 9, 3, 9);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 10, 0, 1);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 11, 1, 5);
INSERT INTO phpbb_portal_struct ( page_id, mod_id, struct_col, struct_order) VALUES ( 1, 12, 3, 8);

INSERT INTO phpbb_portal ( portal_name , portal_value ) VALUES ('default_mennav', '1');
INSERT INTO phpbb_portal_navmen ( menu_id , menu_desc ) VALUES (1, 'Menu principal');
INSERT INTO `phpbb_portal_navig` VALUES (1, 4, 'Home', '', 'portal.php', '', 1, 'icon_mini_house', '', 0, 1, 0, 0, 0, 1, '');
INSERT INTO `phpbb_portal_navig` VALUES (2, 4, 'FAQ', '', 'faq.php', '', 1, 'icon_mini_faq', '', 0, 4, 0, 0, 0, 1, '');
INSERT INTO `phpbb_portal_navig` VALUES (3, 4, 'Forum', '', 'index.php', '', 1, 'icon_mini_house', '', 0, 2, 0, 0, 0, 1, '');
INSERT INTO `phpbb_portal_navig` VALUES (4, 4, 'Search', '', 'search.php', '', 1, 'icon_mini_search', '', 0, 3, 0, 0, 0, 1, '');
INSERT INTO `phpbb_portal_navig` VALUES (5, 4, 'Memberlist', '', 'memberlist.php', '', 1, 'icon_mini_members', '', 0, 5, 0, 0, 0, 1, '');
INSERT INTO `phpbb_portal_navig` VALUES (6, 4, 'Usergroups', '', 'groupcp.php', '', 1, 'icon_mini_groups', '', 0, 6, 0, 0, 0, 1, '');
INSERT INTO `phpbb_portal_navig` VALUES (7, 4, 'Private_Messaging', '', 'privmsgs.php', '', 1, 'icon_mini_message', '', 0, 8, 0, 0, 1, 1, '');
INSERT INTO `phpbb_portal_navig` VALUES (8, 4, 'Profile', '', 'profile.php', '', 1, 'icon_mini_profile', '', 0, 7, 0, 0, 1, 1, '');
INSERT INTO `phpbb_portal_navig` VALUES (9, 4, 'Login', '', 'login.php', '', 1, 'icon_mini_login', '', 0, 9, 0, 0, -1, 1, '');
INSERT INTO `phpbb_portal_navig` VALUES (10, 4, 'Logout', '', 'login.php?logout=true', '', 1, 'icon_mini_login', '', 0, 10, 0, 0, 1, 1, '');

tout le prob est localisé au niveau de la bdd, j'ai fait du rewrite sur un phpbb2 et installé le mod portal après gfportail-v1.2.0c
voici le résultat catstrophique:
***//melcfrance.keogratuit.com/forum/portal.php
***//melcfrance.keogratuit.com/forum/index.php
help s'il vous plaît


cleden
WRInaute passionné
WRInaute passionné
 
Messages: 1194
Inscription: 6 Jan 2003

Message le Mer Avr 12, 2006 0:00

Bonjour,

J'en profite pour rajouter ma liste de courses:

Ail
Asperges
Aubergines
Betteraves
Bouquet garni
Brocolis
Carottes
Céleris
Champignons
Chou-fleur
Choux de Bruxelles
Chaise
Concombres
Courgettes
Corde
Echalotes
Endives
Haricots blancs
Haricots verts
Herbes (thym, laurier, basilic...)
Navets
Oignons
Persil
Poireaux
Poivrons
Pommes de terre
Radis
Salade
Tomates

Si quelqu'un a ça, qu'il me contacte en MP :wink:

Merci d'avance,
Loïc.


dyzon
WRInaute discret
WRInaute discret
 
Messages: 144
Inscription: 31 Jan 2006

Message le Mer Avr 12, 2006 8:56

cleden a écrit:Bonjour,

J'en profite pour rajouter ma liste de courses:

Ail
Asperges
Aubergines
Betteraves
Bouquet garni
Brocolis
Carottes
Céleris
Champignons
Chou-fleur
Choux de Bruxelles
Chaise
Concombres
Courgettes
Corde
Echalotes
Endives
Haricots blancs
Haricots verts
Herbes (thym, laurier, basilic...)
Navets
Oignons
Persil
Poireaux
Poivrons
Pommes de terre
Radis
Salade
Tomates

Si quelqu'un a ça, qu'il me contacte en MP :wink:

Merci d'avance,
Loïc.

c'est vraiment pas sympa, autant éviter de répondre dans ces cas là


Si vous avez aimé cette discussion, partagez-la sur vos réseaux sociaux préférés :

Formation recommandée sur ce thème :

Formation URL Rewriting et sites dynamiques : apprenez comment mettre en place la réécriture d'URL, comment optimiser vos URL et profiter de vos pages dynamiques pour booster votre référencement. Formation animée par Olivier Duffez et Fabien Facériès, experts en référencement naturel.

Tous les détails sur le site Ranking Metrics : programme, prix, dates et lieux, inscription en ligne.

Lectures recommandées sur ce thème :



Qui est en ligne

Utilisateurs parcourant ce forum: Aucun utilisateur enregistré et 0 invités