Album - Image Pagination

I'm using Acid Free with Drupal v4.7 and installation has been completed (slideshow and views works). However I have an error because I working with an old version of MySQL (3.23) which does not support the 'Offset' declaration used for the image pagination. After going through the acidfree.module code I replaced the offset declaration in the '_acidfree_pager_rewrite' function from 'limit 1 offset 1' to 'limit 1, 1' however this has only meant that I can move between the first and second images within the album, when i reach the second image the 'next', '3' and 'last' links contain the node id set to the current node, thus I cant progress. Does anyone know if Im on the right track by editing the _acidfree_pager_rewrite' function and better still does anyone know a way round this?

Thanks