vb.org Archive
Page 10 of 13 « First 89 10 1112 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB3 Member Album 2.0 (https://vborg.vbsupport.ru/showthread.php?t=63733)

PitchouneN64ngc 11-13-2004 09:09 PM
No, this query was executed successfully during the first attempt (during the installation).

Try the other queries and see if all is ok after :)

HarryBO 11-13-2004 09:13 PM
Yor?re my personal Jesus! Big Thx that works! :D

HarryBO 11-14-2004 08:29 PM
Argh! I´ve found some error again! When User Update there Pic, it would be changed in ACP! There´s ever there first postet Pic!

Hades-1 11-16-2004 06:05 PM
these ae my errors, i swear to god i tried eveythign inthis thread and nothing works, please help.

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

mysql error: Unknown table 'customprofilepic'

ALSO

Warning: Division by zero in /home/rvadmin/public_html/x-six/V.3/VB3/album.php on line 142

Warning: Division by zero in /home/rvadmin/public_html/x-six/V.3/VB3/includes/functions.php on line 1730
Invalid SQL:
SELECT user.userid, dateline,
comment, user.username, user.usertitle,
user.joindate, user.usergroupid
FROM vb3_customprofilepic
LEFT JOIN vb3_user USING (userid)
WHERE visible=1

ORDER BY posts desc
LIMIT 0,

I even ran the entire installation again, someone help please

ecarabin 11-19-2004 12:21 AM
Hi all, here's my first post.

Thanx for this hack. ^_^

I'm trying to install it on my board, and it seems to work. ( I installed the fixed version for 3.0.3 )
The queries were successfully executed, the first look at the album was ok ...

But I have some troubles

* In the Admincp, I just get red crosses for new picture profiles that have to be approved

* In the album, some of new pictures are ok, but some just show red crosses. I dont really understand.

* When I try type2 ( should show signatures ) I get this error

Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
                SELECT user.userid, user.username, user.usergroupid,
                user.usertitle, usertextfield.signature, usertextfield.sigdateline,
                avatar.avatarpath, user.avatarrevision, NOT ISNULL(customavatar.avatardata) AS hascustomavatar,
                customavatar.dateline AS avatardateline
                FROM vb3_user
                LEFT JOIN vb3_usertextfield AS usertextfield
                USING (userid)
                LEFT JOIN vb3_avatar AS avatar
                ON(avatar.avatarid = user.avatarid)
                LEFT JOIN vb3_customavatar AS customavatar
                ON(customavatar.userid = user.userid)
                WHERE usertextfield.signature!=''
                ORDER BY posts desc
                LIMIT 0, 18
       
mysql error: Unknown table 'user' in field list

mysql error number: 1109
I don't understand, since the table vb3_user exists ?!

An idea please ? ^_^

