vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Geek Gallery Popup for vBadvanced Gallery or PhotoPost 4 or higher (https://vborg.vbsupport.ru/showthread.php?t=73040)

T3MEDIA 03-13-2005 07:04 PM

Errors for days!

Quote:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT
images.imageid, filename, thumbname, extension, images.title, categories.title AS cattitle,images.width, images.height
FROM myvb3_adv_gallery_images AS images
INNER JOIN myvb3_adv_gallery_categories AS categories USING (catid)
WHERE images.userid=22610 and extension in ('jpg','gif','png') ORDER BY dateline DESC LIMIT 0 ,13
mysql error: Table mysite_com_-_sqlname.myvb3_adv_gallery_images' doesn't exist

mysql error number: 1146

Date: Sunday 13th of March 2005 03:54:56 PM
Script: http://www.mysite.com/forums/geek-gallery-popup.php?
Referer: http://www.mysite.com/forums/index.p...lery-popup.php
Username: MixedMam
IP Address: 24.229.168.188

tormodg 03-13-2005 07:07 PM

Quote:

Originally Posted by The Geek
If you use the front end program (either PP or vBadvanced) to move or reorganise the images, then it doesnt really matter as the images will always stay in the same physical location.
If you were to manually move them, you would break the front end programs depiction of the image as well as this popup.

HTH's :)

Ah, Geek...a warm, beardy, virtual kiss from me.

The Geek 03-13-2005 07:10 PM

Does this table exists?

myvb3_adv_gallery_images

T3MEDIA 03-13-2005 08:30 PM

Quote:

Originally Posted by The Geek
Does this table exists?

myvb3_adv_gallery_images

your updated php file isnt any good for me.
reverting back to the other one. oh well.

The Geek 03-13-2005 08:34 PM

Quote:

Originally Posted by T3MEDIA
your updated php file isnt any good for me.
reverting back to the other one. oh well.

The only difference is that it does a check for the thumbnail before displaying it. Nothing else should have changed. My guess is that you missed a setting in the new file - hence the reason I asked you if the table exists.

T3MEDIA 03-13-2005 08:56 PM

Quote:

Originally Posted by The Geek
The only difference is that it does a check for the thumbnail before displaying it. Nothing else should have changed. My guess is that you missed a setting in the new file - hence the reason I asked you if the table exists.

new setting? I reverted to the old file she works fine.

didnt realize I had to do mods inside the php file.

T3MEDIA 03-13-2005 09:02 PM

welp realized there was some code in the top that needed to be added. I totally forgot. now the window opens really small and all this text is in the box. dubble checked.
did it again. the same.

reverted back. all is well. Well the users that have that issue still are there but it still works.

I'll wait for a final update I guess. Thanks.

T3MEDIA 03-15-2005 05:21 PM

I found what the issue is. in the PHP you uploaded it asks this.

Quote:

//$gallery_server_path is the server path to the gallery
//something like:
//$gallery_server_path="/var/www/gallery";
photopost does not have such a directory. So I dont know what to put here and should I have a trailing slash or not.

GamerzWorld 03-15-2005 07:44 PM

Same error here

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 .photos AS images
INNER JOIN .categories AS c on images.cat=c.id
WHERE images.userid=171 and images.approved=1 ORDER BY images.date DESC LIMIT 0 ,13
mysql error: Table 'merlin_unity.photos' doesn't exist

All my file is correct yet its directing at unity.photos. The table is infact pp_photos

The Geek 03-16-2005 08:04 AM

Thanks for the rating.

Try this. I reposistioned the settings as it seems that some people are having difficulty setting them all (yes - even pp has a server path). Let me know if this works for you. If so Ill update the package.

nJoy


All times are GMT. The time now is 04:43 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
  • Page Generation 0.01219 seconds
  • Memory Usage 1,744KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete