My log after the upgrade is full of these errors:

PDOStatement::execute(): SQLSTATE[42000]: Syntax error or access
violation: 1064 You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '} where tag_slug= 'app'' at line 1 in s...

Everything else lokks like working fine.

Balazs

On Wed, Nov 25, 2009 at 10:46 PM, Balazs Koren <[email protected]> wrote:
> Great news! Thanks, I'll try it tomorrow.
>
> Balazs
>
> On Wed, Nov 25, 2009 at 4:59 PM, rick c <[email protected]> wrote:
>> For anyone using the development version of Habari:
>>
>> As you may know, one of the goals for Habari 0.7 is to implement
>> taxonomy. One aspect of this is implementing tags as terms in a tags
>> vocabulary. We've been working on this in a branch. It now seems to be
>> at a usable state, so the changes were merged into trunk in r3829 and
>> r3830. The code needs some love yet, but maybe with it in trunk, it
>> will get more.
>>
>> As with all major updates, I'd recommend backing up your db before
>> doing svn up. The update should be seamless, moving your tags and
>> tag2post tables into the terms and object_terms tables respectively.
>> The tags and tag2posts tables are *not* deleted. They are still in
>> your database, but they are no longer registered.
>>
>> One unavoidable side effect of this change is that any plugins or
>> themes that use direct access to the database to get tags will need to
>> be updated to use the new table structure. In other words, until they
>> are updated they will break. If the plugin or theme uses the api
>> rather than direct database access, it should be okay. One possible
>> common instance is
>>
>> $tags = DB::get_results( 'SELECT * FROM ' . DB::table('tags') );
>>
>> This will no longer work. Instead use
>>
>> $tags = Tags::get();
>>
>> More complex SQL will still require SQL. The new SQL will be more
>> complex than what you are using now. See the post on this subject to
>> the -dev list for more details
>>
>> http://groups.google.com/group/habari-dev/t/c62e38ed828093dc
>>
>> One other change, we tried to make tags something that isn't limited
>> to posts, so in the future, if this was done right, plugin authors
>> will be able to tag other object types that may be added.
>>
>> Rick
>>
>> --
>> To post to this group, send email to [email protected]
>> To unsubscribe from this group, send email to 
>> [email protected]
>> For more options, visit this group at 
>> http://groups.google.com/group/habari-users
>>
>
>
>
> --
> http://kobak.org
> http://fotolog.hu
>



-- 
http://kobak.org
http://fotolog.hu

-- 
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/habari-users

Reply via email to