( sorry if there are english mistakes, I'm french ).

Boofo 11-24-2004 12:11 PM
Quote:
Originally Posted by ecarabin
Hi all, here's my first post.

Thanx for this hack. ^_^

I'm trying to install it on my board, and it seems to work. ( I installed the fixed version for 3.0.3 )
The queries were successfully executed, the first look at the album was ok ...

But I have some troubles

* In the Admincp, I just get red crosses for new picture profiles that have to be approved

* In the album, some of new pictures are ok, but some just show red crosses. I dont really understand.

* When I try type2 ( should show signatures ) I get this error

Code:
Database error in vBulletin 3.0.3:
 
Invalid SQL:
                SELECT user.userid, user.username, user.usergroupid,
                user.usertitle, usertextfield.signature, usertextfield.sigdateline,
                avatar.avatarpath, user.avatarrevision, NOT ISNULL(customavatar.avatardata) AS hascustomavatar,
                customavatar.dateline AS avatardateline
                FROM vb3_user
                LEFT JOIN vb3_usertextfield AS usertextfield
                USING (userid)
                LEFT JOIN vb3_avatar AS avatar
                ON(avatar.avatarid = user.avatarid)
                LEFT JOIN vb3_customavatar AS customavatar
                ON(customavatar.userid = user.userid)
                WHERE usertextfield.signature!=''
                ORDER BY posts desc
                LIMIT 0, 18
 
mysql error: Unknown table 'user' in field list
 
mysql error number: 1109
I don't understand, since the table vb3_user exists ?!

An idea please ? ^_^

( sorry if there are english mistakes, I'm french ).
Try changing:

PHP Code:
 FROM vb3_user 
to

PHP Code:
 FROM vb3_user AS user 

Hades-1 11-24-2004 12:59 PM
Quote:
Originally Posted by Slynderdale
Working out a couple bugs if you have it so attachments are saved to the file system and writing some code that lets you rebuild the album thumbnails.

Make my above fixes, that will fix images from being escapes twice. The image gets escaped already if you have it so your attachments are saved in the MySQL data base. This would cause errors with the thumbnails. The thumbnail doesn't get escaped when you save the files to the file system so this code fixes that and also fixes a small bug if theres an error with the thumbnail.


After you installed this hack and weasles fix,
find in path/to/forums/includes/functions_upload.php:
PHP Code:
      if ($type == 'profilepic')
      {
          require_once('./includes/functions_image.php');
          
          $image['name'] = $upload_name;
          $image['tmp_name'] = $filename;
          
          $thumbnail = fetch_thumbnail_from_image($image);
          $thumbnail = $thumbnail['filedata'];
  
         // Display thumbnail error to admins in an attempt to cut down on support requests due to failed thumbnails.
         if (!$thumbnail AND $imageerror AND $permissions['adminpermissions'] & CANCONTROLPANEL)
          {
             eval('$error = "' . fetch_phrase($imageerror, PHRASETYPEID_ERROR) . '";');
              $errors[] = array(
                 'filename' => $attachment_name,
                  'error' => $error
              );
          }
      } 
and replace it with:
PHP Code:
    if ($type == 'profilepic')
      {
          require_once('./includes/functions_image.php');
  
          $image['name'] = $upload_name;
          $image['tmp_name'] = $filename;
  
          $thumbnail = fetch_thumbnail_from_image($image);
          $imageerror = $thumbnail['imageerror'];
      $thumbnail = $thumbnail['filedata'];
  
      if ($vboptions['attachfile'])
      {
        $thumbnail = $DB_site->escape_string($thumbnail);
      }
  
         // Display thumbnail error to admins in an attempt to cut down on support requests due to failed thumbnails.
         if (!$thumbnail AND $imageerror AND $permissions['adminpermissions'] & CANCONTROLPANEL)
          {
             eval('$error = "' . fetch_phrase($imageerror, PHRASETYPEID_ERROR) . '";');
              $errors[] = array(
                 'filename' => $attachment_name,
                  'error' => $error
              );
          }
      } 
The rebuilding of the album thumbnails code is almost done.

what do i do if neither of these codes are in functions_upload?

can someon post their functions_upload file for this hack?

Pseudomizer 11-24-2004 12:59 PM
Quote:
Originally Posted by Hades-1
i hate you all

all people care about is themselves, everyone just ignores other peopls problems and posts and goes ahead and posts their own.

I could help but go to hell instead!!
Hello Hades,

[offtopic]
these are not nice words. If you would have read the thread you should have seen that the checkbox "supported" is NOT checked. If you install a hack where the author didn't check this box, you should not expect that people will run to help you. All people here are not paid for support.

So pleaes don't blame people here like this and calm down. ;-)
[/offtopic]

Try Bofo's hints because he is very experienced in coding.

Cheers,

Hades-1 11-24-2004 01:11 PM
Quote:
Originally Posted by Pseudomizer
Hello Hades,

[offtopic]
these are not nice words. If you would have read the thread you should have seen that the checkbox "supported" is NOT checked. If you install a hack where the author didn't check this box, you should not expect that people will run to help you. All people here are not paid for support.

So pleaes don't blame people here like this and calm down. ;-)
[/offtopic]

Try Bofo's hints because he is very experienced in coding.

Cheers,
yeah i know and i did not mean the author.

it seems like people post a problem but it get burried by other people who dont even to read to see if its the same as theirs and they dont care, they dont care if you die they just want their album to work and i hate that.

ecarabin 11-24-2004 04:08 PM
* Thank you Boofo ! now it works fine !
Merci beaucoup :-)

* Hades I did read all posts of this topic before posting.
Not answering you didn't mean I didn't care about your problem.
If I could have helped you ... I would have done it !
but I really don't know what to do !!
I even find my question stupid now that I see it was so easy ... :-(

So even if I go to hell, I wish someone could help you.

bye.

Boofo 11-24-2004 04:49 PM
Quote:
Originally Posted by ecarabin
* Thank you Boofo ! now it works fine !
Merci beaucoup :-)

* Hades I did read all posts of this topic before posting.
Not answering you didn't mean I didn't care about your problem.
If I could have helped you ... I would have done it !
but I really don't know what to do !!
I even find my question stupid now that I see it was so easy ... :-(

So even if I go to hell, I wish someone could help you.

bye.
For future reference, any time you have more than one table accessed in a query, you must have each table AS table. ;)

Glad I could help. ;)

