can't upload images / too many connections

Need some help with the script?

can't upload images / too many connections

Postby haverica » Mon Mar 01, 2010 7:56 pm

Hay all guys,

I have been using cutenewsru for a while now (let’s say around 2 years). I’m very happy with the script or better say excellent CMS system – as it provide me more freedom in designing, so that is probably the main reason I stick with the cutenewsru. To be honest, now days it’s very hard to keep such one project alive when there is a large number of programs (CMS systems) on the market. User seems to turn (and I understand way) to those CMS systems (joomla, drupe, wordpres, etc…) as they are much easier to install, use, add new futures, better support, need less knowledge.

Anyway, I have been resolving all my problems by support of this forum, and the reason I’m writing now is because I’m experiencing two problems with the script.
a)
I’m not able to upload images on my web site. I recently moved from one hosting company to another and since then I started to experience this problem. Simply, when I try to upload an image it last long, (2 to 3 minutes) and at the end it show this massage:
“Error 500: Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.
The problem is on the server side, not with your browser or the address. Most probably, a certain service (e.g., Tomcat engine) is down. Please contact your webmaster.“
Any idea? What could be the problem?

b)
Is true that cutenewsru is having hard time to deal with the a lot of users, which visit the web city? Recently I started to experienced this problem (I didn’t move from any hosting company, this is totally different web city). This is not often, but the problem is happening. A worming message goes like this:

“Warning: mysql_connect(): Too many connections in /var/www/html/cutenews/inc/db/mysql.class.php on line 14
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/html/cutenews/inc/db/mysql.class.php on line 27
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/html/cutenews/inc/db/mysql.class.php on line 182
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/html/cutenews/inc/db/mysql.class.php on line 182”

A appreciate any help,

Thank you in forward to you all!
haverica
 
Posts: 13
Joined: Wed Dec 03, 2008 12:07 pm

Postby Hawk » Tue Mar 02, 2010 8:36 am

Could you tell us the size and extension of the file which you are trying to upload? I remember getting an error like that on one web host, and it turned out there was some limitation on server which prevented upload of larger files.

Too many connections on db means that there are too many users connected to the database. If you are on shared hosting, it might suggest that the server can't handle that many sites hosted which use the db.

However, I remember the topic about cnr making too many queries which can lead to the problem you described, however I haven't made a website so far which has 1000 users per day and is based on cnr to actually see if the problem really is cnr related.

One thing I have learned from exprience with large portals is that eventually the website will definetly need a dedicated server, for example the company I work for has a portal with about 30000 visitors per day, and we had to cluster 3 servers to work together, ads server, apache/html cache server and a db server. All beside ads server which is like 3 years old are brand new and powerful servers. We used eZ publish as the CMS base.

There is always room for optimizing number of running queries and the database itself, but as I wrote, it can be a server side thing aswell specially if you are on shared hosting plan.
User avatar
Hawk
 
Posts: 248
Joined: Tue Aug 29, 2006 9:00 pm

Postby Torstein » Wed Mar 03, 2010 8:46 pm

Atleast a few years ago the default upload limit set in the php configuration file (php.ini) was 2MB.

CuteNews.RU isn't designed for very popular websites, so if you receive many visitors you might experience some problems. With that said, I do not believe that CNR is any worse than any other CMS out there when it comes to number of db queries. However CNR's caching is a bit dated/not working properly.
Torstein
 
Posts: 292
Joined: Thu Aug 03, 2006 11:19 pm

Postby DarkSlim » Thu Mar 04, 2010 9:38 pm

It is something I want to make better in CNR, does anyone
familiar with caching?
I want to look deeply into CNR caching system, and also read
about caching and tricks how to make it better :)
User avatar
DarkSlim
 
Posts: 296
Joined: Thu Aug 06, 2009 4:18 pm
Location: IL


Return to Help



Who is online

Users browsing this forum: No registered users and 3 guests