Bastien (Créer un compte)

Toutes mes réponses sur les forums

15 sujets de 1 à 15 (sur un total de 50)
  • Auteur
    Messages
  • en réponse à : du local à l’hébergeur #724190
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    Bonjour,

    Commencez par sauvegarder votre blog fonctionnel ( http://videonoob.fr/wordpress/mise-a-jour ), puis effectuez la migration en respectant les étapes décrites ici : http://www.ya-graphic.com/2009/03/migration-wordpress-migrer-son-blog-wordpress/

    en réponse à : Insertion d’un texte statique au dessus des articles #714239
    cantaeus
    Participant
    Padawan WordPress
    57 contributions
    en réponse à : Bug pour écrire les articles #713919
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    Essaies de vider le cache de ton navigateur, ou essaies d’afficher la page avec un navigateur différent. Quoi qu’il en soit, essaies toujours de travailler avec la dernière version de wordpress.

    en réponse à : Articles différés en échec depuis la mise à jour de WordPress 2.9 #705362
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    Super boulot du côté du plugin conseillé… ça met le message d’erreur, mais quelques minutes après, le billet est bel et bien publié. espérons que ce bug soit corrigé bientôt.

    en réponse à : Articles différés en échec depuis la mise à jour de WordPress 2.9 #705361
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    Salut à toi Calitel , salut ô grand Lumière de Lune.

    Pour moi même combat. Clean install sur un dédié (debian 5, AMP), planification manquée. Mais de mon côté, ça ne date pas de la 2.9, mais de bien avant … si vous avez des nouvelles, je suis preneur. En attendant, j’essaie ce plugin et je reviens vers vous 😉

    en réponse à : Lien « envoyer cette page par e-mail » #684042
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    Salut JBB, merci pour ta réponse :happy:.

    Je suis surpris que ça n’existe pas, voici un exemple qui se fait tout seul ou très facilement avec Joomla : http://www.souffledelinde.com/index.php/la-condition-de-la-femme-en-inde/63-le-mariage-des-femmes-en-inde.html (petite enveloppe en haut de page).

    Si ça n’existe pas il pourrait être intéressant de le développer qu’en pensez-vous ?

    en réponse à : Cherche tuto pour installer mon site du serveur local MAMP vers Free #657839
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    Salut Boris,

    Chaque manipulation peut être annulée en faisant la manipulation inverse, tu ne devrais pas avoir de problème à revenir en arrière.

    Si tu as bien migré le dashboard + exporté la base de données + modifié la base de données + importé la bdd chez free + modifié le fichier de conf que tu as mis chez ovh, alors il n’y a pas de raisons que ça ne fonctionne pas, à première vue.

    Ou en es-tu et que veux-tu faire, dans l’ordre ?

    en réponse à : Bug WordPress 2.7 : Planification de Bulletin ? #656498
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    @binbin : même problème, mais avec un .htaccess (un peu complexe car système de cache + réécriture d’url) :

    RewriteEngine On
    RewriteBase /
    AddDefaultCharset UTF-8
    
    
    RewriteCond %{REQUEST_METHOD} !=POST
    RewriteCond %{QUERY_STRING} !.*=.*
    RewriteCond %{HTTP:Cookie} !^.*(comment_author_|wordpress|wp-postpass_).*$
    RewriteCond %{HTTP:Accept-Encoding} gzip
    RewriteCond %{DOCUMENT_ROOT}/wp-content/cache/supercache/%{HTTP_HOST}/$1/index.html.gz -f
    RewriteRule ^(.*) /wp-content/cache/supercache/%{HTTP_HOST}/$1/index.html.gz [L]
    
    RewriteCond %{REQUEST_METHOD} !=POST
    RewriteCond %{QUERY_STRING} !.*=.*
    RewriteCond %{HTTP:Cookie} !^.*(comment_author_|wordpress|wp-postpass_).*$
    RewriteCond %{DOCUMENT_ROOT}/wp-content/cache/supercache/%{HTTP_HOST}/$1/index.html -f
    RewriteRule ^(.*) /wp-content/cache/supercache/%{HTTP_HOST}/$1/index.html [L]
    
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule . /index.php [L]
    
    AddEncoding gzip .gz
    AddType text/html .gz
    SetEnvIfNoCase Request_URI .gz$ no-gzip
    Header set Cache-Control ‘max-age=3600, must-revalidate’
    ExpiresActive On
    ExpiresByType text/html A300


    @Lorand
    : Idem, la solution de chez parenthèse.be ne fonctionne pas.

    ça ne pourrait pas venir d’un problème de droits sur les fichiers cron ou wp-cron ?

    A l’aide les pros … 😗

    en réponse à : plus de 800 requêtes SQL par page !? #667210
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    Haha, merci Jay pour m’avoir donné tes idées. Je ne m’attendais pas une seconde à ce qu’une table sql puisse se corrompre comme ça, ça ne m’était jamais arrivé.

    T’as pas idée quand tu dis que ma fusée décollera encore plus vite, étant donné que je viens d’activer et de configurer le plugin wp super cache.

    Maintenant, en plus d’avoir un serveur de rêve (merci à Snibbits.net), mes pages sont générées une fois toutes les demies heures, stockées et distribuées sous forme de pages statiques, plus d’accès superflus à MySQL, le rêve :D !

    PS : même en tentant d’éditer mon premier post, je n’arrive pas à modifier le titre en [résolu], une idée ?

    en réponse à : plus de 800 requêtes SQL par page !? #667208
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    Ok j’ai trouvé le problème ET la solution :

    Ma table WordPress étant corrompue, ça se voit lorsqu’on essaie d’en lister le contenu dans phpmyadmin par exemple :

    Table « wp_options » is marked as crashed and should be repaired

    Il faut donc aller dans l’onglet SQL, puis lancer la commande :

    REPAIR TABLE wp_options

    et normalement ça roule.

    N’oubliez jamais de faire des sauvegardes de vos tables SQL.
    Cf tutoriel : comment sauvegarder et mettre à jour son blog wordpress.

    en réponse à : plus de 800 requêtes SQL par page !? #667207
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    Voilà les requêtes effectuées par wp pour la homepage :

    SET NAMES ‘utf8’
    SELECT option_value FROM beta1_options WHERE option_name = ‘siteurl’
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘cron’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘siteurl’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘home’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘hack_file’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘active_plugins’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘feedburner_settings’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘wordpress_api_key’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_home_description’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_home_title’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_donate’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_can’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_rewrite_titles’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_use_categories’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_category_noindex’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_archive_noindex’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_tags_noindex’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_generate_descriptions’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_post_title_format’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_page_title_format’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_category_title_format’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_archive_title_format’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_tag_title_format’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_search_title_format’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_description_format’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_paged_format’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_404_title_format’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_post_meta_tags’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_page_meta_tags’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_home_meta_tags’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘aiosp_do_log’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘use_smilies’ LIMIT 1
    SHOW TABLES LIKE ‘beta1_smileys’
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘sociable_conditionals’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘sociable_usecss_set_once’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘WPAjaxEditComments20’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘gzipcompression’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘blog_charset’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘simpletags’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘date_format’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘widget_stags_cloud’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘permalink_structure’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘category_base’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘tag_base’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘template’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘stylesheet’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘logged_in_salt’ LIMIT 1
    SELECT * FROM beta1_users WHERE user_login = ‘koon’
    SELECT meta_key, meta_value FROM beta1_usermeta WHERE user_id = 8
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘beta1_user_roles’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘widget_categories’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘widget_text’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘widget_rss’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘sidebars_widgets’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘update_core’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘rewrite_rules’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘html_type’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘show_on_front’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘posts_per_page’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘comments_per_page’ LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
     SELECT SQL_CALC_FOUND_ROWS  beta1_posts.* FROM beta1_posts  WHERE 1=1  AND beta1_posts.post_type = ‘post’ AND (beta1_posts.post_status = ‘publish’ OR beta1_posts.post_status = ‘private’)  ORDER BY beta1_posts.post_date DESC LIMIT 0, 10
    SELECT FOUND_ROWS()
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_value FROM beta1_options WHERE option_name = ‘sticky_posts’ LIMIT 1
    SELECT * FROM beta1_posts WHERE ID = 1143 LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT post_id, meta_value FROM beta1_postmeta, beta1_posts WHERE post_id = ID AND meta_key = ‘links_to’ AND (post_status = ‘static’ OR post_status = ‘publish’)
    SELECT * FROM beta1_posts WHERE ID = 1132 LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT * FROM beta1_posts WHERE ID = 1107 LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT * FROM beta1_posts WHERE ID = 1042 LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT * FROM beta1_posts WHERE ID = 1111 LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT * FROM beta1_posts WHERE ID = 1098 LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT * FROM beta1_posts WHERE ID = 1075 LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT * FROM beta1_posts WHERE ID = 1081 LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT * FROM beta1_posts WHERE ID = 127 LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT * FROM beta1_posts WHERE ID = 1024 LIMIT 1
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT t.*, tt.*, tr.object_id FROM beta1_terms AS t INNER JOIN beta1_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN beta1_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’, ‘post_tag’) AND tr.object_id IN (1143, 1132, 1107, 1042, 1111, 1098, 1075, 1081, 127, 1024) ORDER BY t.name ASC
    SELECT post_id, meta_key, meta_value FROM beta1_postmeta WHERE post_id IN (1143,1132,1107,1042,1111,1098,1075,1081,127,1024)
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options

    problème donc avec ces requêtes inutiles et récurrentes :

    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options
    SELECT option_name, option_value FROM beta1_options WHERE autoload = ‘yes’
    SELECT option_name, option_value FROM beta1_options

    des idées ??

    en réponse à : plus de 800 requêtes SQL par page !? #667206
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    Bonne idée ! Cependant le nombre de requêtes affichées varie à chaque actualisation de page, c’est vraiment bizarre.
    Je me fais un petit monitoring mysql pour regarder d’où ça vient, après je tenterai ton approche. Merci pour le coup de main.

    en réponse à : plus de 800 requêtes SQL par page !? #667204
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    J’ai activé WP super cache, afin de réduire au minimum la charge de mon serveur, aussi puissant soit-il, mais ceci ne résoud mon porblème que partiellement, et j’aimerais vraiment savoir si je suis le seul à avoir eu ce genre de problèmes. De votre côté, quel temps prends votre serveur pour générer une page ?

    Testez avec ce code en footer :

    <p> equêtes.  secondes.</p>

    en réponse à : plus de 800 requêtes SQL par page !? #667203
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    @JayLBR : j’ai une fusée : quadri xeon 8go de ram, donc mon blog a bien un problème :(

    Je fais ta modif cependant, par acquis de conscience…

    Une autre idée :D ?

    en réponse à : Plug in : mise à jour automatique #653720
    cantaeus
    Participant
    Padawan WordPress
    57 contributions

    @babas3d : merci d’avoir répondu, je désespérais un peu. Je ne demande qu’à faire ce que tu me dis, mais j’amerais bien avant tout comprendre ce que sont ces clefs d’authentification. Je suppose, que si elle porte ce nom, c’est pour qu’elle soit unique à chaque blog. Comment la générer, à quoi sert-elle ?

    Merci pour votre temps 🍺

15 sujets de 1 à 15 (sur un total de 50)