Several issues, questions ...

Hi!! Thanks a lot for your interest in Jisko.

I'll try to answer all of your questions:
1. Sometimes you have to wait some minutes until the data is processed and
received...
2. I can't say anything about this problem because I don't use Windows...
3. In the friends tab you can see your notes + the noyes of your followings.
Then, to have "friends" you have to follow an user.
4. Try reading the FAQ at the bottom of the page (in any page of your Jisko
installation you'll see a link to the FAQ)
5. Same as 4

Also, I didn't have any error with MySQL. However you can be telling the
truth, so please report all your problems in the Bug interface (
bugs.launchpad.net/jisko)

Thanks again for your interest in Jisko!!

marcos garcía // <email address hidden>
Desde mi HTC DREAM

On dic 17, 2009 4:58 a.m., "Peter" <email address hidden>
wrote:

New question #94330 on Jisko:
https://answers.launchpad.net/jisko/+question/94330

First of all; interesting and nice script. Could you maybe confirm or
comment on the them if you have time - have been trying to get it installed
for long time.

1. Notes gets uploaded to Twitter, but I get nothing bavk from Twitter.

2. Posting a note in IE8 stops the ajax rutine and it just hangs. Working
though in FF ...

3. I see there a Frirends Tab, but how can you add friends? I just don't see
it.

4. Private Tab and Received/Sent? How do you send a receive private notes? I
can see nothing under this tab here.

5. How about those tags? Can see any and none are registered in database?
Did I miss something?

During the installation I found that many columns in tables are not set to
accept NULL and that breaks a lot a queries on MySQL installation
(Serverversion: 5.0.67-community-nt). Basically through the installation I
had to check what is wrong and go into the database and set a lot of columns
to accept NULL, when not set in the queries. Looking throuigh the sql file
it is clear that there a quite som columns set to "NOT NULL", while there
shouldn't be. Before MySql 5.0.2 it was more accepted, but not now.

--
You received this question notification because you are an answer
contact for Jisko.

Hi and thanks Marcos!

- Receive Twitter don't work. Well will look into that.
- I see the friends tab don't work, even if I have people I'm following. Well I will look into that.
- Post private messages don't work, problably a MySQL issue. Will check that out, that's easy to fix.

5. Tags. There is nothing in FAQ about tags, so it is hard to get how to use it ...

6. What about the cron.php. What does it do?

Peter

I think those features are no working because of compatibility issues...
They work on a local server...

Well, to post a tag type #tag, it will highlight the name of the tag and
you'll see some stats about all the tags that all the people have done.

I can't help you with the Twitter problem because the class was not
developed by us and this is not the first problem we are having with it...
I'll look into the problem and I'll try to release a fix in the next version
3.5

Hope tjhis helped.

marcos garcía // <email address hidden>
Desde mi HTC DREAM

On dic 17, 2009 9:27 p.m., "Peter" <email address hidden>
wrote:

Question #94330 on Jisko changed:

https://answers.launchpad.net/jisko/+question/94330
   Status: Answered => Open

Peter is still having a problem:
Hi and thanks Marcos!

- Receive Twitter don't work. Well will look into that.
- I see the friends tab don't work, even if I have people I'm following.
Well I will look into that.
- Post private messages don't work, problably a MySQL issue. Will check that
out, that's easy to fix.

5. Tags. There is nothing in FAQ about tags, so it is hard to get how to
use it ...

6. What about the cron.php. What does it do?

Peter

--

You received this question notification because you are an answer contact
for Jisko.

This* (sorry about that)

Thanks for your interest in Jisko!!

Regards, Marcos.

marcos garcía // <email address hidden>
Desde mi HTC DREAM

On dic 17, 2009 9:27 p.m., "Peter" <email address hidden>
wrote:

Question #94330 on Jisko changed:

https://answers.launchpad.net/jisko/+question/94330
   Status: Answered => Open

Peter is still having a problem:
Hi and thanks Marcos!

- Receive Twitter don't work. Well will look into that.
- I see the friends tab don't work, even if I have people I'm following.
Well I will look into that.
- Post private messages don't work, problably a MySQL issue. Will check that
out, that's easy to fix.

5. Tags. There is nothing in FAQ about tags, so it is hard to get how to
use it ...

6. What about the cron.php. What does it do?

Peter

--

You received this question notification because you are an answer contact
for Jisko.

Hello again,

Really thankful for the answers and you taking the time.

So you are working on 3.5? Not 3.0? Do you submit the code to SVN on regular basis, so I could try what is cooking :)

Also the cron.php. What is it used for?

Peter

One again, thanks for all the answers.

So I found the issue with twitter and private notes! :)

You declared in DB->notes column read as TINYINT(1) , but when inserting information you use "false" or "true". In strict MySQL that doesn't work and will not insert a thing.

Since you are not checking that you actually get something back after the querty the script is continuing as if it was inserted.

Changing the read column to VARCHAR(30) to check and then it is working.

I will submit it as a bug and continue for more ...

(It was a friend of mine, Martin, that found it - not me...)

Stil I can't get anything in the Friends Tab. This page generate these query:

SELECT `post2id`.`timestamp` AS `orderby`, `post2id`.`note_id` AS id, `post2id`.`type` FROM `post2id` WHERE `post2id`.`type` IN('public', 'personal') AND `post2id`.`to`= 2

That query don't give me any results even if user (id=2) follows another user.

Any thoughts?

Sorry, I meant 2.5.... I don't know if I can publish the code yet, I'll ask
to Rubén Díaz (the other developer).

The problems with the queries can be related with the mysql server version
you're using... I can't say anything because I only know a little of SQL
query language....

Regards, Marcos..

2009/12/18 Peter <email address hidden>

> Question #94330 on Jisko changed:
> https://answers.launchpad.net/jisko/+question/94330
>
> Peter gave more information on the question:
> Stil I can't get anything in the Friends Tab. This page generate these
> query:
>
> SELECT `post2id`.`timestamp` AS `orderby`, `post2id`.`note_id` AS id,
> `post2id`.`type` FROM `post2id` WHERE `post2id`.`type` IN('public',
> 'personal') AND `post2id`.`to`= 2
>
> That query don't give me any results even if user (id=2) follows another
> user.
>
> Any thoughts?
>
> --
> You received this question notification because you are an answer
> contact for Jisko.
>

--
marcos garcía // <email address hidden>

Would be nice to see/try early version of 2.5 in the trunk. Maybe I would have less errors.

How about the cron.php. What does it do and how often should it be run? (Last question I hope :) )

Hope so :)

Well... cron.php it's not really a Cron file, it just works for cleaning the twitter database and for updating the twitter timeline.

You *should* only use cron for cleaning the twitter database. It works in this way:

http://youserver/cron?p=yourpassword

The password is defined in your config.php file

Thanks again for your interest in Jisko!

Regards, Marcos.