Re: Error upgrading from 4.0.6 to 4.0.7 on Joomla 4
Posted: 05 Nov 2023, 17:42
OK, found the error's source. There are 3 sql files in the /update folder in admin - both in the site if you attempted an upgrade, and also in the kit. The file admin\update\sql\mysql\3.0.2.sql contains these lines (among others)
ALTER TABLE `#__phocadownload` ADD COLUMN `token` char(64) default NULL;
ALTER TABLE `#__phocadownload` ADD COLUMN `tokenhits` int(11) NOT NULL default 0;
IF you comment out these two files OR you delete both from the webserver and the downloaded kit the above files the upgrade wents through withouth errors, and you got a perfectly working PhocaDownload component.
ALTER TABLE `#__phocadownload` ADD COLUMN `token` char(64) default NULL;
ALTER TABLE `#__phocadownload` ADD COLUMN `tokenhits` int(11) NOT NULL default 0;
IF you comment out these two files OR you delete both from the webserver and the downloaded kit the above files the upgrade wents through withouth errors, and you got a perfectly working PhocaDownload component.