Hello

Now I changed in such a way, but now I get one mysql errors.
Before I still "AS user" an "AS.." attached hattte was not the error.
Only the pictures were not indicated.
Neither in the Admincp nor in the album

Ungueltige SQL-Abfrage:
SELECT vb3_user.userid, dateline, comment, vb3_user.username, vb3_user.usertitle, vb3_user.joindate, vb3_user.usergroupid
FROM vb3_customprofilepic AS customprofilepic
LEFT JOIN vb3_user AS user USING (userid)
WHERE visible=1

ORDER BY posts desc
LIMIT 0, 18

mysql error: Unknown table 'vb3_user' in field list

mysql error number: 1109

The tables are called with me all vb3 _ and are also present. Also the vb3 _ table.

cu Deta

Now I get this error in the albumcp

See: https://vborg.vbsupport.ru/showpost....&postcount=433

Now I get a parse error instead. :[

Also images arent even showing on the album.

Hello,

after which I tinkered much and it does not go yet with the pictures,
now times the question.
I have the version 3.0.5 Vbulletin to to run.
What exact do I have to make in this version, which the pictures are indicated with me?
I have the GD2 on the Webserver.

At present I only one X get in the Gallerie indicated.

cu Deta

PLEASE HELP!!!!!

I still cannot get the thumbnail images to display in the album or admincp, even though the profile pics display correctly.

I have GD2+ installed & enabled.

Do I have to enable attachment thumbnails in posts for the album to work?

If so, is there another way to get it to work because I want the regular sized pics in the posts, not thumbnails?

Hello I Fond the problem.
Look hier: https://vborg.vbsupport.ru/showpost....&postcount=432

You must install all Files, an alle Patches... inkl. Templates..

:-)

cu Deta

Thanks. I still couldn't get the images to load after redoing it. Ijustended up displaying the actual profile picture instead of thethumbnail by changing type=pthumb to type=profile in albumcp.php and the album_image_list template.

Thanks, this is great. Everything installed fine, but the profile pics display as red X 's. How can I fix this? Thanks.

theres a fix for that browse the msg board...theres a thread about it

What message board, where? I just installed this and I'm having the same problem.

EDIT: Oh, nvm, I went one page back in this thread and it had a link to a post with all the info required. It works fine now.

good 2 go :nervous:

I have tray to install this to v 3.0.6 but I dont nowe howe I can Create a new template can some one help me ??

RTFM = Read the f. manual. http://www.vbulletin.com

Cheers,

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT user.userid, dateline,
comment, user.username, user.usertitle,
user.joindate, user.usergroupid
FROM vb_customprofilepic
LEFT JOIN vb_user USING (userid)
WHERE visible=1

ORDER BY posts desc
LIMIT 0, 20

mysql error: Unknown table 'user' in field list

mysql error number: 1109

Date: Sunday 20th of February 2005 07:39:13 PM
Script: http://10.0.20.65/VB/album.php

This Mod Work on 3.0.7 to?

yeah it does...even better ...

I got it to work in 3.0.7 but for some reason the images never show in the admincp when going to approve them....

I have the same problem, and in the profile the image is broken too...

Hello guys,

if I would like to add a short image next to each member name who has uploaded a profile pic in the showthread view, how would you implement something like this?

My understanding would be that it would do a query for each user to check if the blob data is in the DB and it would react upon the answer. This is fine if you would use this way of checking the DB for one pic but if you are viewing a thread with many postings of many users, this could kill your database performance.

Someone any idea how I could achieve this without killing my board?

Thanks in advance.

Cheers,

There is a hack for that right here on vb.org

edit : problem is solved !

When it's confirmed that this works with 0.7 I am so installing this!

Do you knwo how its named?

Hi,
I love this hack especially when my users are looking for place to display their pictures to their friends and admirers after installing i get this error message when i click on verify pictures i get this error message below:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT customprofilepic.*, user.username
FROM nwvb3customprofilepic
LEFT JOIN nwvb3user
USING (userid)
ORDER BY username

