You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by sn...@apache.org on 2006/02/10 16:52:37 UTC
svn commit: r376744 -
/incubator/roller/trunk/src/org/roller/business/utils/UpgradeDatabase.java
Author: snoopdave
Date: Fri Feb 10 07:52:36 2006
New Revision: 376744
URL: http://svn.apache.org/viewcvs?rev=376744&view=rev
Log:
Missing value in 2.1 upgrade method was causing error w/PostgreSQL
Modified:
incubator/roller/trunk/src/org/roller/business/utils/UpgradeDatabase.java
Modified: incubator/roller/trunk/src/org/roller/business/utils/UpgradeDatabase.java
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/src/org/roller/business/utils/UpgradeDatabase.java?rev=376744&r1=376743&r2=376744&view=diff
==============================================================================
--- incubator/roller/trunk/src/org/roller/business/utils/UpgradeDatabase.java (original)
+++ incubator/roller/trunk/src/org/roller/business/utils/UpgradeDatabase.java Fri Feb 10 07:52:36 2006
@@ -9,6 +9,7 @@
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
+import java.util.Date;
import org.roller.pojos.PermissionsData;
@@ -271,8 +272,8 @@
// insert a new template for a website
PreparedStatement insertWeblogTemplate = con.prepareStatement(
"insert into webpage"+
- "(id, name, description, link, websiteid, template) "+
- "values(?,?,?,?,?,?)");
+ "(id, name, description, link, websiteid, template, updatetime) "+
+ "values(?,?,?,?,?,?,?)");
// update the default page for a website
PreparedStatement updateDefaultPage = con.prepareStatement(
@@ -282,6 +283,7 @@
String description = "This template is used to render the main "+
"page of your weblog.";
ResultSet websiteSet = selectUpdateWeblogs.executeQuery();
+ Date now = new Date();
while (websiteSet.next()) {
String websiteid = websiteSet.getString(1);
String template = websiteSet.getString(2);
@@ -315,6 +317,7 @@
insertWeblogTemplate.setString( 4, "Weblog");
insertWeblogTemplate.setString( 5, websiteid);
insertWeblogTemplate.setString( 6, template);
+ insertWeblogTemplate.setDate( 7, new java.sql.Date(now.getTime()));
insertWeblogTemplate.executeUpdate();
// set the new default page id
@@ -380,3 +383,4 @@
}
}
}
+