[pLog-svn] Notification of required database changes

Jon Daley plogworld at jon.limedaley.com
Wed Apr 5 14:29:27 GMT 2006


 	Yes.

On Wed, 5 Apr 2006, Mark Wu wrote:

> 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
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>

**************************************
Jon Daley
http://jon.limedaley.com/

A nuclear war can ruin your whole day.


More information about the pLog-svn mailing list