I'm testing club website on my pc, I can create photo albums as administrator but when I try to write news or events and save it the website doesn't save it...why?
Plz do click "Mark as Answer" on the post that helped you. This will also give you point and help readers to know which post solved your issue and make their search easy.
I'sorry for my ignorance maybe I'm doing something wrong, it's long time that I don't use vwd...I've found the description table in club.mdf database but I can't change the lenght and properties of tables, If I'm not wrong I remember that I could change
this properties in vwd then I've tried to open the website's database with sqlserver management studio express but I can't change properties even this way. I've noted that when I've tried to start sqlsmse the server name was computer name/sql server but it
wouldn't start, the reason was that recently I've changed my computers name once I've pasted my new computer name in the name server window it starts. Is it possible that I can't edit tables properties for this reason or I'm completely on the wrong way? Is
it possible that my problem resides in sql that hasn't updated my new computer name?
No it will not throw an error, but it is because you are truncating a field. changing the varchar will fix the problem.
Why it does not throw an error is that the redirect is still triggering. Therefore you do not have a chance to see the error.
Thank you MaineOne, as you can read in my reply I'm not able to change varchar setting, can you please explain me how do this, I'll be grateful to you.
My last news is that if I copy and paste the text of news or events in the description box it isn't saved, if I write it myself it is saved!!!???Why...
Why this website isn't available in italian language?
I do believe if you are using VWD express you cannot change the settigs, but if you are using SQL management you should be able to. I'll check it out later today and give you a step by step.
As far as the copy and paste, again I will look into it more, but I believe it could be that you are copying from a app with formatting, what you are pasting into is a multiline textbox. Most people use http://freetextbox.com/ or
other html editor. That will allow you to save formatted text.
luigit
Member
3 Points
6 Posts
can't edit events and news pages
Nov 17, 2009 12:15 PM|LINK
Hi, I'm new to this forum,
I'm testing club website on my pc, I can create photo albums as administrator but when I try to write news or events and save it the website doesn't save it...why?
Thanks
I use C#
rtpHarry
All-Star
56620 Points
8958 Posts
Re: can't edit events and news pages
Nov 17, 2009 01:44 PM|LINK
do you get any kind of error?
luigit
Member
3 Points
6 Posts
Re: can't edit events and news pages
Nov 17, 2009 03:50 PM|LINK
No any kind of error, I've been redirected to news or event new pages but news and events aren't saved.
thanks
luigit
Member
3 Points
6 Posts
Re: can't edit events and news pages
Nov 19, 2009 09:00 AM|LINK
Short news or events are saved, longest one aren't...
please help me
MaineOne
Contributor
2087 Points
469 Posts
Re: can't edit events and news pages
Nov 19, 2009 11:46 AM|LINK
By default the description column is set to varchar(800), if you go into the Events table and set it to varchar(max) it should fix the issue.
nimish_soft
Contributor
2419 Points
459 Posts
Re: can't edit events and news pages
Nov 19, 2009 11:49 AM|LINK
I dont think this is the prob of field size, as he said no error is coming and if field size prob occurs, it throws exception...
Software Developer
IndiaMART InterMESH Limited, Noida
For Free ASP.NET & Oracle Code Snippets
Follow: http://nimishgarg.blogspot.com/
Plz do click "Mark as Answer" on the post that helped you. This will also give you point and help readers to know which post solved your issue and make their search easy.
luigit
Member
3 Points
6 Posts
Re: can't edit events and news pages
Nov 19, 2009 05:03 PM|LINK
I'sorry for my ignorance maybe I'm doing something wrong, it's long time that I don't use vwd...I've found the description table in club.mdf database but I can't change the lenght and properties of tables, If I'm not wrong I remember that I could change this properties in vwd then I've tried to open the website's database with sqlserver management studio express but I can't change properties even this way. I've noted that when I've tried to start sqlsmse the server name was computer name/sql server but it wouldn't start, the reason was that recently I've changed my computers name once I've pasted my new computer name in the name server window it starts. Is it possible that I can't edit tables properties for this reason or I'm completely on the wrong way? Is it possible that my problem resides in sql that hasn't updated my new computer name?
Thank you in advance.
MaineOne
Contributor
2087 Points
469 Posts
Re: can't edit events and news pages
Nov 19, 2009 10:41 PM|LINK
No it will not throw an error, but it is because you are truncating a field. changing the varchar will fix the problem.
Why it does not throw an error is that the redirect is still triggering. Therefore you do not have a chance to see the error.
luigit
Member
3 Points
6 Posts
Re: can't edit events and news pages
Nov 21, 2009 10:10 AM|LINK
Thank you MaineOne, as you can read in my reply I'm not able to change varchar setting, can you please explain me how do this, I'll be grateful to you.
My last news is that if I copy and paste the text of news or events in the description box it isn't saved, if I write it myself it is saved!!!???Why...
MaineOne
Contributor
2087 Points
469 Posts
Re: can't edit events and news pages
Nov 21, 2009 03:00 PM|LINK
I do believe if you are using VWD express you cannot change the settigs, but if you are using SQL management you should be able to. I'll check it out later today and give you a step by step.
As far as the copy and paste, again I will look into it more, but I believe it could be that you are copying from a app with formatting, what you are pasting into is a multiline textbox. Most people use http://freetextbox.com/ or other html editor. That will allow you to save formatted text.