vb.org Archive
Page 48 of 52 « First 384647 48 4950 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)

Marco van Herwaarden 04-17-2005 05:25 AM
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.

boeserwolf 04-17-2005 12:01 PM
Does this hack work with the 3.07 too.

Not found a suitable answer here

yours

Markus

MichaelJM13k 05-06-2005 04:46 AM
Every time i try to install this hack i get an error:
Quote:
Warning: Division by zero in /album.php on line 142
Warning: Division by zero in /includes/functions.php on line 1861

There seems to have been a slight problem with the xbimpulse.com forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.7:

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

ORDER BY posts desc
LIMIT 0,

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9

mysql error number: 1064

Date: Friday 06th of May 2005 12:38:22 AM
Script: http://www.xbimpulse.com/forums/album.php
Referer: http://www.xbimpulse.com/
Username: MY USERNAME
IP Address: MY IP
Could you help me please? :surprised:

blueuniverse 05-06-2005 02:30 PM
Funnily enough, I get exactly the same error. I'd appreciate any help you could give us.

blueuniverse 05-10-2005 06:03 AM
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);

MichaelJM13k 05-11-2005 12:11 AM
Yeah, this hack sucks.
We need support!

dsboyce8624 05-11-2005 01:27 PM
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

dsboyce8624 05-11-2005 04:10 PM
Quote:
Originally Posted by MichaelJM13k
Yeah, this hack sucks.
We need support!
Yeah, there's a good way to get help.

dsboyce8624 05-11-2005 11:31 PM
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.

Marco van Herwaarden 05-12-2005 08:30 AM
You should have left the AUTO_INCREMENT in that statement, only remove the default value there.


All times are GMT. The time now is 10:52 AM.
Page 48 of 52 « First 384647 48 4950 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.01801 seconds
  • Memory Usage 1,752KB
  • 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_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