Hello, i hope you guys can help me. I keep getting this error, i know its a db error but i cant seem to fix it.
UberCMS has encountered an error
Field 'acc_pornbanned' doesn't have a default value
Printable View
Hello, i hope you guys can help me. I keep getting this error, i know its a db error but i cant seem to fix it.
UberCMS has encountered an error
Field 'acc_pornbanned' doesn't have a default value
Well done on answering your own question. Your 'acc_pornbanned' needs a default value as it clearly states.
No because when i try to correct it, i get this error. [Err] 1101 - BLOB/TEXT column 'acc_pornbanned' can't have a default value
This is because you're trying to use blob or text which in both cases cannot be used to set a default value. Try changing your field type to varchar and try again.Quote:
Originally Posted by GravyTrainChief
Fuck porn ban, Is there a way to completely delete it?
You could but it would require more effort for what it's worth. Attempting to just delete the column would set off a ton of errors.Quote:
Originally Posted by GravyTrainChief
Ok thanks for the warning what should i run to fix this. Sorry to ask to be spoon fed but im really desperate right now.
ALTER TABLE `tablename` MODIFY `acc_pornbanned` VARCHAR(100);
Change tablename to the table your 'acc_pornbanned' column is located.
Your a god but now i got this error "UberCMS has encountered an error
Field 'position' doesn't have a default value"
http://i.gyazo.com/7e0c108d88b1b1204e7bfa82adf2f603.png
- - - Updated - - -
Wow im an idiot dont even reply to this XD
Do as he just showed you, but change `acc_pornbanned` to `position` and change tablename to the table that `position` is located in, most-likely `users`.
ALTER TABLE `tablename` MODIFY COLUMN `position` DEFAULT '30';
Try that. It should set the default value of column 'position' to 30. Remember to edit 'tablename' again.
It isn't the same command. For position we're adding a default value, not changing the field type.Quote:
Originally Posted by HTML IS MY NAME
EDIT: My bad. HTML IS MY NAME is right. I misread.