×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Unknown column 'max_hits' in '__mtukio_booking_co

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #35998

  • InterCultur gGmbH
  • InterCultur gGmbH's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 12
  • Thank you received: 0
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.

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #35999

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
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

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #36000

  • InterCultur gGmbH
  • InterCultur gGmbH's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 12
  • Thank you received: 0
#__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

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #36001

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
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

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #36002

  • InterCultur gGmbH
  • InterCultur gGmbH's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 12
  • Thank you received: 0
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';
";

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #36003

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
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
The following user(s) said Thank You: InterCultur gGmbH

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #36004

  • InterCultur gGmbH
  • InterCultur gGmbH's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 12
  • Thank you received: 0
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.

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #36005

  • InterCultur gGmbH
  • InterCultur gGmbH's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 12
  • Thank you received: 0
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.

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #36006

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
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

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #36007

  • InterCultur gGmbH
  • InterCultur gGmbH's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 12
  • Thank you received: 0
For sure i've only altered the Table.

Unknown column 'max_hits' in '__mtukio_booking_co 6 years 10 months ago #36008

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
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
The following user(s) said Thank You: InterCultur gGmbH
  • Page:
  • 1
Time to create page: 0.214 seconds