probleme avec recherche [Réglé]
message erreur fatal sur recherche en haut de la page accueil
Support Général
patgame Membre non connecté
-
Booster Missile
- Voir le profil du membre patgame
- Inscrit le : 03/09/2009
- Site internet
- Groupes :
rreur fatale : invalid while request
(SELECT
85 AS id_search,
a.id AS id_content,
a.title AS title,
( 2 * MATCH(a.title) AGAINST('Boosté') + MATCH(a.contents) AGAINST('Boosté') ) / 3 * 1 AS relevance, CONCAT(CONCAT(CONCAT('../articles/articles.php?id=',a.id),'&cat='),a.idcat) AS link
FROM phpboost_articles a
LEFT JOIN phpboost_articles_cats ac ON ac.id = a.idcat
WHERE
a.visible = 1 AND ((ac.aprob = 1 AND ac.auth LIKE '%s:3:"r-1";i:1;%') OR a.idcat = 0)
AND (MATCH(a.title) AGAINST('Boosté') OR MATCH(a.contents) AGAINST('Boosté'))
ORDER BY relevance DESC LIMIT 0, 10) UNION (SELECT 86 AS id_search,
d.id AS id_content,
d.title AS title,
( 3 * MATCH(d.title) AGAINST('Boosté') + 2 * MATCH(d.short_contents) AGAINST('Boosté') + MATCH(d.contents) AGAINST('Boosté') ) / 6 * 1 AS relevance, CONCAT('../download/download.php?id=',d.id) AS link
FROM phpboost_download d
WHERE ( MATCH(d.title) AGAINST('Boosté') OR MATCH(d.short_contents) AGAINST('Boosté') OR MATCH(d.contents) AGAINST('Boosté') ) AND d.idcat IN (2,3) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 87 AS id_search,
f.id AS id_content,
f.question AS title,
( 2 * MATCH(f.question) AGAINST('Boosté') + MATCH(f.answer) AGAINST('Boosté') ) / 3 * 1 AS relevance, CONCAT(CONCAT(CONCAT(CONCAT(CONCAT('../faq/faq.php?id=',f.idcat),'&question='),f.id),'#q'),f.id) AS link
FROM phpboost_faq f
WHERE ( MATCH(f.question) AGAINST('Boosté') OR MATCH(f.answer) AGAINST('Boosté') ) AND f.idcat IN (1,2) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 88 AS `id_search`,
msg.id AS `id_content`,
t.title AS `title`,
MATCH(t.title) AGAINST('Boosté') * 1 AS `relevance`,
CONCAT(CONCAT(CONCAT(CONCAT('..','/forum/topic.php?id='),t.id),'#m'),msg.id) AS `link`
FROM phpboost_forum_msg msg
JOIN phpboost_forum_topics t ON t.id = msg.idtopic
JOIN phpboost_forum_cats c ON c.level != 0 AND c.aprob = 1 AND c.id = t.idcat
WHERE MATCH(t.title) AGAINST('Boosté')
GROUP BY t.id
ORDER BY relevance DESC LIMIT 0, 50) UNION (SELECT 89 AS id_search,
f.id AS id_content,
f.name AS title,
( 2 * MATCH(f.name) AGAINST('Boosté') + MATCH(f.contents) AGAINST('Boosté') ) / 3 * 1 AS relevance, CONCAT(CONCAT(CONCAT('../media/media.php?id=',f.id),'&cat='),f.idcat) AS link
FROM phpboost_media f
WHERE ( MATCH(f.name) AGAINST('Boosté') OR MATCH(f.contents) AGAINST('Boosté') ) AND f.idcat IN (3,5) ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 90 AS id_search,
n.id AS id_content,
n.title AS title,
( 2 * MATCH(n.title) AGAINST('Boosté') + (MATCH(n.contents) AGAINST('Boosté') + MATCH(n.extend_contents) AGAINST('Boosté')) / 2 ) / 3 * 1 AS relevance, CONCAT('../news/news.php?id=',n.id) AS link
FROM phpboost_news n
WHERE ( MATCH(n.title) AGAINST('Boosté') OR MATCH(n.contents) AGAINST('Boosté') OR MATCH(n.extend_contents) AGAINST('Boosté') )
AND visible = 1 AND ('1252689758' > start AND ( end = 0 OR '1252689758' < end ) )
ORDER BY relevance DESC LIMIT 0, 100) UNION (SELECT 92 AS `id_search`,
q.id AS `id_content`,
q.author AS `title`,
( MATCH(q.contents) AGAINST('Boosté') + MATCH(q.author) AGAINST('Boosté') ) / 2 * 1 AS `relevance`,
CONCAT('../quotes/quotes.php?id=',q.id) AS `link`
FROM phpboost_quotes q
WHERE ( MATCH(q.author) AGAINST('Boosté')
OR MATCH(q.contents) AGAINST('Boosté') )) UNION (SELECT 93 AS `id_search`,
`id` AS `id_content`,
`title` AS `title`,
((MATCH(title) AGAINST('Boosté') )* 1) AS `relevance`,
CONCAT('../wiki/wiki.php?title=',encoded_title) AS `link`
FROM phpboost_wiki_articles
WHERE MATCH(title) AGAINST('Boosté'))
Illegal mix of collations for operation 'UNION'
Ligne 337 : search.class.php
Accueil » Retour
horn Membre non connecté
-
Modérateur
- Voir le profil du membre horn
- Inscrit le : 31/12/2007
- Site internet
- Groupes :
-
Equipe Historique
patgame Membre non connecté
-
Booster Missile
- Voir le profil du membre patgame
- Inscrit le : 03/09/2009
- Site internet
- Groupes :
horn :
j ai fait comme explique ds le topic que tu m'as fourni si je fais re=charche avev le mini search parfosi encore ce meme message si je fais par le module recherche ds menu general aucun resultat retourne toutes les i,terclassement sont les memes latin 1 general ci ???
merci a toi pat
horn Membre non connecté
-
Modérateur
- Voir le profil du membre horn
- Inscrit le : 31/12/2007
- Site internet
- Groupes :
-
Equipe Historique
Colle moi le résultats des deux requêtes listant les collations pour les tables et les champs (comme dans l'autre topic), je regarderai.
PS : quand tu écris, relis toi un peu, les accents (si t'en as sur ton clavier), les apostrophes ça existent, un correcteur orthographique, ça peut aider pour "i,terclassement" et "re=charche", "avev", ...
patgame Membre non connecté
-
Booster Missile
- Voir le profil du membre patgame
- Inscrit le : 03/09/2009
- Site internet
- Groupes :
Édité par patgame Le 12/09/2009 à 20h39
horn Membre non connecté
-
Modérateur
- Voir le profil du membre horn
- Inscrit le : 31/12/2007
- Site internet
- Groupes :
-
Equipe Historique
Code SQL :
et SELECT TABLE_NAME, table_collation FROM information_schema.TABLES WHERE TABLE_NAME LIKE 'phpboost_%';
Code SQL :
SELECT TABLE_NAME, column_name, column_type, collation_name, character_set_name FROM information_schema.COLUMNS WHERE TABLE_NAME LIKE 'phpboost_%' AND collation_name != ''
Colle moi les résultats ici.
patgame Membre non connecté
-
Booster Missile
- Voir le profil du membre patgame
- Inscrit le : 03/09/2009
- Site internet
- Groupes :
horn :
Pour vérifier ça
Colle moi les résultats ici.
Code SQL :
et SELECT TABLE_NAME, table_collation FROM information_schema.TABLES WHERE TABLE_NAME LIKE 'phpboost_%';
Code SQL :
SELECT TABLE_NAME, column_name, column_type, collation_name, character_set_name FROM information_schema.COLUMNS WHERE TABLE_NAME LIKE 'phpboost_%' AND collation_name != ''
Colle moi les résultats ici.
resultats:
[/pre] [/pre]
| able_name | table_collation |
| phpboost_articles | latin1_general_ci |
| phpboost_articles_cats | latin1_general_ci |
| phpboost_calendar | latin1_general_ci |
| phpboost_com | latin1_general_ci |
| phpboost_configs | latin1_general_ci |
| phpboost_download | latin1_general_ci |
| phpboost_download_cat | latin1_general_ci |
| phpboost_events | latin1_general_ci |
| phpboost_faq | latin1_german2_ci |
| phpboost_faq_cats | latin1_general_ci |
| phpboost_forum_alerts | latin1_general_ci |
| phpboost_forum_cats | latin1_general_ci |
| phpboost_forum_history | latin1_general_ci |
| phpboost_forum_msg | latin1_general_ci |
| phpboost_forum_poll | latin1_general_ci |
| phpboost_forum_topics | latin1_general_ci |
| phpboost_forum_track | latin1_general_ci |
| phpboost_forum_view | latin1_general_ci |
| phpboost_gallery | latin1_general_ci |
| phpboost_gallery_cats | latin1_general_ci |
| phpboost_group | latin1_general_ci |
| phpboost_guestbook | latin1_general_ci |
| phpboost_lang | latin1_general_ci |
| phpboost_media | latin1_general_ci |
| phpboost_media_cat | latin1_general_ci |
| phpboost_member | latin1_general_ci |
| phpboost_member_extend | latin1_general_ci |
| phpboost_member_extend_cat | latin1_general_ci |
| phpboost_menus | latin1_general_ci |
| phpboost_modules | latin1_general_ci |
| phpboost_news | latin1_general_ci |
| phpboost_news_cat | latin1_general_ci |
| phpboost_newsletter | latin1_general_ci |
| phpboost_newsletter_arch | latin1_general_ci |
| phpboost_pages | latin1_general_ci |
| phpboost_pages_cats | latin1_general_ci |
| phpboost_pm_msg | latin1_general_ci |
| phpboost_pm_topic | latin1_general_ci |
| phpboost_poll | latin1_general_ci |
| phpboost_poll_ip | latin1_general_ci |
| phpboost_quotes | latin1_general_ci |
| phpboost_ranks | latin1_general_ci |
| phpboost_search_index | latin1_general_ci |
| phpboost_search_results | latin1_general_ci |
| phpboost_sessions | latin1_general_ci |
| phpboost_shoutbox | latin1_general_ci |
| phpboost_smileys | latin1_general_ci |
| phpboost_stats | latin1_general_ci |
| phpboost_stats_referer | latin1_general_ci |
| phpboost_themes | latin1_general_ci |
| phpboost_upload | latin1_general_ci |
| phpboost_upload_cat | latin1_general_ci |
| phpboost_verif_code | latin1_general_ci |
| phpboost_visit_counter | latin1_general_ci |
| phpboost_web | latin1_general_ci |
| phpboost_web_cat | latin1_general_ci |
| phpboost_wiki_articles | latin1_general_ci |
| phpboost_wiki_cats | latin1_general_ci |
| phpboost_wiki_contents | latin1_general_ci |
| phpboost_wiki_favorites | latin1_general_ci |
| table_name | column_name | column_type | collation_name | character_set_name |
| phpboost_articles | title | varchar(100) | latin1_general_ci | latin1 |
| phpboost_articles | contents | mediumtext | latin1_general_ci | latin1 |
| phpboost_articles | icon | varchar(255) | latin1_general_ci | latin1 |
| phpboost_articles | users_note | text | latin1_general_ci | latin1 |
| phpboost_articles_cats | name | varchar(100) | latin1_general_ci | latin1 |
| phpboost_articles_cats | contents | text | latin1_general_ci | latin1 |
| phpboost_articles_cats | icon | varchar(255) | latin1_general_ci | latin1 |
| phpboost_articles_cats | auth | text | latin1_general_ci | latin1 |
| phpboost_calendar | title | varchar(150) | latin1_general_ci | latin1 |
| phpboost_calendar | contents | text | latin1_general_ci | latin1 |
| phpboost_com | login | varchar(255) | latin1_general_ci | latin1 |
| phpboost_com | contents | text | latin1_general_ci | latin1 |
| phpboost_com | script | varchar(20) | latin1_general_ci | latin1 |
| phpboost_com | path | varchar(255) | latin1_general_ci | latin1 |
| phpboost_com | user_ip | varchar(50) | latin1_general_ci | latin1 |
| phpboost_configs | name | varchar(150) | latin1_general_ci | latin1 |
| phpboost_configs | value | text | latin1_general_ci | latin1 |
| phpboost_download | title | varchar(100) | latin1_general_ci | latin1 |
| phpboost_download | short_contents | text | latin1_general_ci | latin1 |
| phpboost_download | contents | text | latin1_general_ci | latin1 |
| phpboost_download | url | text | latin1_general_ci | latin1 |
| phpboost_download | image | varchar(255) | latin1_general_ci | latin1 |
| phpboost_download | users_note | text | latin1_general_ci | latin1 |
| phpboost_download_cat | name | varchar(150) | latin1_general_ci | latin1 |
| phpboost_download_cat | contents | text | latin1_general_ci | latin1 |
| phpboost_download_cat | icon | varchar(255) | latin1_general_ci | latin1 |
| phpboost_download_cat | auth | text | latin1_general_ci | latin1 |
| phpboost_events | entitled | varchar(255) | latin1_general_ci | latin1 |
| phpboost_events | description | text | latin1_general_ci | latin1 |
| phpboost_events | fixing_url | varchar(255) | latin1_general_ci | latin1 |
| phpboost_events | module | varchar(100) | latin1_general_ci | latin1 |
| phpboost_events | auth | text | latin1_general_ci | latin1 |
| phpboost_events | identifier | varchar(64) | latin1_general_ci | latin1 |
| phpboost_events | type | varchar(64) | latin1_general_ci | latin1 |
| phpboost_faq | question | varchar(255) | latin1_german2_ci | latin1 |
| phpboost_faq | answer | text | latin1_german2_ci | latin1 |
| phpboost_faq_cats | auth | text | latin1_general_ci | latin1 |
| phpboost_faq_cats | name | varchar(255) | latin1_general_ci | latin1 |
| phpboost_faq_cats | description | text | latin1_general_ci | latin1 |
| phpboost_faq_cats | image | varchar(255) | latin1_general_ci | latin1 |
| phpboost_forum_alerts | title | varchar(255) | latin1_general_ci | latin1 |
| phpboost_forum_alerts | contents | text | latin1_general_ci | latin1 |
| phpboost_forum_cats | name | varchar(100) | latin1_general_ci | latin1 |
| phpboost_forum_cats | subname | varchar(150) | latin1_general_ci | latin1 |
| phpboost_forum_cats | auth | text | latin1_general_ci | latin1 |
| phpboost_forum_cats | url | varchar(255) | latin1_general_ci | latin1 |
| phpboost_forum_history | action | varchar(50) | latin1_general_ci | latin1 |
| phpboost_forum_history | url | varchar(255) | latin1_general_ci | latin1 |
| phpboost_forum_msg | contents | text | latin1_general_ci | latin1 |
| phpboost_forum_msg | user_ip | varchar(50) | latin1_general_ci | latin1 |
| phpboost_forum_poll | question | varchar(255) | latin1_general_ci | latin1 |
| phpboost_forum_poll | answers | text | latin1_general_ci | latin1 |
| phpboost_forum_poll | voter_id | text | latin1_general_ci | latin1 |
| phpboost_forum_poll | votes | text | latin1_general_ci | latin1 |
| phpboost_forum_topics | title | varchar(100) | latin1_general_ci | latin1 |
| phpboost_forum_topics | subtitle | varchar(75) | latin1_general_ci | latin1 |
| phpboost_gallery | name | varchar(255) | latin1_general_ci | latin1 |
| phpboost_gallery | path | varchar(255) | latin1_general_ci | latin1 |
| phpboost_gallery | users_note | text | latin1_general_ci | latin1 |
| phpboost_gallery_cats | name | varchar(150) | latin1_general_ci | latin1 |
| phpboost_gallery_cats | contents | text | latin1_general_ci | latin1 |
| phpboost_gallery_cats | auth | text | latin1_general_ci | latin1 |
| phpboost_group | name | varchar(100) | latin1_general_ci | latin1 |
| phpboost_group | img | varchar(255) | latin1_general_ci | latin1 |
| phpboost_group | color | varchar(6) | latin1_general_ci | latin1 |
| phpboost_group | auth | varchar(255) | latin1_general_ci | latin1 |
| phpboost_group | members | text | latin1_general_ci | latin1 |
| phpboost_guestbook | contents | text | latin1_general_ci | latin1 |
| phpboost_guestbook | login | varchar(255) | latin1_general_ci | latin1 |
| phpboost_lang | lang | varchar(150) | latin1_general_ci | latin1 |
| phpboost_media | name | varchar(255) | latin1_general_ci | latin1 |
| phpboost_media | contents | text | latin1_general_ci | latin1 |
| phpboost_media | url | text | latin1_general_ci | latin1 |
| phpboost_media | mime_type | varchar(255) | latin1_general_ci | latin1 |
| phpboost_media | users_note | text | latin1_general_ci | latin1 |
| phpboost_media_cat | auth | text | latin1_general_ci | latin1 |
| phpboost_media_cat | name | varchar(255) | latin1_general_ci | latin1 |
| phpboost_media_cat | description | text | latin1_general_ci | latin1 |
| phpboost_media_cat | image | varchar(255) | latin1_general_ci | latin1 |
| phpboost_member | login | varchar(255) | latin1_general_ci | latin1 |
| phpboost_member | password | varchar(64) | latin1_general_ci | latin1 |
| phpboost_member | user_groups | text | latin1_general_ci | latin1 |
| phpboost_member | user_lang | varchar(25) | latin1_general_ci | latin1 |
| phpboost_member | user_theme | varchar(50) | latin1_general_ci | latin1 |
| phpboost_member | user_mail | varchar(50) | latin1_general_ci | latin1 |
| phpboost_member | user_editor | varchar(15) | latin1_general_ci | latin1 |
| phpboost_member | user_avatar | varchar(255) | latin1_general_ci | latin1 |
| phpboost_member | user_local | varchar(50) | latin1_general_ci | latin1 |
| phpboost_member | user_msn | varchar(50) | latin1_general_ci | latin1 |
| phpboost_member | user_yahoo | varchar(50) | latin1_general_ci | latin1 |
| phpboost_member | user_web | varchar(70) | latin1_general_ci | latin1 |
| phpboost_member | user_occupation | varchar(50) | latin1_general_ci | latin1 |
| phpboost_member | user_hobbies | varchar(50) | latin1_general_ci | latin1 |
| phpboost_member | user_desc | text | latin1_general_ci | latin1 |
| phpboost_member | user_sign | text | latin1_general_ci | latin1 |
| phpboost_member | activ_pass | varchar(30) | latin1_general_ci | latin1 |
| phpboost_member | new_pass | varchar(64) | latin1_general_ci | latin1 |
| phpboost_member_extend_cat | name | varchar(255) | latin1_general_ci | latin1 |
| phpboost_member_extend_cat | field_name | varchar(255) | latin1_general_ci | latin1 |
| phpboost_member_extend_cat | contents | text | latin1_general_ci | latin1 |
| phpboost_member_extend_cat | possible_values | text | latin1_general_ci | latin1 |
| phpboost_member_extend_cat | default_values | text | latin1_general_ci | latin1 |
| phpboost_member_extend_cat | regex | varchar(255) | latin1_general_ci | latin1 |
| phpboost_menus | title | varchar(128) | latin1_general_ci | latin1 |
| phpboost_menus | object | text | latin1_general_ci | latin1 |
| phpboost_menus | class | varchar(64) | latin1_general_ci | latin1 |
| phpboost_modules | name | varchar(150) | latin1_general_ci | latin1 |
| phpboost_modules | version | varchar(15) | latin1_general_ci | latin1 |
| phpboost_modules | auth | text | latin1_general_ci | latin1 |
| phpboost_news | title | varchar(100) | latin1_general_ci | latin1 |
| phpboost_news | contents | mediumtext | latin1_general_ci | latin1 |
| phpboost_news | extend_contents | mediumtext | latin1_general_ci | latin1 |
| phpboost_news | img | varchar(255) | latin1_general_ci | latin1 |
| phpboost_news | alt | varchar(255) | latin1_general_ci | latin1 |
| phpboost_news_cat | name | varchar(150) | latin1_general_ci | latin1 |
| phpboost_news_cat | contents | text | latin1_general_ci | latin1 |
| phpboost_news_cat | icon | varchar(255) | latin1_general_ci | latin1 |
| phpboost_newsletter | varchar(50) | latin1_general_ci | latin1 | |
| phpboost_newsletter_arch | title | varchar(200) | latin1_general_ci | latin1 |
| phpboost_newsletter_arch | message | text | latin1_general_ci | latin1 |
| phpboost_newsletter_arch | type | varchar(10) | latin1_general_ci | latin1 |
| phpboost_pages | title | varchar(255) | latin1_german2_ci | latin1 |
| phpboost_pages | encoded_title | varchar(255) | latin1_general_ci | latin1 |
| phpboost_pages | contents | mediumtext | latin1_german2_ci | latin1 |
| phpboost_pages | auth | text | latin1_general_ci | latin1 |
| phpboost_pm_msg | contents | text | latin1_general_ci | latin1 |
| phpboost_pm_topic | title | varchar(150) | latin1_general_ci | latin1 |
| phpboost_poll | question | varchar(255) | latin1_general_ci | latin1 |
| phpboost_poll | answers | text | latin1_general_ci | latin1 |
| phpboost_poll | votes | text | latin1_general_ci | latin1 |
| phpboost_poll_ip | ip | varchar(50) | latin1_general_ci | latin1 |
| phpboost_quotes | contents | varchar(255) | latin1_general_ci | latin1 |
| phpboost_quotes | author | varchar(63) | latin1_general_ci | latin1 |
| phpboost_ranks | name | varchar(150) | latin1_general_ci | latin1 |
| phpboost_ranks | icon | varchar(255) | latin1_general_ci | latin1 |
| phpboost_search_index | module | varchar(64) | latin1_general_ci | latin1 |
| phpboost_search_index | search | varchar(50) | latin1_general_ci | latin1 |
| phpboost_search_index | options | varchar(50) | latin1_general_ci | latin1 |
| phpboost_search_results | title | varchar(255) | latin1_general_ci | latin1 |
| phpboost_search_results | link | varchar(255) | latin1_general_ci | latin1 |
| phpboost_sessions | session_id | varchar(64) | latin1_general_ci | latin1 |
| phpboost_sessions | session_ip | varchar(50) | latin1_general_ci | latin1 |
| phpboost_sessions | session_script | varchar(100) | latin1_general_ci | latin1 |
| phpboost_sessions | session_script_get | varchar(100) | latin1_general_ci | latin1 |
| phpboost_sessions | session_script_title | varchar(255) | latin1_general_ci | latin1 |
| phpboost_sessions | user_theme | varchar(50) | latin1_general_ci | latin1 |
| phpboost_sessions | user_lang | varchar(50) | latin1_general_ci | latin1 |
| phpboost_sessions | modules_parameters | text | latin1_general_ci | latin1 |
| phpboost_sessions | token | varchar(64) | latin1_general_ci | latin1 |
| phpboost_shoutbox | login | varchar(150) | latin1_general_ci | latin1 |
| phpboost_shoutbox | contents | text | latin1_general_ci | latin1 |
| phpboost_smileys | code_smiley | varchar(50) | latin1_general_ci | latin1 |
| phpboost_smileys | url_smiley | varchar(50) | latin1_general_ci | latin1 |
| phpboost_stats | pages_detail | text | latin1_general_ci | latin1 |
| phpboost_stats_referer | url | varchar(255) | latin1_general_ci | latin1 |
| phpboost_stats_referer | relative_url | varchar(255) | latin1_general_ci | latin1 |
| phpboost_themes | theme | varchar(50) | latin1_general_ci | latin1 |
| phpboost_upload | name | varchar(150) | latin1_general_ci | latin1 |
| phpboost_upload | path | varchar(255) | latin1_general_ci | latin1 |
| phpboost_upload | type | varchar(10) | latin1_general_ci | latin1 |
| phpboost_upload_cat | name | varchar(150) | latin1_general_ci | latin1 |
| phpboost_verif_code | user_id | varchar(15) | latin1_general_ci | latin1 |
| phpboost_verif_code | code | varchar(20) | latin1_general_ci | latin1 |
| phpboost_visit_counter | ip | varchar(50) | latin1_general_ci | latin1 |
| phpboost_web | title | varchar(100) | latin1_general_ci | latin1 |
| phpboost_web | contents | text | latin1_general_ci | latin1 |
| phpboost_web | url | text | latin1_general_ci | latin1 |
| phpboost_web | users_note | text | latin1_general_ci | latin1 |
| phpboost_web_cat | name | varchar(150) | latin1_general_ci | latin1 |
| phpboost_web_cat | contents | text | latin1_general_ci | latin1 |
| phpboost_web_cat | icon | varchar(255) | latin1_general_ci | latin1 |
| phpboost_wiki_articles | title | varchar(250) | latin1_general_ci | latin1 |
| phpboost_wiki_articles | encoded_title | varchar(250) | latin1_general_ci | latin1 |
| phpboost_wiki_articles | undefined_status | text | latin1_general_ci | latin1 |
| phpboost_wiki_articles | auth | text | latin1_general_ci | latin1 |
| phpboost_wiki_contents | menu | text | latin1_general_ci | latin1 |
| phpboost_wiki_contents | content | mediumtext | latin1_general_ci | latin1 |
| phpboost_wiki_contents | user_ip | varchar(50) | latin1_general_ci | latin1 |
Édité par patgame Le 13/09/2009 à 03h14
horn Membre non connecté
-
Modérateur
- Voir le profil du membre horn
- Inscrit le : 31/12/2007
- Site internet
- Groupes :
-
Equipe Historique
patgame Membre non connecté
-
Booster Missile
- Voir le profil du membre patgame
- Inscrit le : 03/09/2009
- Site internet
- Groupes :
horn :
ben c 'est ça peut être le problème mais quand je change et que je valide je tombe sur ce message et la je suis bloqué je sais pas faire Pour La faq et les pages il reste des collations (tables et colonnes) en latin1_german2_ci, passe les en latin1_general_ci
Erreur
requête SQL:
ALTER TABLE `phpboost_faq` CHANGE `question` `question` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
MySQL a répondu:Documentation
#1283 - Column 'answer' cannot be part of FULLTEXT index
Champ TypeDocumentation Taille/Valeurs* Interclassement Attributs Null Défaut** Extra
armscii8_binarmscii8_general_ciascii_binascii_general_cibig5_binbig5_chinese_cibinarycp1250_bincp1250_croatian_cicp1250_czech_cscp1250_general_cicp1251_bincp1251_bulgarian_cicp1251_general_cicp1251_general_cscp1251_ukrainian_cicp1256_bincp1256_general_cicp1257_bincp1257_general_cicp1257_lithuanian_cicp850_bincp850_general_cicp852_bincp852_general_cicp866_bincp866_general_cicp932_bincp932_japanese_cidec8_bindec8_swedish_cieucjpms_bineucjpms_japanese_cieuckr_bineuckr_korean_cigb2312_bingb2312_chinese_cigbk_bingbk_chinese_cigeostd8_bingeostd8_general_cigreek_bingreek_general_cihebrew_binhebrew_general_cihp8_binhp8_english_cikeybcs2_binkeybcs2_general_cikoi8r_binkoi8r_general_cikoi8u_binkoi8u_general_cilatin1_binlatin1_danish_cilatin1_general_cilatin1_general_cslatin1_german1_cilatin1_german2_cilatin1_spanish_cilatin1_swedish_cilatin2_binlatin2_croatian_cilatin2_czech_cslatin2_general_cilatin2_hungarian_cilatin5_binlatin5_turkish_cilatin7_binlatin7_estonian_cslatin7_general_cilatin7_general_csmacce_binmacce_general_cimacroman_binmacroman_general_cisjis_binsjis_japanese_ciswe7_binswe7_swedish_citis620_bintis620_thai_ciucs2_binucs2_czech_ciucs2_danish_ciucs2_esperanto_ciucs2_estonian_ciucs2_general_ciucs2_hungarian_ciucs2_icelandic_ciucs2_latvian_ciucs2_lithuanian_ciucs2_persian_ciucs2_polish_ciucs2_roman_ciucs2_romanian_ciucs2_slovak_ciucs2_slovenian_ciucs2_spanish2_ciucs2_spanish_ciucs2_swedish_ciucs2_turkish_ciucs2_unicode_ciujis_binujis_japanese_ciutf8_binutf8_czech_ciutf8_danish_ciutf8_esperanto_ciutf8_estonian_ciutf8_general_ciutf8_hungarian_ciutf8_icelandic_ciutf8_latvian_ciutf8_lithuanian_ciutf8_persian_ciutf8_polish_ciutf8_roman_ciutf8_romanian_ciutf8_slovak_ciutf8_slovenian_ciutf8_spanish2_ciutf8_spanish_ciutf8_swedish_ciutf8_turkish_ciutf8_unicode_ci
CURRENT_TIMESTAMP
mais merci a toi pas facile de conseiller les néophytes c'est très sympa
pat
jesuistêtu etil faut bien mettre les mains dans le cambouis j'essaie de comprendre parmoi même j'ai trouvé une autre erreur dans les colonnes la voici :
index: Documentation
Nom de la clé Type Cardinalité Action Champ
PRIMARY PRIMARY 19 Modifier Supprimer id
question FULLTEXT 19 Modifier Supprimer question
answer FULLTEXT 19 Modifier Supprimer answer
question_2 FULLTEXT 19 Modifier Supprimer question
answer
Warning Plus d'un index de type FULLTEXT existe pour la colonne `question`
Créer une clef sur colonne(s)
Espace utilisé:
Type Espace
Données 13 636 Octets
Index 31 744 Octets
Total 45 380 Octets
Statistiques:
Information Valeur
format dynamique
Interclassement latin1_general_ci
Enregistrements 19
Longueur enr. ø 717
Taille enr. ø 2 388 Octets
Suivant Autoindex 20
Création Dimanche 13 Septembre 2009 à 03:34
Dernière modification Dimanche 13 Septembre 2009 à 13:05
Dernière vérification Dimanche 13 Septembre 2009 à 04:54
pour la ou les réparer ces erreurs dis moi bien ce que je dois faire dans le détail trèsnouveau pour moi php et mysql
merci à toi
Édité par patgame Le 13/09/2009 à 18h51
horn Membre non connecté
-
Modérateur
- Voir le profil du membre horn
- Inscrit le : 31/12/2007
- Site internet
- Groupes :
-
Equipe Historique
patgame Membre non connecté
-
Booster Missile
- Voir le profil du membre patgame
- Inscrit le : 03/09/2009
- Site internet
- Groupes :
sinon je vire l'index comment c'est quoi l'index ?
merci à toi
Shadow Membre non connecté
-
Booster Fusée
- Voir le profil du membre Shadow
- Inscrit le : 30/12/2007
- Site internet
patgame Membre non connecté
-
Booster Missile
- Voir le profil du membre patgame
- Inscrit le : 03/09/2009
- Site internet
- Groupes :
Shadow :
Patgame, je t'ai déjà demandé, sur le forum et en MP (tu lis tes MP au moins ?) de ne pas insérer de retour à la ligne après la balise quote (et de faire plus attention à la formulation de tes messages). Merci
bien sur je lis mes mp, je fais ce que je peux parfois une info m'échappePatgame, je t'ai déjà demandé, sur le forum et en MP (tu lis tes MP au moins ?) de ne pas insérer de retour à la ligne après la balise quote (et de faire plus attention à la formulation de tes messages). Merci
c'est tout nouveau pour moi et c'est souvent écrit petit je ne vois pas toujours très bien je dois changer mes lunettes bientot, l'age n'aide pas
ceci dit je prends bonne note tu as sans doute remarqué qu'il y avait du mieux non quand même
peux tu m'écrire cette requête ?
cordialement
Édité par patgame Le 14/09/2009 à 16h05
horn Membre non connecté
-
Modérateur
- Voir le profil du membre horn
- Inscrit le : 31/12/2007
- Site internet
- Groupes :
-
Equipe Historique
patgame Membre non connecté
-
Booster Missile
- Voir le profil du membre patgame
- Inscrit le : 03/09/2009
- Site internet
- Groupes :
horn :
quand on est demandeur comme je le suis on a pas d'exigence particulière à avoir Je te ferai la requête dans la soirée si j'ai le temps, sinon demain, mais je ne t'oublies pas, je n'ai plus la syntaxe exacte là.
dis moi simplement la manoeuvre à faire dans le détail
merci à toi
cordialement
patrick
Répondre
Vous n'êtes pas autorisé à écrire dans cette catégorie