Database error in

I get e-mails which in the subject line says: Database error in <SiteName>

No other text in the body of the e-mail

I get similar. I get Database error in

Query:

SELECT * FROM `bx_sites_main` WHERE `id` = Array LIMIT 1

Mysql error: Unknown column 'Array' in 'where clause'

Found error in the file '/home/wlhamil/public_html/modules/boonex/sites/classes/BxSitesDb.php' at line 46.
Called 'getRow' function with erroneous argument #0.

Anyone know if the schema changed between the RC and release version?

I too get the same email with subjectline Database error in <SiteName>

and the body contains 100s of lines of text and I give first few lines here:

===========================

Database error in

Query:

SELECT * FROM `sys_modules` WHERE INSTR('BxShoutBoxModule', `class_prefix`)=1 LIMIT 1

Mysql error: MySQL server has gone away

Found error in the file '/home/xxxxx/public_html/inc/classes/BxDolModule.php' at line 106.
Called 'db_arr' function with erroneous argument #0.
==============================
This is the third time I get this message. Please help to sort this out.

What i know is this error comes when some one register  your site(or edit profile info). and any of the registration information fields doesnd fidn the space on data bases to record.

yes this is what i  estimate. i am also in search of a solution to this.

same error Database error in <SiteName>

Towards the top of the email you will find the informational hint as to what caused it. All the text after that is essentially everything in your database. Be careful you don't post it publicly because it contains your database username and password in plain text.

There is a way to limit the output of that message to just the error but I can't remember how to do it. Someone commented on how recently in another post I made.

http://www.boonex.com/unity/forums/?action=goto&my_threads=1#topic/Database-Login.htm

SELECT * FROM `sys_modules` WHERE INSTR('BxShoutBoxModule', `class_prefix`)=1 LIMIT 1

 In this particular error, Mysql error: MySQL server has gone away
 your database is closing the connection before the queries have finished. On my setup, the default was set to 20 seconds. I raised it to 40 seconds and completely solved the issue.

You need to change the wait_timeout in your my.cnf file for your MySql database. It has been suggested to set it somewhere between 30 & 40 seconds.

At one point in time i was going to suggest looking at it, but i made the stupid mistake of thinking that setting would be at it's default value. Believe it or not, that values default for a default setup of the mysql server is 28800 seconds.

Why yours would have been set that low is beyond me.

I would think on an active server, even 40 seconds would be to low. But then again, if it takes 40 seconds for the server to execute a sql query, then it's time to upgrade.

I'm just going by what my guy at HFW told me. I have zero skill in this area. I couldn't even get my shell to work, lol. Had to have someone do it for me.

I'm receiving this Database error in <SiteName> messages too. So who are the one to to set this "wait_timeout in your my.cnf file for your MySql database" to ie. 40 sec? Can we do it ourselves or this need the hosting provider?

If your on a shared hosting plan, then you will need to contact your host to do it.

I think it's another issue, too.

I tested that "bug" and it happens to me for the following reason:

User uploads a video ... Then cronjob does the conversion to FLV file. This conversion may take seconds (if file is small), but may take e.g.

2-3 minutes serverside to complete the job. In that case "MySQL server has gone away" or the QUERY has timed out, as the conversion

still works and after job is done, this Query-connection timed out.

Hello everyone!

And I have such problem.

Database error in <SiteName>

Query:  SELECT COUNT(*) FROM `RayVideoFiles`  left JOIN `Profiles` ON `Profiles`.`ID`=`RayVideoFiles`.`Owner` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND CONCAT(`RayVideoFiles`.`Tags`) LIKE ('%o'zbek%') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos'

Mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'zbek%') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos'' at line 1

I think problem is - When somebody looks for tags or clicks tags with symbol <'> (single quote). It stops query I think. Other tags OK.

Any ideas how to fix this problem?

you need escape tag value