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)
-   -   Chat Modifications - MGC Chatbox Evo (https://vborg.vbsupport.ru/showthread.php?t=168992)

Jazzinto 12-08-2008 09:39 PM

One mysql error in the Mgc Chat evo:

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(chatid) AS nbchats
FROM vbmgc_cb_evo_chat AS c
LEFT JOIN vbuser AS fromu ON (c.fromuid=fromu.userid)
LEFT JOIN vbuser AS tou ON (c.touid=tou.userid)
LEFT JOIN vbmgc_cb_evo_command AS co ON (c.primcid=co.cid)

WHERE primcid='0'
ORDER BY c.dateline DESC;

MySQL Error : Can't find file: 'vbmgc_cb_evo_chat.MYI' (errno: 2)
Error Number : 1017
Request Date : Tuesday, December 9th 2008 @ 12:29:05 AM
Error Date : Tuesday, December 9th 2008 @ 12:29:05 AM
Script : /mgc_cb_evo.php?do=view_archives&page=1
Referrer : showthread.php?p=115597#post115597
IP Address : ******
Username : *****
Classname : *****
MySQL Version : 4.1.20-log

Anybody can help me?, thanks and sorry for my English.

VBDev 12-09-2008 07:58 AM

This error is strange.

Are you sure the chatbox is installed ?

Jazzinto 12-09-2008 10:29 AM

Quote:

Originally Posted by VBDev (Post 1681487)
This error is strange.

Are you sure the chatbox is installed ?

Ok, The error is in a Table of Database, I reinstalled that Table and All Ok.

Thanks.

jerx 12-09-2008 02:21 PM

Improvement suggestion:

smilie pop up: give it the same look as default smilie pop up.
Meaning add the phrase "Click a smilie to insert it into your message." below page title and organize smilies in categories.

Right now you are unable to determine which category they belong to and you are not able to change smilie display order by changing the display order of the smilie categories.

nath89 12-10-2008 02:47 AM

im installing MGC Chatbox Evo into 3.7.4

in my styles directory do i just enter the folder titled 'images'?

do you know anything about the following instruction

2/ Upload the content of the "Images" directory in each of your forum styles directories

does this mean everything in the 'images' file?

MGC Chatbox Evo>images>misc>?????

Ranger187 12-10-2008 03:00 AM

Quote:

Originally Posted by Greenskull (Post 1680061)
got it, sent you a pm

Green, sorry about the delay. My daughter and I had a pretty bad cold. I just took a few days off and didn't check anything on the computer.

Quote:

Originally Posted by nath89 (Post 1682068)
im installing MGC Chatbox Evo into 3.7.4


in my styles directory do i just enter the folder titled 'images'?

do you know anything about the following instruction

2/ Upload the content of the "Images" directory in each of your forum styles directories

does this mean everything in the 'images' file?

MGC Chatbox Evo>images>misc>?????

You goto your /misc folder for all styles, copy the mgc dir into that. Say your site is www.turd.com (and that's where forums load) and locally on the server say it's d:\user\jewboy\turd.com

You'd goto d:\user\jewboy\turd.com\images\misc and in the zip, you'd goto the /images/misc and drop from there. Meaning, grab the mgc_cb_evo folder and subs and drag it to ur d:\user\jewboy\turd.com\images\misc , and doing so for any other styles...

SnapOff Racing 12-10-2008 05:15 AM

Quote:

Originally Posted by Ranger187 (Post 1682074)
Green, sorry about the delay. My daughter and I had a pretty bad cold. I just took a few days off and didn't check anything on the computer.



You goto your /misc folder for all styles, copy the mgc dir into that. Say your site is www.turd.com (and that's where forums load) and locally on the server say it's d:\user\jewboy\turd.com

You'd goto d:\user\jewboy\turd.com\images\misc and in the zip, you'd goto the /images/misc and drop from there. Meaning, grab the mgc_cb_evo folder and subs and drag it to ur d:\user\jewboy\turd.com\images\misc , and doing so for any other styles...

Turd.com hell yeah man that's my favorite site. LMAO

Ranger187 12-10-2008 05:46 AM

Haahaha!

Angel-Wings 12-10-2008 02:37 PM

Quote:

Originally Posted by Ranger187 (Post 1678714)
What I do, and what others do is an assumption. Does everyone use smilies in this chat? No, Does everyone use the PM function? No. But having it as an option is not a drawback in any form. Why? I see things differently. ;) 1 being say a full backup of a database is 100+ megs. You tell me you've never had a large dB timeout exporting, importing etc. Would you rather export / import a 1 meg file, or 100 meg file? Whether the people do their admin functions is not my concern. Having a useful function is. This to me is. Let me know when you use shared hosting, and you have to have THEM do the import because you can't due to limitations etc. There is a reason for this.

For sure your points are all valid - just - if someone wants to backup, AdminCP -> Database Backup and then just selecting the Chatbox tables.
I just want to say it's maybe not required to invent the wheel a second time if already everything's there.
If you backup only the Chatbox tables, the resulting backup won't be that large - just - people would manually need to do it.

This should be exactly what you want, isn't it ? :)

In case of a complete data loss, backup would be that installing the Chatbox again, getting the tables created and then re-import the Chatbox Tables Backups - everything without a complete DB import.

Oh - and - I really never had a large timeout ;) I'm personally using a Master -> Slave replication on a very small backup server and from there again to my local home network.

Back to topic - like said - Backups of the Chatbox can already be done without doing a complete backup of the board DB via AdminCP, adding such a feature would maybe result in a more complex script and we all know - the more complex something is, the more hard it is to have it clean of any hidden bugs.

But - if the developer wants to add such a function, no problem as well :)

