Piwigo.org

mendip_discovery · 2012-11-04 21:48:43

Good evening,
I have moved my gallery over to a new server but I seem to have an issue but I am not sure what is causing it,

Code:

[Sun Nov 04 15:31:06 2012] [error] [client IP] PHP Warning: [mysql error 126] Incorrect key file for table '/tmp/#sql_583_6.MYI'; try to repair it\n\nSELECT DISTINCT(image_id)\n FROM piwigo_image_category\n INNER JOIN piwigo_images ON id = image_id\n WHERE\n 1=1\n\n ORDER BY file ASC, date_creation DESC\n; in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 770, referer: http://gallery.jackstringer.co.uk/picture.php?/2266++++++++++++++++++++++++++++++Result:+no+post+sending+forms+are+found;

Piwigo 2.4.5
PHP: 5.3.3 (Show info) [2012-11-04 20:43:52]
mysql: 5.1.61 [2012-11-04 20:43:52]
Graphics Library: External ImageMagick 6.5.4-7

I was wondering if when I copied the MySQL database over I managed to mess it up. If I have how do others move a large SQL database between servers, the one being copied from does not support remote use of the database, but I can use SSH on both servers.

I have also done a database repair.

Jack

flop25 · 2012-11-04 22:16:52

Hello

mendip_discovery wrote:
I have also done a database repair.

Jack

That's the solution :still errors?
I thank you for your great post, I wish everyone would post like you

mendip_discovery · 2012-11-04 22:29:33

Flop, I know the best way to get help is to provide as much info as you can and to provide what you have done already to fix it.

I did a database repair but I don't think it worked. When importing the database I had to do it via phpmyadmin and in several parts as the database is 106megs of sql file.

I am going to try and do it via SSH as I can upload the sql to the server first so there is no download issue then.

Jack

Piwigo.org

Announcement

#1 2012-11-04 21:48:43

Strange Error found in my Error Log

Code:

#2 2012-11-04 22:16:52

Re: Strange Error found in my Error Log

mendip_discovery wrote:

#3 2012-11-04 22:29:33

Re: Strange Error found in my Error Log

Board footer