Install script problem - invalid sql error

[GeoffE]

Hello,

Just installing Gallery for the first time on a test board (3.0.7) and I get the following error just after the image section in the install script:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT * FROM vb3_template
WHERE template.title IN('imgdir_attach', 'imgdir_button', 'imgdir_editor', 'imgdir_misc', 'imgdir_poll', 'imgdir_rating', 'imgdir_reputation', 'imgdir_statusicon', 'titleimage')

mysql error: Unknown table 'template' in where clause

mysql error number: 1109

Date: Thursday 17th of March 2005 08:20:22 AM
Script: http://www.clubdogma.com/testforum/a...s&pagenumber=1
Referer: http://www.clubdogma.com/testforum/a...ry_install.php

The script crashes out with no way to go forward. Any ideas? The only unusual thing about the install is that I've had to rename the Gallery directory to VBAGallery as I already use another gallery with the same dir name. I understood this could be setup via the AdminCP afterwards though and shouldn't affect the install?

Sorry about that. I just made some changes to the install files for all 3 scripts last night so that it would no longer be necessary to modify your style paths manually and apparently had a small error that would affect those who use table prefixes. I've just updated the packages here, so if you'll download the files again and re-upload the install file then that should take care of the problem.

[GeoffE]

Working fine now, thanks for the quick reply.

[sunnycher]

This is the same error I'm getting on my install now.

[mholtum]

Originally Posted by sunnycher

This is the same error I'm getting on my install now.

Then redownload a fresh set of files and upload those to your server

[sunnycher]

smarty LOL

[sunnycher]

YAY!! MIKE TO THE RESCUE!! mholtum! You ROCK! you are THE BEST!
Thank you SO much for hangin in there with me and fixing it all for me!
If you were here right now and I wasn't married and you weren't married,,,well I'd....I'd Kiss you LOL!!!
THANK YOU THANK YOU!
You are THE BEST!!!!!!!!!!!!!!!!!!!!!

[sunnycher]

Originally Posted by sunnycher

YAY!! MIKE TO THE RESCUE!! mholtum! You ROCK! you are THE BEST!
Thank you SO much for hangin in there with me and fixing it all for me!
If you were here right now and I wasn't married and you weren't married,,,well I'd....I'd Kiss you LOL!!!
THANK YOU THANK YOU!
You are THE BEST!!!!!!!!!!!!!!!!!!!!!

No problem.. Once I fixed your errors () it was an easy install...

Glad to help

[oldengine]

I got this page not found error on fresh install files of today.

http://www.mydomain.com/forum/adminc...s&pagenumber=1

do=doimages&type=styleimages&pagenumber=1

This was right after updating smilies. What's next?

Everything appears to be working. Did I miss anything?

[Zachariah]

The only thing that may not work is a few smiles.
- You may need to edit the smiles and add a full URL to the smile