Database query error

This can be many different reasons you get these errors.

Did the site ever work, or did this just start happening?

make sure your not having problems with your MySQLdatabase dropping off.

and edit your link to Users, unless you want all to see your site.

Your site is not up BTW, your using Windows IIS 7, I have read on here those setups are a little more challenging

Probably you should enable database debug.

In inc/classes/BxDolDb.php at line 26

define( 'DB_FULL_DEBUG_MODE', false );

change it to this'

define( 'DB_FULL_DEBUG_MODE', true );

at least we will get more info about the error because Database query error gives no idea.

after a server startup I get this message "" Error

Database query error "on any site that is blocked, the site works perfectly well before that

---

Database query error

Query:

SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1

Mysql error:

Table 'flash_data.sys_localization_languages' doesn't exist

--

Found error in the file '/home/data/public_html/inc/classes/BxDolEmailTemplates.php' at line 35.

Called 'getOne' function with erroneous argument #0.

Debug backtrace:

Array

(

    [1] => Array

        (

            [file] => /home/data/public_html/inc/classes/BxDolDb.php

            [line] => 253

            [function] => error

            [class] => BxDolDb

            [object] => BxDolDb Object

                (

                    [error_checking] => 1

                    [error_message] => Table 'flash_data.sys_localization_languages' doesn't exist

                    [host] => localhost

                    [port] => 

                    [socket] => 

[dbname] => flash_data

                    [user] => *****

                    [password] => *****

                    [link] => Resource id #28

                    [current_res] => 

                    [current_arr_type] => 1

                    [oParams] => BxDolParams Object

                        (

                            [_oDb] => BxDolDb Object

 *RECURSION*

                            [_oCache] => BxDolCacheFile Object

                                (

                                    [sPath] => /home/data/public_html/cache/

                                    [_error] => 

                                )

                            [_sCacheFile] => sys_options_f058840be6b1450906d5b2aa36669763.php

                            [_aParams] => [truncated]

                            [_error] => 

                        )

                    [oDbCacheObject] => BxDolCacheFile Object

                        (

                            [sPath] => /home/data/public_html/cache/

                            [_error] => 

                        )

                    [_error] => 

                )

            [type] => ->

            [args] => Array

                (

                    [0] => Database query error

                    [1] => 

                    [2] => SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1

                )

so "flash_data" is your database and it gives that sys_localization_languages is missing in your database

well thats very strange... Try to restore from a backup. Something deleted your table.

how I can restore the database, I have a backup of the database but several GB, I must restore all the database where I have restored what?

thanks for try  helping to me. my english is not  % good, so  my webside is megadevi.com it is not dating website,this website is for contractor fined or contractor come and regestered after get jop. so  i was chenged male>>for conractor  women>>>for customer in the lunguage sction. after my site is not good working. but i fix alredy working good.am still working on my site.

This may or may not help...

Today I awoke to find one of my sites that has been working fine for months doing this, Database query error ....!!

I could navigate to site.com/administration/ and see that, but trying to select a module or Members would lead right back to the error message!

I have been around a while and could really not think of what might have caused this as I have not done any site changes recently.

So it dawned on me that in our cPanel, database wizard, you have the option to "repair" your databases, so I ran the repair on the Dolphin data and it fixed it!

There has been many times in the past when I have seen this and was so stumped on what to do I would just do a site restore.

This saved me tons of time and stress!!!!!!!!

 Thank you very much, I followed below instruction it is now working.