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


All times are GMT. The time now is 06:30 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.10462 seconds
  • Memory Usage 1,755KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (7)pagenav_pagelinkrel
  • (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