By the way, at no point did I mean to insult Janra when I expressed out of frustration that following the SAG was what got me where I was. I appologize if any offense was taken, by anyone. Regards, Scott On 7/28/06, William Scott Lockwood III <wsl3 at lrsehosting.com> wrote: > > Yeah, I didn't do that. I'm going to roll back now. :-( > > > On 7/28/06, Rusty <rusty at kuro5hin.org> wrote: > > > > When you ran upgrade-db.pl, did you first do it using the patches in the > > 0.9-1.0/ directory, and then current/? It needs to be brought up from > > 0.9x to the 1.0 release first, and then from there up to the present. > > > > See > > http://scoop.kuro5hin.org/guide/2_6_Upgrading_Scoop.html#SECTION00026300000000000000 > > > > > > > > --R > > > > > > > > On Fri, 2006-07-28 at 12:40 -0500, William Scott Lockwood III wrote: > > > Heh - 0.9 something... > > > > > > On 7/28/06, Cory R. King <coryking at xlan.org > wrote: > > > Hey William, > > > > > > Sounds like you are having quite a party! > > > > > > Did the upgrade script barf on you? Did it get any errors > > > while it was > > > upgrading? > > > > > > Here is the highest database patches for 1.1.7: > > > > > > mysql> select max(patch_num), scoop_ver from patches group by > > > scoop_ver > > > order by scoop_ver; > > > +----------------+-----------+ > > > | max(patch_num) | scoop_ver | > > > +----------------+-----------+ > > > | 26 | 0_7-dev | > > > | 47 | 0_9-dev | > > > | 37 | 1_0-dev | > > > | 31 | 1_1-dev | > > > | 2 | 1_2-dev | > > > +----------------+-----------+ > > > > > > The highest patch number should match the highest patch number > > > > > in the > > > corresponding ./struct/patch-files/<scoop_ver> directory. > > > > > > If you have missing tables, you will need to look at scoop.sql > > > and copy > > > & paste the "CREATE TABLE"'s. This is risky because you don't > > > > > know what > > > else might have tanked. Some of the table schemas get altered > > > as part > > > of the upgrade as well. > > > > > > Since you are using a straight CVS checkout, all bets are off > > > for > > > workingness. Honestly you'd be safer going with a proper > > > release, not a > > > CVS checkout. If I was in your shoes, I'd roll back the > > > database and > > > start the upgrade again, only using 'scoop_1.1.7.tar.gz' > > > instead. > > > > > > How old of a build were you using anyway? > > > > > > Good luck! > > > > > > -- > > > Cory R. King > > > Mozi Media Group, LLC. > > > http://www.mozimedia.com > > > > > > > > > > > > William Scott Lockwood III wrote: > > > > It looks like some things were missed in the DB upgrade. Is > > > there a simple > > > > sql file somewhere I can import that will fix these things? > > > > > > > > <<ERROR>> << 208.47.211.203>> in db_select: Table > > > > 'guppylog_scoop.event_property_items' doesn't exist (Query > > > is SELECT * FROM > > > > event_property_items) : Error > > > in /usr/local/scoop/lib/Scoop.pm line 573 at > > > > /usr/local/scoop/lib/Scoop/DB.pm line 109. > > > > DBD::mysql::st fetchrow_hashref failed: fetch() without > > > execute() at > > > > /usr/local/scoop/lib/Scoop.pm line 578. > > > > DBD::mysql::st execute failed: Table > > > 'guppylog_scoop.calendars' doesn't > > > > exist at /usr/local/scoop/lib/Scoop/DB.pm line 103. > > > > <<ERROR>> <<208.47.211.203>> in db_select: Table > > > 'guppylog_scoop.calendars' > > > > doesn't exist (Query is SELECT * FROM calendars) : Error in > > > > /usr/local/scoop/lib/Scoop.pm line 603 > > > at /usr/local/scoop/lib/Scoop/DB.pm > > > > line 109. > > > > DBD::mysql::st fetchall_hashref failed: statement contains > > > no result [err > > > > was 4 now 1] > > > > Field 'cal_id' does not exist (not one of ) at > > > > /usr/local/scoop/lib/Scoop.pm > > > > line 607. > > > > [Fri Jul 28 09:54:44 2006] [error] [client 208.47.211.203] > > > File does not > > > > exist: /home/www/guppylog.com/public_html/loud.gif > > > > DBD::mysql::st execute failed: Table > > > 'guppylog_scoop.pref_items' doesn't > > > > exist at /usr/local/scoop/lib/Scoop/DB.pm line 103. > > > > <<ERROR>> <<208.47.211.203>> in db_select: Table > > > > 'guppylog_scoop.pref_items' > > > > doesn't exist (Query is SELECT * FROM pref_items) : Error in > > > > /usr/local/scoop/lib/Scoop.pm line 501 > > > at /usr/local/scoop/lib/Scoop/DB.pm > > > > line 109. > > > > DBD::mysql::st fetchrow_hashref failed: fetch() without > > > execute() at > > > > /usr/local/scoop/lib/Scoop.pm line 506. > > > > DBD::mysql::st execute failed: Table > > > 'guppylog_scoop.event_property_items' > > > > doesn't exist at /usr/local/scoop/lib/Scoop/DB.pm line 103. > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > _______________________________________________ > > > > Scoop-help mailing list > > > > Scoop-help at lists.kuro5hin.org > > > > http://lists.kuro5hin.org/mailman/listinfo/scoop-help > > > _______________________________________________ > > > Scoop-help mailing list > > > Scoop-help at lists.kuro5hin.org > > > http://lists.kuro5hin.org/mailman/listinfo/scoop-help > > > > > > > > > > > > -- > > > Regards, > > > Scott > > > _______________________________________________ > > > Scoop-help mailing list > > > Scoop-help at lists.kuro5hin.org > > > http://lists.kuro5hin.org/mailman/listinfo/scoop-help > > > > _______________________________________________ > > Scoop-help mailing list > > Scoop-help at lists.kuro5hin.org > > http://lists.kuro5hin.org/mailman/listinfo/scoop-help > > > > > > -- > Regards, > Scott > -- Regards, Scott -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.kuro5hin.org/pipermail/scoop-help/attachments/20060728/86c05c36/attachment.html