Problem with database

The Archives Help Topics
1

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:
Status
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

regard

2

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

3

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

4

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

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

5

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.

6

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.

7