![]() |
Quote:
|
Quote:
You have my support this could be a very big feature to the Popup Hack :) |
Hey Geek can you do a estimate time when will new pop up version be with categories and all...
|
Quote:
|
I would REALLY like to get this hack working since our gallery is a very important part of the site. I have followe all directions to the T. This is what I see when I click the "Open" link under "My Pictures". What is realyl strange is that if you look at the file it is trying to open "sparkswillfly.jpg" the file is actually there under the thumbs folder BUT there is a number one in front of teh real file ("1sparkswillfly.jpg"). Why is it looking for the wrong file?
EDIT// I just realized it was pullign info from the forums db (old tables not yet deleted) before i split the gallery db off into it's own db. HOWEVER, my gallery db is named "pimprig_com_-_gallery". How can I get this gallery db name to work right? What code needs to go where? :) |
Quote:
|
hmmm.... had another user who had the same problem and I am trying to remember what the solution was.
If I remember right - mysql hated calling that DB by the fully qualified name as it thought you were trying to use the - operator (it too had _-_ in it). Seems like the solution was to take the db prefix out, then set the DB before the query and return it back after the query. I would personally avoid using hyphens as object names for this reason (though I know that doesnt help ;) ) |
Quote:
|
Just out of curiosity - can you see what happens if you put ` around the name ie `pimprig_com_-_gallery`
|
This is what I got when I added those around the field for database name (Ex: "'pimprig_com_-_gallery'"):
Database error in vBulletin 3.0.6: Invalid SQL: 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 'pimprig_com_-_gallery'.photos AS images INNER JOIN 'pimprig_com_-_gallery'.categories AS c on images.cat=c.id WHERE images.userid=1 and images.approved=1 ORDER BY images.date DESC LIMIT 0 ,13 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 ''pimprig_com_-_gallery'.photos AS images INNER JOIN 'p mysql error number: 1064 Date: Wednesday 25th of May 2005 05:40:38 PM Script: http://forums.pimprig.com/geek-gallery-popup.php Referer: Username: GlitterKill IP Address: 68.53.59.67 |
All times are GMT. The time now is 05:49 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|