Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2019-08-11 15:59:15

THE BLUE DRAGON
Member
From: Israel
Registered: 2007-11-16
Posts: 619
Website

Images seems to reached the limit in database, how to increase?

Hi,
I have a site with lots of images, when trying to upload more it returns this error: No file was specified.

If I delete an old image then I once again able to upload a new one, so it seems to me like there is some limit somewhere maybe in the database or on the server?

How can I solve this please?

Here’s an image of the txp_image table in the database:
https://i.ibb.co/jTbmCpf/Untitled.png

Offline

#2 2019-08-11 19:33:32

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: Images seems to reached the limit in database, how to increase?

Intriguing. How many images are we talking about? There are sites out there with nearly 30,000 in them working fine. It’s unlikely to be the database per se as that can handle a good few million records. But things to check:

  1. Your database table (innodb) has enough disk space to write its index and data info.
  2. The volume where your /images directory resides has free space in it.

Beyond that I can’t think of a reason why you’d see this behaviour.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#3 2019-08-12 10:24:00

etc
Developer
Registered: 2010-11-11
Posts: 5,028
Website GitHub

Re: Images seems to reached the limit in database, how to increase?

Given the nature of the error message (UPLOAD_ERR_NO_FILE), it looks like some file system limitation, either on temp or image directory. Rather uncommon, though.

Offline

#4 2019-08-16 14:42:08

THE BLUE DRAGON
Member
From: Israel
Registered: 2007-11-16
Posts: 619
Website

Re: Images seems to reached the limit in database, how to increase?

Thank you,
it was a disk space limit on the server, it had nothing to do with the database or anything related to Textpattern, free up some space on the server solved it.

Offline

Board footer

Powered by FluxBB