BxDolEmailTemplates

All of a sudden since upgrading to D7.02 I am receiving this error sent to my site email.

Database error in

Query:
SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1Mysql error: MySQL server has gone away

Found error in the file '/home/XXXX/XXXXX/inc/classes/BxDolEmailTemplates.php' at line 35.
Called 'getOne' function with erroneous argument #0.

Any ideas?

Could this be the custom template that I use? Should I try going back to the basic original one? I also can not play new uploaded videos since this upgrade. I can play old ones already uploaded before,but not the new ones. I have changed permission and nothing so went back to 755. My flash/modules/video folder is set to 755, and so is all the folders inside this folder.

You need increase mysql memory

Now why do I have to do that? I have never had to up my mysql memory before.

Hi,

I have same problem....

Regards

Glenn

Did you upgrade to 7.0.2  now you have video problem or mysql problem ?

If you upgraded and have the video problem    check to see if   /flash/modules/global/app/ffmpeg.exe  has 755 permissions and not 644

Hi,

Clean install of 702. Video etc fine - it is triggered by cron jobs- looking into it.

Thanks Glenn

Hi,

It is not related to cron jobs - still coming every 5 minutes - emails range from 109kb to 34mb in size!!!!!!

143 in a few hours - how do i stop them????/

I am on hostforweb VPS - loads of power and resources

HELP Please.

Glenn

Hi,

Bump

Regards

Glenn

Hi,

Checked my server raw logs:

[Fri Aug 20 04:10:15 2010] [error] [client 216.xxx.41.xxx] PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 67654585 bytes) in /home/mysite/public_html/inc/classes/BxDolDb.php on line 451

Hope someone can shed lights.......?

Regards

Glenn

PHP ran out of memory. Need to increase memory limits for php.

Hi,

These are my my-sql settings-

What needs to be changed?

skip-bdb
set-variable = max_connections=500
safe-show-database

connect_timeout=10
interactive_timeout=45
wait_timeout=20

join_buffer_size=2M
key_buffer_size=128M
max_allowed_packet=32M
myisam_sort_buffer_size=48M
read_buffer_size=2M
sort_buffer_size=2M
read_rnd_buffer_size=1M
table_cache=1024
thread_cache_size=96
tmp_table_size=64M
query_cache_limit=1M
query_cache_size=24M
query_cache_type=1

Regards

Glenn

For this error. PHP Fatal error:  Allowed memory size of 134217728

Thats PHP's memory limit not the MySQL limit.

Your php.ini Settings.

These are the dolphin recommend settings.

register_globals=Off
magic_quotes_gpc=On
allow_url_fopen=On
allow_url_include=Off
upload_max_filesize=300M
post_max_size=300M
max_input_time=3000
max_execution_time=3000
memory_limit=128M
short_open_tag=On

I however recommend memory_limit be at least twice that. 256M

Look at your current setting and double it.

Hi,

Set my limits to above - still getting emails...

Regards

Glenn

Hi,

Only coming through once a day so far.......

Regards Glenn

Hi,

PLEASE can someone help- I have upped the settings as per deno....

It is hogging my email account sending these huge email - some 47mb big.

The site is flying fast - so why the emails???

Regards

Glenn

Hi,

I changed the dolphin cron from 5 mins to 15 mins and so far so good.

Let see...

regards

Glenn

Hi, Still happening???

Random...

Regards

Glenn

Hi,

Please can someone assist - it is still happening at random.

I have stopped all cron jobs to see if that was the issue - no it is not.

I have my system set to dolphin specs and even better.

What is going on??????

Database error in

Query:
SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
Mysql error: MySQL server has gone away

Found error in the file '/home/junc33/public_html/inc/classes/BxDolEmailTemplates.php' at line 35.
Called 'getOne' function with erroneous argument #0.

I am getting four emails at a time  - one of which is 40mb big.

Please can someone help!!!!!

Regards

Glenn

Your error describes this : Mysql error: MySQL server has gone away

Try adding this to your php.ini file located in the root directory of where you have Dolphin installed:

mysql.allow_persistent= Off

Hi,

Thanks for that, I have it done - lets see what happens. It was set to on.

many thanks

Glenn

Hi,

Just got 4 emails now:

Database error in

Query:
SELECT `id`, `title`, `vendor`, `version`, `update_url`, `path`, `uri`, `class_prefix`, `db_prefix`, `date` FROM `sys_modules` WHERE `uri`='simple_messenger' LIMIT 1
Mysql error: MySQL server has gone away

Found error in the file '/home/junc33/public_html/inc/classes/BxDolModuleDb.php' at line 46.
Called 'fromMemory' function with erroneous argument #2.

------------------------------

Database error in

Query:
SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
Mysql error: MySQL server has gone away

Found error in the file '/home/junc33/public_html/inc/classes/BxDolEmailTemplates.php' at line 35.
Called 'getOne' function with erroneous argument #0

Not sure whats next????

Regards

Glenn

I have the same problem.

someone found the solution?

Hi,

Suddenly getting these errors:

Database error in

Query:
SELECT `RSSUrl` FROM `bx_crss_main` WHERE `ID`='0' AND `Status`='active'
Mysql error: Table 'xxxxxxxxx.bx_crss_main' doesn't exist

Found error in the file '/home/xxxxx/public_html/modules/boonex/custom_rss/get_rss_feed.php' at line 7.
Called 'db_value' function with erroneous argument #0.


Debug backtrace:

What is going ONNNNNNNNNNNNN??????????????????????????????

Glenn

Hi,

Just got an email dump of four emails con through at the same :

1 x 90mb big

1x41mb big

1x 5mb

1x875kb

This is screwing up my email on my devices.

CAN SOMEONE SORT OUT A FIX PLEASE - Yes I am shouting now.

I paid lots of money to be a premium member - no real  support.......on the forums.

One should have a helpdesk like any normal company..

I am getting really frustrated now.

Glenn

It happens because of interactive_timeout mysql setting, it is too low! Especially if you have mysql persistent connection - error will happen all the time.

Default MySQL value is 28800.

I suggest the following:

if mysql persistent connections are ON set it to 28800.

if mysql persistent connections are OFF set it to 1800 at least, it is 30 min. But if your video conversion takes more that 30 minutes you will still get the error, so maybe it can be set to 3600 (1 hour), hope video will not be converted longer than 1 hour.

Also there is a problem in Dolphin 7.0.2 with video playing - it is not starting to play before loading whole video. Maybe because of this it looks like video is not playing.

This problem is already fixed and will be available in 7.0.3:

http://www.boonex.com/trac/dolphin/ticket/2116

Dolphin 7.0.3 is near completion and beta version for testing will be available very soon.

Hi Alex,

Thanks for the reply. I have it set to your settings - still get these emails. Intermittent - even if no videos are utilized?

So not sure ??

Regards

Glenn

Please provide root access to your site via PM - I will have a look.