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
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
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](< base_url >/applications/core/interface/file/attachment.php?id=120)
Hmm, that column is deprecated. It’s odd it’s throwing an error. What version are you on?
Version 2.0.854 i downloaded it 2 days ago
What about mysql and php versions?
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.”
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
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…
INT null would have been ok. I’m looking into it, that field shouldn’t be used since it gets it from the aircraft