upgrading from 0.6 to 0.7 -> issues

[vossi]

hi,

i just updated my blog at http://www.vossi.at from 0.6 to 0.7 to gain spam protection.

no i have 2 issues with the new version:

first, all my smilies and images are gone, they aren't shown and in the source code the <img src""> is empty .. dunno where to start searching for this

the second is that i deleted some comments in phpmyadmin and the comment count for each entry is now wrong.
is there a easy way to reset them or do i have to figure out on my own in SQL ?


tia for ur time and hope someone can help me, cos i really like s9y

[garvinhicking]

The NEWS file says this in the notes:

* Moved smilies/xml buttons to template directory (img/) to be
customized per-template (garvinhicking)

The "new" way of having smilies implemented is documented here: http://www.s9y.org/44.html#A29

To fix the comment count, you need to edit your serendipity_entries table there as well for the entry. With MySQL 4.1/PgSQL you could use a nifty subselect to put the right comment count into each field:

Code: Select all

UPDATE serendipity_entries 
   SET serendipity_entries.comments = 
       (SELECT count(serendipity_comments.id) as ccount 
          FROM serendipity_comments
         WHERE serendipity_comments.entry_id = serendipity_entries.id)

HTH, and have fun!

Regards,
Garvin

[vossi]

ok smilies work now but the images inside the author-interface and the s9y icon @ right bottom is not here

---

bout the sql query .. no i got mysql 4 .. so it doesn't take subselects .. i have to make a lil' workaround script that i will post here then.

[vossi]

ok fixed the comment count issue with a DIIIRRRRRRRRTY trick.
have a local mysql 4.1 db -> export online -> import local -> run query local -> export local -> import online

hrhrhr

so the only thing what's missing are the friggin images everywhere (except the smilies)

nice help until yet .. i love you guys

[garvinhicking]

Hm, did you make sure that you extracted ALL the files from the latest release? Seems there are images really missing...

What's your URL?

Regards
Garvin

[vossi]

www.vossi.at

thought i have extracted everything

[garvinhicking]

Hm, it really looks like there are files missing from folder templates/default/img and/or templates/default/admin/img - can you please check for them? At least the file with the s9y "powered by" logo should be ther?!

Regards,
Garvin

[vossi]

the default files where missing .. everything ok now

thanks 1000times for helping me out .. i know i am a lazy fool but u saved my day

keep up the good work, s9y roxx

[garvinhicking]

No problem, great it solved the issue.

Have fun at JoWood; seems like you got a cool job, I always wanted to be a gaming beta-tester.

Regards,
Garvin

[vossi]

i'll let you know if we're searching for beta-testers

there is only 1 issue left .. how the heck can i make a trackback .. eg.

i have a entry that i updated my blog (http://vossi.at/index.php?/archives/36- ... pdate.html) and i want to have a trackback to my first post on the blog (http://vossi.at/index.php?/archives/1-Blog-online.html)

do i have to link it in my post ? no plan sorry

[garvinhicking]

Hi vossi!

i'll let you know if we're searching for beta-testers

You do that

there is only 1 issue left .. how the heck can i make a trackback .. eg.

According to our documentation available at http://www.s9y.org/48.html *g* that's right. Just make a link to your full entry, the trackback will then happen automatically.

Regards,
Garvin

[vossi]

would be cool to have something like a "related links" plugin .. don't know if something like that exists. but i'll also be cool to add them by hand.

thx a lot