Forum Suggestions & User Assistance - Technical issues

I have been unable to post in 50+ since about 8pm this evening (eastern daylight time). I am able to log on and off the forum and change things on my control panel but any attempt to post just sits and sits...................

edit: started just a couple of moments after a previous post in another thread in 50+.

Same here!

Same here.

With Firefox the forum doesn't work at all. Only possible to access forum through Internet Exploder.

Thomas

No word yet on what the issue is, but everything works fine for me. Thanks for your patience.

Brian

With Firefox the forum doesn't work at all. Only possible to access forum through Internet Exploder.

Thomas

Same problem with me using Firefox 2.0.0.2 and Firefox 3.0 on both mac and PC. IE and Safari work fine.

Also a newbie here...can't post new threads since earlier today, July 10.

Whether it's in Firefox 2, 3, or IE 7, on two different computers, the results are the same. I hit submit, and immediately, I get a "server can't be contacted" error. No delay whatsoever.

Every time I try to make a post with about more than about as many lines as this post, I get this message:

Safari can’t open the page “http://www.bikeforums.net/newreply.php?do=postreply&t=439436” because the server unexpectedly dropped the connection, which sometimes occurs when the server is busy. You might be able to open the page later.

I haven't been able to send anyone a private message for the past several hours. All I get is the standard Windows message that "Internet Explorer cannot display the web page." I get the same message whether I'm logged in at home or at work. I also got the same message when trying to post to the Tour de France forum.

I can send a PM so long as it's brief.

I just posted to my Tempest thread with 9 pictures and cut one of them so IE may not be it.

I just posted this thread with no problems. FF 3.0 Win XP.

http://www.bikeforums.net/showthread.php?t=439780

EDIT: I have trouble posting in other forums.

Its still bad here. I can post in some forums, but not 50+. Any attempt to post results in a spinning arrow that never stops.

Others have new posts still appearing in 50+ as I can read them without problem.

I have verified that the problem exists at other computers from different locations.

I can't seem to reply to a PM, and some threads won't let me reply either

Can't make new topics as of 12:41 11/07/08

I've posted several posts with about two dozen pictures and no trouble.

Intermittent difficulties on 50+

A "quick" reply just shows the never ending circular arrow

An "advanced" reply gives a "Can't find the web page" error.

Does it have anything to do with PCad?

Does it have anything to do with PCad?

Well, if you want to point fingers, I'm ok with that. ;)

I suspect that it an issue with one server and certain forums and functions are on that one while others are not.

I can't post new threads either. It started yesterday July 10th. Tried IE7, Firefox 2 and now IE6 (different computer).

I can't pm. I managed to get a couple through that were shorter, but no longer. :(

this is a test. if i can post, then i know i can post here, there, and everywhere.

Please stop emailing me! I have no update at this time.

unable to post in ss/fg. same issues as everyone else.

You might think about putting an announcement up where everyone can see it. That would probably cut down on your email.

Not that it is any newsflash, but same problems here. Both posting and editing.

-Kurt

Avoid using SQL Keywords in posts. Those are what seem to be breaking the forums.

Avoid using SQL Keywords in posts. Those are what seem to be breaking the forums.

You got to be kidding me.... :eek: Okay, I will be nice and not say what I am thinking... (25 year veteran of SQL)...

of course Tom, you do know the following are SQL key words

AND
OR
WHERE

:lol:

Certain key words are apparently the ones doing it. Just not sure of the whole list of the ones causing it. Brillig and red house found the problem and by gum, they seem to be right.of course Tom, you do know the following are SQL key words


:lol:

I give up. What's an SQL keyword?

and they stopped me from being able to post just now until I removed them from your quote.

I give up. What's an SQL keyword?

http://msdn.microsoft.com/en-us/library/aa238507(SQL.80).aspx

Thanks.

That's pretty funny.

It seems to be random scrubbing of the key words, even in sentences.