Angel-Wings 12-10-2008 02:41 PM

Quote:

Originally Posted by Jazzinto (Post 1681246)
MySQL Error : Can't find file: 'vbmgc_cb_evo_chat.MYI' (errno: 2)

Are you sure your Database is ok and that the install process went fine ?

Looks like this table is completely missing or gone. If it exists, maybe do a "Repair" run

lord eriol 12-10-2008 08:00 PM

Quote:

Originally Posted by VBDev (Post 1679353)
Here is a fix that should work :
PHP Code:

            $smilies $vbulletin->db->query_read("
              SELECT s.smilieid, s.smilietext, s.smiliepath, s.title
              FROM " 
TABLE_PREFIX "smilie AS s
              LEFT JOIN " 
TABLE_PREFIX "imagecategory AS cat ON (s.imagecategoryid=cat.imagecategoryid)
              ORDER BY cat.displayorder ASC,s.displayorder ASC
              LIMIT " 
$vbulletin->options['mgc_cb_evo_editor_nbsmileys']
                                                  ); 

Please can you try ?

i would try this fix but i don't understand wich part of mgc_cb_evo.php replace it

VBDev 12-10-2008 08:34 PM

Na don't worry for this I'll include it in my next release :)

SnapOff Racing 12-10-2008 11:31 PM

Quote:

Originally Posted by VBDev (Post 1682701)
Na don't worry for this I'll include it in my next release :)

Speaking of which, any ETA on the 2.0 version?

VBDev 12-11-2008 10:30 AM

The release is ready but I am waiting for all my other products to be updated before I unleash it !

It's installed on my site and some others to ensure that there are no remaining bugs.

KevinL 12-11-2008 11:10 AM

I can't wait for it! It looks ridiculous!

Ranger187 12-11-2008 01:11 PM

Quote:

Originally Posted by VBDev (Post 1683019)
The release is ready but I am waiting for all my other products to be updated before I unleash it !

It's installed on my site and some others to ensure that there are no remaining bugs.

Turd...... Where's my beta ;)

And got a few peoples issues on here fixed. I might even get a paypal donation friday from someone finally which would be sweet. Now back to having a stupid cold.

VBDev 12-11-2008 02:09 PM

Quote:

Originally Posted by KevinL (Post 1683035)
I can't wait for it! It looks ridiculous!

lol :D I think I will release it on christmas day :D That would be my present for all of you ;)

