• tom
  • Senior Member
  • Offline
  • From: USA, FL, Tampa
  • Registered: 03/24/2009
  • Posts: 326

Topic: 504 Gateway Timeout

I am doing a fresh install on a new hosting platform

In the setup wizard I get the db connection setup ok, but when I import the COA with or without demo data I get

504 Gateway Timeout

any suggestions where to look?

Is the import data local or being pulled from an FA site?

Tom

tom's Website

2 Reply by tom (edited by tom 09/26/2024 09:37:42 pm)

  • tom
  • Senior Member
  • Offline
  • From: USA, FL, Tampa
  • Registered: 03/24/2009
  • Posts: 326

Re: 504 Gateway Timeout

Ok, I was able to manually import the US demo data and I get an error:

ERROR 1067 (42000) at line 35: Invalid default value for 'tran_date'

The table is:

CREATE TABLE `0_attachments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(60) NOT NULL DEFAULT '',
  `type_no` int(11) NOT NULL DEFAULT '0',
  `trans_no` int(11) NOT NULL DEFAULT '0',
  `unique_name` varchar(60) NOT NULL DEFAULT '',
  `tran_date` date NOT NULL DEFAULT '0000-00-00',
  `filename` varchar(60) NOT NULL DEFAULT '',
  `filesize` int(11) NOT NULL DEFAULT '0',
  `filetype` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `type_no` (`type_no`,`trans_no`)
) ENGINE=InnoDB;


I am using mysql:8.3.0 (docker image)
Maybe I need to use an older version. The docs did not recommend any specific mySQL version...

Thanks!
ps. I don't think I can use an older mysql due to some clustering that is being done.

I did see that the valid date range is : The supported range is '1000-01-01' to '9999-12-31'.

Will the default value of 1000-01-01 cause any SQL issues?

tom's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: 504 Gateway Timeout

https://stackoverflow.com/questions/168736/how-do-you-set-a-default-value-for-a-mysql-datetime-column
https://stackoverflow.com/questions/54007824/how-to-set-sql-mode-in-my-cnf-in-mysql-8

Also check the parameter for legacy dates in my.cnf

[mysqld]

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

apmuthu's Website