Can't update 1.45.00 to 1.46.01

Ralf
Posts: 42
Joined: 23 Sep 2018, 18:13

Can't update 1.45.00 to 1.46.01

Post by Ralf »

Copied new 1.46.01 files on existing 1.45.00 version and Login screen shows:

Upgrading to version 1.46.00
Failed to upgrade database, please contact support@soplanning.org with full details.
upgrade failed :
1.46.00
request failed :
ALTER TABLE `planning_user` ADD `date_creation` DATETIME NOT NULL AFTER `login_actif`

:(
soplanning
Site Admin
Posts: 296
Joined: 31 Aug 2017, 15:58

Re: Can't update 1.45.00 to 1.46.01

Post by soplanning »

Hello
Can you run manually this query in phpmyadmin and let us know what is the error ?
it seems some users have the same problem, depending on their server settings.
thanks
Ralf
Posts: 42
Joined: 23 Sep 2018, 18:13

Re: Can't update 1.45.00 to 1.46.01

Post by Ralf »

ALTER TABLE `planning_user` ADD `date_creation` DATETIME NOT NULL AFTER `login_actif`

MySQL meldet:
#1292 - Falscher datetime-Wert: '0000-00-00 00:00:00' für Feld 'date_creation' in Zeile 1
soplanning
Site Admin
Posts: 296
Joined: 31 Aug 2017, 15:58

Re: Can't update 1.45.00 to 1.46.01

Post by soplanning »

can you try this please :
ALTER TABLE `planning_user` ADD `date_creation` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `login_actif`;
and run the rest of the sql file
Ralf
Posts: 42
Joined: 23 Sep 2018, 18:13

Re: Can't update 1.45.00 to 1.46.01

Post by Ralf »

Upgrading to version 1.46.00
Database upgrade ok for version 1.46.00
Upgrading to version 1.46.01
Database upgrade ok for version 1.46.01
:D
Merci beaucoup
Great job
Stay healthy
Graysonss
Posts: 62
Joined: 24 Nov 2021, 13:16

sshz

Post by Graysonss »

I really appreciate the kind of topics you post here. Thanks for sharing us a great information that is actually helpful. Good day! Chapewerken
Graysonss
Posts: 62
Joined: 24 Nov 2021, 13:16

sshz

Post by Graysonss »

I was very pleased to find this site.I wanted to thank you for this great read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post. Koelcel
Graysonss
Posts: 62
Joined: 24 Nov 2021, 13:16

sshz

Post by Graysonss »

Your blog provided us with valuable information to work with. Each & every tips of your post are awesome. Thanks a lot for sharing. Keep blogging, Isolerende chape
Graysonss
Posts: 62
Joined: 24 Nov 2021, 13:16

sshz

Post by Graysonss »

This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information... Koelsystemen
Graysonss
Posts: 62
Joined: 24 Nov 2021, 13:16

sshz

Post by Graysonss »

With so many books and articles coming up to give gateway to make-money-online field and confusing reader even more on the actual way of earning money, Vloer isolatie
Post Reply