Results 1 to 4 of 4

Thread: LOCK TABLES error please help

  1. #1
    New user
    Join Date
    11-16-11.
    Posts
    5

    Default LOCK TABLES error please help

    We have a developer that's working on a website for us. Everything was going fine, but we've now had issue with the site freezing and even caused our server to crash which is not ideal.

    We've done some digging of our own and found the following error reported:

    Code:
    Fatal error: Uncaught exception Exception with message Query error: Table  
    'tl_page' was not locked with LOCK TABLES (SELECT * FROM tl_page WHERE  
    (id=0 OR alias='home') AND (start='' OR start<1321350209) AND (stop='' OR  
    stop>1321350209) AND published=1) thrown in  
    /var/www/vhosts/domain.co.uk/httpdocs/system/libraries/Database.php  
    on line 677
    #0  
    /var/www/vhosts/domain.co.uk/httpdocs/system/libraries/Database.php(624):  
    Database_Statement->query()
    #1 /var/www/vhosts/domain.co.uk/httpdocs/index.php(97):  
    Database_Statement->execute(0, 'home')
    #2 /var/www/vhosts/domain.co.uk/httpdocs/index.php(319):  
    Index->run()
    #3 {main}
    We've tried to ask the developer to fix this issue, but they are lost for an answer and hence we have been left with this problem. We would very much appreciate the cantao community give us some advise on this or even better help us fix the problem. We would even consider paying someone to fix this issue and get the website completed if that's what was needed.

    If anyone can help I would be very appreciative.

    Many thanks in advance.

    Anthony.

  2. #2
    New user
    Join Date
    11-16-11.
    Posts
    5

    Default Re: LOCK TABLES error please help

    This has been solved.

    Thank you to Blair and the guys at Winans Creative for their help. These guys really know their stuff.

  3. #3
    Experienced user
    Join Date
    01-12-10.
    Posts
    814

    Default Re: LOCK TABLES error please help

    How did you solve it? Common to also answer your own question to help others if possible.

  4. #4
    New user
    Join Date
    10-17-12.
    Posts
    2

    Default Re: LOCK TABLES error please help

    Hi,
    I have the same problem, could it be possible that you give us your solution ?
    We are stuck on this problem from more than 10 days. We think that it's maybe come from the Data Base of Godaddy (lock, or config) but after different conf call with them the problem stays the same. If you have an answer or even a part of it it would be awsome ! Thank you in advance.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •