Problem with Datetime

Discuss MySQL Ajax Table Editor

Problem with Datetime

Postby a-glas » Wed Jan 20, 2021 11:23 pm

i Added a collum named lastedit

in the Function i have:

function initiateEditor()
{
$tableColumns['updated'] = array(
'display_text' => 'Updated',
'perms' => 'EVCXQT',
'mysql_edit_fun' => "NOW()",
);
...
}

But i Always get the error:
Es war ein Fehler...
Wahrscheinlich die falsche.
Wenn die ajax url korrekt ist, sehen Sie im Apache errorlog weitere Informationen

error log:
......lastedit` = NOW() where id = :old_primary_key_value<........


I Tried many Cofigurations ( Collum DATE,DATETIME,TIME,)....


Anyone have a idea how to solve this?
a-glas
 
Posts: 4
Joined: Sun Jun 30, 2019 8:01 pm

Re: Problem with Datetime

Postby jyoungCCE » Sat Feb 27, 2021 4:39 am

I'd like to see more of the column settings and the error code before I can assist.
jyoungCCE
 
Posts: 3
Joined: Fri Feb 26, 2021 10:00 pm

Re: Problem with Datetime

Postby admin » Sat Feb 27, 2021 6:13 am

You could try using the on_edit_fun callback instead and returning date('Y-m-d H:i:s')

You might what to set the hidden_edit option to true also (if you are not already).
admin
Site Admin
 
Posts: 1502
Joined: Fri Jul 11, 2008 1:34 am


Return to Open Discussion

Who is online

Users browsing this forum: No registered users and 6 guests

cron