What does this mean

hi im getting this in my database warning  : 27 clients are using or haven't closed the table properly

this is one thing that I have always wondered about with dolphin. When I furst started learning about php and mysql, I was under the impresssion that when you opened a connection to the database, you would need to close it after your queries were done. and then reopen as needed for next queries. Then I started using dolphin, nd with my normal practices I was closing the database connection and the site would jack up. This has always been a small concern but I never asked about it. Hopefully someone can give an explanation of why it seems that dolphin is not closing the connection to the db.

@imoverhere - Are you getting something that tells you the table names? If so try a repair on the tables where the problem is occuring. More information on what causes it is here. http://dev.mysql.com/doc/refman/5.0/en/myisam-table-close.html

@ProfessorSr - Not the same issue. Closing a table and closing a connection are two different things. For his issue the counter are out of sync. For your issue, The reason is dolphin uses persistent database connections meaning they stay open for a while to be reused. Suppose to be more efficient and is on high traffic sites that would trigger a large number of open and close requests, but can cause problems on hosts that limit the number of connections.

Does not matter much now anyway. Soon dolphin is going to have to change things over to using MySQLi because php is depreciating the standard mysql database functions as of php version 5.5.0.

thanks for the clarification Deano - as always, you are a great help.

Thankyou for the info and the help , many thanks