Vacation entry problem in mysql

Falco
2009-04-06
2013-01-23
  • Falco

    Falco - 2009-04-06

    Hello,
    I realized some mistake in vacation section.
    When i post in mysql my vacation statu, the message was modified for the return line.

    ex :

    I
    test
    a
    vacation
    message

    go to :
    I rntest rna rnvacation rnmessage

    it seem to be an error record in database.

    Good journey :)

     
    • GingerDog

      GingerDog - 2009-04-06

      Hmm, there are \r\n characters added somewhere, I suspect they're partly to blame.

       
    • Falco

      Falco - 2009-04-06

      Yes, sure.
      But my postfixadmin version & database is up to date with svn, so where i can correct this ?
      Thanks :)

       
    • Falco

      Falco - 2009-04-08

      Up ! :)
      Please help me.
      Where is the problem in edit-vacation ?
      Thanks in advance.
      Regards
      Fs

       
    • GingerDog

      GingerDog - 2009-04-08

      I don't know... will try testing now...

       
    • GingerDog

      GingerDog - 2009-04-08

      I've tested vacation.pl from svn-trunk and it all works as expected. I'm confused as to what your problem is.

       
    • Falco

      Falco - 2009-04-09

      Hello,
      Thanks for your help.
      I just do a new test, i delete edit-vacation.php, re-update with svn, go in user test, put vacation on, and juste refresh users/vacation.php, all the text is in a same line.

      It's seem to be a wrong insert in database.

      My config.inc.php used mysqli
      My php version is :  5.2.6-3
      My mySQL version is : 5.0.51a

      Thanks for your help.
      Regards
      Fs

       
    • Falco

      Falco - 2009-04-09

      I test to delete users/vacation.php and reup from svn.
      The problem continu...

       
    • GingerDog

      GingerDog - 2009-04-09

      But did you update vacation.pl ??

       
    • Falco

      Falco - 2009-04-10

      Hello,
      No, i did not update it, you think all vacations insert need now to be in a same line with \r\n ?
      I need to change all (omg :x) ?
      I m afraid to change vacation.pl to do that.
      I m suprise by this problem, all work good 3 weeks ago.
      Maybe something change in users/vacation.php to hack insert db.

      Thanks for your help and time.
      Regards
      FS

       
    • Falco

      Falco - 2009-04-25

      Hello,
      Sorry for my question but :
      - I have updated all files, vacation.pl too, and my problem continu.
      - db was update with upgrade.php
      - I check all file edit-vacations.php, template, vacations.pl, functions.inc.php etc, but i did not find error.
      - I test with a new user, old one, when a user push in db(mySQL with mysqli or mysql connections) vacation body, all returns were continue to replace by rn

      I think something wrong from with last update file of edit-vaction.php and maybe functions.inc.php.

      This error was appear when last update (5 weeks ago)

      Thanks for you help
      Falco

       
    • Christian Boltz

      Christian Boltz - 2009-04-25

      Found it: The vacation subject and message were passed to escape_string twice - once in users/vacation.php and once in model/VacationHandler.php.

      Fixed in SVN r646 (by removing the superfluous escape_string in users/vacation.php) - thanks for pointing this out!

       
    • Falco

      Falco - 2009-04-26

      Thanks !
      I m gonna be crasy :)
      Good end of week end
      Falco

       

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks