Jump to content

PHPVMS 5 Error Adding Schedules


saj5020

Recommended Posts

Hello Guys, 

I've stumbled across this issue only today while finishing up my VA production. I tried adding them manually and via a .csv file but I'm getting the same error:

"There was an error adding the schedule, already exists DB error: Field 'route_details' doesn't have a default value"

I set the default value for 'route_details' to NULL and caused an error in another field (payforflight) which I fixed by setting it's value to NULL, after I did that, the schedules were being added but they weren't showing up on SmartCARS or the Schedule Search page.

 

These are the only two fields that were edited, screenshots were taken before I edited the tables.

https://prnt.sc/l8iq5k

https://prnt.sc/l8iq2u

 

Any help at all would be appreciated.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...