TOPIC: Unknown column 'max_hits' in '__mtukio_booking_co

While upgrading to 6.1.4 i've got the the error.

Unknown column 'max_hits' in '#__matukio_booking_coupons'

My workarround to create an integer field in the mentoined table, it's not exactly brilliant.

Hi,

from which version did you update? And when you looked at the table, did you have the fields hits and max_hits?

Best,
Yves

#__matukio_booking_coupons`
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(255) NOT NULL,
`value` float(11,2) NOT NULL DEFAULT '0.00',
`procent` tinyint(1) NOT NULL DEFAULT '1',
`published_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`published_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL DEFAULT '0',
`max_hits` varchar(32) NOT NULL, /*my workarround*/
`event_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)

I try to upgrade from 6.1.2 to 6.1.4

Hmm, there are two columns more missing in your table: hits int (11) and event_id int (11). They are both there for like over a year. What was the first version you ever installed?

Best,
Yves

in your script.php i've found the following code

$query = "CREATE TABLE IF NOT EXISTS `#__matukio_booking_coupons` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`code` VARCHAR( 255 ) NOT NULL ,
`value` FLOAT( 11.2 ) NOT NULL DEFAULT '0.00',
`procent` TINYINT( 1 ) NOT NULL DEFAULT '1',
`published_up` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`published_down` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`published` TINYINT( 1 ) NOT NULL DEFAULT '0'
) COMMENT='Coupons';
";

That's only for versions prior 1.0.0 (should be non-existing nowadays). The sql executed on install is:

administrator/components/com_matukio/sql/install.mysql.sql

CREATE TABLE IF NOT EXISTS `#__matukio_booking_coupons` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`code` VARCHAR( 255 ) NOT NULL ,
`value` FLOAT( 11,2 ) NOT NULL DEFAULT '0.00',
`procent` TINYINT( 1 ) NOT NULL DEFAULT '1',
`max_hits` INT ( 11 ) NOT NULL DEFAULT '0',
`hits` INT ( 11 ) NOT NULL DEFAULT '0',
`event_id` INT ( 11 ) NOT NULL DEFAULT '0',
`published_up` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`published_down` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`published` TINYINT( 1 ) NOT NULL DEFAULT '0'
) DEFAULT CHARSET=utf8mb4 COMMENT='Coupons';

Best,
Yves

We've installed matikuio for over Years. Don't now why we have the problem now. I'll prepare a backup from the last week and try to find the error.

It's mysterious i've installed the Backup from last week no hits no max_hits. Version info 6.1.3? Try to update also terminates with

Warnung
Unknown column 'max_hits' in '#__matukio_booking_coupons'
Fehler
Fehler bei der Komponenten-Installation.

Maybe one of my colleagues or me activate an older Table Backup?
But it's not a General error.

It's not an issue, so no reason to activate an older backup, just fix the table manually.

Maybe some update went wrong, i think the coupons table changed in version 5-ish or something. But when everything else is working just keep it the way it is

Best,
Yves

For sure i've only altered the Table.

Just looked at the updater, the max_hits and hits column was added back in 2013 / 14 with version 3.0.2

So a long time ago, anyways good that everything else is working.

Best,
Yves