Updating the metaseo helped. Thanks. On Thu, Dec 3, 2009 at 1:31 PM, rick c <[email protected]> wrote: > 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 >
-- 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
