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 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.kuro5hin.org/pipermail/scoop-help/attachments/20060728/c4b953b3/attachment-0001.html