×

Notice

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

TOPIC: 1054 - Unknown column 'newfields_perplace'

1054 - Unknown column 'newfields_perplace' 9 years 9 months ago #30701

  • Tim Hoogland
  • Tim Hoogland's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 25
  • Thank you received: 1
I got an error when I ask for 3 places instead of 1 (nrbooked).

Full message is:
1054 - Unknown column 'newfields_perplace' in 'field list'
SQL=INSERT INTO `vrhl_matukio_bookings` (`id`,`name`,`email`,`semid`,`userid`,`bookingdate`,
`nrbooked`,`zusatz1`,`zusatz2`,`zusatz3`,`zusatz4`,`zusatz5`,`zusatz6`
,`zusatz7`,`zusatz8`,`zusatz9`,`zusatz10`,`zusatz11`,`zusatz12`,`zusatz13`
,`zusatz14`,`zusatz15`,`zusatz16`,`zusatz17`,`zusatz18`,`zusatz19`,
`zusatz20`,`newfields`,`uuid`,`payment_method`,`payment_netto`,
`payment_tax`,`payment_brutto`,`coupon_code`,`status`,
`newfields_perplace`) VALUES ('0','Tim namens Taletta Hoogland',
'tim.hoogland@kpnplanet.nl','76','0','2015-03-18 17:32:09','3','','','','','','','','','','','','','','','','','','','','','{\"3\":{\"key\":\"firstname\",\"value\":\"Tim namens Taletta\"},\"4\":{\"key\":\"lastname\",\"value\":\"Hoogland\"},\"16\":{\"key\":\"hoe_ontdekt\",\"value\":\"option2\"},\"11\":{\"key\":\"email\",\"value\":\"tim.hoogland@kpnplanet.nl\"},\"12\":{\"key\":\"phone\",\"value\":\"+31255515515\"}}','89c3d64290a74a67ba281e2ff043eb01','cash','30','0','30','','1','[]')

What can I do about it?

Kind regards,

Tim Hoogland.

1054 - Unknown column 'newfields_perplace' 9 years 9 months ago #30703

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
Hi Tim,

looks like your Matukio table is inconstant, did any error occur during updating? And what was the version you last updated from?

Kind regards,

Yves

1054 - Unknown column 'newfields_perplace' 9 years 9 months ago #30704

  • Tim Hoogland
  • Tim Hoogland's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 25
  • Thank you received: 1
Hi Yves,
Problem is solved: I added two lacking fields to the database and it works again!

Kind regards,
Tim Hoogland.




Hi Yves,

I am now using version 5.1.3. I installed it on a fresh Joomla 3.3 website, which is now upgraded to 3.4.
Iam not sure about the earlier version of Matukio : I think it is 4.5.1.
I exported the table of the events and imported it into the new version, so that may have caused some troubles??
Until now there were no other issues discovered.

Kind regards,

Tim Hoogland.
  • Page:
  • 1
Time to create page: 0.134 seconds