DB error adding schedules

[g3r84]

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

[Nabeel]

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

[g3r84]

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

[Nabeel]

Hmm, that column is deprecated. It's odd it's throwing an error. What version are you on?

[g3r84]

Version 2.0.854 i downloaded it 2 days ago

[Nabeel]

What about mysql and php versions?

[g3r84]

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."

[g3r84]

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

[g3r84]

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...

[Nabeel]

INT null would have been ok. I'm looking into it, that field shouldn't be used since it gets it from the aircraft