You are here: Home Support Forums
Categories
Categories:   All Categories
Suggested keywords
x
New
 Issue

SQL-Error during update version 3.4.27

JEvents (Free Access)
  JEvents (Free Access)
markusj
  markusj
  Thursday, 12 January 2017
  10 Replies
  1.9K Visits
0
Votes
Undo
Hi,
i get the following error during updating JEvents from version 3.4.25 up to 3.4.27:
Warning:
Invalid default value for 'modified' SQL=ALTER TABLE #__jevents_vevdetail modify extra_info text NOT NULL

Joomla!-Version: Joomla! 3.6.5 Stable [ Noether ] 1-December-2016 22:46 GMT
PHP-Version 5.6.29
mysql 5.1.73

What's the Problem ?

Thanks in advance
Oldest First  
tonyp
tonyp
Thursday, 12 January 2017 22:04
·
#181520
0
Votes
Undo
Hello,

Please use this version:
https://www.dropbox.com/s/948pm6uhp1fhon3/com_jevents34_3.4.27_patch_install.zip?dl=1

Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
mibert
mibert
Friday, 13 January 2017 13:12
·
#181597
0
Votes
Undo
This has worked perfectly. Thank you very much.

Best regards

Michael
tonyp
tonyp
Monday, 16 January 2017 21:40
·
#181725
0
Votes
Undo
Great to hear michael.

Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
figadvertising
figadvertising
Friday, 20 January 2017 22:47
·
#182042
0
Votes
Undo
Problem also occurs when trying to update 3.4.25 -> 3.4.28 ( joomla 3.6.5 )
tonyp
tonyp
Saturday, 21 January 2017 09:51
·
#182054
0
Votes
Undo
Hello,

thank you! If you install again it will fix it but as of JEvents 3.4.29 this SQL error will not occur again carlos finally fathomed out the cause yesterday since both Geraint and myself couldn't replicate it on our own installs.

Many thanks
Tony
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
rudolf
rudolf
Saturday, 21 January 2017 10:38
·
#182059
0
Votes
Undo
Had the same issue:


Invalid default value for 'created' SQL=Alter table #__jevents_icsfile MODIFY COLUMN srcURL varchar(500) NOT NULL default '' Package Update: There was an error installing an extension: com_jevents.zip


Installing the upgrade twice solved it. Thx for your posts. :)
formfranska
formfranska
Sunday, 22 January 2017 14:00
·
#182084
0
Votes
Undo
Thank you this thread helped me as well. Had the issue with v3.4.28 but it worked the second time.
tonyp
tonyp
Tuesday, 24 January 2017 10:13
·
#182198
0
Votes
Undo
No problem, this is fixed in V3.4.29 out yesterday :-).
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!
  • Page :
  • 1
There are no replies made for this post yet.

Members Area

Show your support

Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons

Your membership will ensure that JEvents continues to be the best events calendar for Joomla.