[spip-dev] Bug sur les sites syndiqués ?

Bonjour,

J'ai constaté quelquechose de bizarre : de temps en temps mon site
resyndique les mêmes articles (ça ne se produit pas à chaque mise à jour).
Ce problème est présent sur plusieurs sites syndiqués donc ca ne doit pas
venir de leurs backend...

D'où mes questions :
- s'agit il d'un bug ou d'une fonctionnalité (du genre resyndication si on
a rien de plus récent...) ?
- d'autres ont-ils le même problème ?

Mes liens syndiqués sont visibles ici :
http://www.livres-online.com/liens.php3

Actuellement je suis en 1-6a3 mais je crois que c'était pareil dans ma
version précédente...

Bonne soirée à tous,

David

Y'a des bugs sur le backend de dacode. Si tes sites en face sont des
dacode, ça peut expliquer.

J'ai le meme problème et qui se reproduit assez couramment. Sur plusieurs sites egalement dont pour certains je suis sur qu'ils ne sont pas de Dacode.
(cf http://www.newlc.com).

L'item est dupliqué dans la table spip_syndic_article (meme titre, meme URL, meme descriptif, mais date de syndication différente).

Ci joint la source RSS, l'item "Love Dice" est dupliqué alors qu'il semble conforme (en tout cas pas différents des autres):

<?xml version="1.0"?>
<!-- generator="b2/0.6pre3" -->
<rss version="0.92">
  <channel>
    <title>My-Symbian.com</title>
    <link>http://My-Symbian.com/main/index.php</link>
    <description>My-Symbian.com</description>
    <lastBuildDate>Thu, 13 Mar 2003 01:02:26 GMT</lastBuildDate>
    <docs>http://backend.userland.com/rss092</docs>
    <managingEditor>you@yourdomain.com</managingEditor>
    <webMaster>you@yourdomain.com</webMaster>
    <language>en</language>
    <item>
      <title>tApCalc</title>
      <description>tApCalc Finance is a mobile tape calculator program with all standard calculator keys and a host of Financial and Accounting function keys. Trial version can be downloaded from our Downloads section. Full version is available in our On-line store.</description>
      <link>http://My-Symbian.com/main/index.php?p=1168&c=1</link>
    </item>
    <item>
      <title>Handy Essentials bundle</title>
      <description>Epocware presents Handy Essentials. This suite consists of 3 programs: Handy Safe, Handy Day and Handy Expense. Buying this suite you pay 45.95 USD for Sony Ericsson P800 software that costs 59.85 USD, saving almost 14 USD on a purchase. Trial version is available for download in our Downloads section. Full version can be purchased in our On-line store.</description>
      <link>http://My-Symbian.com/main/index.php?p=1167&c=1</link>
    </item>
    <item>
      <title>Fax support for Series 60</title>
      <description>Bitween is currently working on MobileFAX application for Series 60 devices. MobileFAX will provide full fax support and will enable users to send and receive faxes directly from their Nokia 7650/3650 phones. Public release is scheduled for next week.</description>
      <link>http://My-Symbian.com/main/index.php?p=1166&c=1</link>
    </item>
    <item>
      <title>Love Dice</title>
      <description>Love Dice is a mobile phone game for Lovers looking for a little chance and a few extra ideas of things to do. The game first selects some loving act to be performed, then decides who is doing it to whom. Available for download in our Downloads section.</description>
      <link>http://My-Symbian.com/main/index.php?p=1162&c=1</link>
    </item>
    <item>
      <title>Forest Fire</title>
      <description>Forest Fire is the first mission pack for Strategic Assault by Xen Games - a real time strategy game for the P800. Forest Fire will only work with the registered version of Strategic Assault. There is no trial version. Full version is available in our On-line store.</description>
      <link>http://My-Symbian.com/main/index.php?p=1161&c=1</link>
    </item>
    <item>
      <title>Nokia @ CeBIT</title>
      <description>Nokia presents three useful hardware accessories for Series 60 phones:

* Digital Pen - when paired with a compatible phone, the Nokia Digital Pen lets you send colorful handwritten MMS messages to a compatible phone or email address. You can also use it to store handwritten notes on your compatible PC.

* Image Viewer - now that you've taken all those digital photos with the compatible Nokia imaging phones, project them larger than life onto your compatible TV screen or video projector. Uploading is easy over the wireless Bluetooth connection, and controlling your slideshows couldn't be simpler with the two-button system on the device.

* Add-on Lens - get up close and snap great photos with the Add-on Lens. Fit it onto your Nokia 3650 phone and choose between lenses with depths of 10 centimeters or 5 centimeters, or use the phone's standard lens while the add-on is still attached.</description>
      <link>http://My-Symbian.com/main/index.php?p=1165&c=1</link>
    </item>
    <item>
      <title>CallingCodes</title>
      <description>L3 Solutions' CallingCodes offer international country and city codes, North American are codes (NPA), and outbound direct dialing number patterns. Trial version is available for download in our Downloads section. Full version can be purchased in our On-line store.</description>
      <link>http://My-Symbian.com/main/index.php?p=1160&c=1</link>
    </item>
    <item>
      <title>Strategic Assault for the P800</title>
      <description>Strategic Assault by Xen Games is a fast paced real-time strategy game. Construct bases and capture strategic buildings. Lead your army to victory commanding tanks, helicopters, gunboats, and many other military units in battle against a vicious enemy. Whether outgunned or packing serious overkill, only careful tactical and strategic planning will secure victory. Trial version is available for download in our Downloads section. Full version can be purchased in our On-line store.</description>
      <link>http://My-Symbian.com/main/index.php?p=1159&c=1</link>
    </item>
    <item>
      <title>Samsung's first Series 60 phone</title>
      <description>Samsung presents their first Symbian OS, Series 60 based mobile phone called SGH-D700. It has a twisting screen and camcorder feature with built-in VGA camera. SGH-D700 supports stereo sound and MP3 playback and includes full MMS support, allowing users to create and send their own multimedia content. The interface for PC Sync is operated through USB and gives higher speed data rates. D700 offers 16-bit (65536 colors) screen, GPRS support, WAP browser, email client and supports Java MIDP and Symbian OS (C++) 3rd party applications. The device weighs 110 gram and supports 900/1800 and 1900 MHz bands. Embedded memory of 4 MB can be expanded with memory cards. SGH-D700 will be available in the second half of 2003.</description>
      <link>http://My-Symbian.com/main/index.php?p=1164&c=1</link>
    </item>
    <item>
      <title>GemDropX</title>
      <description>GemDropX is a fast-paced puzzle game where it's your job to clear the screen of gems before they squash you. Another P800 port by SomeOne. Available for free download in our Downloads section.</description>
      <link>http://My-Symbian.com/main/index.php?p=1158&c=1</link>
    </item>
  </channel>
</rss>

Gaetan Ryckeboer wrote:

Je me propose de tester ce bout de code :

$query_deja = "SELECT id_syndic_article FROM spip_syndic_articles WHERE
url=\"$le_lien\" AND id_syndic=$now_id_syndic";
    $result_deja = spip_query($query_deja);
    if (!($row = spip_fetch_array($result_deja))) {
     $query_syndic = "INSERT INTO spip_syndic_articles (id_syndic, titre,
url, date, lesauteurs, statut, descriptif) ".
      "VALUES ('$now_id_syndic', '$le_titre', '$le_lien', '$la_date',
'$les_auteurs', '$moderation', '$la_description')";
     $result_syndic=spip_query($query_syndic);
    }

dans inc_sites.php3

En effet il m'arrive de voir ma base MySQL perdre sa connexion (sur
http://www.livres-online.com hébergé chez OVH). Or dans l'ancien code ( if
(spip_num_rows($result_deja)==0){ ) si la connexion était perdue il
renvoyait peut être 0 alors que la requête n'était pas vraiment
effectuée....

Dans tous les cas il peut être bon de supprimer ce "select *" qui trainait
alors qu'on veux juste savoir si il y a des résultats...

Je vais tester pendant quelques jours.... je vous tiend au courant !

David