Database query error

Error
Database query error
 
 
i get database error in the Admin panel when i try to go in to Users  area,
Quote · 9 May 2012

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.

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 9 May 2012

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

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 9 May 2012

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.

so much to do....
Quote · 9 May 2012

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

                )

 
 
Quote · 14 May 2012

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.

so much to do....
Quote · 15 May 2012

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?

Quote · 15 May 2012

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.

Quote · 17 May 2012

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!!!!!!!!

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 17 May 2012

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

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.

 

Quote · 27 Oct 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.