vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Big problem! (https://vborg.vbsupport.ru/showthread.php?t=120802)

Pete C 07-10-2006 10:27 AM
Big problem!
 
My 3.5.4 board is fairly new and has several hacks installed, all of which appear to be working properly. The pm system was tested and working, but since installing one of these hacks (sadly I'm not sure which one) it's failed totally. The system was working prior to installing vBPlaza, but since the subsequent hacks were added within a short time, I can't be sure at which point the system failed.

Whenever I or any member try to send a PM, the following error is generated:
Code:
Database error in vBulletin 3.5.4:
 
Invalid SQL:
 
            SELECT pm.*, pmtext.*
                , icon.title AS icontitle, icon.iconpath
            FROM radiocapm AS pm
            LEFT JOIN radiocapmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
            LEFT JOIN radiocaicon AS icon ON(icon.iconid = pmtext.iconid)
            WHERE pm.userid=3 AND pm.folderid=0
            ORDER BY pmtext.dateline DESC
            LIMIT 0, 50;
 
MySQL Error  : Can't create/write to file '/tmp/mysql/#sql_1023_0.MYI' (Errcode: 2)
Error Number : 1
Date        : Monday, July 10th 2006 @ 05:40:25 AM
Script      : http://radio-cafe.com/private.php
Referrer    : http://radio-cafe.com/private.php?do=newpm&u=10
IP Address  : **.***.***.** (edited)
Username    : Belder
Classname    : vb_database
vB ver 3.5.4
Hacks Installed (in this order):

Ajax Shoutbox, V3 Arcade, SHOUTcast on forumhome full, Users online last 24hrs, Show last game installed in what's going on box, Staff colour legend, vBPlaza, vBookie, vbPlaza/vBookie vBux integration, V3Arcade Alternative layout, SHOUTcast Stats moved below Navbar.

My apologies if this isn't in the right place - please feel free to move it guys. Any advice on this will be most appreciated . . . it's a serious problem.

*Update: Just ran a check on the MySQL database and found this line:
Code:
radioca_radiocafe.radiocapm                        OK
Clearly it's not ok, and now I'm even more confused - help!

Kirk Y 07-10-2006 10:48 AM
Try disabling all your Products/Plugins one by one and see if that solves your problem, then either remove or disable your faulty one.

Pete C 07-10-2006 10:57 AM
Thanks acidburn0520. I kind of panicked when I found a mailbox full of d/b errors . . I'm sure your suggestion is the logical approach. I just hope we're not going to have to forfeit one of the hacks to resolve it.

* Update* Ok - I tried disabling the plug-ins one by one, and testing the pm system. So far none have made any difference to the PM system error. Unfortunately, now they've been re-enabled, I'm getting d/b errors in the arcade and on my ACP options. That is to say, the vB options no longer display, and I cannot take the board offline whilst I try to resolve things.

There must be another way of approaching this issue - any more suggestions please?


All times are GMT. The time now is 04:59 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.01062 seconds
  • Memory Usage 1,715KB
  • 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
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete