Re: [aur-general] AUR Maintenance

2013-03-03 Thread Phillip Smith
On 1 March 2013 15:07, Connor Behan connor.be...@gmail.com wrote: Except that line there is 161 characters and contains two comments (one comment deleted by its poster about Ruby and one non-deleted comment about GNOME). The line in the real file is a million characters and contains ~20k

Re: [aur-general] AUR Maintenance

2013-03-03 Thread Martti Kühne
On 3/3/13, Phillip Smith li...@fukawi2.nl wrote: While it is a lot of data, I agree that it shouldn't be that difficult to recover. What am I missing? Any chance those of us who aren't TU's can get access to the file? I also came close to that question, which indeed is kind of obvious.

Re: [aur-general] AUR Maintenance

2013-03-01 Thread Martti Kühne
On Fri, Mar 1, 2013 at 5:07 AM, Connor Behan connor.be...@gmail.com wrote: [...] INSERT INTO `PackageComments` VALUES (17,46,68,'ruby bindings for fastcgi',1113164127,68),(28,69,65,'A countdown timer applet for the GNOME panel.',1113178883,0); Except that line there is 161 characters and

Re: [aur-general] AUR Maintenance

2013-03-01 Thread Connor Behan
On 01/03/13 06:02 AM, Martti Kühne wrote: On Fri, Mar 1, 2013 at 5:07 AM, Connor Behan connor.be...@gmail.com wrote: [...] INSERT INTO `PackageComments` VALUES (17,46,68,'ruby bindings for fastcgi',1113164127,68),(28,69,65,'A countdown timer applet for the GNOME panel.',1113178883,0);

Re: [aur-general] AUR Maintenance

2013-02-28 Thread Florian Pritz
On 28.02.2013 07:14, Connor Behan wrote: I was stupid enough not to make a backup so can someone with access please put this on nymeria? Thank-you. I've put it in your home on nymeria. You're lucky SevenL didn't yet shut down sigurd. signature.asc Description: OpenPGP digital signature

Re: [aur-general] AUR Maintenance

2013-02-28 Thread Connor Behan
On 28/02/13 01:54 PM, Phillip Smith wrote: I'd be willing to try and assist with this too. What is the format of that backup file? It is a 46MB text file of SQL commands; the kind you would get by running mysqldump. It only has 462 lines, but some of them are very long. The important lines are

[aur-general] AUR Maintenance

2013-02-27 Thread Connor Behan
Some of you may remember the lost comments fiasco of 2010. When this happened, a file on sigurd was created aur-20100205-1859.sql.fixed2.xz with AUR comments that had been lost. I volunteered (on the mailin list) to help manually restore them to the AUR [1]. Since I did not know SQL or how to

[aur-general] AUR maintenance works

2011-11-27 Thread Lukas Fleischer
Some of you might have noticed that the AUR has been in maintenance mode for the last three hours. We did a full backup of the server and prepared everything for a drive replacement that is scheduled for tomorrow, 28. Nov 2011. The server might be down again tomorrow for a couple of minutes.

[aur-general] AUR Maintenance

2010-09-19 Thread Loui Chang
I'm going to be updating the AUR in the next few minutes. Don't be alarmed. Please stand by.

Re: [aur-general] AUR Maintenance

2010-09-19 Thread Loui Chang
On Sun 19 Sep 2010 20:24 -0400, Loui Chang wrote: I'm going to be updating the AUR in the next few minutes. Don't be alarmed. Please stand by. Should be good now. Let me know if there are any issues. Cheers.

Re: [aur-general] AUR Maintenance

2010-09-19 Thread Thomas Dziedzic
On Sun, Sep 19, 2010 at 8:09 PM, Loui Chang louipc@gmail.com wrote: On Sun 19 Sep 2010 20:24 -0400, Loui Chang wrote: I'm going to be updating the AUR in the next few minutes. Don't be alarmed. Please stand by. Should be good now. Let me know if there are any issues. Cheers. There are

Re: [aur-general] AUR Maintenance

2010-09-19 Thread Loui Chang
On Sun 19 Sep 2010 20:40 -0500, Thomas Dziedzic wrote: On Sun, Sep 19, 2010 at 8:09 PM, Loui Chang louipc@gmail.com wrote: On Sun 19 Sep 2010 20:24 -0400, Loui Chang wrote: I'm going to be updating the AUR in the next few minutes. Don't be alarmed. Please stand by. Should be good

Re: [aur-general] AUR Maintenance

2010-09-19 Thread Hilton Medeiros
On Sun, 19 Sep 2010 20:40:23 -0500 Thomas Dziedzic gos...@gmail.com wrote: On Sun, Sep 19, 2010 at 8:09 PM, Loui Chang louipc@gmail.com wrote: On Sun 19 Sep 2010 20:24 -0400, Loui Chang wrote: I'm going to be updating the AUR in the next few minutes. Don't be alarmed. Please stand by.

Re: [aur-general] AUR Maintenance

2010-05-12 Thread Slash
On Mon, May 3, 2010 at 6:53 PM, Loui Chang louipc@gmail.com wrote: Hah. Thanks for your enthusiasm, but it wouldn't be very effective to go through it manually. Most of the scrambled strings are in languages other than English, and it would take waay too much work. I do plan on restoring

Re: [aur-general] AUR Maintenance

