Project

General

Profile

Bug #1359

cannot edit database from admin interface

Added by Kevin Zaleski over 3 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
High
Assignee:
Start date:
01/29/2021
Due date:
% Done:

0%


Description

Go to https://hostings.com/hm/siteBillingReport.php

in first field enter ebiblefellowship.com, hit submit

click this link:

and it goes to https://hostings.com/hm/pmaOld/tbl_change.php?lang=en-iso-8859-1&server=1&db=hostings_com_hm&table=additionalCharges&pos=0&dontlimitchars=0&primary_key=+%60id%60+%3D+%27149%27&sql_query=SELECT+%2A+%0AFROM+%60additionalCharges%60+%0AWHERE+id+%3D+%27149%27&goto=sql.php

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

ntdrjeyr4.jpg View (22.6 KB) Kevin Zaleski, 01/29/2021 07:18 AM

Screenshot_2.png View (36.6 KB) Thom Ho, 01/29/2021 07:40 AM

Screenshot_2.png View (37.3 KB) Thom Ho, 03/02/2021 12:38 AM

History

#1 Updated by Thom Ho over 3 years ago

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 over 3 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 3 years ago

  • Status changed from Code revision needed to Submitted

Fixed.

#4 Updated by Kevin Zaleski about 3 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 3 years ago

Please re-test again. somehow the code was reverted to old state. Just fixed and it seems works.

#6 Updated by Kevin Zaleski about 3 years ago

  • Status changed from Submitted to Closed

Also available in: Atom PDF