SQL ERROR [ mysqli ]

Unknown column 'topic_url' in 'field list' [1054]

SQL

INSERT INTO phpbb_3topics (topic_poster, topic_time, topic_last_view_time, forum_id, icon_id, topic_approved, topic_title, topic_url, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment, poll_title, poll_start, poll_max_options, poll_length, poll_vote_change) VALUES (2, 1249892835, 1249892835, 12, 0, 1, 'Jouez vous d\'un instrument ?', '', 'Kevin', 'FF9900', 0, 0, 0, 'Jouez vous d\'un instrument ?', 1249892835, 1, 0, 0)

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1911
CALL: dbal_mysqli->sql_query()

FILE: posting.php
LINE: 1047
CALL: submit_post()

6) Rendez vous sur votresite.com/phpBB/phpbb_seo/phpbb_seo_install.php et suivez les instruction d'installation.

Synchronisation des URLs

Vous devez activer le stockage d’URLs dans la base de données pour utiliser ce script!

Code: Tout sélectionner

ALTER TABLE `phpbb_3topics` ADD `topic_url` VARCHAR( 255 ) NOT NULL DEFAULT ''

MathieuM. a écrit:C'est que tu n'utilises pas l'option SQL Rewriting, autant pour moi alors

Exécute cette requête SQL :

Code: Tout sélectionner

ALTER TABLE `phpbb_3topics` ADD `topic_url` VARCHAR( 255 ) NOT NULL DEFAULT ''

Mathieu.

Code: Tout sélectionner

# Lines That should already be in your .htacess
<Files "config.php">
Order Allow,Deny
Deny from All
</Files>
<Files "common.php">
Order Allow,Deny
Deny from All
</Files>

# You may need to un-comment the following lines
# Options +FollowSymlinks
# To make sure that rewritten dir or file (/|.html) will not load dir.php in case it exist
# Options -MultiViews
# REMEBER YOU ONLY NEED TO STARD MOD REWRITE ONCE
RewriteEngine On
# REWRITE BASE
RewriteBase /
# HERE IS A GOOD PLACE TO FORCE CANONICAL DOMAIN
# RewriteCond %{HTTP_HOST} !^clicparty\.fr$ [NC]
# RewriteRule ^(.*)$ http://clicparty.fr/$1 [QSA,L,R=301]

# DO NOT GO FURTHER IF THE REQUESTED FILE / DIR DOES EXISTS
RewriteCond %{REQUEST_FILENAME} -f
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule . - [L]
#####################################################
# PHPBB SEO REWRITE RULES ALL MODES
#####################################################
# AUTHOR : dcz http://www.phpbb-seo.com
# STARTED : 01/2006
#################################
# FORUMS PAGES
###############
# FORUM INDEX REWRITERULE WOULD STAND HERE IF USED. "forum" REQUIRES TO BE SET AS FORUM INDEX
# RewriteRule ^forums/forum\.html$ /forums/index.php [QSA,L,NC]
# FORUM ALL MODES
RewriteRule ^forums/(forum|[a-z0-9_-]*-f)([0-9]+)(-([0-9]+))?\.html$ /forums/viewforum.php?f=$2&start=$4 [QSA,L,NC]
# TOPIC WITH VIRTUAL FOLDER ALL MODES
RewriteRule ^forums/(forum|[a-z0-9_-]*-f)([0-9]+)/(topic|[a-z0-9_-]*-t)([0-9]+)(-([0-9]+))?\.html$ /forums/viewtopic.php?f=$2&t=$4&start=$6 [QSA,L,NC]
# GLOBAL ANNOUNCES WITH VIRTUAL FOLDER ALL MODES
RewriteRule ^forums/annonces/(topic|[a-z0-9_-]*-t)([0-9]+)(-([0-9]+))?\.html$ /forums/viewtopic.php?t=$2&start=$4 [QSA,L,NC]
# TOPIC WITHOUT FORUM ID & DELIM ALL MODES
RewriteRule ^forums/([a-z0-9_-]*)/?(topic|[a-z0-9_-]*-t)([0-9]+)(-([0-9]+))?\.html$ /forums/viewtopic.php?forum_uri=$1&t=$3&start=$5 [QSA,L,NC]
# PHPBB FILES ALL MODES
RewriteRule ^forums/ressources/[a-z0-9_-]+/(thumb/)?([0-9]+)$ /forums/download/file.php?id=$2&t=$1 [QSA,L,NC]
# PROFILES THROUGH USERNAME
RewriteRule ^forums/membre/([^/]+)/?$ /forums/memberlist.php?mode=viewprofile&un=$1 [QSA,L,NC]
# USER MESSAGES THROUGH USERNAME
RewriteRule ^forums/membre/([^/]+)/(topics|posts)/?(page([0-9]+)\.html)?$ /forums/search.php?author=$1&sr=$2&start=$4 [QSA,L,NC]
# GROUPS ALL MODES
RewriteRule ^forums/(groupe|[a-z0-9_-]*-g)([0-9]+)(-([0-9]+))?\.html$ /forums/memberlist.php?mode=group&g=$2&start=$4 [QSA,L,NC]
# POST
RewriteRule ^forums/post([0-9]+)\.html$ /forums/viewtopic.php?p=$1 [QSA,L,NC]
# ACTIVE TOPICS
RewriteRule ^forums/sujets-actifs(-([0-9]+))?\.html$ /forums/search.php?search_id=active_topics&start=$2&sr=topics [QSA,L,NC]
# UNANSWERED TOPICS
RewriteRule ^forums/sans-reponses(-([0-9]+))?\.html$ /forums/search.php?search_id=unanswered&start=$2&sr=topics [QSA,L,NC]
# NEW POSTS
RewriteRule ^forums/nouveaux-messages(-([0-9]+))?\.html$ /forums/search.php?search_id=newposts&start=$2&sr=topics [QSA,L,NC]
# THE TEAM
RewriteRule ^forums/equipe\.html$ /forums/memberlist.php?mode=leaders [QSA,L,NC]
# HERE IS A GOOD PLACE TO ADD OTHER PHPBB RELATED REWRITERULES

# FORUM WITHOUT ID & DELIM ALL MODES (SAME DELIM)
# THESE FOUR LINES MUST BE LOCATED AT THE END OF YOUR HTACCESS TO WORK PROPERLY
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^forums/([a-z0-9_-]+)(-([0-9]+))\.html$ /forums/viewforum.php?forum_uri=$1&start=$3 [QSA,L,NC]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^forums/([a-z0-9_-]+)\.html$ /forums/viewforum.php?forum_uri=$1 [QSA,L,NC]
# END PHPBB PAGES
#####################################################