Uber Cms Help

[Gravy]

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

[MentaL]

[Unphased]

Well done on answering your own question. Your 'acc_pornbanned' needs a default value as it clearly states.

[Gravy]

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

[Unphased]

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.

[Gravy]

Fuck porn ban, Is there a way to completely delete it?

[Unphased]

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.

[Gravy]

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.

[Unphased]

ALTER TABLE `tablename` MODIFY `acc_pornbanned` VARCHAR(100);

Change tablename to the table your 'acc_pornbanned' column is located.

[Gravy]

Your a god but now i got this error "UberCMS has encountered an error
Field 'position' doesn't have a default value"



- - - Updated - - -

Wow im an idiot dont even reply to this XD

[HTML IS MY NAME]

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

[Unphased]

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.

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

It isn't the same command. For position we're adding a default value, not changing the field type.

EDIT: My bad. HTML IS MY NAME is right. I misread.