vb.org Archive
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Vbulletin and server problem (https://vborg.vbsupport.ru/showthread.php?t=282619)

IRANCITY 05-08-2012 02:35 PM
Vbulletin and server problem
 
hi dear
i have problem in my server and forum
after i update server via Easy apache i have problem
i have receive very db err email
i fix very db err in my forum but my problem is Continue
...
when i send tread or post is very too long time and then send it ...
in forum home do not show last post (front forum title)
in cyber topposter do not show topic update

when i active vbblog i receive db err email

and i have 1 image upload script .... it have db err too...

what am i doing ?
i i try to repair db via whm , cpanel , admincp , tools.php , compareutility.php

but on compareutility.php and tools.php and admincp ... it 's not work ,,,, just send request in browser but nothing do !
i do this on phpmyadmin ... same do nothing

what am i doing ?

--------------- Added [DATE]1336491574[/DATE] at [TIME]1336491574[/TIME] ---------------

SOME ERROR
Code:

Database error in vBulletin 3.8.7:

Invalid SQL:

                                      SELECT languageid,
                      phrasegroup_global AS phrasegroup_global,
                      phrasegroup_posting AS phrasegroup_posting,
                      phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
                      phrasegroup_postbit AS phrasegroup_postbit,
                      phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
                      phrasegroup_inlinemod AS phrasegroup_inlinemod,
                      options AS lang_options,
                      languagecode AS lang_code,
                      charset AS lang_charset,
                      locale AS lang_locale,
                      imagesoverride AS lang_imagesoverride,
                      dateoverride AS lang_dateoverride,
                      timeoverride AS lang_timeoverride,
                      registereddateoverride AS lang_registereddateoverride,
                      calformat1override AS lang_calformat1override,
                      calformat2override AS lang_calformat2override,
                      logdateoverride AS lang_logdateoverride,
                      decimalsep AS lang_decimalsep,
                      thousandsep AS lang_thousandsep
                                      FROM language
                                      WHERE languageid = 2;

MySQL Error  : Unknown column 'phrasegroup_vbblogglobal' in 'field list'
Error Number  : 1054
Request Date  : Saturday, May 5th 2012 @ 06:54:07 PM
Error Date    : Saturday, May 5th 2012 @ 06:54:07 PM


Code:

atabase error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/iecloob/public_html/forum/includes/class_core.php on line 311

MySQL Error  :
Error Number  :
Request Date  : Friday, May 4th 2012 @ 01:42:16 PM
Error Date    : Friday, May 4th 2012 @ 01:42:16 PM



Code:

Database error in vBulletin 3.8.7:

Invalid SQL:

                              SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb

                              FROM userlist AS userlist
                              INNER JOIN user AS user ON (user.userid = userlist.relationid)
                              LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
                              LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

                              WHERE userlist.userid = 1
                                      AND userlist.type = 'buddy'
                                      AND userlist.friend = 'yes'

                              ORDER BY RAND()
                              LIMIT 0, 6;

MySQL Error  : Got error 28 from storage engine
Error Number  : 1030

Code:

Database error in vBulletin 3.8.7:

Invalid SQL:

              SELECT
                      userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
                      IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid,
                      language.phrasegroup_global AS phrasegroup_global,
                      language.phrasegroup_posting AS phrasegroup_posting,
                      language.phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
                      language.phrasegroup_postbit AS phrasegroup_postbit,
                      language.phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
                      language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
                      language.options AS lang_options,
                      language.languagecode AS lang_code,
                      language.charset AS lang_charset,
                      language.locale AS lang_locale,
                      language.imagesoverride AS lang_imagesoverride,
                      language.dateoverride AS lang_dateoverride,
                      language.timeoverride AS lang_timeoverride,
                      language.registereddateoverride AS lang_registereddateoverride,
                      language.calformat1override AS lang_calformat1override,
                      language.calformat2override AS lang_calformat2override,
                      language.logdateoverride AS lang_logdateoverride,
                      language.decimalsep AS lang_decimalsep,
                      language.thousandsep AS lang_thousandsep

              FROM user AS user
              LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
              LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 2, user.languageid))

              WHERE user.userid = 1;

MySQL Error  : Unknown column 'language.phrasegroup_vbblogglobal' in 'field list'
Error Number  : 1054

snakes1100 05-08-2012 03:38 PM
Due to you updating the server, we wouldnt know what all is wrong at this point, without seeing the server itself.

1. Verify the phrasegroup_vbblogglobal actually exists, if it doesnt, verify you removed the hack/addon and its files, so its not called anymore.

2. The error 28 means you've ran out of disk space, but again, we wouldnt know if its related to /tmp or a overall disk space issue, so verify your disk space on the server.

Lynne 05-08-2012 03:39 PM
First error to take care of NOW is the error 28:
One or more partitions on your server is out of space or doesn't have enough space to complete this operation. You need to shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.

You cannot deal with the other errors until you take care of that one NOW.

IRANCITY 05-08-2012 04:19 PM
thanks a lot dear friends
i access to ssh and whm ...
please tel me what am i doing ?

snakes1100 05-08-2012 04:47 PM
If you have no understanding of what to do via ssh, i would suggest someone other than yourself fix the issues.

There is not a lot anyone can say, when we dont have access to the server, to verify what the actual issues are.

IRANCITY 05-10-2012 02:48 PM
Code:
root@vmd665 [~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3              95G  46G  45G  51% /
/dev/sda1              99M  24M  70M  26% /boot
none                1006M    0 1006M  0% /dev/shm
/var/tmpMnt          1008M  110M  848M  12% /tmp
--------------- Added [DATE]1336664932[/DATE] at [TIME]1336664932[/TIME] ---------------

Code:
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/iecloob/public_html/forum/includes/class_core.php on line 311

MySQL Error  :
Error Number  :
Request Date  : Tuesday, May 8th 2012 @ 07:39:26 PM
Error Date    : Tuesday, May 8th 2012 @ 07:39:26 PM

snakes1100 05-10-2012 02:54 PM
Are you running a separate DB server?

Did you verify the host, database, user & pass credentials set in config.php?

df shows no issues

IRANCITY 05-10-2012 03:17 PM
1 - No ... local DB
2 - i can post in forum but it cannot show in forumhome ! and every day send me alot of db err mail ... !!

snakes1100 05-10-2012 03:22 PM
Typical for a cant connect to mysql, is its either down or the login credentials are incorrect.

What does mysql show for up time?

IRANCITY 05-10-2012 03:25 PM
Code:
Database error in vBulletin 3.8.7:

Invalid SQL:

                              INSERT IGNORE INTO postindex
                              (wordid, postid, score, intitle)
                              SELECT DISTINCT wordid, 518683, CASE title WHEN 'gfgfgfgf' THEN 2 WHEN 'fdgfgdfg' THEN 1 ELSE 1 END, CASE title WHEN 'gfgfgfgf' THEN 2 WHEN 'fdgfgdfg' THEN 0 ELSE 0 END
                              FROM word
                              WHERE title IN ('gfgfgfgf','fdgfgdfg');

MySQL Error  : Lost connection to MySQL server during query
Error Number  : 2013
--------------- Added [DATE]1336667179[/DATE] at [TIME]1336667179[/TIME] ---------------

Code:
Server version          5.1.62-cll
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket            /tmp/mysql.sock
Uptime:                1 day 22 hours 16 min 24 sec


All times are GMT. The time now is 07:20 PM.
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

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.01101 seconds
  • Memory Usage 1,783KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)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