vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - Username HTML Markup 4.2.x (https://vborg.vbsupport.ru/showthread.php?t=229146)

aj8690 12-12-2009 02:02 AM

This is causing database errors on RC2.

Charlie98902 12-12-2009 02:44 AM

Yep database errors when enabled.

ArcadeSyndicate 12-12-2009 06:51 AM

doesn't work with ibpro arcade.

Trek 12-12-2009 07:42 AM

Another report for DB errors on RC2, here's the error incase you need it:

Code:

Invalid SQL:

                SELECT forum.forumid, forum.lastpost, CONCAT(usergroup.opentag, forum.lastposter, usergroup.closetag) AS lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
                    , forumread.readtime AS forumread
                FROM dhv_forum AS forum
                LEFT JOIN dhv_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
                LEFT JOIN dhv_user AS user ON (user.userid = forum.lastposterid)
                LEFT JOIN dhv_userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
                LEFT JOIN dhv_user AS user ON (forum.lastposterid = user.userid) LEFT JOIN dhv_usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid);

MySQL Error  : Not unique table/alias: 'user'
Error Number  : 1066
Request Date  : Saturday, December 12th 2009 @ 03:40:07 AM
Error Date    : Saturday, December 12th 2009 @ 03:40:07 AM


Tize. 12-12-2009 10:37 AM

Great file, Installed.
Thanks added.
Regards.

mitch84 12-12-2009 11:07 AM

don't work with rc2

Greight 12-12-2009 02:49 PM

Quote:

Originally Posted by mitch84 (Post 1929271)
don't work with rc2

Databse Error:
Quote:

Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT forum.forumid, forum.lastpost, CONCAT(usergroup.opentag, forum.lastposter, usergroup.closetag) AS lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend

FROM forum AS forum

LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN user AS user ON (forum.lastposterid = user.userid) LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid);

MySQL Error : Not unique table/alias: 'user'
Error Number : 1066

Charlie98902 12-12-2009 05:26 PM

How many posts are needed to state this? This is a RC and a RC/beta mod give time to the developer.

MikalMirkas 12-12-2009 07:14 PM

Doesn't work for vBulletin 4.0 Release Candidate 2.

Charlie98902 12-12-2009 07:42 PM

Really? There is like 5+ posts stating this already. Give the coder time.

Stromba 12-12-2009 07:42 PM

yep indeed its not working on the VB4_C2

Hasann 12-12-2009 08:55 PM

Quote:

Originally Posted by Charlie98902 (Post 1929142)
Yep database errors when enabled.

Quote:

Originally Posted by Trek (Post 1929218)
Another report for DB errors on RC2, here's the error incase you need it:

Quote:

Originally Posted by mitch84 (Post 1929271)
don't work with rc2

Quote:

Originally Posted by MikalMirkas (Post 1929494)
Doesn't work for vBulletin 4.0 Release Candidate 2.

Quote:

Originally Posted by Stromba (Post 1929513)
yep indeed its not working on the VB4_C2

fixed database error on vBulletin 4.0 RC 2

aj8690 12-12-2009 09:19 PM

Thanks for fixing it! Is there any possibility of this working with the new sidebar? Some blocks on the sidebar show the username and this mod does not seem to affect it. Thank you!

Stromba 12-12-2009 09:36 PM

thanks hasann works great

halkum 12-12-2009 10:13 PM

Thanks for the update. Took me forever to find which mod it was crashing my forums.

Trek 12-13-2009 02:56 AM

Installed the one for RC2 (not crashing any more), but the usernames are whacked now:

Code:

Trekkan is offline now.">Trekkan
Other members are showing up blank.

The HTML markup is set (same as it is on my live 3.8 site) as such:

Code:

<span style="color: #FF6600;">
</span>

Not sure what the problem is.

ASPnix 12-13-2009 03:34 AM

Odd, once installing on our RC2 board we get
Code:

The service is unavailable.
Once we uninstall it, everything goes happy again.

EDIT: Strange, redownloaded it and its all good now :).

EDIT 2: Has issue... Each forum category...
Code:

by Chris is offline now.">Chris
All display ">

fahl 12-13-2009 07:58 AM

Quote:

by Chris is offline now.">Chris
Getting same problem

fahl 12-15-2009 03:59 PM

Sorted..
Works fine with RC2

Vaupell 12-15-2009 04:39 PM

Tx, works with new update.. cheers. installed :D

Mrquarter2 12-15-2009 09:40 PM

I am getting the same errors with the "is offline" crap.

Charlie98902 12-15-2009 09:43 PM

Charlie is online now neXt Tech™ Administrator Owner

I am not getting that. It may be a conflict with one of your mods.

whitetigergrowl 12-15-2009 11:01 PM

Quote:

Originally Posted by fahl (Post 1929772)
Getting same problem

Same problem here.

Trek 12-16-2009 05:26 AM

I guess we can't expect any support any longer:

https://vborg.vbsupport.ru/showpost....03&postcount=9

We don't "deserve" it... His choice, but pretty crappy thing to say. Ohh well.

