One collection empty showing error but books still in total count

TalkBug Collectors

Join LibraryThing to post.

One collection empty showing error but books still in total count

This topic is currently marked as "dormant"—the last message is more than 90 days old. You can revive it by posting a reply.

1PAHistorian
Apr 1, 2013, 12:25 am

This is the error message:
SELECT count(1) AS count FROM workalias LEFT JOIN bookstack ON wa_fullcode = books_sameness_resolved WHERE wa_workcode = AND books_usernum = 0 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 'AND books_usernum = 0' at line 5

3jbd1
Apr 1, 2013, 8:25 am

Chris C.'s fixed this, so you should be all set now. Thanks, and sorry!