Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • in reply to: sqlwhere clause : how does it work ? #15921
    Jalrond
    Member

    Hello !

    Sorry for being a bit late to answer your suggestions…

    1st : Shadow, I tried this morning to write the datetime data int the 'correct' form ('2004-xx-xx xx:xx:xx'), no difference…

    Then, I downloaded your trial version of SQLYog (I succeded in finding a Pc under Windows :P, but this was hard 😛 ) SQLYog is very nice to use, shame it doesn't exist under Linux !

    I re-created my databases (no network connection to my main server ;)), and I used the wizard to do the sync….It worked perfectly !

    I do believe now that the problem comes from your Linux version… (I copied the XML file to my Linux computer and tried to use it…with the same errors as before 😡 )

    Sad… Do you still want my backups, Ritesh ?

    in reply to: sqlwhere clause : how does it work ? #15918
    Jalrond
    Member

    update :

    I seem to have the same problem than in the previous topic (error 1064…)

    Explanations : in the sja.log file, I have this error :

    “You have an error in your SQL syntax near 'group by 1 order by 2' at line 1”

    as in the other topic, this error disappears as soon as I choose to sync all the tables 😮

    in reply to: sqlwhere clause : how does it work ? #15917
    Jalrond
    Member

    Hello again,

    Thanks for your help, the work is progressing (I had the same idea that you suggested, was glad of this 😀 )

    But it doesn't work 😡

    Let me show you the “wrong?” part of the XML file :

    `mouvements`

    mouvements.date_fiche_maj > 20040610115204

    (mouvements is the only table I want to update, and only the records which were updated after a certain date… the request works fine if I try it directly with mysql 😕 !!!)

    Do you see another 🙁 error ?

    I wanna say, you are very kind for helpingus, poor newbies 😛

    in reply to: sqlwhere clause : how does it work ? #15915
    Jalrond
    Member

    Thank you very much for my XML problem

    Now, the easiest way is probably to describe you what I want to do ^_^

    I've got two databases and I'd want to synchronize one table, called 'mouvements'

    There is a field name 'date_modification', which format is datetime

    And the datas from this table can be modified by users using any of the 2 databases.

    So, when I sync, I want to put the newest record everywhere, without knowing where he is at first, that's why I wanted to use a sqlwhere clause in my params.

    I made many experiments, but it seems hardly useful to describe them 😮

    My latest idea was to have a request looking like “date_modification > LAST_DATE”, but how to compare 2 dates, and to obtain this param LAST_DATE ? By getting it in the sja.log file ?

    I saw in the forums that we can't put in the XML file any request using the both databases, so I'm now 😮 ing , thanks in advance for your help

Viewing 4 posts - 1 through 4 (of 4 total)