PHP : Alexandria Library

Started by simon79, 22 March 2011, 11:20:22

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

simon79

ITALIAN

Ho installato il componente Biblioteca di Alessandria sul mio Joomla versione 1.15.22.
Per ora, non ho incontrato alcun problema tranne che:

Quando creo una "ricerca per autore" menu ho diversi messaggi di errore che compare quando faccio clic su questo link sul mio sito:

Sotto ho le mie briciole di pane:

Warning: Invalid argument in dotazione per foreach () in / miosito / components / com_abook / models / author.php on line 129

Warning: mysql_num_rows (): argomento fornito non è una risorsa valida di risultato di MySQL in / miosito / libraries / joomla / database / database / mysql.php on line 344

Apparentemente si tratta di un problema di MySQL, ma può mettere a conoscenza di PHP, vengo a chiedere aiuto.

E la presentazione dell '"autore" Ho il messaggio di errore:

Warning: Invalid argument in dotazione per foreach () in / miosito / components / com_abook / views / autore / tmpl / default.php on line 88

Mon site

Versione PHP: 5.2.17
Hosting: 1 & 1

Vi ringrazio in anticipo per il vostro aiuto

_________________________________________________

FRENCH :

J'ai installé le composant Alexandria Library sur ma version 1.15.22 de joomla.
Pour le moment, je n'ai pas rencontré de soucis à part celui la :

Quand je crée un menu "recherche par auteur" j'ai plusieurs messages d'erreurs qui apparait quand je clique sur ce lien sur mon site :

En dessous de mon fil d'ariane j'ai :

Warning: Invalid argument supplied for foreach() in /monsite/components/com_abook/models/author.php on line 129

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

Apparement ça viendrait d'un problème Mysql, mais mis connaissant peut dans le domaine php, je viens vous demander de l'aide.

Et dans la présentation de l' "Auteur" j'ai le message d'erreur :

Warning: Invalid argument supplied for foreach() in /monsite/components/com_abook/views/author/tmpl/default.php on line 88

Mon site

Version de PHP: 5.2.17
Hebergeur : 1&1

Merci d'avance pour votre aide

_________________________________________________


ENGLISH :

I installed the Alexandria Library component on my joomla version 1.15.22.
For now, I have not encountered any trouble except that it:

When I create a menu "author search" I have several error messages that appears when I click on this link on my site:

Below I have my breadcrumb:

Warning: Invalid argument Supplied for foreach () in / mysite / components / com_abook / models / author.php on line 129

Warning: mysql_num_rows (): Supplied argument is Not a valid MySQL result resource in / mysite / libraries / joomla / database / database / mysql.php on line 344

Apparently it comes from a MySQL problem, but can put knowledge in php, I come to ask for help.

And the presentation of the "Author" I have the error message:

Warning: Invalid argument Supplied for foreach () in / mysite / components / com_abook / views / author / tmpl / default.php on line 88

Mon site

PHP Version: 5.2.17
Hosting: 1 & 1

Thank you in advance for your help

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

dario

#1
Hi simon79, if it's ok for you we can talk in english.
Which version of abook do you have?
The latest version of Alexandria Book Library is 1.1.0
[url=http://www.knoppix.it]Knoppix italia[/url]
[url=http://www.disconnessi.org]Stacca la spina![/url]
[url=http://www.informatizzati.org]Informatizzati.org: Computer, Linux, Windows, VMware[/url]

simon79

Parles-tu Français ?

J'avais la version 1.0.1
J'ai installé la version 1.1.0, mais aucun changement


simon79

Dans cette version, un onglet importer/exporter est disponible.
J'ai une bibliothèque sur google livre.
Est-il possible d'exporter cette bibliothèque en csv et de l'importer ensuite sur alexandria book ?

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

simon79

Do you speak French?

I had version 1.0.1
I installed version 1.1.0 but no change




In this version, a tab import / export is available.
I have a library book on google.
Is it possible to export the library to csv and then import it on alexandria book?

simon79

Ces vrai que ça sera plus pratique ^^ !

Pour le premier message d'erreur Warning: Invalid argument supplied for foreach() in /homepages/monsite/components/com_abook/models/author.php on line 129

Ligne 120 à 135 :
function getData()
	
{
	
	
// Lets load the data if it doesn't already exist
	
	
if (empty( 
$this->_data ))
	
	
{
                       
	
$query $this->_buildQuery();
                       
	
$this->_data $this->_getList$query$this->getState('limitstart'), $this->getState('limit') );
                
	
}
	
	
	
$k=0;
	
	
	
foreach(
$this->_data as $libro){
	
	
	
	
$this->_authorname($libro->id);
	
	
	
	
$this->_data[$k]->authors=$this->_authorname;
	
	
	
	
$k=$k+1;
	
	
	
}
	
	
return 
$this->_data;
	
}



Pour le second message d'erreur : Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /monsite/libraries/joomla/database/database/mysql.php on line 344

Ligne 342 à 345 :
	
function 
getNumRows$cur=null )
	
{
	
	
return 
mysql_num_rows$cur $cur $this->_cursor );
	
}


Pour le troisième message d'erreur : Warning: Invalid argument supplied for foreach() in /monsite/components/com_abook/views/author/tmpl/default.php on line 88

Ligne 81 à 93 :
        <?php
	
$params = &JComponentHelper::getParams'com_abook' );
	
$imgpath=$params->get'img_path' );
        
$k 0;
        
$i 0;
        
$n count$this->items );
        
$rows = &$this->items;
        foreach (
$rows as $row) {
                
$link           JRoute::_'index.php?option=com_abook&view=book&catid='.$row->catslug.'&id='$row->slug );
                
?>
                <tr class="sectiontableentry<?php echo $k+1?><?php echo $this->escape($this->params->get('pageclass_sfx')); ?>">
	
	
	
<td width="100" height="100">
	
	
	
<?php

simon79