Are you sure about that, Tom?
_______________________________________

Begin to accept foreign percent select file password insert CREATE TABLE

CREATE PROCEDURE findjobs @nm sysname = NULL
AS
IF @nm IS NULL
BEGIN
PRINT 'You must give a username'
RETURN
END
ELSE
BEGIN
SELECT o.name, o.id, o.uid
FROM sysobjects o INNER JOIN master..syslogins l
ON o.uid = l.sid
WHERE l.name = @nm

Silly GORM tricks, part III: SQL keywords as attributes

I was writing a very simple Grails application and ran into a problem when I accidentally used a SQL keyword as a property name. This post documents what happened, and how I (pretty easily) fixed it.

To illustrate the issue, consider a trivial Grails application called “messaging” with a single class called Message.


class Message {
String from
String to
String text
}

This is supposed to represent a simple email message, with fields to represent the sender, the receiver, and the text of the message itself. It seemed quite logical at the time to use the words from, to, and text for the fields, but that leads to problems.

I added a MessageController with dynamic scaffolding (i.e., def scaffold = Message) and started the server. When I accessed the MessageController link, however, I got

org.hibernate.exception.SQLGrammarException: could not execute query

In order to see the actual problem, I modified my DataSource.groovy file to add “loggingSql = true” in the dataSource section. After restarting the server, in the console window I saw that the exception was caused by a SQL command generated by the scaffolded list method in MessageController:


Hibernate:
select
this_.id as id0_0_,
this_.version as version0_0_,
this_.from as from0_0_,
this_.text as text0_0_,
this_.to as to0_0_
from
message this_ limit ?

This statement looks fine, and in fact there’s nothing wrong with it. I couldn’t see the problem until I switched to MySQL so that I could browse the database independently.

(Switching to another database is covered many places in the Grails literature. In short, it means adding the JDBC driver to the messaging/lib directory, creating the messaging database in MySQL, and changing the driverClassName, url, username, and password settings in DataSource.groovy.)

When I did that and checked the database with the MySQL client, I found the problem (or at least a symptom of it):

mysql> show tables;
Empty set (0.00 sec)

In other words, the problem was that the message table didn’t exist. Somehow the SQL used to generate the table in the first place didn’t work.

Logging the SQL as I did wasn’t sufficient to show me the CREATE TABLE statement. If, however, I go into Config.groovy and change the value of log4j.logger.org.hibernate to debug, I see in the resulting console:


[1125] hbm2ddl.SchemaExport
create table message (
id bigint not null auto_increment,
version bigint not null,
from varchar(255) not null,
text varchar(255) not null,
to varchar(255) not null,
primary key (id)
)

followed immediately by

[1125] hbm2ddl.SchemaExport Unsuccessful: create table message …
[1125] hbm2ddl.SchemaExport You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘from varchar(255) not null, text varchar(255) not null, to varchar(255) not null’ at line 1

The problem is that the word “from” is a SQL keyword. MySQL got upset when I tried to use it in the create table statement, as shown above.

How can I fix this? I could change the name of the from property, to, say, sender. Since Grails 1.0, however, GORM now has the ability to do custom ORM mappings, which feels like a cleaner way to solve the problem. Therefore, I added the following closure to my class:


static mapping = {
from column: 'sender'
}

Now the generated create statement is:


[1157] hbm2ddl.SchemaExport
create table message (
id bigint not null auto_increment,
version bigint not null,
sender varchar(255) not null,
text varchar(255) not null,
to varchar(255) not null,
primary key (id)
)

and the new error is

[1157] hbm2ddl.SchemaExport You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘to varchar(255) not null, primary key (id))’ at line 1

So apparently the word “to” is also a problem. I therefore modified the mapping closure to include it as well:


static mapping = {
from column: 'sender'
to column: 'receiver'
}

Like I said, it's random......:notamused:

Like I said, it's random......:notamused:

