psnGallery2 : famous line 97

Posted on by

Quickfix to try.

Try to replace the famous line 97 :

if (!$wpdb->query("SHOW TABLES FROM ".DB_NAME." LIKE '$psnGalleryTable'"))

I wrote try because I can’t reproduce on my side the issue…..

Give me your feedback !

Sorry to be so absent but I have a lot of work…..

14 thoughts on “psnGallery2 : famous line 97”

  1. Hi–I’ve been trying to get psnGallery2v1.4.0.A.1 working with WP 1.5 and Coppermine 1.3.2, and have run into the same problems discussed here and in the WP Forum. I’ve tweaked at (famous) lines 47, 97, and 160, but now I get this:

    Fatal error: Call to a member function on a non-object in /home/isogloss/public_html/wordpressfolder/wp-content/plugins/psnGallery2.php on line 101

    This is well beyond my ability to troubleshoot at this point. Any help in getting this working? Thanks in advance.

  2. @Joran:

    at the end of the modified line 97

    if (!$wpdb->query(“SHOW TABLES FROM “.DB_NAME.” LIKE ‘$psnGalleryTable’”))

    put an {

    so it actually should be

    if (!$wpdb->query(“SHOW TABLES FROM “.DB_NAME.” LIKE ‘$psnGalleryTable’”)) {

  3. I am not sure why, since I upgrade to psngallery2 v1.4, the cpgpicture tag show normal size picture as full size ? how can I correct this ?

  4. sorry… did not work for me – ive got a fresh install of psnGallery2 1.4.1a and an upgraded install of WP1.5…

  5. I have tried to install the latest version and got the error in line 97, changed the line with the new code and now I;ve got an error in line 160
    Parse error: parse error, unexpected ‘}’ in wordpress/wp-content/plugins/psnGallery2.php on line 160

    Any idea how to solve this problem?

  7. Now it works ! :-)

    The issues were :

    1. The database name for CPG is : “*******_***”
    2. The CPG Prefix is : “cpg11d_”
    3. in CPG itself, the “ecards_more_pic_target” was set to
    “http://coppermine.sourceforge.net/” instead of
    “http://www.friendphotos.com/”
    4. It seems that the wp_psnGallery table was generated in the CPG
    database instead of the WP database…I have to investigate this.

  8. Can you log into my wordpress and show me what did i wrong? I have follow the read me file step by step already.

    First , i run the install script at :

    http://friendphotos.com/me/wp-admin/psnCPGInstall.php

    and inputed my CPG database info and successed.

    and the i went in plug in under admin of word press to active the plug and i did it.

    but when i go to admin of psnGallery page at

    http://www.friendphotos.com/me/wp-admin/psnCPGAdmin.php?setup

    it gives me errors, can you help???????????????

    my wordpress login is: ************ Password is:************

    my friendphotos.com and friendphotos.com/me ftp login is:

    server: friendphotos.com
    Login: ************
    pass: ************

    my email is **********.

    THANKS!!!!!

  9. Is there a way to not show pics from private albums when showing random pics from all albums? or is there a way to show random pics from certain categories?

  10. Is there a way to not show private albums when you choose to show random pics from all? or is there a way to show random pics from multiple categories?