Robert Heller

Where are there apostrophes in your input (which input fields). This sounds like a quoting bug somewhere in the input sanitizing code.

The only thing I can suggest it turning on history and form memory in firefox. Putting in *all* authors in the database in the author field as a dropdown could become combersome once the collection started to fill up with a large collection of items from a large number of authors.

Several things:

First, have you entered the correct Amazon credentials? You need the public and private keys, plus an associate’s id.

Additionally, I have some questions:

1) What O/S does your web hosting server run (Linux or MS-Windows)?
2) Is your WordPress install a single site install or a multi-site/networked install?
3) Which web browser are you using (Firefox, Chrome, Safari, or IE)? Under what operating system (MS-Windows, Linux, MacOSX, Android, or Ios)?

There have been problems reported with MS-Windows as the web site hosting server. *I* don’t have any way of supporting this plugin with WordPress running on a MS-Windows server. There have also been problems with this plugin with WordPress running as a multi-site or networked installation (I don’t know what the problem there is, but I suspect it is some weirdness with users and roles in that environment or something).

No, I have been busy with more pressing things.

Well, normally, *books* have authors and for things like CDs and DVDs most library systems consider the various creative people involved in Music/TV/Movies (performers / song writers / actors / directors / screen writers / etc.) as ‘authors’, and so would use the ‘Author’ field of a library cataloging system to hold the names of such people. I am not sure what you mean by “authorities”.

I think what is happening is that somehow the barcode ‘counter’ is getting stuck somehow. Completely deleting the table and then re-creating it should cure this.

The code generates bar codes by finding the ‘highest value’ bar code and ‘incrementing’ it. Somehow either it is not finding the truely highest barcode or failing to properly increment it. This is something I have to look into deeply.

A long post, giving all of the details is always good — it helps with debugging the code. Often people post a ‘short’ message without any details and most of the time my ‘crystal ball’ does not provide the answers I need…

You would need to enter a SQL statement like:

drop table wp_weblib_collection;

using a plugin or tool that allows you to directly enter database statements.

Then log into the dashboard as an adminstrator and go to the WebLibrarian settings page (Settings->Web Librarian). The turn ON “Debug Database:”, then click on the “Make Database” button. And then turn OFF “Debug Database:”.