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