This release as an Evo Evo lol It contains many new enhancement (some not listed here by the way ;)).

Quote:

Originally Posted by Ranger187 (Post 1683119)
Turd...... Where's my beta ;)

Hidden in the dark :D

Quote:

Originally Posted by Ranger187 (Post 1683119)
And got a few peoples issues on here fixed. I might even get a paypal donation friday from someone finally which would be sweet. Now back to having a stupid cold.

He he :) Haven't had a donation since a long time but that always a great reward, this is really nice and totally justified that you get some.

Angel-Wings 12-11-2008 04:43 PM

Quote:

Originally Posted by VBDev (Post 1683155)
This release as an Evo Evo lol It contains many new enhancement (some not listed here by the way ;)).

Maybe an option like:

My number of chats = Board's biggest Chatbox "Spammer" Chats + 1

:D

SnapOff Racing 12-11-2008 06:30 PM

Quote:

Originally Posted by VBDev (Post 1683019)
The release is ready but I am waiting for all my other products to be updated before I unleash it !

It's installed on my site and some others to ensure that there are no remaining bugs.

Sounds good. Hey BTW I was gonna mention this the other day but I completely forgot about it. When viewing my forum on an iPhone, for some reason the chatbox scroll bars don't show up. Any Ideas?

https://vborg.vbsupport.ru/

VBDev 12-11-2008 07:01 PM

Quote:

Originally Posted by Angel-Wings (Post 1683250)
Maybe an option like:

My number of chats = Board's biggest Chatbox "Spammer" Chats + 1

:D

?? I don't understand you.

Quote:

Originally Posted by SnapOff Racing (Post 1683310)
Sounds good. Hey BTW I was gonna mention this the other day but I completely forgot about it. When viewing my forum on an iPhone, for some reason the chatbox scroll bars don't show up. Any Ideas?

http://i178.photobucket.com/albums/w...box_iphone.png

Lol on that one I honestly can't answer. I do have an iphone though but debugging wouldn't be that easy.

I'll check on safari on my mac to see if I don't have any problem as iphone embeds safari too.

Ranger187 12-11-2008 08:10 PM

Format the mac, problem solved. ;)

Skyrider 12-11-2008 08:41 PM

Bug found. You are unable to use " in a private message to someone through the chat box. When you do so, the message won't send.

Tekmon 12-12-2008 02:39 AM

I added this to my file as required "var SECURITYTOKEN = "0";"
and I still get the missing security token message...

I am running vb 3.7.4 patch level 1 and have also tried "var SECURITYTOKEN = 0;" which someone else suggested. We also only use one skin.

This is a fresh install of the chatbox as I uninstalled the old version.

I would really like to get this working soon.

VBDev 12-12-2008 05:36 AM

Quote:

Originally Posted by Ranger187 (Post 1683371)
Format the mac, problem solved. ;)

lol... No way :D

Quote:

Originally Posted by FF|Skyrider (Post 1683396)
Bug found. You are unable to use " in a private message to someone through the chat box. When you do so, the message won't send.

Oh oh damned :D

How did you experienced that ? By entering the whole command syntax or in a different way ?

Quote:

Originally Posted by Tekmon (Post 1683528)
I added this to my file as required "var SECURITYTOKEN = "0";"
and I still get the missing security token message...

I am running vb 3.7.4 patch level 1 and have also tried "var SECURITYTOKEN = 0;" which someone else suggested. We also only use one skin.

This is a fresh install of the chatbox as I uninstalled the old version.

I would really like to get this working soon.

With vB3.7.4 DO NOT put the var securitytoken thing !!! This for earlier version not your version of vB as stated in the readme.

Tekmon 12-12-2008 05:47 AM

Thanks for the feed back, However I only put the "var SECURITYTOKEN="0"" in because we got the message that the security token was missing...

I have taken it out again, per your message and we still get the exact same message that we are missing the security token. Anything else I can try?

jerx 12-12-2008 09:12 AM

Quote:

Originally Posted by FF|Skyrider (Post 1683396)
Bug found. You are unable to use " in a private message to someone through the chat box. When you do so, the message won't send.

