photo number limit?

jeffngym

my zenphoto server is 1.4.6 [bbddab7675] (Official build)
and php ver is 5.3.3
and mysqli ver is 5.1.73

i have 21952 photo in my server
and 1311 album in my server

when i try to upload more photo into my server
it fail and i cant see any album and photo anymore

when i check the log file
it show

USER ERROR: MySQLi Error: ( SHOW FULL COLUMNS FROM `[prefix]albums` ) failed. MySQLi returned the error Incorrect key file for table '/tmp/#sql_680_0.MYI'; try to repair it in /var/www/html/zenphoto/zp-core/functions-db-MySQLi.php on line 78
trigger_error called from query (functions-db-MySQLi.php [78])
from db_show (functions-db-MySQLi.php [300])
from db_list_fields (functions-db-MySQLi.php [311])
from lookupSortKey (functions.php [280])
from AlbumBase->getAlbumSortKey (class-album.php [311])
from Album->getAlbums (class-album.php [1286])
from AlbumBase->getNumAlbums (class-album.php [339])
from setAlbumSubtabs (admin-functions.php [454])
from admin-edit.php [554]
{2795:Wed, 26 Nov 2014 00:55:14 GMT}

is there any limit of the photo numbers?

acrylian

No, there is no limit by Zenphoto. THe only limit would be the server space and processing power. Naturally if you upload a lot very big images at one time processing them may overload your server especially if you are on shared hosting.

jeffngym

the server of my zenphoto is my own server
is that the problem of mysqli?
becoz the log tell that mysqli error

acrylian

That is a MySQL error. But I sadly neither have any idea right now why that happens for you nor did I ever encounter that myself. The part `table '/tmp/#sql_680_0.MYI';` looks somehow wrong.

jeffngym

so if i create a new table and try again may solve the problem?

fretzl

Maybe this topic helps. It's basically about disk space.
http://stackoverflow.com/questions/2090073/mysql-incorrect-key-file-for-tmp-table-when-making-multiple-joins