Extra Queries (v2.2) for Movienizer until v5.5

Additional plug-ins for the program.
TerribleFloater
Superstar
Posts: 1896
Joined: Thu Feb 28, 2008 4:20 pm

Re: Extra Queries (v2.0)

Post by TerribleFloater » Sat Sep 24, 2011 3:33 am

Well, here they are:
1. Installing V.2.0 (over V.1.1) into Plugins directory.
2. Starting Movienizer.
3. Starting V.2.0.
4. Checking "duplicates queries" (with/without case insensitivity). "Without" runs OK, "with" returns "Out of memory", as usual :-)
5. Deleting some movie by right click on its page. No responce.
6. Getting panic :-)
7. Restarting Movinizer.
8. Repeating pp.5-6-7.
9. Starting V.2.0.
9. Checking any query: the answer is "Database is locked".
10. Deleting V.2.0.
11. Restarting Movinizer.
12. Deleting some movie by right click. OK.
Хочу: чёрные списки, пол людей, пользовательские поля изданий.
Кинопоиск: Image ПлюсКинопоиск: Image

User avatar
JeF
Black Belt Squirrel
Posts: 1173
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: Extra Queries (v2.0)

Post by JeF » Sat Sep 24, 2011 7:41 am

Ok, i believe all that is due to the 'out of memory' pb (did you see your prefered movie again ? issue rising after another 12:25 ?).
Please try this v2.1 beta and let me know (should be: a) faster, b) no more 'out of memory' error)
JeF

edit: obsolete v21 beta removed

TerribleFloater
Superstar
Posts: 1896
Joined: Thu Feb 28, 2008 4:20 pm

Re: Extra Queries (v2.0)

Post by TerribleFloater » Sat Sep 24, 2011 6:14 pm

Yes, I believe this too.
I think the program (and the plugins of course) need some 'fool-proofibility' :-)
Thanks for response!
Хочу: чёрные списки, пол людей, пользовательские поля изданий.
Кинопоиск: Image ПлюсКинопоиск: Image

User avatar
JeF
Black Belt Squirrel
Posts: 1173
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: Extra Queries (v2.0)

Post by JeF » Sat Sep 24, 2011 7:23 pm

Hi,
TerribleFloater wrote:Yes, I believe this too.
I think the program (and the plugins of course) need some 'fool-proofibility' :-)
Thanks for response!
Did you get same issue with 2.1 beta or is it fixed ?
JeF

TerribleFloater
Superstar
Posts: 1896
Joined: Thu Feb 28, 2008 4:20 pm

Re: Extra Queries (v2.0)

Post by TerribleFloater » Sun Sep 25, 2011 8:48 am

Pros.
This query runs well. No "Out of memory".

Code: Select all

SELECT p.code, p.name, COUNT( d.person ) , m.in_collection FROM data d, persons p, movies m WHERE d.person = p.code AND m.code = d.movie AND m.in_collection = 1 AND d.mode = 3 GROUP BY p.code ORDER BY COUNT( d.person ) DESC
(Actors by movies in collection).

Cons.
Try this:
1. Open any movie card and clear the cast (maybe directors, writers, composers -- it does not matter). Then save the card. Sometimes changes are not saved. Any query returns "db is locked" in this case.
2. If changes are saved (and the cast is empty), try downloading info from the Internet. Then save the card. Sometimes changes are not saved. Any query returns "db is locked" in this case.
Хочу: чёрные списки, пол людей, пользовательские поля изданий.
Кинопоиск: Image ПлюсКинопоиск: Image

User avatar
JeF
Black Belt Squirrel
Posts: 1173
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: Extra Queries (v2.0)

Post by JeF » Sun Sep 25, 2011 2:03 pm

