Closed (fixed)
Project:
Quotes
Version:
5.x-1.7
Component:
Upgrading
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
11 Sep 2008 at 18:06 UTC
Updated:
6 Oct 2008 at 16:23 UTC
First thanks for a great module. :)
I upgraded from this Quotes module:
// $Id: quotes.module,v 1.19 2007/02/14 15:28:35 jhriggs Exp $
It's the only information I can provide. It's from a backup of my installation and I don't have the correct version number.
But during upgrade I got some errors which I post here beneath. Most of which was concerning the Quotes module.
But during upgrade the Author field somehow was made smaller and I had the habit of entering a lot of text plus links, which has gotten deleted during the upgrade to 5.x-1.7 on Drupal 5.10. I have a backup of the tables, so I will be able to recreate most of the information at some point. Oddly enough it seems kind of random which quotes Author fields were made smaller.
Here are some common errors from the logs. There were a lot :/
Duplicate entry '<p><font size="1">PS' for key 2 query: INSERT INTO quotes_authors (name, bio) VALUES ('<p><font size=\"1\">PS', ', 22. juni 2006.</font>\r\n</p>') i /home/www/domain/includes/database.mysql.inc på linje 172.
error
----
http://www./update.php?op=do_update
Henvisning http://www./update.php?op=selection
Besked Duplicate entry '<p><font size="1">PS' for key 2 query: INSERT INTO quotes_authors (name, bio) VALUES ('<p><font size=\"1\">PS', ', 22. august 2006.</font>\r\n</p>') i /home/www/*.dk/includes/database.mysql.inc på linje 172.
error
-----
Placering http://www/update.php?op=do_update
Henvisning http://www./update.php?op=selection
Besked Duplicate entry 'ordsprog' for key 2 query: INSERT INTO quotes_authors (name, bio) VALUES ('ordsprog', '') i /home/www/*.dk/includes/database.mysql.inc på linje 172.
error
Comments
Comment #1
FlemmingLeer commentedOne example of the shortening in Author name:
In the original this was the text:
<strong>Uffe Østergaard</strong>, Professor ved Handelshøjskolen, København til <a href="http://www.information.dk/160830">Information</a> d. 14.-15. juni 2008This was in quotes_authors.name shortened to:
<strong>Uffe Østergaard</strong>,and the rest was gone :/Comment #2
nancydruThe stuff after the comma should have moved to the bio field. Can you check that, please?
When we added the capability to have an author's biography, many people had done as you and stuffed that into the author name field. The update code tried to find that stuff and move it to the bio field. Since I speak only English, my attempt to do that may not have been very good for you. So let's try to see how much damage there is and if it can be corrected or if we have to drop back and regroup.
BTW, 1.19 is the very first 5.x version and a lot has gone on since then, including 8 database changes.
Comment #3
nancydruComment #4
FlemmingLeer commentedHi,
I had a backup and I added the missing data to the author field manually. There were about 100 quotes, so it was not that bad.
Comment #5
nancydruSorry about that. Did you see if the extra stuff went into the bio field? Do I need to remove that code from the update?
Comment #6
FlemmingLeer commentedK, NancyDru np
No, the excess was not moved in to the bio field. I'm not a programmer, so I can't shed light on this issue. :/
Comment #7
nancydruWell, maybe I just need to be less nice and not "help" you move that stuff to the bio column.
Comment #8
nancydruFlemming, in a way I hate to do this. Since you have fixed your issue, some of which results from the big jump, and since no one else has reported this, I'm not inclined to change the update code. There have been two updates since that, and it's been quite a while.
I will leave this issue in the queue in case someone else has the same problem.
Comment #9
nancydru