Hasann 12-16-2009 06:57 AM

Quote:

Originally Posted by Trek (Post 1929689)
Installed the one for RC2 (not crashing any more), but the usernames are whacked now:

Code:

Trekkan is offline now.">Trekkan
Other members are showing up blank.

The HTML markup is set (same as it is on my live 3.8 site) as such:

Code:

<span style="color: #FF6600;">
</span>

Not sure what the problem is.

will fix the issue tonight
Quote:

Originally Posted by Trek (Post 1931533)
I guess we can't expect any support any longer:

https://vborg.vbsupport.ru/showpost....03&postcount=9

We don't "deserve" it... His choice, but pretty crappy thing to say. Ohh well.

Not you man :)
I mean my people
my turkish people don't deserve my hacks for free. :D

Greight 12-16-2009 09:45 AM

Hi
I noticed on forumhome , username tooltips show the html code. Can this be fixed?

Matais 12-16-2009 11:54 AM

Hopefully you'll get it fixed soon, im getting it aswell

Code:

Matais is offline now.">Matais

Madlike 12-16-2009 07:03 PM

Quote:

Originally Posted by Hasann (Post 1922791)
please make sure and check html markup for each usergroup input valid syntax.

example for html markup valid syntax.

first input add
PHP Code:

<span style='color: #000000'><b

second input add
PHP Code:

</b></span


need to comply with standards :)

HTML Code:

<span style="color:#fff;"><strong>...</strong><span>
;)

Trek 12-17-2009 01:50 AM

That was it, changed to single quotes! Thank you for catching that, it's all fixed and running as it should on my RC4 release now. =)

Matais 12-17-2009 08:17 AM

can you add this too the "What's New" tab?

sani79 12-17-2009 03:56 PM

1 Attachment(s)
Hy

Why show me my forum this mod so??

Attachment 107665

THX
sani79

Trek 12-17-2009 04:15 PM

Quote:

Originally Posted by sani79 (Post 1932322)
Hy

Why show me my forum this mod so??

Attachment 107665

THX
sani79

read up a few posts/page. I had the same problem. Replace any double quotes (") in the usergroup color style with single quotes (') and it'll work.

ZoltanN 12-18-2009 10:24 AM

Tagged for future use, very nice add-on.

Thank you for releasing it.

odln018 12-21-2009 02:29 PM

Receiving this in RC 4

Quote:

Database error in vBulletin 4.0.0 Release Candidate 4:

Invalid SQL:

SELECT forum.forumid, forum.lastpost, CONCAT(usergroup.opentag, forum.lastposter, usergroup.closetag) AS lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
, forumread.readtime AS forumread
FROM forum AS forum
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN user AS user ON (forum.lastposterid = user.userid) LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid);

MySQL Error : Not unique table/alias: 'user'
Error Number : 1066
Request Date : Monday, December 21st 2009 @ 10:20:54 AM
Error Date : Monday, December 21st 2009 @ 10:20:54 AM
Script : http://www.site.com/testforum/forum.php
Referrer : http://www.site.com/testforum/content.php
IP Address : xx.xxx.xxx.xx
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.39-community

arauf 12-21-2009 09:59 PM

DB Error when i enabled it on Latest vB 4 which is released today.

odln018 12-21-2009 11:08 PM

Same here with 4.0

Quote:

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT subscribeforumid, forum.forumid, forum.lastpost, CONCAT(usergroup.opentag, forum.lastposter, usergroup.closetag) AS lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
, forumread.readtime AS forumread
FROM forum AS forum
LEFT JOIN subscribeforum AS subscribeforum ON (subscribeforum.forumid = forum.forumid AND subscribeforum.userid = 1)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN user AS user ON (forum.lastposterid = user.userid) LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid);

MySQL Error : Not unique table/alias: 'user'
Error Number : 1066
Request Date : Monday, December 21st 2009 @ 07:01:06 PM
Error Date : Monday, December 21st 2009 @ 07:01:06 PM
Script : http://www.xxxxx.com/testforum/forum...-Announcements
Referrer : http://www.xxxxx.com/testforum/forum.php
IP Address : xx.xxx.xxx.xx
Username : User
Classname : vB_Database
MySQL Version : 5.1.39-community

Charlie98902 12-21-2009 11:10 PM

Thanks still works on vbulletin gold.

M3xital 12-23-2009 07:27 AM

Thank you, i confirm works on vB4 gold :)

sebaldus 12-23-2009 09:50 AM

I got this error when I use the script:

by
Admin is offline now.">Admin

This are all colour names.
All posts.
Regards from Sebaldus.

Cadellin 12-23-2009 02:36 PM

Quote:

Originally Posted by sebaldus (Post 1936197)
I got this error when I use the script:

by
Admin is offline now.">Admin

This are all colour names.
All posts.
Regards from Sebaldus.

Same on 4.0.0 PL1


All times are GMT. The time now is 11:58 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.01785 seconds
  • Memory Usage 1,834KB
  • 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
  • (8)bbcode_code_printable
  • (1)bbcode_html_printable
  • (2)bbcode_php_printable
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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