BookLibary Component Support

I tried to install booklibrary basic on my 1.5.14 joomla site (www.arcigayverona.org/sito), because I wanted to test the functioning before proceeding to buy the pro version. I verified that PHP5, CURL, GD and XSL are correctly installed and inabled. However, during the installation process, I received a long error message (see below). In the backend of joomla, the booklibrary seemed to be installed, but when I tried to open the component options, I received some other errors in the "books" and "categories" tabs.

Maybe I did something stupid... What should I do?

ERROR DISPLAYED DURING THE INSTALLATION PROCESS:

BookLibrary
cheking database
install database
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLES IF EXISTS ura_booklibrary, ura_booklibrary_lend, ura_boo SQL=DROP TABLES IF EXISTS ura_booklibrary, ura_booklibrary_lend, ura_booklibrary_lend_request, ura_booklibrary_review, ura_booklibrary_suggestion,ura_booklibrary_categories, ura_booklibrary_versionYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_general_ci' at line 33 SQL=CREATE TABLE IF NOT EXISTS ura_booklibrary ( `id` int(11) unsigned NOT NULL auto_increment, `bookid` varchar(20) NOT NULL default '0', `isbn` varchar(20) NOT NULL default '', `date` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `archived` tinyint(1) NOT NULL default '0', `approved` tinyint(1) NOT NULL default '1', `authors` varchar(200) default '', `title` varchar(200) default '', `imageURL` varchar(200) default '', `URL` varchar(250) default '', `rating` int(2) default '0', `manufacturer` varchar(200) default '', `comment` TEXT, `informationFrom` int(11) default '0', `language` varchar(45) default '', `fk_lendid` int(11) default '0', `release_Date` VARCHAR(45), `edition` VARCHAR(45), `price` VARCHAR(15), `priceunit` VARCHAR(6), `ebookURL` VARCHAR(250), `vm_id_product` int(11) default '0', `numberOfPages` int(6) default '0', `owneremail` VARCHAR(50), PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 COLLATE utf8_general_ciYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_general_ci' at line 16 SQL=CREATE TABLE IF NOT EXISTS ura_booklibrary_lend ( `id` int(11) unsigned NOT NULL auto_increment, `fk_bookid` int(11) NOT NULL default 0, `fk_userid` int(11), `lend_from` datetime NOT NULL default '0000-00-00 00:00:00', `lend_until` datetime, `lend_return` datetime, `checked_out` int(11) NOT NULL default 0, `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `user_name` varchar(250) default '', `user_email` varchar(250) default '', `user_mailing` TEXT default '', PRIMARY KEY (`id`), FOREIGN KEY (`fk_userid`) REFERENCES ura_users(`id`), FOREIGN KEY (`fk_bookid`) REFERENCES ura_booklibrary(`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 COLLATE utf8_general_ciYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_general_ci' at line 17 SQL=CREATE TABLE IF NOT EXISTS ura_booklibrary_lend_request ( `id` int(11) unsigned NOT NULL auto_increment, `fk_bookid` int(11) NOT NULL default 0, `fk_userid` int(11), `lend_from` date NOT NULL default '0000-00-00', `lend_until` date, `lend_request` datetime NOT NULL default '0000-00-00 00:00:00', `checked_out` int(11) NOT NULL default 0, `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `user_name` varchar(250) default '', `user_email` varchar(250) default '', `user_mailing` TEXT default '', `status` int(1) default 0, PRIMARY KEY (`id`), FOREIGN KEY (`fk_userid`) REFERENCES ura_users(`id`), FOREIGN KEY (`fk_bookid`) REFERENCES ura_booklibrary(`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 COLLATE utf8_general_ciYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_general_ci' at line 12 SQL=CREATE TABLE IF NOT EXISTS ura_booklibrary_review ( `id` int(11) unsigned NOT NULL auto_increment, `fk_bookid` int(11) NOT NULL default 0, `fk_userid` int(11), `date` datetime NOT NULL default '0000-00-00 00:00:00', `rating` int(2) default 0, `title` varchar(250) default '', `comment` TEXT, PRIMARY KEY (`id`), FOREIGN KEY (`fk_userid`) REFERENCES ura_users(`id`), FOREIGN KEY (`fk_bookid`) REFERENCES ura_booklibrary(`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 COLLATE utf8_general_ciYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_general_ci' at line 8 SQL=CREATE TABLE IF NOT EXISTS ura_booklibrary_categories ( `id` int(11) unsigned NOT NULL auto_increment, `bookid` int(11) NOT NULL default 0, `catid` int(11), PRIMARY KEY (`id`), FOREIGN KEY (`bookid`) REFERENCES ura_booklibrary(`id`), FOREIGN KEY (`catid`) REFERENCES ura_categories(`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 COLLATE utf8_general_ciYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_general_ci' at line 6 SQL=CREATE TABLE IF NOT EXISTS ura_booklibrary_version ( `id` int(11) unsigned NOT NULL auto_increment, `version` int(11) NOT NULL default 0, `number` varchar(11), PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 COLLATE utf8_general_ciYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_general_ci' at line 9 SQL=CREATE TABLE IF NOT EXISTS ura_booklibrary_suggestion ( `id` int(11) unsigned NOT NULL auto_increment, `fk_userid` int(11), `date` datetime NOT NULL default '0000-00-00 00:00:00', `title` varchar(250) default '', `comment` TEXT, PRIMARY KEY (`id`), FOREIGN KEY (`fk_userid`) REFERENCES ura_users(`id`) ) TYPE=MyISAM AUTO_INCREMENT=2 COLLATE utf8_general_ciTable 'Sql46699_2.ura_booklibrary_version' doesn't exist SQL=INSERT INTO ura_booklibrary_version (`version`,`number`) VALUES ('2.0','Basic'end install database
DB function failed with error number 1146
Table 'Sql46699_2.ura_booklibrary' doesn't exist SQL=truncate ura_booklibrarySample data loaded
BookLibrary

This component is published under the License.
Installation: succesful


ERROR DISPLAYED IN "BOOKS":

Table 'Sql46699_2.ura_booklibrary_categories' doesn't exist SQL=SELECT count(*) FROM ura_booklibrary_categories AS jea LEFT JOIN ura_booklibrary AS jei ON jei.id = jea.bookid LEFT JOIN ura_booklibrary_lend AS l ON jei.fk_lendid = l.idDB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT bookid FROM ura_booklibrary_categories )GROUP BY jea.boo SQL=SELECT cc.title AS category, cc.id as catid , jei.* , l.id as lendid, l.lend_from as lend_from, l.lend_return as lend_return, l.lend_until as lend_until, usr.name AS editor FROM ura_booklibrary_categories AS jea, ura_categories AS cc ,ura_booklibrary AS jei LEFT JOIN ura_booklibrary_lend AS l ON jei.fk_lendid = l.id LEFT JOIN ura_users AS usr ON usr.id = jei.checked_out WHERE cc.id = jea.catid AND jei.id = jea.bookid AND jei.id IN (SELECT bookid FROM ura_booklibrary_categories )GROUP BY jea.bookid ORDER BY cc.ordering,cc.id, jei.ordering LIMIT 0,100;


ERROR DISPLAYED IN "CATEGORIES":

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.arcigayverona.org/home/sito/administ...dmin.booklibrary.php on line 492

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.arcigayverona.org/home/sito/administ...dmin.booklibrary.php on line 492

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.arcigayverona.org/home/sito/administ...dmin.booklibrary.php on line 492

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.arcigayverona.org/home/sito/administ...dmin.booklibrary.php on line 492

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.arcigayverona.org/home/sito/administ...dmin.booklibrary.php on line 492

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.arcigayverona.org/home/sito/administ...dmin.booklibrary.php on line 492
DB function failed with error number 1146
Table 'Sql46699_2.ura_booklibrary_categories' doesn't exist SQL=SELECT jc.id, jc.parent_id, COUNT(jea.id) AS books FROM ura_categories AS jc LEFT JOIN ura_booklibrary_categories AS jea ON jea.catid = jc.id WHERE jc.section='com_booklibrary' GROUP BY jea.catid ORDER BY jc.parent_id DESC,jc.ordering;

Hello

Please tyry check ours last version for Book Library free software.
Please write do all for you good or not

Thanks,
OrdaSoft team

Thank you. I reinstalled the updated version after your suggestion.

The result is that the error during the installation phase is shorter (see below) and that the error in the categories tab has completely disappeared.

There is still an error in "books", but it's that shown below.

ERROR DURING THE INSTALLATION PHASE:

BookLibrary
cheking database
install database
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLES IF EXISTS ura_booklibrary, ura_booklibrary_lend, ura_boo SQL=DROP TABLES IF EXISTS ura_booklibrary, ura_booklibrary_lend, ura_booklibrary_lend_request, ura_booklibrary_review, ura_booklibrary_suggestion,ura_booklibrary_categories, ura_booklibrary_versionend install database
Sample data loaded
BookLibrary

This component is published under the License.
Installation: succesful

ERROR IN THE "BOOKS" TAB:

DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT bookid FROM ura_booklibrary_categories )GROUP BY jea.boo SQL=SELECT cc.title AS category, cc.id as catid , jei.* , l.id as lendid, l.lend_from as lend_from, l.lend_return as lend_return, l.lend_until as lend_until, usr.name AS editor FROM ura_booklibrary_categories AS jea, ura_categories AS cc ,ura_booklibrary AS jei LEFT JOIN ura_booklibrary_lend AS l ON jei.fk_lendid = l.id LEFT JOIN ura_users AS usr ON usr.id = jei.checked_out WHERE cc.id = jea.catid AND jei.id = jea.bookid AND jei.id IN (SELECT bookid FROM ura_booklibrary_categories )GROUP BY jea.bookid ORDER BY cc.ordering,cc.id, jei.ordering LIMIT 0,100;

Please try upgrade book library software from last version on site.

Thanks,
OrdaSoft team

I had the same problem but I use booklibrary locally with xampp.
My solution was to install the older xampp version xampp-win32-1.7.1 with joomla 1.5.22 and booklibrary version com_booklibrary_BASIC_2_0_2011_02_03.
This is a solution for local installation.
Maybe is the php version.
Admins will know!

After the last installation, I didn't receive any arror during the installation process, nor in the category tab. However, I still have a problem in the book lab:

DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT bookid FROM ura_booklibrary_categories )GROUP BY jea.boo SQL=SELECT cc.title AS category, cc.id as catid , jei.* , l.id as lendid, l.lend_from as lend_from, l.lend_return as lend_return, l.lend_until as lend_until, usr.name AS editor FROM ura_booklibrary_categories AS jea, ura_categories AS cc ,ura_booklibrary AS jei LEFT JOIN ura_booklibrary_lend AS l ON jei.fk_lendid = l.id LEFT JOIN ura_users AS usr ON usr.id = jei.checked_out WHERE cc.id = jea.catid AND jei.id = jea.bookid AND jei.id IN (SELECT bookid FROM ura_booklibrary_categories )GROUP BY jea.bookid ORDER BY cc.ordering,cc.id, jei.ordering LIMIT 0,100;


Unfortunately I can't follow Pickolo suggestion, because we use an online provider that doesn't allow the installation of different versions of xampp.