I tried using ", but it works for me.

VBDev 12-12-2008 10:13 AM

Quote:

Originally Posted by Tekmon (Post 1683646)
Thanks for the feed back, However I only put the "var SECURITYTOKEN="0"" in because we got the message that the security token was missing...

I have taken it out again, per your message and we still get the exact same message that we are missing the security token. Anything else I can try?

You can try :
  1. Check that you have uploaded all the new files
  2. Refresh your cache

Tekmon 12-12-2008 01:48 PM

I uninstalled and removed every mgc file I could find and then did a complete reinstall ensuring that every file in the files folder was coppied tothe forumns directory. I moved all of the images to the standard images folder as well as my greenskin images folder.

I still get the missing security token message when I try to post in the chat box...

Any other ideas?

Ranger187 12-12-2008 02:43 PM

Quote:

Originally Posted by Tekmon (Post 1683824)
I uninstalled and removed every mgc file I could find and then did a complete reinstall ensuring that every file in the files folder was coppied tothe forumns directory. I moved all of the images to the standard images folder as well as my greenskin images folder.

I still get the missing security token message when I try to post in the chat box...

Any other ideas?

Try using firefox and pull up the error console and see what errors it gives. You shouldn't be using that Var token key.

Tekmon 12-12-2008 03:06 PM

Thank you for the suggestion Ranger187, it says the following

Chatbox_ask_name is not defined
http://www.mmowned.com/forums/client.../mgc_cb_evo.js

Any help?

Skyrider 12-12-2008 03:10 PM

Quote:

Oh oh damned

How did you experienced that ? By entering the whole command syntax or in a different way ?
I'm clicking on the arrow, selected "Send private chat" and added the " in the chat. It never sends the message.

Small feature request by the way.. Is it possible you can add it so people can't spam the chat box? having a "line per minute" rule? So people are forced to edit their own chats?

VBDev 12-12-2008 03:39 PM

Quote:

Originally Posted by Tekmon (Post 1683899)
Thank you for the suggestion Ranger187, it says the following

Chatbox_ask_name is not defined
http://www.mmowned.com/forums/client.../mgc_cb_evo.js

Any help?

Then you haven't refreshed your cache nor have uploaded the newer js files.

Quote:

Originally Posted by FF|Skyrider (Post 1683908)
I'm clicking on the arrow, selected "Send private chat" and added the " in the chat. It never sends the message.

Small feature request by the way.. Is it possible you can add it so people can't spam the chat box? having a "line per minute" rule? So people are forced to edit their own chats?

Ok will track the bug !

Hum yes that's a good suggestion but will not be in the next release as it's finished.

Tekmon 12-12-2008 03:52 PM

Thanks for your help but I have now rebooted my www servers and rebooted my home machine so any cache I have should be cleared, right???

I still have the same message.

VBDev 12-12-2008 04:14 PM

No no I meant your browser cache :)

Tekmon 12-12-2008 04:33 PM

well it is not just me, none of my users or admins can get it to work.... I am at a loss. I have uploaded the latest files, all of them and still it gives me the error:

chatbox_ask_name is not defined
http://www.mmowned.com/forums/client.../mgc_cb_evo.js line 498

VBDev 12-12-2008 06:40 PM

None has experienced such issues.
Only thing that could cause such problem :
  • The js files are not up-to-date
  • You have a modified version of the mgc_cb_evo template which is not reverted
  • Your browser cache is not refreshed (same for all of your users)

Fivetide 12-13-2008 08:02 PM

I just get lots of errors for some reason

Ranger187 12-13-2008 08:15 PM

Quote:

Originally Posted by Fivetide (Post 1684740)
I just get lots of errors for some reason

If you want support, try being more descriptive please.

Ranger187 12-15-2008 02:34 AM

Can't wait for the new version. Everything has been improved.

nerofix 12-15-2008 02:39 AM

is it possible to disallow posting www links?


All times are GMT. The time now is 05:13 PM.

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.12983 seconds
  • Memory Usage 1,856KB
  • 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_php_printable
  • (26)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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