Any idea when Biblio D6 will be back?

It's coming along, but I have had some other distractions lately so I haven't had a lot of time to devote to this.

I can't make any guarantees, but hopefully within the next week.

Ron.

Ron,

I am also looking forward to your new release.
And I volunteer for testing of database upgrades.

Cheers,
thomas

No pressure or anything eh!!!

If you can tell me what your absolute must have requirements are, perhaps I can tell you if this module will fit your needs.

Ron.

Hi,

we are also "waiting" for the D6 bibliography module for our lab new website. No big pressure, since the site has to be online next academic year. We have tried v5 and it seems to mostly fit our needs. The extra feature that would be of great interest for us would be CCK integration, as described here:

http://drupal.org/node/234891

are there any plans to adapt the bibliography module to CCK?

Besides, good work Ron!

Is the CVS tree stable enough to install and enter data? If so, which tag should I use?

We are *very* interested in using this great module for our new site, and would like to get a jump on entering our publication info.

Thanks, and keep up the Good Work!

I appreciate that there is a demand for the 6.x version, but I have made some major changes to the database and how authors are handled which has impacted almost every part of the code. As a result I would not suggest using any version just yes as I have not fully tested everything and I can almost guarantee that there will be problems. I expect there to be a new "beta" release within days.

It's back...

I added the new v6 to my dev site, but its Update Status remains "Not supported!"

Hi Ron.

Thanks a lot. Already upgraded and everything seems to be working smoothly.

I am surprised though that there were no major database updates necessary.

Cheers,
thomas

Hi Ron,

I only just saw that it is recommended/required to uninstall the old version first.

I didn't do that ;-)

I would like to keep the existing publications, though.
Any upgrade path?

Thanks,
thomas

I'm guessing that you now see publications without any author information? Assuming you were using one of the previous 6.x-dev versions, you can force a database update by editing the system table and finding the row related to the biblio module and changing the value in the "schema_version" column. The question will be how far back to go... update 6004 is the one the moves author information to the new data base structure, so assuming you have tables listed in update 6002, then it's probably a safe bet to set schema_version to 6003 and then run update.php other wise you might have to set it back to 6001.

Ron.

It just occurred to me that if you downloaded the -dev version it may in fact be from yesterday since they only get built every 12 hours. Also I just found (and fixed) a bug which messes up the author conversion, so you should use the beta-5 version since it has the fix.

Ron.

I just found another bug :-() which should only affect upgrades from 5.x but if you are seeing authors listed twice in the tabular view and are NOT seeing the new author editing widget (single author / line) then this bug is affecting you also. You can always export all the entries you have put into previous beta versions and the uninstall, re-install and reimport the data.

Ron.

For me, everythiing is fine (but unchanged) with the release from last night. Schema version was 6002.

I will now do the update to the latest release and write the next message.

Cheers,
thomas

I now upgraded to beta5, database schema 6004.

I had a whole lot of warnings in the upgrade of this type:

# user warning: Unknown column 'md5' in 'field list' query: SELECT md5,cid FROM thomas_biblio_contributor_data in /homepages/46/d13406185/htdocs/thomas/drupal/modules/biblio/biblio.contributors.inc on line 284.
# user warning: Unknown column 'name' in 'field list' query: INSERT INTO thomas_biblio_contributor_data (name, lastname, firstname, prefix, suffix, initials, affiliation, md5) VALUES ('Thomas Deselaers', 'Deselaers', 'Thomas', '', '', '', '', '4a87ac45c5cd7ad9369f83c43d7aa4be') in /homepages/46/d13406185/htdocs/thomas/drupal/includes/common.inc on line 3303.

I only quickly checked my site and everything seems to be ok.

Cheers,
thomas

Given these errors, I think your database is still inconsistent, and will continue to generate errors. Best to get the latest -dev version (dated today) and export everything, uninstall, reinstall and reimport.

well, I was fearing such a solution.

The thing is that I uploaded all the PDF files and I would really not like to redo this.

Cheers, Thanks.
thomas

I added the new v6 to my dev site, but its Update Status remains "Not supported!"

This issue seems to have resolved itself. Please disregard.

