MySQL server has gone away problem

[eluser]basty_dread[/eluser]
A Database Error Occurred

Error Number: 2006

MySQL server has gone away

select * from thttpstatuscode order by OrderNo

I keep on having this error. I checked on the google and I increased my max_allowed_packet = 128M

I currently upgraded the MySql. Please help thankx

[eluser]Cristian Gilè[/eluser]
Hi basty_dread,

there are several reasons for the MySQL server has gone away error but the most common is that the server timed out and closed the connection.
Are you working with big BLOB columns? We need to know more about the query. T

Please, provide the code of the model and the controller.

Cristian Gilè

[eluser]basty_dread[/eluser]
what is a big BLOB column?

[eluser]Cristian Gilè[/eluser]
[quote author="basty_dread" date="1294932091"]what is a big BLOB column?[/quote]
Google is your best friend.

Please, provide the code of the model and the controller.

Cristian Gilè

[eluser]basty_dread[/eluser]
I dont use model, only the database model of CI, my controller only. but just a basic database query:
but mostly my database record is 2000+, and most are with content. Thanks.

[eluser]Cristian Gilè[/eluser]
How many records do you retrieve?

Cristian Gilè

[eluser]basty_dread[/eluser]
The issue is solved. I ask the hosting company to changed the wait_timeout value to 28800