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)

Quote:

Originally Posted by MarcoH64

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

So what would I do to correct it?

Do the following SQL statement and i post the output here.
[sql]show create table customprofilepic;[/sql]

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

Quote:

ALTER TABLE `customprofilepic` ADD thumbnaildata mediumtext NOT NULL AFTER profilepicdata;
ALTER TABLE `customprofilepic` ADD comment varchar(255) NOT NULL AFTER filename;
ALTER TABLE `customprofilepic` ADD disapproved smallint(5) not null default'0';
ALTER TABLE `customprofilepic` ADD reason varchar(100) not null;
ALTER TABLE `usertextfield` ADD sigdateline int(10) unsigned NOT NULL default '0';

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

INSERT INTO `settinggroup` (`grouptitle`, `displayorder`, `volatile`) VALUES ('vb3album', 968, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_perpage', 'vb3album', '18', '18', '', 10, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_pertr', 'vb3album', '3', '3', '', 20, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_approval', 'vb3album', '0', '0', 'yesno', 30, 0, 0);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('album_exempt', 'vb3album', '6,7,5', '6, 7, 5', '', 40, 0, 0);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9231, 0, 'settinggroup_vb3album', 'vB3 Member Album', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9232, 0, 'setting_album_perpage_title', 'Entries Per Page', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9233, 0, 'setting_album_perpage_desc', 'Specify how many entries will show for each page.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9234, 0, 'setting_album_pertr_title', 'Entries Per Row', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9235, 0, 'setting_album_pertr_desc', 'Specify how many entries will show for each row.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9236, 0, 'setting_album_approval_title', 'Require Approval', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9237, 0, 'setting_album_approval_desc', 'If selected, pictures will have to be approved via the AdminCP before visible by the public.', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9238, 0, 'setting_album_exempt_title', 'Exempted Usergroups', 5000);
INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (9239, 0, 'setting_album_exempt_desc', 'If you have approval enabled, but would like specific usergroups to be exempt from it, then <u>in a comma separated list</u>, specify those usergroup IDs.', 5000);

Thanks, sorry to repost but it is quite urgent.

Hi Guys,
I am still struggling with this hack, but i'm making head way, my latest issue is the error that I am getting when i click on upload picture, below is the error message i receive:

Parse error: parse error, unexpected '{' in /home/naijawor/public_html/includes/functions_upload.php on line 448

can someone please tell me how to fix it, I am not good with this code

Marco, you are the man please help thanks man

i gave up on this hack...i've uninstall it...half of the pictures dont even show up....

Quote:

Originally Posted by osariase

Open the file and go to that line. Compare any changes you made to what the instructions say. You probably have a stray bracket that should have been part of the edit.

Quote:

Originally Posted by MarcoH64

Do the following SQL statement and i post the output here.
[sql]show create table customprofilepic;[/sql]

Okay, so it was working fine, despite the SQL mess up.

Something else happened and I had to start over. I followed the new install without a hitch and left out the default value in the one SQL statement.

Seemed great, I was happy. Wrong. Still bunches of little red x's.

Anything else I can try? I cleared the browser cache and even rebooted the server.

Thanks,

Quote:

Originally Posted by osariase

Oops sorry, i missed your reply. Still need help on this?
PS Better send me a PM, or i might miss your reply again.

Has anyone come up with a way of notifying the Admin when a member uploads a pic that needs to be approved?

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 (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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.01570 seconds Memory Usage 1,748KB 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 (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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: