As Michael implied in asking what plugins are active, the most likely source of the errors is either a plugin or a function in your theme's theme.php. One of these appears to using direct database ask through SQL to get the tag you want, and needs to be updated to use the correct tables. The tags and tag2post tables are no longer used. Instead, terms and object_terms are used. We'd be happy to help correct these, or you can look in the trunk version of the metaseo plugin or the built-in theme, Charcoal's theme.php for examples of proper usage.
Rick On Dec 3, 5:29 am, Balazs Koren <[email protected]> wrote: > 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 > >> athttp://groups.google.com/group/habari-users > > > -- > >http://kobak.org > >http://fotolog.hu > > --http://kobak.orghttp://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
