Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2001, 07:51 PM
Gellpak Gellpak is offline
 
Join Date: Jul 2002
Location: Raleigh, NC
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am uninstalling what i have done to make vbb funtional again, but if someone who has had this problem or knows how to fix it will tell me i will probably install it again.....

I installed the avatar hack exactly as the readme stated, but the second to last file to edit (showthread.php) did not have the requested text to find contained within. i looked through it and it did contain the ,iconpath in a few places so i hoped that it was a more current version and continued to change the templates. now when i attempt to view the page i get the infamous MySQL database error and a horde of emails. the readme helped none in actually installing, just the script editing. so i didnt know where to upload the accompanying scripts or where i could find help. so, i came here. any ideas?
Reply With Quote
  #2  
Old 02-14-2001, 10:23 AM
Guest
 
Posts: n/a
Default

first of all we need the error message to figure it out.....but i im sure of the error do you use 1.1.5....if yes i know what you have not done right it take me 2 week to find this error....and if you do a search on avatar hack you will find a tread...i dont remember how many page long and you will surely find a solution to your proble if not ask me i will help you with pleasure

and the file go in the vb root

have a good day
Reply With Quote
  #3  
Old 02-14-2001, 11:38 AM
Guest
 
Posts: n/a
Default

Showthread.php has been slightly rewritten in 1.1.5. Look for a line which looks like:
$posts=$DB_site->query("SELECT post.dateline as dateline,post.postid as <continued>

If you can't figure out the problem, feel free to contact me on ICQ 17278616
Reply With Quote
  #4  
Old 02-14-2001, 07:50 PM
Guest
 
Posts: n/a
Default

heres the error.....

Database error in vBulletin: Invalid SQL: SELECT daysprune,lastvisit,lastactivity,cookieuser,userna me,password,usergroupid,timezo neoffset,iconpath FROM user WHERE userid=1
mysql error: Unknown column 'iconpath' in 'field list'
mysql error number: 1054
Date: Wednesday 14th of February 2001 02:57:57 PM
Script: /php/forums/index.php

i discovered in showthread.php the pattern to the new , select statement though i dont understand it, i added a

,user.iconpath as iconpath

on the end instead of a simple ,iconpath as is stated in the readme.

now unfortunately the same error continues in the index.php file.

i fixed that by inserting a new row in the database (iconpath, varchar 200) but its a bit of a quick fix i suspect
Reply With Quote
  #5  
Old 02-14-2001, 11:16 PM
Guest
 
Posts: n/a
Default

ok, i think i fixed all the problems. the readme was horribly inadequate.....

and i am having trouble figuring out how to add icons. placing them in the directory does not work, is that a problem in itself?

now im having trouble with an upload script i am writing. ill redirect you to the post ---

http://www.vbulletin.com/forum/showt...&threadid=8702
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:33 AM.


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.04253 seconds
  • Memory Usage 2,185KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (1)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete