Bug #1359
cannot edit database from admin interface
0%
Description
Go to https://hostings.com/hm/siteBillingReport.php
in first field enter ebiblefellowship.com, hit submit
click this link:
change the Notes field to contain this:
12/27/09 - refunded $41, reduced DPT three years
1/29/21 - apparently we neglected to renew this domain in Feb 2020, canceling future renewals
Hit "Go" and you get this:
Database hostings_com_hm - Table additionalCharges running on localhost
Error
SQL-query :
UPDATE `additionalCharges` SET `zztimestamp` = NOW( '2020-12-20 05:00:05' ) ,
`notes` = '12/27/09 - refunded $41, reduced DPT three years 1/29/21 - apparently we neglected to renew this domain in Feb 2020, canceling future renewals' WHERE `id` = '149' LIMIT 1 ;
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2020-12-20 05:00:05'), `notes` = '12/27/09 - refunded $41, reduced DPT three ye' at line 1
History
#1
Updated by Thom Ho about 4 years ago
- File Screenshot_2.png View added
- Status changed from Assigned to Submitted
You need to change the timestamp option from NOW to UNIX_TIMESTAMP from the dropdown. so it will save the timestamp value in table.
#2
Updated by Kevin Zaleski about 4 years ago
- Status changed from Submitted to Code revision needed
If you are saying that the admin is going to have to manually change this every time a database record is edited, that is not an acceptable solution.
#3
Updated by Thom Ho about 4 years ago
- Status changed from Code revision needed to Submitted
Fixed.
#4
Updated by Kevin Zaleski about 4 years ago
- Status changed from Submitted to Code revision needed
I followed the exact steps above and got the same error. Please test it before submitting again.
Go ahead and add this line to notes:
1/29/21 - apparently we neglected to renew this domain in Feb 2020, canceling future renewals
#5
Updated by Thom Ho about 4 years ago
- File Screenshot_2.png View added
- Status changed from Code revision needed to Submitted
Please re-test again. somehow the code was reverted to old state. Just fixed and it seems works.
#6
Updated by Kevin Zaleski about 4 years ago
- Status changed from Submitted to Closed