g3r84 Posted January 16, 2010 Report Share Posted January 16, 2010 Hi again... this time when adding an schedule to the db via the phpVMS Admin Panel got this error There was an error adding the schedule, already exists DB error: Incorrect integer value: '' for column 'maxload' at row 1 Im almost sure i didn´t put anything wrong on the data in form tu upload it here a screen of the data so can check http://i264.photobucket.com/albums/ii180/g3r84/phpvms/schedule1.jpg Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted January 16, 2010 Administrators Report Share Posted January 16, 2010 Can you enable DEBUG_MODE (set it to true) in local.config.php, and set /core/logs/log.txt to writeable. Then try adding it again, and attach the log here, thanks Quote Link to comment Share on other sites More sharing options...
g3r84 Posted January 16, 2010 Author Report Share Posted January 16, 2010 Done that the log is attached and checking it it says ' ' where should be the maxload value... but in the form for the schedule upload i dot see that log.txt Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted January 16, 2010 Administrators Report Share Posted January 16, 2010 Hmm, that column is deprecated. It's odd it's throwing an error. What version are you on? Quote Link to comment Share on other sites More sharing options...
g3r84 Posted January 16, 2010 Author Report Share Posted January 16, 2010 Version 2.0.854 i downloaded it 2 days ago Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted January 16, 2010 Administrators Report Share Posted January 16, 2010 What about mysql and php versions? Quote Link to comment Share on other sites More sharing options...
g3r84 Posted January 16, 2010 Author Report Share Posted January 16, 2010 PHP Version 5.3.0 MySQL 5.1.40 Checked on the db table on PHP MyAdmin and there is that 'maxload' column i tried to upload the data from an CSV and got this Airline with code VNE;511;MDSD;SVMI;KARIB UA554 REKON;;27000;;16::00;17::00;;;108;P;123456;1 does not exist! Skipping... The import process is complete, added 0 schedules, updated 0, for a total of 0 tried directly on the db via phpMyAdmin and the error was "The number of CSV data fields on line 1 is invalid." Quote Link to comment Share on other sites More sharing options...
g3r84 Posted January 16, 2010 Author Report Share Posted January 16, 2010 No idea yet for this error...? :'( I finally uploaded all the shcedules manually on phpMyAdmin via a custom csv made directly from the db structure Quote Link to comment Share on other sites More sharing options...
g3r84 Posted January 17, 2010 Author Report Share Posted January 17, 2010 Ok fully fixed now i can upload the schedule via the Admin Panel on phpVMS The problem was solved changing the maxload field on the phpvms_schedules table on the data base from INT NOT NULL to VARCHAR NULL. Can someone check that on the download it was form a fresh install of the version (2.0.854) Happy coding and good landings... Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted January 17, 2010 Administrators Report Share Posted January 17, 2010 INT null would have been ok. I'm looking into it, that field shouldn't be used since it gets it from the aircraft 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.