PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Bug Reports

Photopost Pro Bug Reports Post post installation PhotoPost Pro problems here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old February 26th, 2009, 06:55 PM   #1 (permalink)
Member
Verified Customer
 
Join Date: Feb 2009
Posts: 117
SQL Error on vb3.php

OK, I went troubleshooting some errors and I discovered one that might not have been mentioned.

For whatever reason I deleted the "Location" category from the default VB3 install.

This caused an error to show whenever navigation to the profile or viewing an image.

Added the field yourprefix_field2 to yourprefix_userfields in the VB3 database and all is well now.

Now here is an interesting one.
The: {$Globals['vbulletin']}
Is constantly appending /forum/ to things like the avatar picture and a few javascripts. I do not have /forum/ I use /
I know the instant answer is my paths are wrong - except I have check those the ways from side ways. Keep in mind my gallery is actually working pretty good execpt for a few annoyanses... Any know where this /forum/ is coming from?
cory_booth is offline   Reply With Quote
Old February 26th, 2009, 07:09 PM   #2 (permalink)
Member
Verified Customer
 
Join Date: Feb 2009
Posts: 117
OK figured this one out.
Now I check all the settings and they were right.
So I did a database search using phpMyAdmin for /forum and whalla.
I found the error: URL to your forums main directory was appended with forum.

Why this did not show in the php or admin pages I do not know...

Now trouble shooting some java errors and wondering why I can't Edt/Delete
cory_booth is offline   Reply With Quote
Old February 26th, 2009, 07:24 PM   #3 (permalink)
Member
Verified Customer
 
Join Date: Feb 2009
Posts: 117
OK getting closer to this one, and this may solve ALOT of prior posts.
When using Fiddler2 and running Photopost I see it try to load the following:
images/closelabel.gif
images/loading.gif
clentscript/vbulletin_stdedit.js
clientscript/vbulletin_editor.js
photopost/js/tjpzoom.js

None of these exist. I JUST bought VB 3.8.1 and Photopost yesterday - so????
Now going to see where I can get these files
cory_booth is offline   Reply With Quote
Old February 26th, 2009, 08:16 PM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,940
Code:
Content visible to verified customers only.
Thats straight out of vb3.php your forum url in admin => forum settings has to be incorrect.

images/closelabel.gif
images/loading.gif

You can change those in the js folder in a file called lightbox.js by making them full urls to those images

Code:
Content visible to verified customers only.
I have no idea what fiddler2 is

As far as clientscript files those are vb files and definately exist depending on your vb version.

Photopost tjpzoon.js file definately exists in the js directory under photopost

I would suggest you take a good look to make sure your url is correct for the forum
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old February 26th, 2009, 08:55 PM   #5 (permalink)
Member
Verified Customer
 
Join Date: Feb 2009
Posts: 117
I found the tjpzoon file - not sure how I missed it.
But....
loading and close does not exist in the current version of VB - in fact there are no images in the /images/ folder - they are all in subdirectories.

Speaking of... Your script calls for /images/dropshadow/n.png (nw.png,s.png,se,png,etc...) with the zoom function activated. I just redownloaded and they don't exist.

I have completly reuploaded photopost and find it still calling:
/clientscript/vbulletin_editor.js
/clientscript/vbulletin_stdedit.js

Which do not exist in the current VB zip file.
cory_booth is offline   Reply With Quote
Old February 26th, 2009, 08:58 PM   #6 (permalink)
Member
Verified Customer
 
Join Date: Feb 2009
Posts: 117
Fiddler2 is a freeware windows app that monitors your internet downloads and headers/sessions etc... You can quickly see the directories files are being called from and find mistakes real fast...
cory_booth is offline   Reply With Quote
Old February 26th, 2009, 09:10 PM   #7 (permalink)
Member
Verified Customer
 
Join Date: Feb 2009
Posts: 117
OK got it...
I turned off the VB3 Enhanced editor and that was then by default looking for the "older" files. Although I uploaded those files, it still didn't work...

I turned off the VB3 Enhanced option because I saw you posted that as a solution to the "Unable to Delete"

So...

I think I'm good now :-)
cory_booth is offline   Reply With Quote
Old February 26th, 2009, 10:29 PM   #8 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,940
Those vb files are only called if your running vb 3.0 that I see in the code so maybe your fiddler thing has a problem.

You would be getting errors viewing the photopost page if we where calling files that did not exist



As far as the two image close and loading gifs I posted the solution above in my post.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL error in member.php damon18 Classifieds Bug Reports 4 July 9th, 2007 04:33 PM
showimage.php? SQL error Noxious Installs and Upgrade - vBulletin 3.5.X 4 May 9th, 2006 09:03 PM
index.php cat SQL error(FIXED) Arnie ReviewPost Bug Reports 1 August 28th, 2005 04:57 PM
SQL error after VB3 upgrade tstaut Photopost Pro Installation & Upgrades 4 December 14th, 2004 12:17 PM
Final Step VB3.03 Install SQL Error Table doesn't exist... Barry M Photopost Pro Installation & Upgrades 13 October 10th, 2004 05:45 PM


All times are GMT -5. The time now is 02:24 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0