Jump to content
Larry Ullman's Book Forums

Ch 5: Inserting Pages


Recommended Posts

Hey Larry -

Great book, appreciate your thoroughness, will read your other PHP books.

I'm stuck in Chapter 5, using the SQL.sql download file to insert pages into MySQL. I keep receiving error 1292 regarding the "NOW()+100000" portion of the query. Below, "NOW()+100000" resolves to an integer, but is it merely unformatted?

ERROR 1292 (22007): Incorrect datetime value: '20190710504258' for column 'date_created' at row 2

 

Edited by Jumbo
Link to comment
Share on other sites

Regret asking this question, but if anyone wants the answer, I had to use now() in a context that would render an acceptable value. For me this was in combination with interval:

(NOW() + INTERVAL 1 DAY)) .. etc. Converted seconds (?) to days.
Link to comment
Share on other sites

 Share

×
×
  • Create New...