LockedDB function failed with error number 1146

Author
asimhafeez
Junior Member
2009/11/20 13:29:41 (permalink)

DB function failed with error number 1146

I'm having HC7 when i install Joomla  in website builders HC install it successfully but when i open the given URL... www.example.com/sitebuilder it show me the following message.

"
DB function failed with error number 1146
Table 'example.jos_session' doesn't exist SQL=SELECT session_id FROM jos_session WHERE session_id = '7486c0e23b6b0e764d4d7b58af17318b'
SQL =
SELECT session_id
FROM jos_session
WHERE session_id = '7486c0e23b6b0e764d4d7b58af17318b'
"

database is connecting remotely but i've not find any tables into the database. Kindly help me to resolve the issue.



Regards
Asim
#1

4 Replies Related Threads

    HC Staff
    HC Staff
    Re:DB function failed with error number 1146 2009/11/20 22:38:06 (permalink)
    Yes this error relevant to joomla database which should have created with click apps installation. What about other click apps are they working fine ?

    Either php is not configure properly to connect mysql extension in the php.ini setting. Or mysql server itself suffer with proper privileges.

    Try to give this command in the mysql server

    connect using
    mysql -u root -p

    execute this command

    grant all privileges on *.* to root@localhost identified by 'root-password',root identified by 'root-password' with grant option;
    flush privileges;

    Note: root-password = mysql root user password.
    #2
    ashantycapre
    Junior Member
    Re:DB function failed with error number 1146 2010/07/07 00:31:21 (permalink)
    • Hello!Thank you for having great time to share these.Yes this error relevant to joomla database which should have created with click apps installation.Fast, easy installation gets you up and running in minutes.Complete Host/Reseller control on offering any specific application to web admin.Modular architecture makes it easy to offer any specific/all application with any hosting package.Comprehensive support for web standards.Any Click and Install application can be installed/uninstalled with a click on any website using HC panel.Thank you once again.






    post edited by ashantycapre - 2010/07/07 00:37:35
    #3
    marryanne
    Junior Member
    Re:DB function failed with error number 1146 2010/07/09 01:59:46 (permalink)
    thanks for sharing this hint that I may know other problem in other major ways!
    This error relevant to joomla database which should have created with click apps installation.
    Fast, easy installation gets you up and running in minutes.Complete Host/Reseller control on offering any specific application to web admin.
    thanks!!!!




    post edited by marryanne - 2010/07/09 02:02:07
    #4
    samson45
    Junior Member
    Re:DB function failed with error number 1146 2010/07/13 01:12:47 (permalink)
     Thank you for having great time to share these.Yes this error relevant to joomla database which should have created with click apps installation..............good day!!!!!!

    post edited by samson45 - 2010/07/13 01:14:57
    #5
    Jump to: