[pLog-svn] Notification of required database changes

Mark Wu markplace at gmail.com
Wed Apr 5 14:24:50 GMT 2006


You mean this one? I think I miss this mail :P

Mark

================
I noticed an error in my sql log on 1.1, so I went through and compared all
of my tables to the wizard.  This is what I found:

plog_articles:
category_id int(10) unsigned NOT NULL default '0'
is not added on upgrade, only new install.


plog_articles_comments:
   properties TEXT NOT NULL DEFAULT '',
is not added on upgrade, only new install

plog_blogs:
| properties       | text             |      |     |                     | 
| custom_domain    | varchar(50)      | YES  |     | NULL                | 
My db has a properties field, this is supposed to be gone, so we should
erase it when installing 1.1?
I will add the custom_domain, I only added it on upgrade, not on new
install.


plog_gallery_resources:
  file_size int(20) not null default 0;
  properties TEXT NOT NULL DEFAULT '';
These are not in my 1.0 install


DB questions:

plog_host_blocking_rules:
should this be in the wizard??  It is a plugin now, right?

plog_filtered_content:
I don't know what this is, is it used?



_______________________________________________
pLog-svn mailing list
pLog-svn at devel.lifetype.net
http://devel.lifetype.net/mailman/listinfo/plog-svn

==============
 

> -----Original Message-----
> From: plog-svn-bounces at devel.lifetype.net 
> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of Jon Daley
> Sent: Wednesday, April 05, 2006 9:39 PM
> To: plog-svn at devel.lifetype.net
> Subject: RE: [pLog-svn] Notification of required database changes
> 
> On Wed, 5 Apr 2006, Mark Wu wrote:
> > I think it is because there is no lt_trackbacks table in 
> 1.1. When I 
> > click next, it will go back to step one again.
>  	I forget if I wrote about this the other day - is this 
> table removed on an upgrade?  It wasn't before the schema changes.
> 
>  	Actually, I don't think anyone responded to my email 
> the other day of all the differences my install has from the default.
> 
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn



More information about the pLog-svn mailing list