Registration Error

[Aaron]

Everytime you try to register on my site, it gives me this error: Unknown column 'vatsim' in 'field list'. I've looked everywhere and can't find what's happening. I have a field I added (not a custom field) called vatsimid and ivaoid in the phpvms_pilots table, and there used to be one called vatsim and another called ivao, idk if that helps at all. Thanks

[mark1million]

You should not add these manually, use the admin system to add a custom field Vatsim ID and IVAO ID on the registration page.

There is no need to edit the database directly.

[Aaron]

Well it is edited, and the edits work but there is a small error somewhere. And there is a purpose for the edit, there is some javascript involved in the way I did it.

[mark1million]

I know why you did it to make then required fields but that could have been accomplished another way.

Echo out your array to see what data is being passed, then you will have some idea whats going on, also check the insert query has not been overwritten and is still capable of being passed to the db.

Core>Common>RegistrationData.class.php

[Aaron]

ah, I think I found it, I used to have another field called vatsim along with the vatsimid one, but I got rid of it and now it's trying to insert a value into a column that doesn't exist. I think it will work, thanks for the help.

[mark1million]

No problem.