mysql error: Unknown table 'customprofilepic'

mysql error number: 1051

Can someone please help me fix this problem I will really appreciate it

thanks alot

Change the line:
to:

Hi Marco,
after doing what you told me to do I think it fixed it but I cant see pictures on the admin cp and there is no link to the photo album. Do you think there is something I missed? Please advise

thanks for your help

Just double check the instructions, or wait for the help of the coder.

Sorry i don't have this hack installed myself, so a bit difficult to help you more.

Hi VeloCD,
I have a problem with this hack, the problems keep shifting. I have installed and reinstalled this hack and I was able to see the admincp controls but I only have two options there, 1 is options and the 2nd one is verify pictures. I don't see anything else. When I click on the album link on the navbar i get an error message, please click below to see error message:

http://www.naijaworld.com/album.php


I would really appreciate it if you could help me, everybody seems to have it working except for me.

thanks

Hi all,
anyone here that have used this hack on vb3 successfully, please send me instructions on how to get this thing setup. I will really appreciate it, since he owner of the hack has suspended all support for the hack.

Anyone who think they can help me this hack please contact me at ozinetdot@yahoo.com

I get this error message whenever i try to run the queries requested in step #33, below is the error message

Error
SQL-query:

ALTER TABLE `customprofilepic` DROP PRIMARY KEY
MySQL said:

#1146 - Table 'naijawor_testvbdb.customprofilepic' doesn't exist


I have been getting this error message and I don't know what to do with it. If I am understanding this currectly it is saying customprofilepic doesn't exist which is true, but I do have something else

vb3_customprofilepic.

I am not sure if I should edit the query to match what I already have anyone please help thanks

I will appreciate it

Seems you are using a table prefix and the hack script on't support that here. Edit the file and put your table prefix in fron of the table names.

Does this hack work with the 3.07 too.

Not found a suitable answer here

yours

Markus

Every time i try to install this hack i get an error:
Could you help me please? :surprised:

Funnily enough, I get exactly the same error. I'd appreciate any help you could give us.

Can somebody help me reverse the queries. To be honest, I've spent ages on this, installing all the fixes and I still get the same errors. :S

The initial queries are

Yeah, this hack sucks.
We need support!

Velocd hasn't posted since last year, I doubt he'll be helping. Maybe sombody else could pickup the slack. I would love to use this, but I'm too noob-ish to do it without the chance of help.

Dennis

Yeah, there's a good way to get help.

Okay, I muddled through this. Of course I installed before I found there were fixes throughout the thread.

I found this link:

https://vborg.vbsupport.ru/showpost....&postcount=388

Which a mod should put up top and maybe replace the file to save some of us a bit of work.

I poked through the new file and if memory serves I found one difference which I edited in. Then I replaced the files.

I also noticed that if you paste all of the SQL lines in at once it errors, that's because they have CR/LF crap at the end of each line. Do them individually.

The only one I couldn't get was:

ALTER TABLE `customprofilepic` ADD picture_id int(10) unsigned NOT NULL default '0' AUTO_INCREMENT PRIMARY KEY AFTER userid;

Which (prolly screwed myself somehow) I removed "AUTO_INCREMENT PRIMARY KEY AFTER userid" from and it took. If somebody has a better way please post it. Or a way to fix what my change screwed up.

The only problem I have now is that my thumb nails aren't working. I clicked the rebuild and got the attached pic.

If you intend to install this please follow the link above first.

Now, suggestions on fixing my thumbs please?

EDIT: Actually, if somebody who does and somebody who doesn't have this installed could screen shot me the above mentioned table from MSQLAdmin I'd appreciate it.

EDIT: Okay, I created a test user and his thumb works. This one I don't understand.

EDIT: Okay, now I feel really stupid. After closing all windows everything works fine.

Go figure.

You should have left the AUTO_INCREMENT in that statement, only remove the default value there.