Kayamone Posted March 26, 2020 Report Share Posted March 26, 2020 (edited) I get the following error when trying to register a test account: Incorrect date value: '0000-00-00' for column 'lastlogin' at row 1 Anyone know what could be throwing this error and how to fix it? Edited March 26, 2020 by Kayamone Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 27, 2020 Administrators Report Share Posted March 27, 2020 What version of phpVMS? What version of MySQL or MariaDB? I know you will get this in phpVMS 5.5.2 if you are using MySQL 5.7 . If using phpVMS 5.5.2, I can provide a link to a fix. If using phpVMS, I will let the developer respond. Quote Link to comment Share on other sites More sharing options...
Kayamone Posted March 28, 2020 Author Report Share Posted March 28, 2020 I am using Mysql 5.7.29 with phpVMS 5.5.2.72 (upgraded for PHP 7.2) Quote Link to comment Share on other sites More sharing options...
Kayamone Posted March 28, 2020 Author Report Share Posted March 28, 2020 On 3/26/2020 at 10:51 PM, ProAvia said: What version of phpVMS? What version of MySQL or MariaDB? I know you will get this in phpVMS 5.5.2 if you are using MySQL 5.7 . If using phpVMS 5.5.2, I can provide a link to a fix. If using phpVMS, I will let the developer respond. That link would be very helpful Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 28, 2020 Administrators Report Share Posted March 28, 2020 Since you are using phpVMS 5.5.2.72 - Those edits have already been done for you (as I incorporated them in the release). I am assuming you are using PHP 7.0 thru PHP 7.2. That version of phpVMS will not presently work with PHP 7.3 or greater. Quote Link to comment Share on other sites More sharing options...
Kayamone Posted March 29, 2020 Author Report Share Posted March 29, 2020 The problem is, I updated and thats the error i am getting still. http://vussp.org/phpvms/index.php/registration Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 29, 2020 Administrators Report Share Posted March 29, 2020 What version of PHP? What version of MySQL or MariaDB? Open the pilots table and click on Structure. does it match the below pic - specifically the lines with the red marks? https://drive.google.com/file/d/1hH3eATpqdinQWlY5MbGZbF-3rqyCpU5H/view?usp=sharing Did you 'update' from a prior version of phpVMS or install a new phpVMS 5.5.2.72 ??? Quote Link to comment Share on other sites More sharing options...
Kayamone Posted March 31, 2020 Author Report Share Posted March 31, 2020 All of the lines match, however, lastlogin, joindate, and lastpirep are set as 0000-00-00 as default with type set to date, datetime, datetime (respectively). When I try to change the joindate type to timestamp, i get the following error: "#1067 - Invalid default value for 'lastlogin'" Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted March 31, 2020 Administrators Report Share Posted March 31, 2020 Try changing that default to 1970-01-01 - and let us know if that works. Quote Link to comment Share on other sites More sharing options...
Kayamone Posted March 31, 2020 Author Report Share Posted March 31, 2020 Got the same error except pointing back to 'joindate'. Is there a wayto override the query error so the changes can be made? Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted April 1, 2020 Administrators Report Share Posted April 1, 2020 Put the same in for the default joindate. You may get other date type errors - and may possibly need to change those too. If they display date and time... 0000-00-00 00:00:00 ..... use 1970-01-01 01:01:01 Or change all three to what is in my pic above and see if that works. Did you use your old database or is this a totally fresh install? Quote Link to comment Share on other sites More sharing options...
Kayamone Posted April 2, 2020 Author Report Share Posted April 2, 2020 I used the old database Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted April 2, 2020 Administrators Report Share Posted April 2, 2020 That would be the issue. The pilots table and a few others have changed to allow MySQL 5.6 and MySQL 5.7 to work. I suggest you install a virgin 5.5.2.72 and then compare the databases - especially the pilots table, news table and pages table. Probably the best way is to copy the data ONLY from the old database to the new database - one table at a time. A little time consuming, but at least the table structure will remain intact in the new database. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.