@thomas (#20)

I could give you the SQL to fix it if you don't mind messing with the database manually.

Ron.

I am perfectly fine with changing the SQL directly.

However, how can I check whether everything is fine? Everything seems to be working fine.

thanks,
thomas

Ron,

I believe I found a thing that does not work properly in my site.

If I click a link of an author, no publications are found.

If you like, you can try yourself:

http://thomas.deselaers.de/biblio

So, I guess somewhere some update really failed.

Thanks.
thomas

Try this...

"ALTER TABLE biblio_contributor_data ADD `md5` varchar(32) default NULL;"
"ALTER TABLE biblio_contributor_data MODIFY COLUMN cid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT;"

after doing this check this table to see if there are any authors listed, if no change biblio schema_version in the system table back to 6003 and rerun update.php.

I tried that link but could not access it, got a 403 error. I did find something at http://thomas.deselaers.de/publications which looks like an older version? Also, since the attached files are not really attached to the nodes, but just linked through a linking table, it would probably be possible to modify that table to point to the new nodes if you were to uninstall and reinstall since all that really changed is the nid.

Ron,

I did what you suggested (and added a whole bunch of other columns (suffix, prefix, name) until the database upgrade succeeded. Now it looks better (I can click authors and get results)

But I am not sure whether everything else is fine.

In the last (before the break) development version there were additional field to enter the authors of a paper....
When I now click edit, I have one single field (like the old version) to enter all author information.

Is that right?

Can you give me a hint how I can determine what else might be broken? I am really fearing the export/import/fixing links action that you suggested. :-)

Oh, two more things:

1. Thanks a lot!
2. Sorry for the broken link.

cheers,
thomas

Again me:
I have now figured out that there is something still broken:

REading the node of a publication shows no authors,
Editing the authors of a node does not have any consquences.

The biblio_contributors_data table has entries which look ok to me, though.

Cheers,
thomas

I forgot you also need to do these...

"UPDATE biblio_fields SET name='biblio_contributors',type='contrib_widget' where fid=1 ;"
"DELETE FROM biblio_fields WHERE fid>1 AND fid<5 ;"

Then you should get the single line/ author widget back. The authors may not show up in the "classic node" view since I just fixed that last night and I don't think its been committed yet. If you are using "tabular node view" it should work though.

Ron.

One more observation:

adding new publications leads to publications with no authors at all.

I might consider the export/import thing after all.
Which export format is best? Do you have a suggestion to automatically get the links to the PDF files right?

Cheers,
thomas

OK.

I performed these additional steps, reran the update.php

and now I have the per-author fields.

However, when editing an old publication I get errors of this type:

* warning: Invalid argument supplied for foreach() in /homepages/46/d13406185/htdocs/thomas/drupal/includes/form.inc on line 1394.
* warning: Invalid argument supplied for foreach() in /homepages/46/d13406185/htdocs/thomas/drupal/includes/form.inc on line 1394.
* warning: Invalid argument supplied for foreach() in /homepages/46/d13406185/htdocs/thomas/drupal/includes/form.inc on line 1394.
* warning: Invalid argument supplied for foreach() in /homepages/46/d13406185/htdocs/thomas/drupal/includes/form.inc on line 1394.

Also, creating new publications leads to author-less entries (everywhere, in list view, in tabular view, in normal view and in edit-view).

Thanks, thomas

In theory you should just have to add a constant value to each of the node ids, the trick will be export them in the same order that they are saved (i.e. sorted by nid) assuming they were added sequentially without any other nodes in between (which is probably a bad assumption). Any way you look at it, it's going to get ugly :-(

The good news is that there shouldn't be any further catastrophic changes to the code :-)

Ron.

Well, that will never work.
I guess I typed in my entries in completely random order.

To me it sounds more suitable to extend the export-feature (btw. which export format do you recommend?) to give the PDF file link and then extend the import-feature analogously. That's ugly, too, though. ;-)

Frankly, I would much more like to fix the current version of the database... :-)

Interestingly, currently, the authors are displayed perfectly fine in the list view and in bibtex format.

Cheers,
thanks, thomas

and once again me: I am currently using the 6.x-1.0-beta5 version.

Do you think, I should better upgrade to the current dev version?

Cheers,
thomas

I have been browsing the database, and notices that the biblio_contributor_type table is empty.

I have then figured out (biblio.install) which values need to be in there and it seems to have solved quite some of the problems.

I will now look further into what problems I find.

Ron,

I believe that most things seem to be working ok now.

Two things that I noticed:

1. There are quite a few Author names which have a space at the beginning (when clicking edit for a paper)
2. if there are more than four authors, the paper is displayed fine, then I click edit, only 4 authors are displayed, if I then click "more authors" empty fields are added.
I can add authors there, and this is saved, but when I go to edit the next time, only the first 4 authors are there.

To me, this seems to be a bug which is probably not related to my database upgrade.

Cheers,
thomas (mostly happy ;-)

Definitely a bug, funny I was thinking I should test that very scenario yesterday since I knew that it hadn't been tested. I guess my question is answered now.

I'll try to fix that up later today.

Ron.

OK.
Although it is a bug for you, it is most probably good news for me... because that means I have converted my database from the `good old days' ;)

Thanks a lot.
Thomas

D6 version of biblio is released and in use.