File Manager not showing uploaded Images

[Shepstar]

Hi Scott,

I have a problem that about 80 photos got uploaded via the file
manager but the list in the admin area only shows 30 of the uploaded
pictures.
Also if I go to Publish and try to insert a pictures it only shows me
the last 19 photos.

Old pictures that don't get shown in the file manager list or the pop
up window for inserting pictures, still get shown on the website where
they were inserted at the beginning. Hope you understand what I
mean ;)

Thanks for the help in advance.

[rm]

Are you are using the portfolio module to display those pictures? I
found that when I use the module, it would not allow me to select or
display images that I had loaded manually into the files->images
folder via FTP. Only those that were uploaded via file management or
uploaded fresh via the portfolio module interface. The images already
in the folder were accessible via normal means (say, img tag within
document content, for example). I remedied the specific problem images
in my case by editing the database table "pixie_files" with
phpMyAdmin.

[Shepstar]

Actually they all have been uploaded via the Filemanager not via FTP,
so it should work.

[Shepstar]

Nobody got a solution or a least something I could try?

[Scott]

Hi Shepstar
The Pixie file manager does not currently support pagination - its a
bit of a bugger but you do have a way around it. Providing you tagged
your images and files you can use the tag browser on the right hand
side of the file manager to find the files you are looking for. If you
cannot find the files and they are tagged, something else is wrong.

As for the limit in the drop down list - there should not be one. It
should list all of the image files that Pixie knows about in the
database. To me this suggests that your database and files in your
upload folder have become out of sync (normally caused by building a
site locally and not moving the database onto the live server).

If they have become out of sync you will need to correct this either
by hand - or you could write a little script that reattaches "lost"
files to the database.

Scott

[Shepstar]

Hi Scott,

thanks for the help. But everything got uploaded via the Filemanager.
I understand that this should work with the tags, but unfortunately it
isn't showing the pictures at all.
Even the dropdown list isn't showing the pics. Nothing got moved, nor
the database or the site.

Can you explain how I can sync it by hand?

[Scott]

Hi Shepstar
You will need to open up your files (files/images/) folder in an FTP
application so you have a list of everything you have uploaded. You
will then need to cross reference this list with the pixie_files
database table. You will need something like phpMyAdmin to look at
your database tables.

For every file you have in your files/images folder, you need to have
an entry in the database. If there is any difference between the
database and the folder you will need to either add a row to the
database (more likely) or remove a row from the database.

Your database tables look like this:

file_name file_extension file_type tags
Edit Delete 1 rss_feed_icon.gif gif Image rss feed icon
Edit Delete 2 no_grav.jpg jpg Image gravitar icon

Hope that helps

Scott

[Shepstar]

Hi Scott,

I checked the database with the images folder and it shows the exact
number of pictures. So each uploaded picture is also in the database,
but still if I go to the editor and try to insert a pictures it shows
me only the last 19 uploaded pictures. I checked the ID's and these
are the last 19 pictures which got uploaded in the exact order as they
got uploaded.

Is there a way that the filemanager shows every uploaded picture in on
one page without pagination?

[Shepstar]

Once again, I just went from the normal text editor for a page to the
portfolio plugin which I have installed and if I go to the image thumb
drop down menu it shows all pictures.
So it's only if I try to insert a picture in the text editor that it
doesn't show all of them.

[rm]

The problem is with imagelist.php in admin/jscript/tiny_mce folder. To
see all the files you've uploaded, at line 19, change:
$rs = safe_rows("*", "pixie_files", "file_type = 'Image' order by
file_id desc limit 20");
...to:
$rs = safe_rows("*", "pixie_files", "file_type = 'Image' order by
file_id desc");

Or, change the 'limit 20' to whatever number of items you wish to see
in the dropdown list.

[Scott]

We have been talking about different drop down lists! RM's fix should
work for you.

Scott

[Shepstar]

Thanks, that worked perfect.
Sorry about the mistake for the dropdown. It's always hard to explain
what you really mean.

Is there a way to extend the list in the filemanager, so it just shows
all uploads?

[rm]

If you look at line 152 in admin/admin/modules/mod_filemanager.php,
you can change:
$rs = safe_rows_start("*", "pixie_files", "file_type != 'x' order by
file_id desc limit 30");
..to something like:
$rs = safe_rows_start("*", "pixie_files", "file_type != 'x' order by
file_id desc");
... if you want all rows to be displayed, or just change the 'limit
30' part to whatever number rather than the last 30 files you want to
show.