Boofo 11-24-2004 04:50 PM
Quote:
Originally Posted by Hades-1
what do i do if neither of these codes are in functions_upload?

can someon post their functions_upload file for this hack?
That code is added in the hack. Look at the install.html file and you will see it needs to be added first. ;)

Hades-1 11-25-2004 01:34 AM
Quote:
Originally Posted by Boofo
That code is added in the hack. Look at the install.html file and you will see it needs to be added first. ;)
no what i ment was the directions were like

replace

blah blah

with

blah blah blah blah

but neither were int he file so i wanted to see what someone elses looks like, but instead i am going to unzip it form the original zip and hack it

thanks for the help and sorry for being rude it was not intended.

Hades-1 11-25-2004 02:10 AM
i take it back i need help

the gallery works except for images the are linked, i did every file edit here, i download the vb 3.0.3 fix zip and everything.

If some uploads it works, if they link it shows red x or whatever.

I thought if i edit the upload picture page and made it say "if you want your image to appear in the gallery you must upload it from your pc"

but that did'nt work because when they do that it shows red x on gallery so there is a bunch of red x's for all the linked images.

Any ideas?

engquist 11-27-2004 06:10 AM
Quote:
Originally Posted by Hades-1
i take it back i need help


the gallery works except for images the are linked, i did every file edit here, i download the vb 3.0.3 fix zip and everything.

If some uploads it works, if they link it shows red x or whatever.

I thought if i edit the upload picture page and made it say "if you want your image to appear in the gallery you must upload it from your pc"

but that did'nt work because when they do that it shows red x on gallery so there is a bunch of red x's for all the linked images.

Any ideas?
I have a gallery full of red x's too, can we fix this? Even if I reupload a pic, it's still a red x, but it's not a red x on the memberlist

I have VBulletin 3.0.3

engquist 11-27-2004 07:15 AM
Now I've tried Slynderdale's fixes that were in that zip.

When I did that, I made all file chages again, then I got to the database part to do those changes again. I executed all those queries again (I assumed there were changes) and then it told me that they already existed so the query didn't finish or something.

so I ignored it. Then I finished the directions, and I still have red x's for pictures.

I decided I would try to re-upload my profile pic as a test. So I deleted in in my user CP, then I went to re-upload it and I got a database error something like this:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
                        INSERT INTO customprofilepic
                        (userid, profilepicdata, thumbnaildata, comment, visible, thumbnaildata, comment, visible, dateline, filename, filesize)
                        VALUES


mysql error: Column count doesn't match value count at row 1

mysql error number: 1136
can someone help me by giving me some sql queries I need to run so at least people can add profile pictures again without a database error, because I don't know any SQL.

thank you.

paulmjno 11-28-2004 06:36 PM
Having a prob: everything works fine, with the exception of the actual profile pics in the member album and in the album cp. The images do not display. I rebuilt the album thumbnails.

The image src's are: /path/to/foum/image.php?u=2132&type=pthumb

When I visit that URL, I get a page which displays: Array

paulmjno 11-28-2004 07:09 PM
Hm... I realise that this is yet another unsupported script... *uninstalling*

Pseudomizer 11-28-2004 08:01 PM
Quote:
Originally Posted by paulmjno
Hm... I realise that this is yet another unsupported script... *uninstalling*
Before you unistall it please read the thread. Your problem has been asked 19223462346 times. RTFM.

Cheers,

paulmjno 11-28-2004 08:18 PM
Quote:
Originally Posted by Pseudomizer
Before you unistall it please read the thread. Your problem has been asked 19223462346 times. RTFM.

Cheers,
Could you direct me to where the full fix is? And, why hasn't the zip file been updated with the fix?

I am using 3.0.3.

Pseudomizer 11-28-2004 08:23 PM
Quote:
Originally Posted by paulmjno
Could you direct me to where the full fix is? And, why hasn't the zip file been updated with the fix?

