Librariandb 0.2 installation problem

A place to discuss and receive support for the Library DB application.

Librariandb 0.2 installation problem

Postby pepo80 » Wed Jul 16, 2008 8:59 am

Hi :D ,

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? :oops:
Thanks and regards.
pepo80
 
Posts: 5
Joined: Wed Jul 16, 2008 8:43 am

Postby shannah » Wed Jul 16, 2008 12:08 pm

Mysql 4.1 or higher is required unfortunately :(
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Postby pepo80 » Fri Jul 18, 2008 7:05 am

Hi,

no problem :lol: 10x for information... i update my local server (it's time).

At the next time. Bye... :o
pepo80
 
Posts: 5
Joined: Wed Jul 16, 2008 8:43 am


Return to Library DB Discussion

Who is online

Users browsing this forum: No registered users and 10 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved