Menu
▾
▴
slashcode-general
|
From: dan f. <fl...@xm...> - 2001-05-11 05:53:20
|
A few questions, I have been RTFM'ing BTW. I had started out with plans to upgrade my site to Slash 2.0.0 , but thanks to a SCSI drive scuttling on me, it looks like I'm going to install a new clean 2.0.0 site, then work to get my old database upgraded to work with the new site. Anyways, I had a few questions: Is there any more documentation for the slash1toslash2 script? Something was goofy with my existing DB, and the script fails near the end. I had a clean initialized DB for 2.0.0, and an unaltered DB for my old 1.0.9 Slashsite. A little persistence may fix this, but are there any common problems I should be aware of? I had no problem creating the database from backup. Though I'm wondering if there is a quicker way. Using 'mysql -u blah -p blah < slashdb.dump' takes forever. Concerning httpd.conf, are there any examples available? I know to include the .conf file in the new slash distribution. It seems simple enough, but it would help to see some examples; especially since I do not want to run my site on a virtual host. Any and all help will be greatly appreciated.. thanks... /dan flickinger http://sos.asuu.utah.edu -- One future, two choices. Oppose them or let them destroy us. |
|
From: Alvaro d. C. <ac...@ba...> - 2001-05-11 06:57:51
|
El 10 May 2001 23:53:11 -0600, dan flickinger escribió: > A few questions, I have been RTFM'ing BTW. > > I had started out with plans to upgrade my site to Slash 2.0.0 , but thanks > to a SCSI drive scuttling on me, it looks like I'm going to install a new > clean 2.0.0 site, then work to get my old database upgraded to work with the > new site. > > Anyways, I had a few questions: > > Is there any more documentation for the slash1toslash2 script? Something was > goofy with my existing DB, and the script fails near the end. I had a clean > initialized DB for 2.0.0, and an unaltered DB for my old 1.0.9 Slashsite. A > little persistence may fix this, but are there any common problems I should > be aware of? I had no problem creating the database from backup. Though I'm > wondering if there is a quicker way. Using 'mysql -u blah -p blah < > slashdb.dump' takes forever. perldoc slash1toslash2 Good luck! -- Alvaro > > Concerning httpd.conf, are there any examples available? I know to include > the .conf file in the new slash distribution. It seems simple enough, but it > would help to see some examples; especially since I do not want to run my > site on a virtual host. > > Any and all help will be greatly appreciated.. > > thanks... > > /dan flickinger > http://sos.asuu.utah.edu > > -- > One future, two choices. Oppose them or let them destroy us. > > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > http://lists.sourceforge.net/lists/listinfo/slashcode-general > |
|
From: dan f. <fl...@xm...> - 2001-05-11 08:40:11
|
On Friday 11 May 2001 00:46, it was said: > perldoc slash1toslash2 -- Thanks, but I already read that. It was not much help for my problem. /dan Also, anyone have the quick way to create a new database user with proper access? It's late at night here and I can't find what I'm looking for. If you couldn't tell, I'm a bit rusty on my db-admin skills. I created two blank databases, slash and oldslash using the commands: create database slash; and create database oldslash; from within mysql. I can connect to the server as root from localhost with a password, but I can't seem to get any other users proper access. I created a user called slash, but I cannot get this user to access either one of the new slash db's. Now why the hell did I even decide to upgrade my site? Anyways, thanks everyone in advance for the help... /Dan Flickinger -- One future, two choices. Oppose them or let them destroy us. |
|
From: Chris N. <pu...@po...> - 2001-05-11 13:28:34
|
At 23:53 -0600 2001.05.10, dan flickinger wrote: >Is there any more documentation for the slash1toslash2 script? What is it you need to know? >Something was >goofy with my existing DB, and the script fails near the end. Failed how? >Concerning httpd.conf, are there any examples available? I know to include >the .conf file in the new slash distribution. It seems simple enough, but it >would help to see some examples; especially since I do not want to run my >site on a virtual host. Include FILENAME Then go into the SITENAME.conf file and remove the VirtualHost directives. -- Chris Nandor pu...@po... http://pudge.net/ Open Source Development Network pu...@os... http://osdn.com/ |
|
From: dan f. <fl...@xm...> - 2001-05-11 18:46:39
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Friday 11 May 2001 07:23, you said: > At 23:53 -0600 2001.05.10, dan flickinger wrote: > >Is there any more documentation for the slash1toslash2 script? > > What is it you need to know? > Failed how? During or right after proccessing the stories table: *** Processing stories DBD::mysql::db do failed: Column 'uid' cannot be null at ./slash1toslash2 line 378, <STDIN> line 3. Column 'uid' cannot be null at ./slash1toslash2 line 380, <STDIN> line 3. *** Is this a clear indication of a corrupted old database? AFAIK, the db is an unaltered dump from last night. Has this problem been encountered before? I've now got a site that's slowly coming together -- like that damn mummy.. it's an ugly, dusty, stringy skeleton of a slash site. :) ( http://sos.asuu.utah.edu ) If you look around, you'll see that I have most/all of the comments back; I assume that I have all of my users back, but I can't search past UID 31.. though I verified that newer users do exist. Any specific reason why admin.pl redirects to users.pl? I cannot login as an admin or as a user to the site. > Include FILENAME > > Then go into the SITENAME.conf file and remove the VirtualHost directives. That worked just fine. Thanks.... /Dan Flickinger - -- One future, two choices. Oppose them or let them destroy us. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE6/DNidy7WYyZcw2kRAj60AJ9wfQtZnXNx+v6Tokl4aHbIBwj1ywCgk8/O CUEhYjBbLFAa9+EBrYzKi30= =fEfC -----END PGP SIGNATURE----- |
|
From: Chris N. <pu...@po...> - 2001-05-11 19:36:20
|
At 12:45 -0600 2001.05.11, dan flickinger wrote: >During or right after proccessing the stories table: > >*** >Processing stories >DBD::mysql::db do failed: Column 'uid' cannot be null at ./slash1toslash2 >line 378, <STDIN> line 3. >Column 'uid' cannot be null at ./slash1toslash2 line 380, <STDIN> line 3. >*** > >Is this a clear indication of a corrupted old database? As far as I can tell, it is not a clear indication of anything. Did you ever get this message in the program? Found stories lacking authors, select a uid to assign them to: It looks to me like some stories didn't have a proper aid/uid assigned to them. If this is the case, and the code is for some reason not working properly, you could change this line: my $null_uid = null_stories($story_authors); To this: my $null_uid = 2; It might do the trick. -- Chris Nandor pu...@po... http://pudge.net/ Open Source Development Network pu...@os... http://osdn.com/ |
|
From: dan f. <fl...@xm...> - 2001-05-11 19:48:48
|
On Friday 11 May 2001 13:34, you said: > At 12:45 -0600 2001.05.11, dan flickinger wrote: > >During or right after proccessing the stories table: > > > >*** > >Processing stories > >DBD::mysql::db do failed: Column 'uid' cannot be null at ./slash1toslash2 > >line 378, <STDIN> line 3. > >Column 'uid' cannot be null at ./slash1toslash2 line 380, <STDIN> line 3. > >*** > > > >Is this a clear indication of a corrupted old database? > > As far as I can tell, it is not a clear indication of anything. > > Did you ever get this message in the program? > > Found stories lacking authors, select a uid to assign them to: No. This message did not occur. > It looks to me like some stories didn't have a proper aid/uid assigned to > them. If this is the case, and the code is for some reason not working > properly, you could change this line: > > my $null_uid = null_stories($story_authors); > > To this: > > my $null_uid = 2; > > It might do the trick. I don't think I have any stories with no authors, but I have one problem. The second story on the site (about a tuition increase) .. one of my new authors manually changed the date of the story instead of using the 'fast forward' checkbox. This miffed me when the story lost over half of it's comments when the comments archived two months later into oblivion. Could this create a problem. No stories were restored after this one. /Dan Flickinger -- One future, two choices. Oppose them or let them destroy us. |
|
From: dan f. <fl...@xm...> - 2001-05-12 02:27:37
|
On Friday 11 May 2001 13:34, you said: > my $null_uid = null_stories($story_authors); > > To this: > > my $null_uid = 2; > > It might do the trick. Sorry, it did not. It gave me a new error: After prompting to ask if I want to delete uid 2, the script fails with this message: *** Can't call method "do" on an undefined value at ./slash1toslash2 line 74, <STDIN> line 3. *** I checked if I had any null values for aid in the stories table, and there were none. After double checking, I found that I had one story by an author that doesn't exist anymore. So I changed that story to an existing author. I'm still having a problem with the slash1toslash2 script dying during/after proccessing the stories table. thanks for the help... /dan -- One future, two choices. Oppose them or let them destroy us. |
|
From: Nathan V. <na...@th...> - 2001-05-12 04:08:32
|
On that line slash1toslash2 is trying to set the anonymous_coward_uid variable in the vars table. Did you answer the second question correctly? (I've only tried it with 1). Have a good weekend... On Fri, 11 May 2001, dan flickinger wrote: > On Friday 11 May 2001 13:34, you said: > > > my $null_uid = null_stories($story_authors); > > > > To this: > > > > my $null_uid = 2; > > > > It might do the trick. > > Sorry, it did not. It gave me a new error: > > After prompting to ask if I want to delete uid 2, the script fails with this > message: > *** > Can't call method "do" on an undefined value at ./slash1toslash2 line 74, > <STDIN> line 3. > *** > > I checked if I had any null values for aid in the stories table, and there > were none. After double checking, I found that I had one story by an author > that doesn't exist anymore. So I changed that story to an existing author. > > I'm still having a problem with the slash1toslash2 script dying during/after > proccessing the stories table. > > thanks for the help... > > /dan > > |
|
From: dan f. <fl...@xm...> - 2001-05-12 05:06:12
|
On Friday 11 May 2001 22:08, you said: > On that line slash1toslash2 is trying to set the anonymous_coward_uid > variable in the vars table. Did you answer the second question correctly? > (I've only tried it with 1). I try to set it as UID 14. That's the lowest UID I have that is more or less unused. I know the account owner, and he doesn't want the account anymore.. besides that, the account has never posted, so there shouldn't be any conflict. It seems that if I choose a user with comments in the database, all of the anonymous comments become owned by that account. It's not much of an issue anyways, since the Vice President of Student Affairs at the University of Utah mandates that I DO NOT allow anonymous posting. I disobey the administration and not only do I find myself without a site within a few hours, but I find myself facing expulsion before the student behavioral committee. They have made it very clear that they have zero tolerance for my reckless lawsuit magnet, AKA-- SOS. Making crapflooders sign up for accounts gives them a false sense of security, so ..oh well. In the end, I went back to the unmodified script, since I wasn't encountering a problem with stories with null aid's. I'm hopefully getting close to a solution. I'm debating on dumping the stories out of the database and transfering them to the new database. Half of my authors are missing, even though I set all of the aid's to correspond with a nickname in the users table. I set the matchname's too .. but should I set these to all lowercase with no spaces? (I.E. Sleepless Student --> sleeplessstudent) Of particular interest, I originally changed the passwords of all default uid's 1 - 6 when I installed slash, but I decided to make uid 1 my account a little late in the game. I was originally #9 as flikx. flikx(9) became flikx.(9), (notice the '.' just like Bruce Perens.)and author1 became flikx(1). I didn't think this affected anything, but I'm having doubts now. > Have a good weekend... Yeah, thanks. I try. /Dan Flickinger -- One future, two choices. Oppose them or let them destroy us. |
|
From: Chris N. <pu...@po...> - 2001-05-17 20:16:42
|
At 23:06 -0600 2001.05.11, dan flickinger wrote: >It's not much of an issue anyways, since the Vice President of Student >Affairs at the University of Utah mandates that I DO NOT allow anonymous >posting. I disobey the administration and not only do I find myself without a You still need an anonymous user, for when people view the site before logging in. -- Chris Nandor pu...@po... http://pudge.net/ Open Source Development Network pu...@os... http://osdn.com/ |
|
From: dan f. <fl...@xm...> - 2001-05-17 23:56:20
|
On Thursday 17 May 2001 14:12, you said: > At 23:06 -0600 2001.05.11, dan flickinger wrote: > >It's not much of an issue anyways, since the Vice President of Student > >Affairs at the University of Utah mandates that I DO NOT allow anonymous > >posting. I disobey the administration and not only do I find myself > > without a > > You still need an anonymous user, for when people view the site before > logging in. Yeah, I gathered that after a little research. I never tried operating the site without an anonymous user in the first place. thanks... /dan -- One future, two choices. Oppose them or let them destroy us. |
|
From: Nathan V. <na...@th...> - 2001-05-11 19:49:08
|
On Fri, 11 May 2001, dan flickinger wrote: > > Failed how? > > During or right after proccessing the stories table: > > *** > Processing stories > DBD::mysql::db do failed: Column 'uid' cannot be null at ./slash1toslash2 > line 378, <STDIN> line 3. > Column 'uid' cannot be null at ./slash1toslash2 line 380, <STDIN> line 3. > *** You need to carefully follow the instructions in the slash1toslash2 POD about preparing users and authors in your old database. Also if you've changed an author's or user's name/nickname like I did make sure to update the matchname column too. And make sure all your old stories have aids that exist. Good luck, nathan -- Nathan Vonnahme na...@th... senior web developer third sector technologies http://enteuxis.org/nathan http://thethirdsector.com |
|
From: dan f. <fl...@xm...> - 2001-05-11 20:20:20
|
On Friday 11 May 2001 13:48, you said: > On Fri, 11 May 2001, dan flickinger wrote: > > > Failed how? > > > > During or right after proccessing the stories table: > > > > *** > > Processing stories > > DBD::mysql::db do failed: Column 'uid' cannot be null at ./slash1toslash2 > > line 378, <STDIN> line 3. > > Column 'uid' cannot be null at ./slash1toslash2 line 380, <STDIN> line 3. > > *** > > You need to carefully follow the instructions in the slash1toslash2 > POD about preparing users and authors in your old database. > > Also if you've changed an author's or user's name/nickname like I did make > sure to update the matchname column too. > > And make sure all your old stories have aids that exist. > > Good luck, > nathan I did that, but I may have missed something. I'll double check and give it another shot. Seems like running install-slashsite again will reinitialize everything on the new site for me. Am I right? It seems like I'm working close to getting a solution. Any other suggestions are more than welcome. thanks.. /Dan Flickinger -- One future, two choices. Oppose them or let them destroy us. |
|
From: Nathan V. <na...@th...> - 2001-05-11 20:40:07
|
On Fri, 11 May 2001, dan flickinger wrote: > Seems like running install-slashsite again will reinitialize everything on > the new site for me. Am I right? I've been dropping and creating the new database before running install-slashsite just to be sure. > It seems like I'm working close to getting a solution. Any other suggestions > are more than welcome. I've gone through the process successfully twice in the last couple of days. It was the user/author stuff that got me both times. Good luck! -n |
Thanks for helping keep SourceForge clean.
X