first of all, let me say that I'm monumentally excited about this module. I was desperately in search of software that would do exactly this!

but I'm having a problem -- on /biblio I see "no entries found" and:

user error: 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 '(n.title,1,1) ASC, b.biblio_type ASC   LIMIT 0, 25' at line 2
query: SELECT * FROM node n left join biblio b  on n.nid=b.nid 
            WHERE n.type='biblio'  ORDER BY b.biblio_year DESC, substr(n.title,1,1) ASC, b.biblio_type ASC   LIMIT 0, 25 in /home/myusername/public_html/includes/database.mysql.inc on line 66.

I imported the records from an Endnote 7 XML file, and everything looks OK in the database when I view it. all the individual nodes are there. I don't know enough code to decipher what's up -- is there any fix for this?

Comments

rjerome’s picture

rjerome commented
Status: Active » Fixed

I'm glad to hear that you find the module useful. With regards to your SQL issue, I suspect that you have a version of MySQL which is older than 4.1.1. The problem stems from the fact that I used the SQL synonym SUBSTR which was introduced in version 4.1.1 rather than the full fucntion name SUBSTRING.

I have corrected this and checked in the fix on the DRUPAL-4-6 branch.

ijulie’s picture

ijulie commented
Title: SQL problem with import » working now

BRILLIANT! thank you SO much.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)