errolsirra
New member
I am running Dadabik v4.0 on two separate websites running MySQL 4.1.21 and PHP 4.4.4. For most of the tables I setup I have a primary index set to datetime in MySQL and set this field as update_date in Dadabik (only displaying in details page). On one website I have no problems and can enter multiple records on the same day. When I view the table in phpMyAdmin this datetime field has the date and current time set.
On the second website I recently setup I receive the following error after entering a second record on the same day:
[08] Error: during query execution.
INSERT INTO `bnl_welcome` (`dept`, `welcome_text`, `on_off`, `welcome_index`) VALUES ('Youth Services', 'youth text', 'on', '2007-03-29')
DBMS server said: Duplicate entry '2007-03-29 00:00:00' for key 1
The problem seems clear, that only the date portion is being sent during INSERT and the time is automatically being set to midnight. When I attempt to enter a second record on the same day it will obviously see it as a duplicate primary key and fail. My question is why is this happening for this install but my other nearly identical install doesn't have a problem sending the time for update_date.
The $date_format is set to 'literal_english' in config.php. All other settings are basically the default settings.
On the second website I recently setup I receive the following error after entering a second record on the same day:
[08] Error: during query execution.
INSERT INTO `bnl_welcome` (`dept`, `welcome_text`, `on_off`, `welcome_index`) VALUES ('Youth Services', 'youth text', 'on', '2007-03-29')
DBMS server said: Duplicate entry '2007-03-29 00:00:00' for key 1
The problem seems clear, that only the date portion is being sent during INSERT and the time is automatically being set to midnight. When I attempt to enter a second record on the same day it will obviously see it as a duplicate primary key and fail. My question is why is this happening for this install but my other nearly identical install doesn't have a problem sending the time for update_date.
The $date_format is set to 'literal_english' in config.php. All other settings are basically the default settings.