[SOLVED] ERROR 500. Please Help!

[eolproductions]

My website keeps getting error 500 when you visit it. The site is: http://selectsexywear.co.uk/. The BO works fine its just the front. There is parts of the error log below.

 

 

[20-Jul-2012 16:32:04] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User selectse_pres957 already has more than 'max_user_connections' active connections in /home/selectse/public_html/classes/MySQL.php on line 34

[21-Jul-2012 11:31:42] PHP Fatal error: Uncaught exception 'SmartyCompilerException' with message 'Syntax Error in template "/home/selectse/public_html/themes/presta053v147/modules/blockcms/blockcms.tpl" on line 53 "{/foreach}" unclosed {foreach} tag' in /home/selectse/public_html/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php:431

Stack trace:

#0 /home/selectse/public_html/tools/smarty/sysplugins/smarty_internal_compilebase.php(141): Smarty_Internal_TemplateCompilerBase->trigger_template_error('unclosed {forea...')

#1 /home/selectse/public_html/tools/smarty/sysplugins/smarty_internal_compile_if.php(172): Smarty_Internal_CompileBase->_close_tag(Array)

#2 /home/selectse/public_html/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php(276): Smarty_Internal_Compile_Ifclose->compile(Array, Object(Smarty_Internal_SmartyTemplateCompiler), Array, NULL, NULL)

#3

 

 

I dont know how it has happened or why. If anyone can help that would be GREAT.

 

 

Thanks

Edited July 27, 2012 by eolproductions (see edit history)

[math_php]

Hello,

 

You need a wider mysql hosting. When you work in the BO and you have customer in the same time your max allowed connexion (use of mysl) is not enough.

Ask your hosting cie to provide you more connexion.

[El Patron]

here is a 'solved' post with what seems to be the same or very similar problem.

 

http://www.prestashop.com/forums/topic/153633-solved-more-than-max-user-connections-active-in-classesmysqlphp/

[eolproductions]

Thanks, ill give it a go and get back to you

[eolproductions]

My Hosting provider, Hosting24, said that the max was 10. Would this be enough?

[math_php]

It really depends of

- your customer traffic

- how many 'employee' may be in a same time working in the back office.

- Perhaps you have remote services that also take their share of your 10 connexion.

- Perhaps you made a too wide commercial ads campaign : a lot of hits in the same time

 

Usually you have 4 chairs in your office, it's enough 95% of the time. But for big meetings with 10 people ?

I know the last one is irritating, sorry.

Edited July 27, 2012 by math_php (see edit history)

[eolproductions]

Okay i have solved it. How do i mark this as solved?

[bellini13]

i think you just edit the original post and put solved in the subject (use the full editor).

 

curious, how did you solve it? change hosts? got your hosting company to increase the max connections?

[eolproductions]

Thanks. I installed prestashop again but in a different directory. Then i copied all the images and some files over. I then had to change the CMS and a lot more.

[bellini13]

oh, then i don't think the problem is solved. the error you reported was related to the max number of connections you are allowed. if that was not changed, then you will likely encounter that issue again. i would keep an eye on your php error log to see how frequently that occurs.

[eolproductions]

Well i havnt had any more problems yet. Also i have had my prestashop store on another domain but on the same hosting provide for a year now and not had any problems with them.

[bellini13]

ok, sounds fine to me. I would still suggest you watch your php error_log to ensure. the error won't magically go away with

1) increasing your max connections

2) decreasing your site usage