Bug issues with latest gallery paid version v1.1.1

[Liquor]

same info posted on vbulletin.org

installed latest version, updated on my vB 4.2.0 PL 2

1 data base error when I tried to import the vB Gallery.

Database error in vBulletin 4.2.0:
Invalid SQL:
   SELECT * FROM 'album';
MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''album'' at line 1
Error Number  : 1064

that was with IE if it matters, shouldn't but i couldn't reply wtih IE here...


below is the error message i got when i tried firefox with YES selected to clean up previous import. I assume it there due to the fact the previous import didn't start thus no importid

Database error in vBulletin 4.2.0:

Invalid SQL:

                DELETE
                FROM dbtech_gallery_categories
                WHERE
                    import_id        > 0 &&
                    import_type    = 'vb_album';

MySQL Error   : Unknown column 'import_id' in 'where clause'
Error Number  : 1054

Also lost my watermarks. "watermark text" is still displayed on images though i never changed my settings and my .png watermark was working properly

I used the fix for the import and it seemed to work correctly...but I have these issues now...

Sorry about that. I was a bit overzealous checking my variables I guess.

If you open dbtech/gallery/includes/class_import.php
On line 170 change

SELECT * FROM " . $this->registry->db->sql_prepare($table)

to

SELECT * FROM " . $table

The watermark was never on the lite version, were you running the beta?

Dylan

its the paid full release versions

import successful, no images displayed... Dragonbyte Gallery - MrDeids.com - Your Jeep and Online Gaming Social Network

when i try to rebuild gallery thumbnails it does them but i get this message before the page refreshes

Could not find phrase 'dbtech_gallery_rebuild_images'.

 

[Dylan]

I just released 1.1.2 which should fix a couple of those issues. On the watermarks, are you using the version from vb.org or from here? The vb.org version does not have watermarks available so while it might work if you previously had the pro version installed, you wont be able to fix them with the lite version installed.

With the no images displayed, does it work fine if you manually upload an image and it's only imported images that have the problem? Or both?