Announcement

Collapse
No announcement yet.

A few problems - new to vB5

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Paul.
    replied
    Thanks for that, ProSports!

    Would any one have a clue why we're getting a lot of database errors?
    Less than at the beginning, but they're still appearing.. and often for a particular user's profile.
    We couldn't see her profile for ages, actually.

    I hope it's okay for me to post this publicly?

    Code:
    Database error in vBulletin 5.1.8:
    
    
    [Showing truncated query, original length: 926150]
    [First 500 chars]
    Invalid SQL:
    /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_166157_lvl1data' AND event = 'nodeChg_166157') OR
    (cacheid = 'node_166159_lvl1data' AND event = 'nodeChg_166159') OR
    (cacheid = 'node_166160_lvl1data' AND event = 'nodeChg_166160') OR
    (cacheid = 'node_166176_lvl1data' AND event = 'nodeChg_166176') OR
    (cacheid = 'node_166177_lvl1data' AND event = 'nodeChg_166177') OR
    (cacheid = 'node_166185_lvl1data' AND event = 'nodeChg_166185') OR
    (cacheid = 'node_166189_lvl1da
    [Last 500 chars]
    ent = 'nodeChg_254483') OR
    (cacheid = 'node_254496_lvl1data' AND event = 'nodeChg_254496') OR
    (cacheid = 'node_254499_lvl1data' AND event = 'nodeChg_254499') OR
    (cacheid = 'node_254523_lvl1data' AND event = 'nodeChg_254523') OR
    (cacheid = 'node_254529_lvl1data' AND event = 'nodeChg_254529') OR
    (cacheid = 'node_254544_lvl1data' AND event = 'nodeChg_254544') OR
    (cacheid = 'node_254548_lvl1data' AND event = 'nodeChg_254548') OR
    (cacheid = 'node_254562_lvl1data' AND event = 'nodeChg_254562');
    
                            MySQL Error   : Lock wait timeout exceeded; try restarting transaction
                            Error Number  : 1205
                            Request Date  : Thursday, August 20th 2015 @ 06:21:14 AM
                            Error Date    : Thursday, August 20th 2015 @ 06:22:09 AM
                            Script        : http:///forum/member/13982- bÑŸffy/visitormessage/254562-visitor-message-from-jack-40
                            Referrer      :
                            IP Address    : 108.162.250.122
                            Username      : Bџffy
                            Classname     : vB_Database_MySQLi
                            MySQL Version :
    
    
    Stack Trace:
    #line vB_Database->halt() called in [path]/vb/database/mysqli.php on line 176
    #line vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 504
    #line vB_Database->query_write() called in [path]/vb/db/mysql/querydefs.php on line 7877
    #line vB_dB_MYSQL_QueryDefs->saveDbCache() called in [path]/vb/db/query/method.php on line 175
    #line vB_dB_Query_Method->execSQL() called in [path]/vb/db/assertor.php on line 283
    #line vB_dB_Assertor->assertQuery() called in [path]/vb/cache/db.php on line 384
    #line vB_Cache_Db->shutdown() called in  on line
    #line call_user_func() called in [path]/vb/shutdown.php on line 91
    #line vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 459
    #line vB::shutdown() called in  on line
    Code:
    Database error in vBulletin 5.1.8:
    
    
    [Showing truncated query, original length: 930811]
    [First 500 chars]
    Invalid SQL:
    /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'getSearchResults_ e085c4f89ebc4a0e5c47f92a321ac423' AND event = 'perms_changed') OR
    (cacheid = 'getSearchResults_e085c4f89ebc4a0e5c47f92a321ac423' AND event = 'vB_ChannelStructure_chg') OR
    (cacheid = 'node_166157_lvl1data' AND event = 'nodeChg_166157') OR
    (cacheid = 'node_166159_lvl1data' AND event = 'nodeChg_166159') OR
    (cacheid = 'node_166160_lvl1data' AND event = 'nodeChg_166160') OR
    (cacheid = 'node_166176_lvl1data
    [Last 500 chars]
    vbnodetext_pre_254512_8_1:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_33') OR
    (cacheid = 'vbnodetext_pre_254523_8_1:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_254523') OR
    (cacheid = 'vbnodetext_pre_254523_8_1:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_7') OR
    (cacheid = 'vbnodetext_pre_254529_8_1:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_254529') OR
    (cacheid = 'vbnodetext_pre_254529_8_1:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_7');
    
                            MySQL Error   : Lock wait timeout exceeded; try restarting transaction
                            Error Number  : 1205
                            Request Date  : Thursday, August 20th 2015 @ 01:50:09 AM
                            Error Date    : Thursday, August 20th 2015 @ 01:51:04 AM
                            Script        : http:///forum/member/13982-bџffy
                            Referrer      : http://www.321sexchat.com/forum/priv...ication/1339/1
                            IP Address    : 108.162.242.236
                            Username      : norquay
                            Classname     : vB_Database_MySQLi
                            MySQL Version :
    
    
    Stack Trace:
    #line vB_Database->halt() called in [path]/vb/database/mysqli.php on line 176
    #line vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 504
    #line vB_Database->query_write() called in [path]/vb/db/mysql/querydefs.php on line 7877
    #line vB_dB_MYSQL_QueryDefs->saveDbCache() called in [path]/vb/db/query/method.php on line 175
    #line vB_dB_Query_Method->execSQL() called in [path]/vb/db/assertor.php on line 283
    #line vB_dB_Assertor->assertQuery() called in [path]/vb/cache/db.php on line 384
    #line vB_Cache_Db->shutdown() called in  on line
    #line call_user_func() called in [path]/vb/shutdown.php on line 91
    #line vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 459
    #line vB::shutdown() called in  on line

    Leave a comment:


  • In Omnibus
    replied
    In your config.php file (located in the includes folder)
    Look for this line:

    $config['Misc']['debug'] = true;

    Change it to this:


    $config['Misc']['debug'] = false;

    Leave a comment:


  • Paul.
    replied
    Am I correct in thinking that I shouldn't see these (attached) options?
    How do I go about getting it to what it should be?

    Leave a comment:


  • TLMD
    replied
    It is a phrase which belongs to the GLOBAL phrases. It should show up under your GLOBAL tab, however if it doesn't, try to search for 'Last Post' (without the quotation marks).

    Alternatively you can go to AdminCP > Languages & Phrases > Phrase Manager, select GLOBAL for the Phrase Type and go to last_post manually. With 15 items being displayed on a page, it should be around page 54/55.

    Leave a comment:


  • Paul.
    replied
    Sorry, but I think I'm failing very badly at this, Lol.
    Am I at it now?
    I just can't tell which is the $vbphrase one.

    Leave a comment:


  • In Omnibus
    replied
    Under Language & Phrases / Search In Phrases

    Search for the actual phrase "last_post"

    Then edit the $vbphrase[last_post] from the list of phrases.

    Leave a comment:


  • Paul.
    replied
    Hi,

    I've searched for that and attached what comes up.. did I search the wrong place?

    Leave a comment:


  • In Omnibus
    replied
    $vbphrase[last_post] is the phrase which controls that title.

    Leave a comment:


  • Paul.
    started a topic A few problems - new to vB5

    A few problems - new to vB5

    Hi,

    One of our forums is now vB5 and we have a few problems.
    I'd prefer get through them one by one using this thread, if possible.

    I've attached images of one, what I would think, is a minor problem.
    It's just how Last Post appears versus vbulletin.com

    Just as a note, last year, we made one change that made a global change to the word Posts.
    It was changed to Chats and we're not sure where to go about changing it back.
    When we do a search, it shows 4 places where it can be edited. But we think last year when it was done, it was just one edit that changed it on all of the forum.
    Do you reckon it's the 4 changes I should edit individually or just find where it can be done globally?

    PS: If anyone can notice any obvious problems just by visiting, then please do and let us know.
    It's an 18+ forum.

Related Topics

Collapse

Working...
X