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;