vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Custom User Status by Usergroup [Final] (https://vborg.vbsupport.ru/showthread.php?t=41166)

Elly 09-04-2002 04:26 PM

Thanks Jen ^_^

Allstar DC 09-14-2002 08:25 AM

any updates yet?

Jen 09-14-2002 09:09 AM

My apologies, I've been very busy the past week or so and haven't had time to look into these two issues.

I will work on them over the weekend and have a fix on the image issue and verify if there are conflicts with the other hack.

Jen 09-15-2002 04:33 AM

I tested the hack for using an image as the group custom status and had no problems using the standard HTML IMG tag to reference the image to be used.
PHP Code:

<IMG SRC="http://www.yourhost.com/yourimage.gif"

The standard HTML tag did work without problem. If it is not working for you please post some more information on exactly what behavior you are getting as well as what code you are using to display your image etc.

Allstar DC 09-15-2002 04:38 AM

i got the image working now, but for some reason i now get an error when tying to add or modify a usergroup.

i received the following error when trying to add a new usergroup"

Code:

mysql error: Column count doesn't match value count at row 1

mysql error number: 1136


Jen 09-15-2002 04:44 AM

Found the conflict with the Stars hack.

The database changes for Stars in admin/usergroup.php also occur with this hack and it's likely something was left out or changed improperly which is causing the conflict. I'll post an update to the sql for users who have Stars shortly.

Elly 09-22-2002 07:18 PM

Thank you very much Jen ^_^

Allstar DC 09-27-2002 06:37 AM

sorry for not replying, but i was on a short vacation

my errors are fixed, it had nothing to do with this hack, my database just got screwed up a lil.

about the stars, i have them installed too, but don't have anyprobs with it

JeffyJoe 11-12-2002 11:41 PM

Quote:

Originally posted by Jen
Found the conflict with the Stars hack.

The database changes for Stars in admin/usergroup.php also occur with this hack and it's likely something was left out or changed improperly which is causing the conflict. I'll post an update to the sql for users who have Stars shortly.

Jen, Have you updated the sql yet?
I had stars on mine and cannot get mine to work... I think the stars is the problem...

JeffyJoe 11-18-2002 06:36 PM

What does this mean?
Quote:

Database error in vBulletin 2.2.8:

Invalid SQL:
SELECT
post.*,usergroup.groupcustomstatus,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN usergroup ON usergroup.usergroupid=user.usergroupid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,2163,2198,2199,2202,2205,2396)
ORDER BY dateline

mysql error: Unknown column 'usergroup.groupcustomstatus' in 'field list'

mysql error number: 1054

Date: Monday 18th of November 2002 03:32:34 PM
Script: http://www.mysite.com/chat/chat/show...=&threadid=392
Referer: http://www.mysite.com/chat/forumdisp...p?s=&forumid=5

Specifically what does "mysql error: Unknown column 'usergroup.groupcustomstatus' in 'field list' " mean

(I have been screwing with this for a few weeks now and can't figure it out... considering hiring someone to fix this :(


All times are GMT. The time now is 02:01 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.01216 seconds
  • Memory Usage 1,741KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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