"Please excuse me, that was very impolite!"

Found this site last night in the wee hours of the morning. I was sleepy and decided I was too lazy to sign up, so I clicked the Facebook login button. That's where the trouble started.

Until that point, I could view any page just fine. After I attempted to sign up through Facebook, the entire site hated me. Every page I attempted to open told me "Please excuse me, that was very impolite!" and a bunch of update information that didn't go through.

I thought that my cookies were corrupted due to the attempted Facebook sign up (it didn't work, btw), so I cleared my cookies from this site and all temporary internet files. It worked! At least, I thought it did...

After a page, it started happening again. Same thing every time. The only way I've found to make it stop is to A) clear my cache every time I go to a new page or B) disable cookies for this site. Disabling cookies works, unless I want to log in and post, at which time I have to enable them again to stay logged in past the login screen.

Strange thing is, the Facebook cookie for this site keeps installing itself every time I visit the site--whether I log in or not. It seems to be the problem, because none of the other cookies seem to be causing this issue.

I have Firefox 3.6.13 and Windows 7. Please let me know if there is anymore system information that I need to give. Thank you.

The following is what pops up on every page:

Please excuse me, that was very impolite! - org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Exception

org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.instructables.transaction.TransactionHandler.invoke(TransactionHandler.java:112)
at $Proxy9.save(Unknown Source)
at com.instructables.filter.SecurityFilter.createUserFromFacebookDetails(SecurityFilter.java:319)
at com.instructables.filter.SecurityFilter.doFilter(SecurityFilter.java:153)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
at com.instructables.filter.SetupFilter.doFilter(SetupFilter.java:68)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:514)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:527)
at com.caucho.util.ThreadPool.run(ThreadPool.java:449)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.BatchUpdateException: Data truncation: Out of range value adjusted for column 'facebookUid' at row 1
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
... 21 more

here are a couple of pictures
aldjlf.png.pngUnknown.pngfilename.png.png
rachel6 years ago
This particular issue is being seen on a few cases, apparently where the Facebook account's ID value is very long. I hope to have a fix out by early next week.

As a temporary solution, if you go into your Facebook account and disable permissions for Instructables, you should be able to log in with your Instructables account. To disable permissions, log into Facebook and go to this URL:

https://www.facebook.com/settings/

In the lower left, under Apps and Websites, click the "Edit your settings" link. From that page, choose Instructables and click Remove App when the options box opens up.

Sorry you encountered this and please try again next week!