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 #7812 is a reply to message #7804]

Thu, 23 March 2023 10:51

htManager
Messages: 417
Registered: May 2014

Senior Member

I created a new table with the following specifications:

$fieldspec['id'] = array('type' => 'integer', 'type_native' => 'int','size' => 10, 'minvalue' => -2147483648, 'maxvalue' => 2147483647, 'pkey' => 'y', 'required' => 'y');
$fieldspec['test_datum'] = array('type' => 'date', 'size' => 12);

// primary key details
$this->primary_key = array('id');

When I insert a new record with my application, the line 1.631 in dml.mysqli.class.inc: $result = mysqli_query($this->dbconnect, $this->query); is responsible for inserting the record in my database with the right id and the value 0000-00-00 in the field 'test_datum', if I leave this empty in my screen. I examined the database table before and after executing this line. Before, the record wasn't visible/inserted, afterwards it was.

These variables shows my debugger before executing the line:

$this->query = INSERT INTO test_datum SET `id`='2', `test_datum`=''

client_info = mysqlnd 8.2.0
server_info = 10.4.27-MariaDB

Where else can I search for the problem? My debugger doesn't show any further information. I only can see the inserted record in the database table.

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: Mon May 13 17:44:04 EDT 2024

Total time taken to generate the page: 0.01378 seconds