Portal phpbb rewrité/errors?

WRInaute discret
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
 
WRInaute impliqué
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.
 
WRInaute discret
cleden a dit:
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à
 
Discussions similaires
Haut