New installation - not able to view the images

[jlbarnes]

Hello - I just installed photopost to be integrated with Ikonboard v3.1.2. The integration seems fine as the user accounts transferred over. I have read a few posts on here describing similar problems as I am having, but now of the suggestions seem to fix my issue.

Basically, I cannot view the images that have been uploaded. There are no error messages, just a box with an X where the image should be displayed. If you check the url of the photo by right clicking and getting properties it is missing a numerical prefix. Here is an example: link that photopost tries for image - http://teampanoz.com/photopost486/da...87test-med.jpg

And, if you look through ftp software at that directory the image is at: http://teampanoz.com/photopost486/da...87test-med.jpg

notice the 116 prefix? Different users have different profixes.

Also, when logged in as administrator I get a thumbnail before confirming the upload. As a normal user I get just the filename.

My site is hosted by startlogic.
Apache/1.3.31 (Unix) mod_log_bytes/0.3 FrontPage/5.0.2.2635 PHP/4.3.10 mod_ssl/2.8.19 OpenSSL/0.9.7c
GD 2.0.28

my photopost install

test username:testdummy
test password:turbo

Thank you!
Jason

[Chuck S]

Okay I believe the userid structure has changed since we wrote the Ikonboard Integration

There will be two things you need to do to have our program compatible with IkonBoard

If you PM me site access I can help

It goes as this.

1. With a userid that long every userid field in our mysql tables needs to be changed from an int(8) field to a varchar(32) field.

Looking at their tables thats what they use

2. Next so the userid's get entered correctly for the pictures you need to encapsulate the $upuserid variables inside the insert and update queries in image-inc.php so the userid prefix does not get cut off before the -

Thus in that file $upuserid in those queries would become '$upuserid'

[jlbarnes]

Ok, I've looked at the changes you said were needed and want to double check them with you first.
Going through the database, here are the tables and types that use uerid as a field:
comments mediumint(9)
favorites int(8)
ipcache int(25)
iponline varchar(128)
laston int(11)
notify int(25)
photos int(8)
users int(25)

So, do all of those need to be changed to varchar(32)? Or is it just certain tables?
I honestly have never spent any time looking at databases, so this is all new to me. But, I have already learned a lot just looking up this info, and would like to fix this from this end with your help to learn more...

Ok, I also looked through image-inc.php. I see about 4 places which I assume are calls to INSERT INTO where $upuserid is passed, but none under UPDATE. Is this where I need to encapsulate them? How many places total should I make the change?

Thank you very much,
Jason

[Chuck S]

Jason

Update any field type that is int which means integer. It can't be this because the userid's have a character in them -

In Image Include the inserts is fine. In most of our program we encapsulate and use {$Globals['userid']} but since on upload this can change with the admin who can do upload as a different user there is this variable upuserid. Just encapsulate that variable in the inserts you find in that one file image-inc.php

[jlbarnes]

Well, I made the changes to the database and that seems to have done the trick. I also added the single quotes a total of 4 places in image-inc.php.

When I login as my test user I still don't get a thumbnail in the second screen when uploading. Is this how it is supposed to work, or do I still have issues with image-inc.php?

Thank you for the quick responses!
Jason

[Chuck S]

Yep your running fine now that you made the changes I noted.

Your thumb not showing on the bulkupload screen is a closed issue and you should download the package again and upload the bulkupload file again or add this to bulkupload below the line below add whats in bold

if ( !isset($donotdelete) ) $donotdelete="";
if ( $User['adminedit'] == 0 ) $dthumbs = "yes";