| Author |
 Topic  |
|
|
AleŽ
Starting Member
Italy
25 Posts |
 Posted - 27 Oct 2017 : 01:15:30
|
Mi sono appena accorto che sono parecchi giorni che XMM non aggiorna piů il database con i nuovi film o serie tv inseriti.
Finché non chiudo il software pare tutto a posto, ma se chiudo e riapro tutto quello che ho aggiunto č andato perso. In pratica sembra che il database non venga aggiornato.
Come posso risolvere? |
|
|
JDommi
Administrator
Germany
4653 Posts |
Posted - 27 Oct 2017 : 09:43:50
|
How big is your database? About 2 GiB is the limit of every Access database.
When using the 32-bit release then try to do a "Compact & Repair". |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
 |
|
|
AleŽ
Starting Member
Italy
25 Posts |
Posted - 27 Oct 2017 : 18:51:40
|
The .mdb file is about 70MB.
I've uninstalled the software and then re-installed back and it seems to work.
Now I've only to discover how to put the list in alphabetical order because after the reinstallation all movies are shuffled... |
|
|
|
JDommi
Administrator
Germany
4653 Posts |
Posted - 27 Oct 2017 : 19:52:46
|
| Just click on the column header of the MainGrid. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
AleŽ
Starting Member
Italy
25 Posts |
Posted - 27 Oct 2017 : 21:29:10
|
| Thank you very much! |
|
|
|
AleŽ
Starting Member
Italy
25 Posts |
Posted - 28 Oct 2017 : 17:03:26
|
Now, another problem.
When I import a new movie, everything seem to be ok.
I got pictures, plot, actors and everythings the import engine takes from the web page.
When I close XMM and then reopen it, the movie is still there but all I have imported is gone...
If I create a NEW database (whitout using the DB with all my movies inside) and try to insert some movie, after closing and reopening XMM everything is fine.
So I think that my database may have a problem but I cannot find WHERE is this problem.
I've tried to edit the DB with MSAccess but nothing seem bad.
Can you help me? |
|
|
|
JDommi
Administrator
Germany
4653 Posts |
Posted - 28 Oct 2017 : 19:33:37
|
Only thing I can imagine is to use "Compact & Repair".
Maybe you can upload it to any server and I will try to do it for you. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
AleŽ
Starting Member
Italy
25 Posts |
|
|
JDommi
Administrator
Germany
4653 Posts |
Posted - 29 Oct 2017 : 07:21:13
|
| I will have a look in the evening as I have to go to work now. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
JDommi
Administrator
Germany
4653 Posts |
Posted - 29 Oct 2017 : 17:31:12
|
Well, the database structure itself seems to be ok for me. But there is a big gap between MovieID 6498 and 47400. Did you have manipulated the database manually? If so I think there is some kind of inconsistency that I can't find. What's strange, too: When adding a new movie there already is shown data that I didn't have typed in. Also on some of the "older" movies all actors are stored under awards.
I think this database really can be removed. It would last more time to find the inconsistency than to rebuild it. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
AleŽ
Starting Member
Italy
25 Posts |
Posted - 29 Oct 2017 : 23:04:36
|
I did not ever manipulated the DB. The only thing I can speculate is a trouble with the conversione from older version of XMM.
Now I will try to create a new DB and then cut/paste the field from the old to the new one.
Re-enter all films/TV series would be a endless work... |
|
|
|
JDommi
Administrator
Germany
4653 Posts |
Posted - 30 Oct 2017 : 01:30:44
|
| Good luck on that! |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
AleŽ
Starting Member
Italy
25 Posts |
Posted - 30 Oct 2017 : 23:28:41
|
So, finally I've solved the trouble.
First I've created a new empty database and then I've cutted/pasted all the field in the table "movies" from the old database to the new one with MSAccess.
Then I've copied all images inside the directory "oldDBname_cover" to the directory "newDBname_cover".
Now the new DB works fine and I've recovered all the movies/TV Series from old DB.
There was certainly a problem in the old DB since its size was about 67MB. The new one with exactly the same movies/TV series is only 27MB.
Thanks for your support. |
Edited by - AleŽ on 30 Oct 2017 23:29:32 |
|
|
|
JDommi
Administrator
Germany
4653 Posts |
Posted - 31 Oct 2017 : 10:55:56
|
Think of the other tables, too!
Especially the Episodes and the MovieFilesLinks and the EpisodeLinks.
Even the people have their own table. But here are entries for more movies than you have in your old database. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
AleŽ
Starting Member
Italy
25 Posts |
Posted - 01 Nov 2017 : 02:00:15
|
You are right....
I have to retrieve also other tables.
Tomorrow I will try. |
|
|
| |
Topic |
|
Non vengono salvati i nuovi film aggiunti