Wouldn't updating a file with no screenshot by submitting the PAD file again work better and be less risky?
I'd better make a backup, this could potentially mess up bad, if I understand correctly what it does.

There is a field (filefile_inuse) in the database. All unused files will be usual added to the next posted download, so this will hopefully fix the issue.

But how does it work? I mean, how can it tell which ones are "unused" if the file has 2 or three images attached?

Ok, I just added a routine (in update #7) to automatically remove all unsed images during PAD import. Let me know if this fix the duplicate images problem.

4092 was newly added, 4091 I am not sure (can I check using PHPMyAdmin whether it was updated or newly added?)

Yes, if you don't use the start/expire date feature. In this case you find the date of the first add in the file_startdate and file_expiredate fields.

I'm sorry to say that it doesn't. Besides like I said, it's the database side that performs badly.

Which pages in the admin section are performing badly? Can you give me a few examples?

Then turn it on. This should make a difference, especially with some of the heavier admin pages like the Instant Style editor.

I'm sorry to say that it doesn't. Besides like I said, it's the database side that performs badly.

Sadly, I have to report this bug is back.  http://www.file-portal.net/files/details/pdf4u_pro.html (record 4092) is left without a screenshot, and the previous file  http://www.file-portal.net/files/details/bs1_general_ledger.html (4091) got its screenshot instead. 4092 was newly added, 4091 I am not sure (can I check using PHPMyAdmin whether it was updated or newly added?)

Then turn it on. This should make a difference, especially with some of the heavier admin pages like the Instant Style editor.

Internet Explorer 9 on Vista Sp2 64-bit. Gzip is off.

There are not many database changes between 2.0 and 2.1

Have you already enabled GZIP HTML Output (under Settings => Website Setting) ? This option is disabled by default since 2.1.

Maybe it is Javascript related? The backend of Contentteller 2.1 is using more Javascript then 2.0. Which browser are you using to access the backend?

The tables are already MyISAM. And as far as I klnow most apps use MyISAM without any issues. And other apps I have installed on the same server are noticeably faster than CT (like I said I have Storyteller installed on  http://www.file-portal.net for testing purposes and it is very fast, whereas CT seems to be getting slower with every update. 2.0.4 was visibly faster than the 2.1 version). And as for accessing configuration options, most hosts won't be happy with changing settings for just one customer (especially as I am on shared hosting). Maybe you should try reducing the number of queries or maybe it's something within the PHP code, on the public side it's ok, but the cadmin interface is very slow.

You may want to look into what happens when a file already exists. I think it may have something to do with the "wrong screenshot" problem.

Actually, this cause indeed duplicate screenshots after Contentteller is importing the image during the PAD import. I will try to rewrite that function tomorrow.

As I've told you in another thread, CT feels really slow, compared to the older versions. And ST wipes the floor with it, speed wise (installed on the same server). DB updates feel very slow.

Contentteller depends heavily on the database server. Another customer had recently performance issues and it turned out that an unoptimized database server caused this problem.

Basically, Contentteller is using InnoDB tables as default but it seems that many MySQL configurations aren’t optimized for that table type, so it will slow down. As a workaround it may help to convert the database tables to MyISAM but the proper way would be some InnoDB related optimizations in the my.cnf configuration file.

You may want to look into what happens when a file already exists. I think it may have something to do with the "wrong screenshot" problem. Today I posted this:  http://www.file-portal.net/files/details/empires_online.html and then look at it. Two screenshots to two PAD files which I also tried to add today, but for which I got the message "The provided PAD source already exists in the database". As you can see the wrong screenshots are from the files I tried to post again today, which were already present in the database ( http://www.file-portal.net/files/details/mimosa_scheduling_software.html added on August 31st, 2012 and  http://www.file-portal.net/files/details/studyminder_homework_system.html also added on August 31st, 2012 (although I don't think the date when they were added has any relevance). It's kind of hard to keep track of the files I have already posted since the database already has about 4,000 records in it, and I have already complained about the lack of an "update this record if it already exists" button (  http://www.contentteller.com/forums/threads/please-fix-the-handling-of-file-already-exists-case.1419/ ). Hope this helps you deal with this bug.

I don't think that is what's causing it. First of all, since you are not using the screenshots inside the PAD files, mismatches are bound to happen (there are almost 4,000 files and just 1900 attachments for the files module). And as for the limits, I am not sure. As I've told you in another thread, CT feels really slow, compared to the older versions. And ST wipes the floor with it, speed wise (installed on the same server). DB updates feel very slow. No offense, but I'm not a programmer, you should the one doing some debugging. If you can't tell where your application is going wrong, you think somebody else will?
I will however, ask them about any limitations, but you should look into it as well.

Well, you told me above that you get "page cannot be displayed" errors. This is an explanation for that behavior after Contentteller will be interrupted in the middle of updating. Then again this is not a problem in Contentteller itself but has rather something to do with the server configuration.

I suspect that the webhosting company is running a script to limiting the PHP processes for your website. You could try to open a support ticket with them to see if they can increase or even remove that limit?

Have you made any progress on this bug? It's still happening. It looks like the images are getting inserted on the wrong records, but I don't what's causing it, and it's happening with newly added files as well (today), but strangely, not with all of them.

Unfortunately I don't know what's causing it. I can only assume that it's like this: sometimes when checking for PAD updates, when I press "edit entry" there will be an error with "page cannot be displayed" and and the record will not be updated, and then I try again and it's probably the wrong record is updated, or it's due to adding a pad file manually while the "check for pad updates" script is running.

This is an explaination. However, this is not a problem with Contentteller but with your webhoster. You should never get "page cannot be displayed" errors at all. Look like your host is using a script to limit the usage of PHP scripts.

Can you post step by step instructions how to reproduce this problem?

Unfortunately I don't know what's causing it. I can only assume that it's like this: sometimes when checking for PAD updates, when I press "edit entry" there will be an error with "page cannot be displayed" and and the record will not be updated, and then I try again and it's probably the wrong record is updated, or it's due to adding a pad file manually while the "check for pad updates" script is running.

The problem with current solutions is that they can't integrate with the user database. 

You're too much of a perfectionist. I'm sure people will forgive you for having to register again ) Besides, on github you'll get exposure.

Please add a bugtracker, it's really clumsy like this. You could use github.

I setup now this bug report forum as a temporary solution. A real bug tracker is coming most likely next year. The problem with current solutions is that they can't integrate with the user database.

Can you post step by step instructions how to reproduce this problem?