That's a whole lot a randomness.....

Well, they do seem to have fixed it. I was just emailed by our webmaster and the issue was related. They addressed it, so let's see what happens. :D

Appears that the developers at my day job must have been working on our DB. ;)

Looks like! :D At least we're up and running again.

There's an ad on the right side that's trying to load, and it's causing a high CPU load and eating up memory in Firefox 3.0.1, and it causes an error message in IE 7: Stack overflow at line: 0. I think it's an HSN ad.

There's an ad on the right side that's trying to load, and it's causing a high CPU load and eating up memory in Firefox 3.0.1, and it causes an error message in IE 7: Stack overflow at line: 0. I think it's an HSN ad.

I'm seeing the same thing. It's one of the ads in rotation in the right margin at the top. If I ack the error the ad hangs with the message "loading"

-Roger

I do not have posting rights in the Politics & Religion forum. Does anyone know how it could be fixed? Thank you all in advance!

I do not have posting rights in the Politics & Religion forum. Does anyone know how it could be fixed? Thank you all in advance!

Cycle Disciple:

You have yet to be deemed worthy by the Oracle and it's Acolytes! When you enter the Temple of P&R you must pledge to uphold it's credo and standards and if THAT is not a timely remedy then Forum Moderation Priests must exorcise your demons....

If you answered yes in the login for P&R and were not accepted then you should find a moderator and have then explain why. P&R is restricted due to some really bad attitudes making it UNHOLY so they want those who behave well with others to keep the forum open and tenable.

I'm surprised that I haven't located a sticky on this yet because I'm sure it's there and this is probably the most asked question here other that why is it taking so long to post and search?

I'm seeing the same thing. It's one of the ads in rotation in the right margin at the top. If I ack the error the ad hangs with the message "loading"

-Roger

This appears to be a recurring problem and I offer the theory that if the script is clean and good in our template then the advertisers or other 3rd parties are offering sloppy coding or we should forensically examine these ads as they come to us. I think some of them once were popups/unders and someone did a bad job removing code arbitrary to the blocker programs or browser features available. Instead of rewriting whole section they tried to encapsulate and quarantine some routine(s) in the hopes that it would work generically.

At any rate I would also offer that IE and Firefox are probably the most similar in heritage to Mosaic/Netscape and that would explain the problem occuring mostly in those two browsers.

My two pence bumped to a quid for inflation. Your mileage may not seem indicative if you drive a huge lorry.

Hi. I have recently joined, great community. I am having trouble searching by my user name, to find the threads or posts I have been involved in. Using the search function or clicking the find button next to my name in the member list have the same result, an error message telling me that what I am looking for cannot be found, and lists possible reasons, such as incorrect spelling or simply there ain't no such animal (not in those words...). Searching for other members' posts works fine, so it seems specific to myself. Wondering if the moderators could help on this one. Problem occured in different locations, on both PC and Mac.
Thanks a million

Hi. I have recently joined, great community. I am having trouble searching by my user name, to find the threads or posts I have been involved in. Using the search function or clicking the find button next to my name in the member list have the same result, an error message telling me that what I am looking for cannot be found, and lists possible reasons, such as incorrect spelling or simply there ain't no such animal (not in those words...). Searching for other members' posts works fine, so it seems specific to myself. Wondering if the moderators could help on this one. Problem occured in different locations, on both PC and Mac.
Thanks a million

If you will set your default to automatically subscribe to any thread to which you post (its best without the email notification for me), then when you log in, go to "User control panel" - every thread in which you have posted and in which there is a subsequent post will be listed, and you will not have to search. The search is done for you automatically by the forum program.

Three words for the past few days: SLOW, SLOW, SLOW. Pages take fffffoooooorrrrrreeeeeevvvvveeeeerrrr to load, and I've lost a couple of posts (including an early version of this post.....

OK, somebody just did something right, the page loading speed went WAY up in the last few minutes...