I am using 3.0.3.
I would have to search on my own. Sorry. And the reason why it is not in the zip file is very easy... unsupported thread but great hack.

Cheers,

paulmjno 11-28-2004 09:02 PM
OK, I downloaded the zip file, and made the changes. Things are better, but not completely fine. For instance, most pics show... but a few dont. Also, the signature dates are set to 1970...

mackers8923 11-29-2004 05:08 PM
I'm getting nothing but Red "X's" where the images should be. Is there a fix for this or have I missed something?

engquist 11-30-2004 05:32 AM
Quote:
Originally Posted by engquist
Now I've tried Slynderdale's fixes that were in that zip.

When I did that, I made all file chages again, then I got to the database part to do those changes again. I executed all those queries again (I assumed there were changes) and then it told me that they already existed so the query didn't finish or something.

so I ignored it. Then I finished the directions, and I still have red x's for pictures.

I decided I would try to re-upload my profile pic as a test. So I deleted in in my user CP, then I went to re-upload it and I got a database error something like this:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
                        INSERT INTO customprofilepic
                        (userid, profilepicdata, thumbnaildata, comment, visible, thumbnaildata, comment, visible, dateline, filename, filesize)
                        VALUES


mysql error: Column count doesn't match value count at row 1

mysql error number: 1136
can someone help me by giving me some sql queries I need to run so at least people can add profile pictures again without a database error, because I don't know any SQL.

thank you.
this is my issue if anyone can help ^^ *BUMP*

Hades-1 11-30-2004 02:06 PM
what i say is.....

finish this hack, or take it off this site.

its 100% im complete and probably just messing up most peoples boards.

I got this hack working as good as possible and it still sucks.

So i am removing it, what a waste.

venomx 11-30-2004 06:15 PM
This hack works fine for me.

Natch 12-01-2004 12:01 AM
Quote:
Originally Posted by Hades-1
what i say is.....

finish this hack, or take it off this site.

its 100% im complete and probably just messing up most peoples boards.

I got this hack working as good as possible and it still sucks.

So i am removing it, what a waste.
And for me...

Slynderdale 12-01-2004 01:54 AM
This hack does work, if you look above, this hack was made for vB 3.0.0, any versions higher then that, your basicly installing it at your own risk. There has been several changes to vB 3.0.3 that breaks this hack. I included some fixes for it that worked on my 3.0.3 after a clean install.


If you have an old member gallery 1.1, theres a migrating tool here that lets you migrate your old album over to the new one:
https://vborg.vbsupport.ru/showpost....3&postcount=76

If you have vBulletin 3.0.3, do a clean install with these fixes I posted here:
https://vborg.vbsupport.ru/showpost....&postcount=320

After you made these changes, you will have to rebuild the thumbnails to get them to show without coming up as an error or a red x. After doing so, clear your browsers cache and refresh the page.

If you already installed this hack, but not my fix above, first install weasel's update here:
https://vborg.vbsupport.ru/showpost....&postcount=281

and then make the updates in the posts on this page or could do a fresh install with the fixed version above which is recommended:
https://vborg.vbsupport.ru/showthrea...&page=21&pp=15

Note: If you already ran the SQL queries, you don't have to do so again. Only file changes are needed to get this hack to work for 3.0.3. This isn't my hack, but Ill try to give limited support for 3.0.3 forums when I can. I was hit by a car in a hit and run incident the other day so I haven't been able to use the computer without being in some pain the past couple days.

docvader 12-11-2004 09:41 PM
Installed easily and working well on 3.03. Thanks very much!

rich
http://x.russbo.com/index.php

MikaK 12-17-2004 08:53 PM
Nice hack for the very purpose. I started installing this on 303 based on the original hack... Boy... I suffered tearing hair off my head... Untill I came a cross the 303 -fix.zip by Sly... err... something (too darn tired to remeber) + a comment by Boofo and the sun started to shine - and that made my day:D

Thanks!*installs*
-Mika-

tobkat 12-18-2004 11:46 AM
I've installed the Hack successfully and it seems to work. I tried to upload a picture with the admin account but the picture won't show up in the album. the name "admin" is displayed but there is no picture beside it. help, anyone ?

tobkat 12-18-2004 03:41 PM
Quote:
Originally Posted by engquist
Now I've tried Slynderdale's fixes that were in that zip.

