Problem with database

Dear Dan,

I have big problem with xibo 1.7.2, I lost all work.

In first I have this message in browser:

too many redirection

My connection with client player is:
Le client a trouvé ‘text/html’ comme type de contenu de la réponse, alors qu’il attendait ‘text/xml’.
Échec de la requête avec une réponse vide.

and finally when I try to make new installation with existing database I have this message.
An error occurred populating the database. Statement number: 1. Error Message = [SQLSTATE[42S02]: Base table or view not found: 1146 La table ‘xibo.bandwidth’ n’existe pas]. File = [Array]. SQL = [CREATE TABLE IF NOT EXISTS bandwidth ( DisplayID int(11) NOT NULL, Type tinyint(4) NOT NULL, Month int(11) NOT NULL, Size bigint(20) NOT NULL, PRIMARY KEY (DisplayID, Type, Month) ) ENGINE=InnoDB DEFAULT CHARSET=utf8].

Please help me to recover my work in database


What did you do to get to this state?

You can’t install again in to the same database.

The best thing to do would be to restore a known good backup of your database and start from there

Thank you for your quick reply, I changed the default layout with a name that does not exist.
I have exported the data to a csv file, but not import it into a new database. All my work is in database.
Thank you for your help

You definitely didn’t try to upgrade or something like that?

What happens now if you try to visit your CMS login page?

When I try to access by cms I have this message:
Database not connect

When I try to access database I have this message
#1146 - the table ‘xibo.xxxxx’ not exist.

It sounds like you may have damaged the database trying to install a new copy in to the old database.

Please can you restore a backup from when it was working. That should resolve the problem.