Radicore Forum: Bug Reports » Error with date field

Home » RADICORE development » Bug Reports » Error with date field

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Error with date field [message #7816 is a reply to message #7815]

Sat, 25 March 2023 06:58

htManager
Messages: 427
Registered: May 2014

Senior Member

I made a dump of the table and got a sql file. I added this script (hopefully the right one).

As far as I see, the problem is obviously a SQL problem.

Executing "INSERT INTO test_datum SET `id`='4', `test_datum`='';" in phpMyAdmin results in the same behaviour. The date field has the value '0000-00-00'.

Do I have to change the sqlmode?

Attachment: test_datum.sql
(Size: 1.26KB, Downloaded 184 times)

Report message to a moderator

[Message index]

		Error with date field By: htManager on Tue, 28 February 2023 06:01
		Re: Error with dictionary import By: AJM on Tue, 28 February 2023 07:02
		Re: Error with dictionary import By: htManager on Wed, 01 March 2023 12:30
		Re: Error with dictionary import By: AJM on Wed, 01 March 2023 13:11
		Re: Error with dictionary import By: htManager on Wed, 01 March 2023 16:55
		Re: Error with dictionary import By: AJM on Thu, 02 March 2023 04:42
		Re: Error with dictionary import By: htManager on Thu, 02 March 2023 12:22
		Re: Error with dictionary import By: AJM on Fri, 03 March 2023 04:42
		Re: Error with dictionary import By: htManager on Tue, 07 March 2023 18:16
		Re: Error with date field By: htManager on Thu, 23 March 2023 10:51
		Re: Error with date field By: AJM on Fri, 24 March 2023 05:28
		Re: Error with date field By: htManager on Fri, 24 March 2023 11:40
		Re: Error with date field By: AJM on Sat, 25 March 2023 05:27
		Re: Error with date field By: htManager on Sat, 25 March 2023 06:58
		Re: Error with date field By: htManager on Sat, 25 March 2023 08:02
		Re: Error with date field By: AJM on Sun, 26 March 2023 04:16
		Re: Error with date field By: htManager on Sun, 26 March 2023 05:29
		Re: Error with date field By: AJM on Mon, 27 March 2023 04:45
		Re: Error with date field By: htManager on Mon, 27 March 2023 05:18
		Re: Error with date field By: AJM on Tue, 28 March 2023 04:40
		Re: Error with date field By: htManager on Fri, 31 March 2023 12:49
		Re: Error with date field By: AJM on Sat, 01 April 2023 04:50
		Re: Error with date field By: htManager on Sat, 01 April 2023 09:00
		Re: Error with date field By: AJM on Sun, 02 April 2023 04:43
		Re: Error with date field By: htManager on Sun, 02 April 2023 05:29
		Re: Error with date field By: AJM on Mon, 03 April 2023 04:37
		Re: Error with date field By: htManager on Mon, 03 April 2023 09:09
		Re: Error with date field By: AJM on Tue, 04 April 2023 04:44
		Re: Error with date field By: htManager on Wed, 05 April 2023 09:48

Previous Topic:	PHP 8 - ListViewPrintAfter()
Next Topic:	File classes/mnu_chart.class.inc is missing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Sep 10 12:57:45 EDT 2024

Total time taken to generate the page: 0.01228 seconds