When I did that, I made all file chages again, then I got to the database part to do those changes again. I executed all those queries again (I assumed there were changes) and then it told me that they already existed so the query didn't finish or something.

so I ignored it. Then I finished the directions, and I still have red x's for pictures.

I decided I would try to re-upload my profile pic as a test. So I deleted in in my user CP, then I went to re-upload it and I got a database error something like this:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
                        INSERT INTO customprofilepic
                        (userid, profilepicdata, thumbnaildata, comment, visible, thumbnaildata, comment, visible, dateline, filename, filesize)
                        VALUES


mysql error: Column count doesn't match value count at row 1

mysql error number: 1136
can someone help me by giving me some sql queries I need to run so at least people can add profile pictures again without a database error, because I don't know any SQL.

thank you.

Same Problem here....

Boofo 12-18-2004 05:40 PM
Quote:
Originally Posted by tobkat
Same Problem here....
List that whole query and maybe we can look at it. What are the values? ;)

boo.3 12-26-2004 04:50 PM
ok for the GD Graphics Library how do i know if i have it?

PitchouneN64ngc 12-26-2004 06:09 PM
Quote:
Originally Posted by boo.3
ok for the GD Graphics Library how do i know if i have it?
View your phpinfo if it says "GD" inside :)

MajorFm.com 12-31-2004 11:48 AM
Im gettin a small error...

When i rebuild the thumbs, it displays the list on a white page without any styles and then goes stagnant, nothing happens...

And the images are not showing...

www.majorfm.com/forum/album.php

MajorFm.com 12-31-2004 01:37 PM
Quote:
Originally Posted by Slynderdale
In vBulletin 3.0.3 the thumbnail code changed a bit so invalid thumbnails were made.

If you already installed this hack and Weasel's update:
( Weasles update can be found here: https://vborg.vbsupport.ru/showpost....&postcount=281 )
In the file path/to/forums/includes/functions_upload.php, find
PHP Code:
      if ($thumbnail)
       {        
         $image['update'] = ", thumbnaildata = '". $DB_site->escape_string($thumbnail)."'";
           $image['insert'] = "'".$DB_site->escape_string($thumbnail)."',"; 
Replace that with:
PHP Code:
      if ($thumbnail)
       {        
           $image['update'] = ", thumbnaildata = '$thumbnail'";
           $image['insert'] = "'$thumbnail',"; 
and then in admincp/albumcp.php find:
PHP Code:
         $DB_site->query("
             UPDATE " . TABLE_PREFIX . "customprofilepic
             SET thumbnaildata = '" . $DB_site->escape_string($thumbnail) . "' 
             WHERE picture_id = $image[picture_id]
         "); 
and replace it with:
PHP Code:
         $DB_site->query("
             UPDATE " . TABLE_PREFIX . "customprofilepic
             SET thumbnaildata = '$thumbnail' 
             WHERE picture_id = $image[picture_id]
         "); 
I did these changes, still no luck... also... the link for Weasel's update seems to be a fresh install, which means i can't actually follow it as its asking me to find and replace items that have already been replaced...

I know this hack/thread is kinda old now... but i hope someone can help.

boo.3 01-03-2005 02:45 PM
ok i get this error and don't know why..

when you say run the querys.. i see it has space in some do u run the "3" or all of them 1 at a time? i ran 1 at a time

Code:
Warning: Division by zero in /home/*******/public_html/forums/album.php on line 142

Warning: Division by zero in /home/*****/public_html/forums/includes/functions.php on line 1730
any idea what i did wrong?

Pseudomizer 01-03-2005 03:03 PM
Quote:
Originally Posted by boo.3
ok i get this error and don't know why..

when you say run the querys.. i see it has space in some do u run the "3" or all of them 1 at a time? i ran 1 at a time

Code:
Warning: Division by zero in /home/*******/public_html/forums/album.php on line 142

Warning: Division by zero in /home/*****/public_html/forums/includes/functions.php on line 1730
any idea what i did wrong?
This has been handled already in this thread ( if i am not wrong ).

Cheers,

MajorFm.com 01-03-2005 11:54 PM
any help with me...?


All times are GMT. The time now is 01:09 AM.
Page 10 of 13 « First 89 10 1112 Last »
Show 40 post(s) from this thread on one page

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.01756 seconds
  • Memory Usage 1,906KB
  • 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
  • (7)bbcode_code_printable
  • (8)bbcode_php_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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