<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div><span>On doing some more checking, it seems that hook_update_last_removed() was broken in 7.7, which the site is on. This is preventing the updates from running.<br></span></div><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><strong>Nancy</strong></i></font></div> <div><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span
style="font-weight:bold;">From:</span></b> David Metzler</font><br>
</div><br><div id="yiv1490712436"><div><div>I think it's this way. </div><div><br></div><div>-1 Never been updated or installed. </div><div>0 Once Installed, but the module never provided an update_nn hook, so no schema revision number applies. You shouldn't need to worry about these. </div><div>70xx Installed/updated. </div><div><br></div><div>What you do depends on your goal. If you categorically force an update to -1, remember that you'll be forcing the install hooks to fire. That means there are some create table scripts that are likely to fail. If the modules provide update hooks that haven't run yet, you could always force them to 0, but generally modules that </div><div><br></div><div>For live sites that you don't have access to the db: </div><div><br></div><div>1. Disable then uninstall and reinstall the modules to recreate their tables if any (provided the module provides
appropriate uninstall hooks and you can live with the data loss involved in dropping and recreating the tables). </div><div>2. If drush works on the hosting provider, try writing drush scripts to perform the db updates you need. </div><div>2. Write a custom one time use module to force the db changes that you need once you figure them out on your dev site. You could just write these in an empty modules install hook, but if you're having trouble with getting the update.php process to run you could put them in a callback hook advertised by the module. </div><div><br></div><div><br></div><div>Is there a particular underlying problem you're having with the upgrade that's causing you to be mucking with the system table? It might be easier to figure out what schema changes need to be made to fix your update problem and write a custom module to fix them. </div><div><br></div><div>Sounds like you're in the
soup...</div><div><br></div><div>Good luck, </div><div><br></div><div>Dave</div><div><br></div><div><br></div><div><br></div><br><div><div>On Mar 31, 2012, at 11:26 AM, Ms. Nancy Wichmann wrote:</div><br class="yiv1490712436Apple-interchange-newline"><blockquote type="cite"><div><div style="color:rgb(0, 0, 0);background-color:rgb(255, 255, 255);font-family:arial, helvetica, sans-serif;font-size:12pt;"><div><span>I see some issues related to update.php on a site I'm working on.</span><span> The site is currently 7.7 and I'm trying to get to 7.12.</span><span> I took a look at the system table and I see 44 modules that have a schema_version of "0". Shouldn't they be "-1" if they've never been updated, or "70xx" if they have?<br></span></div><div><span><br></span></div><div><span>Since the "alpha2alpha" and "alpha2beta" modules are present, I'm wondering if this goes back to very early versions of core. If so, is the fix to manually update them all to
"-1" and force an update to occur? And then how do I fix the live site when I don't have access to the database?<br></span></div><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><b>Nancy</b></i></font></div> <div><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></div></div></div></blockquote></div><br></div></div><br><br> </div> </div> </blockquote></div> </div></body></html>