i want to display the files in filename ascending order. Somehow, the images are not being displayed corrected. The are displaying in the order like this: 1.jpg, 10.jpg, 11.jpg, 12.jpg, 13.jpg, 2.jpg,21.jpg.... Why 2.jpg would come after 10.jpg??
there's a default sorting order you can specify in coppermine config, and there's a user sorting order you can specify on each thumbnail screen. You probably have configured yourself (your admin user) to use another sorting method as the default user will have. Create a test user and check what sort method he has applied.
GauGau
Thats simply the way MySQL orders things, it doesnt have a natural sort afaik. Name your files with leading zeros to avoid this if you can.