SQLSTATE[22007]:Invalid datetime format when adding content
  • Vote Up0Vote Down Eldgin BrownEldgin Brown
    Posts: 6Member
    I receive this error repeatedly when adding playlists or smartblocks.  Sometimes the item can be added to a show most times I get the error.  There seems to be no rhyme or reason at to what the smart block or playlist contains.

    I'm running on Ubuntu 13.04 with PHP 5.3 and Postgresql 9.11

    Any help would be appreciated!!
    Post edited by Eldgin Brown at 2014-01-15 07:31:01
  • 7 Comments sorted by
  • Vote Up0Vote Down Eldgin BrownEldgin Brown
    Posts: 6Member
    Well since no one spoke up I backed up my music and reinstalled my VPS, So no need answering!!

    Edit:

    Ok reinstalled everything and issue still remains.  I've noticed that when it happens the Add to selected show button greys out and I'm no longer able to click it and if it's successful the window freezes after processing.

    Someone please help, I've been down for several days because of this!
    Post edited by Eldgin Brown at 2014-01-17 03:28:13
  • Vote Up0Vote Down Albert FRAlbert FR
    Posts: 1,978Member, Airtime Moderator
    you need to be in php 5.4 with Airtime 2.5.x

    http://askubuntu.com/questions/109404/how-do-i-install-latest-php-in-supported-ubuntu-versions-like-5-4-x-in-ubuntu-1
    ----
    Je peux le faire ;) [Pour vous] / I can do it [For You] Gnu/Linux & Media Architect
    Co-founder NessRadio.com
  • Vote Up0Vote Down Eldgin BrownEldgin Brown
    Posts: 6Member
    Actaully switched the VPS to Debian 7 instead of Ubuntu to see if anything changed, and the issue still somewhat remains.

    I can't add any playlists at all to a show, I can add smart blocks but still get prompted every other attempt to add them.

    I am running PHP 5.4 screenshot of PHP Info attached.  Got any other suggestions?

    Edit:

    A little more info the playlists are made up entirely of smart blocks.
    Capture.PNG
    749 x 508 - 34K
    Post edited by Eldgin Brown at 2014-01-24 15:02:55
  • Vote Up0Vote Down Eldgin BrownEldgin Brown
    Posts: 6Member
    Well the issue is back since half of my schedule is missing content!

    Anybody got a clue?
  • Vote Up0Vote Down Tom RuhTom Ruh
    Posts: 18Member
    I am facing the same issue:  I had a working install of Airtime, until.
    -On my local system I re-tagged all my audio.
    -Moved folders of content over 1 by 1.
    -Removed old folders
    -Added the folders to "Watched Folders"
    -Created a new "Dynamic Block"
    ---Tried adding content to the block -  This is where I received the error.
    -I am stepping back now.
    I would really appreciate any help I can get. I am totally offline now.
  • Vote Up0Vote Down Tom RuhTom Ruh
    Posts: 18Member

  • Vote Up0Vote Down Tom RuhTom Ruh
    Posts: 18Member
    I have found the source of my [22007].  I changed the Fade In setting from "0.50" to "1." leaving the "." exposed.
Add a Comment