If there a way to reset the pid to zero ? when I delete all albums and create a new one, the pid did not reset to zero and I the photo file name is the same as the pid that is 0001.jpg would had the pid 1 and so on.
You can reset the pid to start from 1 using a database tool such as phpMyAdmin. You actually need to set the AUTO_INCREMENT value to 1 for cpg_pictures table. But make sure that there are no photos in cpg before doing so.
I had reset the pid to 1 and had my file name consist with the pid that 001.jpg would had pid 1. Thanks Ali for your help!!