2010-05-03 Thread Loui Chang
On Fri 30 Apr 2010 22:04 -0400, Connor Behan wrote: I read in the archives that comments were 95% repaired by Firmicus and the copy with a few illegal characters is: /home/francois/aur-20100205-1859.sql.fixed2.xz on a server to which I do not yet have access. Since the comments are not back, I

[aur-general] AUR Maintenance

2010-04-30 Thread Connor Behan
I read in the archives that comments were 95% repaired by Firmicus and the copy with a few illegal characters is: /home/francois/aur-20100205-1859.sql.fixed2.xz on a server to which I do not yet have access. Since the comments are not back, I gather there is more to be done. Could I please go

Re: [aur-general] AUR Maintenance

2010-04-30 Thread Farhan Yousaf
I can help out as well, though I am not a trusted user so I wonder how much I can really help. But my offer is there. :) On 2010-04-30, at 10:04 PM, Connor Behan wrote: I read in the archives that comments were 95% repaired by Firmicus and the copy with a few illegal characters is:

Re: [aur-general] AUR Maintenance

2010-03-30 Thread Allan McRae
So... is there an official word about what is the final decision on restoring these? Is it still being investigated how to fix this or it just being left? Allan

Re: [aur-general] AUR Maintenance

2010-03-29 Thread Pierre Schmitz
Am Montag, 29. März 2010 01:21:09 schrieb Allan McRae: Is there any progress on fixing this? There are a lot of packaging notes on those pages that would be a shame to lose. It's very likely the same issue I had updating the wiki. This is caused by a mysql packaging change which switched the

Re: [aur-general] AUR Maintenance

2010-03-29 Thread Firmicus
On 29/03/2010 09:00, Pierre Schmitz wrote: Am Montag, 29. März 2010 01:21:09 schrieb Allan McRae: Is there any progress on fixing this? There are a lot of packaging notes on those pages that would be a shame to lose. I did it last Thursday. I've done my best to repair the mysql

Re: [aur-general] AUR Maintenance

2010-03-24 Thread Firmicus
On 23/03/2010 22:24, Loui Chang wrote: On Tue 23 Mar 2010 16:51 -0400, Daenyth Blank wrote: On Tue, Mar 23, 2010 at 16:43, Loui Changlouipc@gmail.com wrote: It may be possible to restore most of the old comments, but that's something that we'd have to look into later.

[aur-general] AUR Maintenance

2010-03-23 Thread Loui Chang
Hello everyone! I'm going to look into fixing some issues with the AUR right now. Please don't be alarmed if the site isn't working for a little while.

Re: [aur-general] AUR Maintenance

2010-03-23 Thread Loui Chang
On Tue 23 Mar 2010 15:09 -0400, Loui Chang wrote: Hello everyone! I'm going to look into fixing some issues with the AUR right now. Please don't be alarmed if the site isn't working for a little while. I've deleted existing comments from the AUR. I ran into a problem juggling the encodings,

Re: [aur-general] AUR Maintenance

2010-03-23 Thread Xavier Chantry
On Tue, Mar 23, 2010 at 9:43 PM, Loui Chang louipc@gmail.com wrote: On Tue 23 Mar 2010 15:09 -0400, Loui Chang wrote: Hello everyone! I'm going to look into fixing some issues with the AUR right now. Please don't be alarmed if the site isn't working for a little while. I've deleted

Re: [aur-general] AUR Maintenance

2010-03-23 Thread Daenyth Blank
On Tue, Mar 23, 2010 at 16:43, Loui Chang louipc@gmail.com wrote: It may be possible to restore most of the old comments, but that's something that we'd have to look into later. What's needed for this, and what ways could someone contribute?

Re: [aur-general] AUR Maintenance

2010-03-23 Thread Loui Chang
On Tue 23 Mar 2010 16:51 -0400, Daenyth Blank wrote: On Tue, Mar 23, 2010 at 16:43, Loui Chang louipc@gmail.com wrote: It may be possible to restore most of the old comments, but that's something that we'd have to look into later. What's needed for this, and what ways could someone

Re: [aur-general] AUR Maintenance

2010-03-23 Thread Loui Chang
On Tue 23 Mar 2010 21:51 +0100, Xavier Chantry wrote: On Tue, Mar 23, 2010 at 9:43 PM, Loui Chang louipc@gmail.com wrote: On Tue 23 Mar 2010 15:09 -0400, Loui Chang wrote: Hello everyone! I'm going to look into fixing some issues with the AUR right now. Please don't be alarmed if the

Re: [aur-general] AUR Maintenance

2010-03-23 Thread Xavier Chantry
On Tue, Mar 23, 2010 at 10:39 PM, Loui Chang louipc@gmail.com wrote: I'm not sure how much value is in the old comments, but it's not worth keeping the AUR locked down while I try to figure it out. I would say there are 90% of crap and 10% that would be a shame to lose :) I hope someone

Re: [aur-general] AUR Maintenance

2010-03-23 Thread Daenyth Blank
On Tue, Mar 23, 2010 at 17:41, Xavier Chantry chantry.xav...@gmail.com wrote: I would say there are 90% of crap and 10% that would be a shame to lose :) I hope someone more knowledgeable about mysql/encoding/sysadmin can help. I might throw up an announcement on the forums that they've been