1. To be no good for anything, not right for its supposed purpose, not successful. English = (be) useless, (be) hopeless.
2. To be no longer good for its purpose because something is too old and broken, or used too much and no longer efficient or working. English = worn out, exhausted.