SQL-Error during update version 3.4.27
By Guest on Thursday, 12 January 2017
Posted in JEvents (Free Access)
Replies 10
Likes 4
Views 1.9K
Votes 0
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
Hello,

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

Many thanks
Tony
Guest
·
Thursday, 12 January 2017 22:04
·
4 Likes
·
0 Votes
·
0 Comments
·
This has worked perfectly. Thank you very much.

Best regards

Michael
Guest
·
Friday, 13 January 2017 13:12
·
4 Likes
·
0 Votes
·
0 Comments
·
Great to hear michael.

Many thanks
Tony
Guest
·
Monday, 16 January 2017 21:40
·
4 Likes
·
0 Votes
·
0 Comments
·
Problem also occurs when trying to update 3.4.25 -> 3.4.28 ( joomla 3.6.5 )
Guest
·
Friday, 20 January 2017 22:47
·
4 Likes
·
0 Votes
·
0 Comments
·
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
Guest
·
Saturday, 21 January 2017 09:51
·
4 Likes
·
0 Votes
·
0 Comments
·
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.
Guest
·
Saturday, 21 January 2017 10:38
·
4 Likes
·
0 Votes
·
0 Comments
·
Thank you this thread helped me as well. Had the issue with v3.4.28 but it worked the second time.
Guest
·
Sunday, 22 January 2017 14:00
·
4 Likes
·
0 Votes
·
0 Comments
·
No problem, this is fixed in V3.4.29 out yesterday :-).
Guest
·
Tuesday, 24 January 2017 10:13
·
4 Likes
·
0 Votes
·
0 Comments
·
View Full Post