02-04-2020, 04:38 AM,
|
|
briantmg
Member
|
Posts: 24
Threads: 13
Joined: Jul 2017
|
|
Unknown Date Format
I just upgraded to the latest version 4.15.1. When I click on the StockMovements.php script, nothing shows in the table and I get an error, "invalid date format", when I click on the dates. If I replace the script with my old script (4.14.1), It works fine. Do I have a setting somewhere that needs to be updated?
Thanks
|
|
02-04-2020, 10:08 AM,
|
|
briantmg
Member
|
Posts: 24
Threads: 13
Joined: Jul 2017
|
|
RE: Unknown Date Format
I tried clearing the cache and tried it in private browsing mode also. It didn't make any difference. I haven't done any modifications of the scripts.
|
|
02-04-2020, 11:14 PM,
|
|
briantmg
Member
|
Posts: 24
Threads: 13
Joined: Jul 2017
|
|
RE: Unknown Date Format
It looks like I only cleared the cache for the previous hour. I cleared all the cash and history and now I do not get the unknown date format error any more. And the date picker shows up. However, nothing shows up in the history of stock movements.
I did a little more investigating and tried different versions of the script. All of them work except the latest one in Git. The commit on Nov 9, 2018 works, but the commit on April 2019 is not working for me. The dates work, but nothing nothing shows in the history of the part.
|
|
02-05-2020, 02:11 AM,
|
|
briantmg
Member
|
Posts: 24
Threads: 13
Joined: Jul 2017
|
|
RE: Unknown Date Format
The parts are not controlled items. There was an error in the database upgrade on the custbranch table. the lat and ing have a type of float(10,6) and the upgrade tried to change it to float(12,8). It was unable to do this and when I tried to do it in phpmyadmin, it gave the same error of:
Cannot drop index 'DebtorNo' needed in a foreign key restraint.
Not sure if that has anything to do with it?
|
|
02-05-2020, 09:38 AM,
|
|
briantmg
Member
|
Posts: 24
Threads: 13
Joined: Jul 2017
|
|
RE: Unknown Date Format
That seems to have fixed the problem. It is working now.
|
|
|