Warning: ... on line 344

[Don Camillo]

Hello,

starting with developing work at my local web system I regularly get an error
>>Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampplite\htdocs\Joomla\libraries\joomla\database\database\mysql.php on line 344<<

when I select the menu point to see my collection.

I found out that creating a new menu point with the same view to the same collection solves the problem. After solving the problem with the new menu point the error vanishes for the original menu point as well. For that day it is solved.

Looking at it after some days I got the error in line 344 again. Any hints ?

I've seen that there were some french posts concerning the error, but my french is not as good to understand the answers. So sorry for eventually posting twice.

[steevo]

Hi,

There is a problem with search reset by clicking on menu.
Try to disable "Reset last search" in menu parameters.

[Don Camillo]

Hello,

so after a while of using different menu points to come a little bit closer to the line 344 error I can report a strange assumption.

My original menue title was "gebrauchte Fußballschuhe" which contains a special german letter. I think that everytime after a longer delay (days) I get the line 344 error . Creating a new menu point with exact the same configuration but with the title "Schuhe" has never (!! for sure) shown this error. As described above after using the new menu point "Schuhe" the old one works as well.

Creating a third menu point with the title "gebrauchte Schuhe" brings up no error as well.

So the assumption is that the line 344 error is based on the special german character "ß".

Perhaps that gives some hints where the reason for that error lies.

>Disable the "Reset last Search" didn't bring up any changes.

[steevo]

Thank you for this report.

This will help. I will check that.

[ovni]

Bonjour,
je viens de restaurer mon site et je me retrouve avec la même ligne erreur mais avec un libellé un peu différent.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lesze345/public_html/castillano/libraries/joomla/database/database/mysql.php on line 344

De fait, la collection ne s'affiche pas.
J'utilise la version 0.4.1.
Pour la restauration, j'ai fait :
- installation de joomla
- restauration plugins / composants / modules
- restauration de la base de données

Je ne sais pas quoi dire de plus mais je suis bien embété, j'ai passé un temps fou a remplir 3 collections.

Merci beaucoup

[steevo]

Bonjour,

Avez-vous essayé de recréer le lien du menu à partir de zéro ?
Quel est la configuration du paramètre "reset de la dernière recherche" ?
Est-ce que la zone de recherche s'affiche ? Si oui, que donne un clic sur le bouton reset ?

[ovni]

Bonjour,

euh je me sent un peu bête là ...
le clic sur rafraichir fait tout apparaitre correctement.
Je note pour la prochaine fois.

Merci beaucoup

PS : merci également pour initiative de ce composant très bien fait, extremement utile et avec un support des plus efficasse.