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