thread won't preview or submit

[testerex]

Hello.

When I try to type in the following title for a thread the thread won't submit or preview. Any idea why?

Create filenames from the values in a MS Excel spreadsheet

Thanks.

[Doc.AElstein]

Hi Testiereg,
Welcome to the Forum

There are a few things like reported in the posts listed below that cause a sucuri firewall thing to spring in when you have certain characters in a post.
I have also heard of things in the title bar that cause some problem before. I think that is a different problem. I could not find the threads yet talking about that. I do remember that a forum Moderator, alansidman, knew something about it, but I have not found the threads yet were he solved it.
In any case, the usual thing is just to take bits out until you suss out the offending bits.

Like for

Create filenames from the values in a MS Excel spreadsheet

It seems to be the following like which all give problems

Create filenames from t
Or
Create filenames from Poo
Or
Create FiLeNames from 4
Or
Create FiLeNames from something quite disgusting I just thought about
Or
CreaTe filenames fRom wee wee and that is nothing like as disgusting as what I was just thinking about



So I am guessing that
Create filenames from x __ where x can be just about anything, is probably some command restricted to certain people to do something.
So if you just change the title to something like_..
Creating filenames from the values in a MS Excel spreadsheet
_..then you will be all right. But I see you have already posted with a slightly different title anyway_....
_.....In a few places ...
http://www.excelforum.com/showthread.php?t=1172356
http://www.excelforum.com/showthread.php?t=1172391&p=4574448&highlight=#post4574448
http://www.vbaexpress.com/forum/showthread.php?58458-create-filenames-from-the-values-in-a-MS-Excel-spreadsheet

By the way, - You should not really Duplicate posts, ( that means post in different Sub Forums at the same Forum),
and if you cross post (that means posting in different Forums ) then you should please copy the URL to the post in the other Forum from the URL bar and paste that in the post in this Forum stating that you are cross posting. That way volunteers can cross check to see if you have an answer that they were thinking about to avoid us wasting time. Thanks

Alan

P.s. Please check out the Rules before posting, Thanks
http://www.excelforum.com/forum-rules/642590-forum-rules.html

P.P.s Please mark the Thread as solved iif you are happy with the answer. ( You might want to wait a bit in case someone with a better idea than me ( and there are many such people ) come along with a better answer )
ThreadSolved.JPG: http://imgur.com/FPiV2Pv

_...............
_____________________________________-





Things known about that cannot be posted because of the restrictions of the sucuri firewall
http://www.excelforum.com/showthread.php?t=1143648&p=4412541#post4412541
http://www.excelforum.com/showthread.php?t=1122761&p=4295092&highlight=#post4295092
http://www.excelforum.com/the-water-cooler/1110566-trouble-connecting-to-site-4.html#post4226385
http://www.excelforum.com/the-water-cooler/1120911-unable-to-change-avatar.html#post4283991
http://www.excelforum.com/suggestions-for-improvement/1121606-sucuri-keeps-stopping-me-replying-to-a-thread.html
http://www.excelforum.com/showthread.php?t=1162371&highlight=#post4520072
http://www.excelforum.com/showthread.php?t=1152556&highlight=#post4502342

[FDibbins]

testing new thread title

edit: OK it would not let me use that tiotle either
Create filenames from the values in a MS Excel spreadsheet

But I shortened/changed it a bit and it was OK

[xlnitwit]

Hi,

I imagine that it is because the firewall is blocking CREATE as a potentially dangerous SQL statement- it's used for creating tables/databases. It appears not to be a well-tuned firewall.

[Doc.AElstein]

Hi Don

I imagine that it is because the firewall is blocking CREATE as a potentially dangerous SQL statement- it's used for creating tables/databases. It appears not to be a well-tuned firewall.

It did not seem to mind that on its own, just the complete strings I tried / showed
Al

EDIT: I thought this was a different problem to the Firewall thing. I seem to remember a Mod saying there are some commands that certain people have the privalege to put in the title bar, but I could not find the previous thread on it yet

[xlnitwit]

Indeed- it is perhaps the pattern combination of 'SQL-KEYWORD any-word FROM' that triggers it.

Tangentially, as the banner has disappeared, has there been any information on the success, or otherwise, of the database upgrade yesterday? So far this morning, all appears exactly as before- in other words, the usual timeouts, duplicate posts and database errors.

[Doc.AElstein]

Indeed- it is perhaps the pattern combination of 'SQL-KEYWORD any-word FROM' that triggers it.......

Tested

Create anything From something

Your right! it errored. Another one to add to the known naughty words.... like some others that I am thinking about just now which are very naughty apparantly

I seems like Business as Usual by me at ExcelForum also, lots of spinners database wonks and the such
EDIT 1 And I got 14 notificatuions of your reply , So looks like -Business as Usual ( That means the Forum Software is wonking about


EDIT 2

.... as the banner has disappeared,....

The banner come and goes... log-in , Log out, Refresh etc... It is sometimes to be seen, sometimes not
http://www.excelforum.com/showthread...03#post4574015
It was still there just now for me after Logging out and Logging in



EDIT 3 I just got 44 Notifications from your last post

[Doc.AElstein]

@ testerex
Hello

Time to mark the Thread as solved please

To do that:
_Go to first Post
_Select Thread Tools from the menu link above and mark this thread as SOLVED.



See this:
ThreadSolved.JPG: http://imgur.com/FPiV2Pv

[samchen]

I'm having trouble too!

But mine says I have html content? Any way I can remedy this?

[Doc.AElstein]

Hi samchen,

I....says I have html content? Any way I can remedy this?

Have you checked that what you are posting does not include some of the things that the Firewal does not like?
Scroll up , back to post 1

There are a few things like reported in the posts listed below that cause a sucuri firewall thing to spring in when you have certain characters in a post..........



Things known about that cannot be posted because of the restrictions of the sucuri firewall
http://www.excelforum.com/showthread...41#post4412541
http://www.excelforum.com/showthread...t=#post4295092
http://www.excelforum.com/the-water-...ml#post4226385
http://www.excelforum.com/the-water-...ml#post4283991
http://www.excelforum.com/suggestion...-a-thread.html
http://www.excelforum.com/showthread...t=#post4520072
http://www.excelforum.com/showthread...t=#post4502342

Alan

[samchen]

Ah! Fixed it. Thanks for the threads you attached. Having a space before and after < or > fixed it.

Thanks so much!

[Doc.AElstein]

Ah! Fixed it. ....a space before and after < or > fixed it.....Thanks ...!

Yous welcome

EDIT: Thanks for the rep thingy