RevCMS Comments on News

[Habplay]

Once again, hello!

I'm running a hotel on my VPS and on localhost. Same db, same CMS, same SWFS, same everything. But on my localhost ''comments on news'' works perfectly, where it ain't on my VPS. Screenshot:

You must be registered for see links

- That's what happening when I try to comment. It's strange since I have imported the cms_news from my Localhost DB and it still don't work. Can anyone help? In advance, thanks.

 

[Kristopher]

Author don't have a default value. Change it to null or look where you are making it not set a value.

 

[Habplay]

Tried changing it to NULL, but it didn't work. Its Strange it works on my localhost with same db, when it ain't on my VPS. Thanks for the reply though


Sent from my iPhone using Tapatalk

 

[Joe]

Comments on the news is a completely different table. Try looking into the code to see what columns and tables you need to add

 

[Pinkman]

It may be because of your links. Is the hotel online if so is it possible you could give us the url so I could see what the actual error is.

Private Message me for more help!

 

[Habplay]

The hotel is online, Yes. Link: Sabbo.me


Sent from my iPhone using Tapatalk

 

[JayC]

ALTER TABLE cms_news
ALTER Author SET DEFAULT 'Unknown'

 

[iGlenn]

its saying that because the column doesn't exist so create it

cms_news > design table > add field author

or if you don't know how to do that just run this query

ALTER TABLE `cms_news` ADD `author` VARCHAR (999)

 

[Habplay]

Thanks guys. It's fixed now.


Sent from my iPhone using Tapatalk

 

[JayC]

its saying that because the column doesn't exist so create it

cms_news > design table > add field author

or if you don't know how to do that just run this query

ALTER TABLE `cms_news` ADD `author` VARCHAR (999)

Just so you're aware it said the column doesn't have a default value, not that the column doesn't exist.

 

[Habplay]

Check PM, Jay, thanks.


Sent from my iPhone using Tapatalk

 

[iGlenn]

Just so you're aware it said the column doesn't have a default value, not that the column doesn't exist.

i am half blind and don't have my glasses on so that explains the misreading