TerribleFloater wrote:Try this:
1. Open any movie card and clear the cast (maybe directors, writers, composers -- it does not matter). Then save the card. Sometimes changes are not saved. Any query returns "db is locked" in this case.
2. If changes are saved (and the cast is empty), try downloading info from the Internet. Then save the card. Sometimes changes are not saved. Any query returns "db is locked" in this case.
Tried 1) and 2) with several movies having hundreds of actors (like malcom X) and never got the message. What i did :
1- Start Movienizer
2- Go to movie card (malcom X)
3- In actors tab of update window, manually deleted all actors one by one (over 300) having my finger complaining... :)
4- called ExtraQueries plugin
5- run 'Actors by movies in collection' query : no pb
6- quit plugin
7- dowloaded info from the internet (always for malcom X), re-creating 300+ actors
8 - repeated step 4 & 5 : no message.

Did i miss something in the way to test ?
Important : When you say
Sometimes changes are not saved.
Do you mean that all deleted (or new) data is not visible on movie card after 'save' button ?
Each try i gave, i did see the actor list become empty and filled again on movie card after update window validation.
I'm testing using a large db (140 Mb, over 3000 movies in collection and over 4000 persons in collection) which is not so far from your db counts i believe.

I would suggest one thing to try :
When you do see that changes are not saved, click another movie card and after it is displayed, call the plugin : same issue ?
Another way : When you do see that changes are not saved, click another movie card and click back on previously modified movie : are changes now visible ?

A last suggestion : do you compact your database from time to time (File Menu > Compact the database) ?

JeF

TerribleFloater
Superstar
Posts: 1896
Joined: Thu Feb 28, 2008 4:20 pm

Re: Extra Queries (v2.0)

Post by TerribleFloater » Sun Sep 25, 2011 5:15 pm

JeF wrote:What i did :
1- Start Movienizer
2- Go to movie card (malcom X)
3- In actors tab of update window, manually deleted all actors one by one (over 300) having my finger complaining... :)
OMG, my condolences :oops: My choice was the movie with ten actors only.
JeF wrote:4- called ExtraQueries plugin
5- run 'Actors by movies in collection' query : no pb
6- quit plugin
Oh, no. My problems occured when saving the movie card; "I just call ExtraQueries to say I love you see db is locked" (© Stevie Wonder) when the card haven't saved correctly. Incorrect program behavior's depended on the plugin's presence, not calling or running. And I did not understand 1) why? 2) why sometimes only?
So I've checked my db structure and I think the cause is found. "CREATE INDEX ind_editions_movie ON editions (movie);" was missing :-(
So I've recreated the index, the trouble's disappeared. But I do not understand (see above 1) and 2))...
JeF, sorry :oops:
JeF wrote:A last suggestion : do you compact your database from time to time (File Menu > Compact the database) ?
Once a month I think.
Sorry again and thanks for your patience.
Хочу: чёрные списки, пол людей, пользовательские поля изданий.
Кинопоиск: Image ПлюсКинопоиск: Image

User avatar
JeF
Black Belt Squirrel
Posts: 1173
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: Extra Queries (v2.0)

Post by JeF » Sun Sep 25, 2011 7:40 pm

TerribleFloater wrote:So I've recreated the index, the trouble's disappeared.
Glad to read it's fixed.
thanks for your patience.
You're welcome :)
JeF

TerribleFloater
Superstar
Posts: 1896
Joined: Thu Feb 28, 2008 4:20 pm

Re: Extra Queries (v2.0)

Post by TerribleFloater » Mon Sep 26, 2011 3:09 am

JeF wrote:
TerribleFloater wrote:So I've recreated the index, the trouble's disappeared.
Glad to read it's fixed.
I'm glad too. The problem was fixing while the post was writing :-) it was the last suggestion for me.
All we need now is some new plugin for structure fixing ;-)
Хочу: чёрные списки, пол людей, пользовательские поля изданий.
Кинопоиск: Image ПлюсКинопоиск: Image

User avatar
JeF
Black Belt Squirrel
Posts: 1173
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: Extra Queries (v2.1)

Post by JeF » Mon Sep 26, 2011 11:06 pm

Hi,

v2.1 is out (see first post) and comes with :
- new feature : quick filter
- optimization

JeF

Post Reply