Announcement

Collapse
No announcement yet.

Long wait after submitting new posts

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

  • BugOutGirl
    replied
    Originally posted by Wayne Luke View Post
    It seems that Joe has found the problem on your site. Please let us know if there are further problems.
    Yes he did!

    And I am completely thrilled.

    Thanks for all of your help on this matter.

    Now I can let my members know

    Leave a comment:


  • Wayne Luke
    replied
    It seems that Joe has found the problem on your site. Please let us know if there are further problems.

    Leave a comment:


  • Wayne Luke
    replied
    What are the cache values in your /core/include/config.php file set to?

    This section:
    Code:
    $config['Cache']['class'][0] = 'vB_Cache_Db'; //regular cache
    $config['Cache']['class'][1] = 'vB_Cache_Memory'; //fastest cache
    $config['Cache']['class'][2] = 'vB_Cache_Db'; //largest cache and longest life.
    And what are the contents of your .htaccess file?

    Leave a comment:


  • BugOutGirl
    replied
    ^Thanks anyway. I'm gonna give up for the day and try again tomorrow.

    Leave a comment:


  • In Omnibus
    replied
    I just read your other post so that suggestion wouldn't have helped. Disregard.
    Last edited by In Omnibus; Wed 12 Aug '15, 1:25pm.

    Leave a comment:


  • BugOutGirl
    replied
    OK I managed to execute the queries successfully... but unfortunately it did not have any effect on the long wait... still about 30.5 seconds. any other ideas?
    MySQL Version 5.5.42-cll-lve

    Leave a comment:


  • Mark.B
    replied
    I just ran into the query issue on another site...the reason it's throwing that error is because you probably have a table prefix.
    So you'll need to add that into the queries.

    For example:

    DELETE FROM vb_cache
    DELETE FROM vb_cacheevent

    Simplest way to see if you have a prefix is to go to AdminCP > Maintenance > Repair / Optimize Tables
    In there you'll see all the table names and if they have a prefix you'll see it in front of each table name. (Don't actually do anything in that screen though!)

    Leave a comment:


  • Wayne Luke
    replied
    What version of MySQL are you using?

    Leave a comment:


  • BugOutGirl
    replied
    Thanks, Mark.

    i'll let you guys know how I make out

    Leave a comment:


  • Mark.B
    replied
    Check this line in /core/includes/config.php:
    Code:
    $config['SpecialUsers']['superadmins']
    Make sure your admin's userid is in the list of userids in that line of code.

    So if your admin userid is 150, add it like this:
    Code:
    $config['SpecialUsers']['superadmins'] = '1,150';

    Leave a comment:


  • BugOutGirl
    replied
    Yes I did them one at a time. And set all my permissions to yes.

    I'm in touch with the server people to see how to do it on their end.

    thanks guys.

    Leave a comment:


  • Mark.B
    replied
    Make sure also, if using the admincp method of running queries, that you run the queries one at a time.
    If you paste them both together you will get the error you describe.

    Leave a comment:


  • Wayne Luke
    replied
    Go to Usergroups -> Administrator Permission and make sure you have all permissions.

    Otherwise you can use phpMyAdmin or whatever tool your hosting provider has made available for that purpose.

    Leave a comment:


  • BugOutGirl
    replied
    Ok, so I was able to give myself the authorization, but when I attempted to run the query, the main window in cpanel opened with my site and displayed a blank page with

    "That action could not be completed. Please try again, and if this occurs again please contact the system administrator and tell them how you got this message. "

    Leave a comment:


  • glennrocksvb
    replied
    Edit /core/config.php and add your userid:

    PHP Code:
    $config['SpecialUsers']['canrunqueries'] = '1'//change 1 to your admin userid 

    Leave a comment:

Related Topics

Collapse

Working...
X