Error - DiscussPost::bind(*NULL*)
By Marco on Wednesday, 10 September 2014
Posted in Technical Issues
Replies 9
Likes 0
Views 625
Votes 0
Not sure if this a ES or ED problem but today I created a post in discuss and I got this error that crashed my website:

I had to manualy delete the ES stream database entry to make it work again..
Hello Marco,

I am sorry for the late reply.
The issue is with your database field. This field has a character limit which limits the param content; truncating the value of the field. Since your post is very long, this field cannot hold the content. So, I have run this query which updates your database tables.
ALTER TABLE  `#_social_stream_item` CHANGE  `params`  `params` LONGTEXT NULL

Initially, the this field 'params' is using 'TEXT'; in which there is character limit in TEXT format, so after I run this query, it will alter this table field to 'LONGTEXT' in which has greater limit compared to TEXT.

Hope this will help.
Thanks.
Yasser Ibrahim
·
Friday, 12 September 2014 10:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Marco,

I am sorry but I seem can't replicate this issue with your site. I have successfully post a discussion on your site without hitting this error. May I know how to replicate this issue on your site so that we can assist, debug and apply fixes need by your site.

Please be advise.
Thanks.
Yasser Ibrahim
·
Wednesday, 10 September 2014 17:31
·
0 Likes
·
0 Votes
·
0 Comments
·
http://www.brutalityguild.com/forum/game-update-notes-september-feature-patch

Copy/Past that post to a new one and click post.
Marco
·
Wednesday, 10 September 2014 17:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Marco,

Can you provide us with the correct ftp access so that we can help you debug this issue? Because when I login to your FTP I got this error:


Response:	530 Login authentication failed

Error:	Critical error

Error:	Could not connect to server


Please be advise.
Thanks.
Yasser Ibrahim
·
Wednesday, 10 September 2014 18:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Try now please, ftp was disabled.
Marco
·
Wednesday, 10 September 2014 18:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Any updates on this? Also I found a new bug..

Posted a reply on a ED thread and on ES stream it shows up with no content, check image for more details.
Marco
·
Thursday, 11 September 2014 00:10
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Marco,

I am sorry for the late reply.
It is not a new bug. Currently I'm commenting out some code in order for your site to work and we are still debugging this issue. I am sorry for the inconvenience caused.
Yasser Ibrahim
·
Thursday, 11 September 2014 00:31
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Marco,

I am sorry for the late reply.
I have helped you fixed this issue. It seems like there is an issue with the database. Your discussion post is very long and it reaches the limit which can be hold by the field in the database. To fix this, I have run some query to alter and update your database and now the issue is gone. Can you verify it for me is this issue is resolved?

Hope this will help.
Thanks.
Yasser Ibrahim
·
Thursday, 11 September 2014 12:55
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for the help Mohd, can you tell me exactly what was the problem with the database and what queries you used to fix it?
Marco
·
Friday, 12 September 2014 05:09
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post