[FASherman]

To everyone getting an error like this:

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT count(id) total FROM [database].photos WHERE userid=[uid];

MySQL Error : Table '[database].photos' doesn't exist
Error Number : 1146
Date : Friday, November 4th 2005 @ 12:56:25 PM
Script : http://www.yoursite.com/forums/g...d=vB_Editor_001
Referrer :
Classname : vb_database

Do this...

FIND

PHP Code:

$pages = $db->query_first("SELECT count(id) total FROM $gallery_db" . $photo_prefix . "photos WHERE userid=$userid "); 


AND REPLACE WITH:

PHP Code:

$pages = $db->query_first("SELECT count(id) total FROM $gallery_db" . $pp_prefix . "photos WHERE userid=$userid "); 


I'm still looking to see what the problem is with the page links.

EDIT...

Okay, found it.

FIND:

PHP Code:

    $query="SELECT
        images.id AS imageid,images.cat,c.catname AS cattitle,'' AS extention,images.title,
        images.bigimage AS filename,images.medsize,images.width owidth, images.height oheight,images.medwidth width,images.medheight height
        FROM $gallery_db" . $pp_prefix . "photos AS images
        INNER JOIN $gallery_db" .  $pp_prefix . "categories AS c on images.cat=c.id
        WHERE images.userid=$userid and images.approved=1 ORDER BY images.date DESC LIMIT $start ," . ($perpage); 


ADD BEFORE IT:

PHP Code:

$start = ($page-1) * $perpage; 


That should fix the URL problem.