Revcms bug after adding code to show author.

Hello everybody,

Today I tried to fix my new author in REVCMS, on a rival forum I found this code:

ALTER TABLE cms_news MODIFY author VARCHAR(25) NOT NULL;

But when I try to post new now I get this error,

Field 'author' doesn't have a default value

How am I able to fix this?
Thank you for your reply,

-Maestro

Change the query, to:
ALTER TABLE cms_news MODIFY author VARCHAR(25) NOT NULL DEFAULT 'Unknown';

Thanks it worked!

But now it doesnt tell my name in the bottom but news works!
Thanks!

-Maestro

Quote:

---

Originally Posted by Maestrom

Thanks it worked!

But now it doesnt tell my name in the bottom but news works!
Thanks!

-Maestro

---

When you create the news, it is not adding the MySQL Query your nick.
Sorry for my english, i'm brazilian..