Thread: vBmoods 1.0
View Single Post
  #46  
Old 08-29-2002, 11:20 PM
Velocd's Avatar
Velocd Velocd is offline
 
Join Date: Mar 2002
Location: CA University
Posts: 1,696
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sorry I'm alittle late in responding to these questions, if you've solved your problem then don't pay any attention.

Quote:
Originally posted by sub
I seem not able to figure out why it's erroring out like this. *blink*
Quote:
Database error in vBulletin 2.2.6:

Invalid SQL: UPDATE post SET pagetext='gawd this betta work',MOOD='',allowsmilie='1',showsignature='0',ic onid='0',attachmentid='0' WHERE postid=''
mysql error: Unknown column 'MOOD' in 'field list'

mysql error number: 1054

Date: Friday 23rd of August 2002 10:34:59 PM
Script: http://www.xxxxxx.com/forums/forums/newthread.php
Referer: http://www.xxxxxx.com/forums/newthr...hread&forumid=2
It states there is an uknown column MOOD, which is correct because this hack called for no creation of the column "mood."

Be sure you follow the instructions exactly, and that these queries have been ran:
Code:
ALTER TABLE post ADD usermoodid SMALLINT (5) unsigned not null;
ALTER TABLE post ADD usermoodmessage varchar(50) not null; 
ALTER TABLE post ADD usermoodpath char(100) not null;
Quote:
Originally posted by Larry@IOG
Ok I have the Moods in my admin CP only problem is when a mood is selected on a new thread it will not show up at all. When someone does not selecta mood a box with a red X shos in its place.

I need some help it deprived me of sleep last night


Thanks

Larry
Uninstall the hack, and install it again following the instructions VERY carefully. That box witht the red X is showing because the mood image is not being found, which means either you have not added in moods in the admin cp, or there is a fault in your installation.

Quote:
Originally posted by Matt87
You think you could give us some smilies for it?
I actually use a totally different set then smilies, and that is set vBulletin.org uses. They work very nicely for moods.

You will have to visit Dark Project Studios (see the footer of vB.org for link) and ask for permission by the webmaster if you can use them on your site.
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01290 seconds
  • Memory Usage 1,769KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete