Page 1 of 1

upgrading from 0.6 to 0.7 -> issues

Posted: Sat Jan 29, 2005 2:10 am
by 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

Re: upgrading from 0.6 to 0.7 -> issues

Posted: Sat Jan 29, 2005 2:19 pm
by 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

Posted: Sat Jan 29, 2005 8:18 pm
by 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.

Posted: Sun Jan 30, 2005 3:18 am
by 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 :)

Posted: Sun Jan 30, 2005 7:11 pm
by 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

Posted: Sun Jan 30, 2005 9:32 pm
by vossi
www.vossi.at

thought i have extracted everything :(

Posted: Sun Jan 30, 2005 9:44 pm
by 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

Posted: Mon Jan 31, 2005 4:07 am
by 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 :)

Posted: Mon Jan 31, 2005 10:24 am
by 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

Posted: Thu Feb 03, 2005 8:53 am
by 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 :)

Posted: Thu Feb 03, 2005 9:58 am
by garvinhicking
Hi vossi!
vossi wrote: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

Posted: Thu Feb 03, 2005 12:53 pm
by 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 :)