vb.org Archive - vB3 Member Album 2.0

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)

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 ?

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....

Quote:

Originally Posted by tobkat

Same Problem here....

List that whole query and maybe we can look at it. What are the values? ;)

ok for the GD Graphics Library how do i know if i have it?

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 :)

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

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.

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?

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,

any help with me...?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (4)bbcode_php_printable (5)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01356 seconds Memory Usage 1,759KB 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 (3)bbcode_code_printable (4)bbcode_php_printable (5)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
Messages: