,
i have downloaded librarian-db vers. 0.2, unzip and test under my local server.
Created db --> ok
Created user --> ok
modify conf.ini --> ok
execute sql command (from install.php)--> ok
i try to enter in index.php and i obtain this:
- Code: Select all
Error: Could not load current record: 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 '(`books`.`date_created`, 'SYSTEM', 'SYSTEM') as `date_created`, SELECT length(`books`.`book_id`) as `__book_id_length`,`books`.`book_id`,length(`books`.`title`) as `__title_length`,`books`.`title`,length(`books`.`author_or_editor`) as `__author_or_editor_length`,`books`.`author_or_editor`,length(`books`.`isbn`) as `__isbn_length`,`books`.`isbn`,length(`books`.`publisher`) as `__publisher_length`,`books`.`publisher`,length(`books`.`copyright_year`) as `__copyright_year_length`,`books`.`copyright_year`,length(`books`.`categories`) as `__categories_length`,`books`.`categories`,length(`books`.`audience`) as `__audience_length`,`books`.`audience`,length(`books`.`media`) as `__media_length`,`books`.`media`,length(`books`.`reference_no`) as `__reference_no_length`,`books`.`reference_no`,length(`books`.`notes`) as `__notes_length`,`books`.`notes`,length(`books`.`borrower_id`) as `__borrower_id_length`,`books`.`borrower_id`,length(`books`.`due_date`) as `__due_date_length`,`books`.`due_date`,length(`books`.`date_created`) as `__date_created_length`,convert_tz(`books`.`date_created`, 'SYSTEM', 'SYSTEM') as `date_created`,length(`books`.`date_modified`) as `__date_modified_length`,convert_tz(`books`.`date_modified`, 'SYSTEM', 'SYSTEM') as `date_modified`,length(`books`.`created_by`) as `__created_by_length`,`books`.`created_by`,length(`books`.`modified_by`) as `__modified_by_length`,`books`.`modified_by` FROM `books` LIMIT 0,1
In my local server i have:
php 4.3.11
mysql 4.0.20a
this release are too much old?
Thanks and regards.
10x for information... i update my local server (it's time).
