You are not logged in.
Pages: 1
So the solution that worked for me was to edit the core\setup\base.sql, replacing this original line 11:
`expires` TIMESTAMP DEFAULT NULL,with this which worked
`expires` timestamp NOT NULL default '0000-00-00 00:00:00',and here's both the original full line
CREATE TABLE `bigtree_caches` (`identifier` varchar(1024) NOT NULL DEFAULT '', `key` varchar(10000) NOT NULL DEFAULT '', `value` longtext, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `expires` TIMESTAMP DEFAULT NULL, KEY `identifier` (`identifier`), KEY `key` (`key`), KEY `timestamp` (`timestamp`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;and new full line:
CREATE TABLE `bigtree_caches` (`identifier` varchar(1024) NOT NULL DEFAULT '', `key` varchar(10000) NOT NULL DEFAULT '', `value` longtext, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `expires` timestamp NOT NULL default '0000-00-00 00:00:00', KEY `identifier` (`identifier`), KEY `key` (`key`), KEY `timestamp` (`timestamp`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;I am trying to install BigTree version 4.5.13 on MAMP version 5.0.6, which uses PHP version 8.3.1 and MySQL version 5.7.24. I get an error when installing, and get a HTTP 500 error. The install page displays correctly, but when clicking the BigTree install button, the page refreshes to a HTTP 500 error. The first 2 tables in the database are created, I'm not sure if they are successfully created, but they do exist. They are bigtree_404s and bigtree_audit_trail.
This is the logged error from php_error.log
[07-Aug-2025 09:15:35 Etc/GMT+6] PHP Fatal error: Uncaught mysqli_sql_exception: Invalid default value for 'expires' in C:\MAMP\htdocs\btt\install.php:38
Stack trace:
#0 C:\MAMP\htdocs\btt\install.php(38): mysqli->query('CREATE TABLE `b...')
#1 C:\MAMP\htdocs\btt\install.php(250): sqlquery('CREATE TABLE `b...')
#2 {main}
thrown in C:\MAMP\htdocs\btt\install.php on line 38
I tried installing the same version of BigTree on MAMP version 4.2.0, which uses PHP version 7.4.1 and MySQL version 5.7.24 and BigTree installed without issue.
For some reason, I had to rename the cache/bigtree-ca-cert.pem file to something different to get mine working again, no clue why it stopped working at some time. Otherwise, I was getting an error (after changing the amazon cloud update php file to spit it out)
Array ( [0] => Error executing "ListBuckets" on "https://s3.amazonaws.com/"; AWS HTTP error: cURL error 77: (see http://curl.haxx.se/libcurl/c/libcurl-errors.html) )
Thanks, using a different browser fixed it!
A few days ago we were alerted that a new version of bigtree cms is available (we are on 4.2.8 today) and we ignored the alert. Today, we went to /admin/developer/upgrade/ to try and start the upgrade process, but we get this message:
No updates are available.
I feel like this might be a bug.
Thanks!
Pages: 1