[symfony-users] Re: www.e4s.co.uk built on symfony
That's good for a startup plan, what kind of server do you use? and how can your bandwidth keep up with the 500k hits like that? On 7/21/07, Amit Rana [EMAIL PROTECTED] wrote: We regularly get over 500,000 hits per day. 80-90% of our visitors are new users. Currently our traffic is almost half of that. We are using Mysql (with propel), 5 queries per second. On 7/20/07, Eric Greene [EMAIL PROTECTED] wrote: hey, nice site! What type database did you use? When you say very high traffic, how high are you talking about? On 7/20/07, amit [EMAIL PROTECTED] wrote: Hi, I am happy to announce release of http://www.e4s.co.uk , another symfony success story. This is a very high traffic site getting thousands of unique users every day. From: http://www.e4s.co.uk/docs/aboutus.htm www.e4s.co.uk http://www.e4s.co.uk is essentially an online job board that enables employers to advertise job vacancies to thousands of job seekers via our comprehensive job search facilities. Comments and feedback are welcome. As always thanks everyone for helping us on the way. Regards, Amit Rana. -- w: www.valuejini.com | blog.techjini.com | www.cheermyteam.com -- w: www.techjini.com | www.cheermyteam.com | www.valuejini.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] sfDoctrine limit/offset problem
Hi all,
i'm using the sfDoctrine plugin as database layer. Everythings seems
pretty fine until i tried to get a limited result over more than one
table.
Here is my schema.yml
Attribute:
tableName: attribute
i18n: {class: AttributeI18n, cultureField: culture}
columns:
AttributeI18n:
tableName: attribute_i18n
columns:
name: string(200)
And i'm trying the following:
$table = sfDoctrine::getTable('Attribute');
$q = $table-createQuery();
$result = $q-from('Attribute a')
-orderby('a.AttributeI18n.name ASC')
-limit($limit)
-offset($start)
-execute();
But this results in the following error:
[Doctrine_Connection_Mysql_Exception]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.id' in
'field list'
If i remove the limit/offset part of the query everything is fine.
Any help?
Timo
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Re: www.e4s.co.uk built on symfony
Hi, I am interested in how you did the forum integration? Which forum software do you use? Do you synchronize the user databases? Can you use the same layout to decorate your symfony pages and your forum pages? Thx Robert On Jul 20, 12:28 pm, amit [EMAIL PROTECTED] wrote: Hi, I am happy to announce release of http://www.e4s.co.uk, another symfony success story. This is a very high traffic site getting thousands of unique users every day. From:http://www.e4s.co.uk/docs/aboutus.htmwww.e4s.co.ukhttp://www.e4s.co.uk is essentially an online job board that enables employers to advertise job vacancies to thousands of job seekers via our comprehensive job search facilities. Comments and feedback are welcome. As always thanks everyone for helping us on the way. Regards, Amit Rana. -- w:www.valuejini.com| blog.techjini.com |www.cheermyteam.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: www.e4s.co.uk built on symfony
Amit, Congrats with finishing this project! I'm very curious on the process that went on during this project. For instance how did you decide the structure for this project? How did you combine the seperate applications and tied them together in this website. It would be nice if you could tell a bit more about this. All the best, grtz BjornW amit wrote: Hi, I am happy to announce release of http://www.e4s.co.uk , another symfony success story. This is a very high traffic site getting thousands of unique users every day. From: http://www.e4s.co.uk/docs/aboutus.htm www.e4s.co.uk http://www.e4s.co.uk is essentially an online job board that enables employers to advertise job vacancies to thousands of job seekers via our comprehensive job search facilities. Comments and feedback are welcome. As always thanks everyone for helping us on the way. Regards, Amit Rana. -- w: www.valuejini.com | blog.techjini.com | www.cheermyteam.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: www.e4s.co.uk built on symfony
I am sorry I didnt quite understand the question. We had to do lot of optimization to be able to cope up to that much traffic. We started with a very bad server P3(1.1GHz) hosting both db and web, which was not able to cope up at all and server load was always above 10 and above 60 during peak time. This made site completely useless. We work on following items as part of optimisation (some before, some after separatin db and web on different servers): 1. Apache configuration (connections, caching, mod_expires, gzip etc) 2. Mysql configuration ( cache, tmp tables, innodb buffer, join buffer etc) 3. Symfony ( Everything from the docs...using caching efficiently helped a lot, gzip, etc) 4. We already had APC The UI design that was given to us had LOTS of images so one page request resulted in over 30 server requests, which was a very bad idea. Our current setup is: DB: P3(1.1GHz), 4GM RAM Web: P4(3GHz), 3GM RAM Server load on both the servers are below 1 (except few spikes) all the time after optimization. On 8/13/07, Hung Dao [EMAIL PROTECTED] wrote: That's good for a startup plan, what kind of server do you use? and how can your bandwidth keep up with the 500k hits like that? On 7/21/07, Amit Rana [EMAIL PROTECTED] wrote: We regularly get over 500,000 hits per day. 80-90% of our visitors are new users. Currently our traffic is almost half of that. We are using Mysql (with propel), 5 queries per second. On 7/20/07, Eric Greene [EMAIL PROTECTED] wrote: hey, nice site! What type database did you use? When you say very high traffic, how high are you talking about? On 7/20/07, amit [EMAIL PROTECTED] wrote: Hi, I am happy to announce release of http://www.e4s.co.uk , another symfony success story. This is a very high traffic site getting thousands of unique users every day. From: http://www.e4s.co.uk/docs/aboutus.htm www.e4s.co.uk http://www.e4s.co.uk is essentially an online job board that enables employers to advertise job vacancies to thousands of job seekers via our comprehensive job search facilities. Comments and feedback are welcome. As always thanks everyone for helping us on the way. Regards, Amit Rana. -- w: www.valuejini.com | blog.techjini.com | www.cheermyteam.com -- w: www.techjini.com | www.cheermyteam.com | www.valuejini.com -- w: www.techjini.com | www.cheermyteam.com | www.valuejini.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: www.e4s.co.uk built on symfony
Hi, We are using vBulletin, we did not play a lot with trying to integrate symfony and the forum. Following is what we have done. 1. All UI customisation is from vBulletin admin panel. 2. We have disabled sign-in and login from the forum directly. You have to come via job seeker panel. 3. All session checking and menu display code is still part of symfony app, vBulletin simply calls it. 4. We have api calls to update forum db whenever a new user is created or changed on our db. HTH On 8/13/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, I am interested in how you did the forum integration? Which forum software do you use? Do you synchronize the user databases? Can you use the same layout to decorate your symfony pages and your forum pages? Thx Robert On Jul 20, 12:28 pm, amit [EMAIL PROTECTED] wrote: Hi, I am happy to announce release of http://www.e4s.co.uk, another symfony success story. This is a very high traffic site getting thousands of unique users every day. From:http://www.e4s.co.uk/docs/aboutus.htmwww.e4s.co.ukhttp://www.e4s.co.uk is essentially an online job board that enables employers to advertise job vacancies to thousands of job seekers via our comprehensive job search facilities. Comments and feedback are welcome. As always thanks everyone for helping us on the way. Regards, Amit Rana. -- w:www.valuejini.com| blog.techjini.com |www.cheermyteam.com -- w: www.techjini.com | www.cheermyteam.com | www.valuejini.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Admin generator and TinyMce textarea
Ok, sorry ! Noob style ^^ On 13 août, 18:55, Tchinkatchuk [EMAIL PROTECTED] wrote: Hi all. I need to use the Tinymce Rte or textarea in admin generator. 1rt, I put tinyce files in web/js/tiny_mce 2th, I wrote this in apps/backend/config/settings.yml all .settings: sf_rich_text_js_dir:js/tiny_mce 3th, I cleared the cache But symfnoy doesn't want to know anything and tell me tinyMce is not installed. Did I forget something ? Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Admin generator and TinyMce textarea
Hi all. I need to use the Tinymce Rte or textarea in admin generator. 1rt, I put tinyce files in web/js/tiny_mce 2th, I wrote this in apps/backend/config/settings.yml all .settings: sf_rich_text_js_dir:js/tiny_mce 3th, I cleared the cache But symfnoy doesn't want to know anything and tell me tinyMce is not installed. Did I forget something ? Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] access myUser.class.php from a template/layout
Hi,
my goal is to access the content of myUser.class.php (located in the
lib dir) from a template or layout. But how can I do that?
My myUser.class.php file:
class myUser extends sfBasicSecurityUser
{
public function getTestData()
{
return test-text;
}
}
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Re: access myUser.class.php from a template/layout
On Monday, August 13, 2007, scube wrote: my goal is to access the content of myUser.class.php (located in the lib dir) from a template or layout. But how can I do that? Use the $sf_user variable from the templates. ?php echo $sf_user-isAuthenticated ? 'You are logged in' : 'You are not logged in' ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: access myUser.class.php from a template/layout
In your case: $sf_user-getTestData();
On 13 Aug., 21:22, scube [EMAIL PROTECTED] wrote:
Hi,
my goal is to access the content of myUser.class.php (located in the
lib dir) from a template or layout. But how can I do that?
My myUser.class.php file:
class myUser extends sfBasicSecurityUser
{
public function getTestData()
{
return test-text;
}
}
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] SymfonyCamp update
Hey guys, Here's another short SymfonyCamp update. I've just deployed the latest version of our site, which now has a bit more information on the event. Unfortunately, the program for the technology days is still not confirmed, aside from the earlier announced attendance of Fabien Potencier and Dustin Whittle. The business day has been confirmed though. Also confirmed is the fact that all participants of the technology days will receive a copy of The Definitive Guide To Symfony. This book by Apress was written by Fabien and Francois, and is both a great learning book and a great reference for experienced Symfony developers (but I don't have to tell you that of course ;) ) And, I'm very proud to let you know SymfonyCamp is sponsored by none other than Sensio themselves! People who have registered can also register their attendance at upcoming.org at http://upcoming.yahoo.com/event/20/ Anyway, have a look at www.symfonycamp.com ... I hope to see you there! Stefan --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Using Propel Doctrine
Hi, I am using both in one of my project, but can't think of any special setting up both, because it's straightforward and easy. Normally you use Propel first, then set up Doctrine. I set it up with the help of sfDoctrine wiki. There will be two database connections in databases.yml, one for Propel and the other for Doctrine. Their configuration, schema and model files are placed separately. Also for the model generation task. Of course you can't use the same class name for the same model, I have to prefix them in Doctrine. And of course you can't write $doctrineUser-Group[0] = $propelGroup without adding underlying magic. Tamcy On Aug 13, 11:44 pm, Matthias Nothhaft [EMAIL PROTECTED] wrote: Hi list, some time ago I read somewhere that it is possible to use Propel and Doctrine at the same time. Unfortunately I cannot find it anymore.. Anyone here who can give an example how to set it up and what to care for? I suppose it is not possible to reference things between Doctrine and Propel!? Regards, Matthias --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
