Piwigo.org

jochen2011 · 2011-03-01 17:52:05

Dear all,

right after one day my piwigo gives me the following error only and so I cannot access the gallery anymore. :-(

Does anyone have an idea ?

Thanks in advance, br, Jochen

Warning: [mysql error 126] Incorrect key file for table './hotels_/piwigo_user_cache_categories.MYI'; try to repair it

SELECT
id, name, permalink, nb_images, global_rank,
date_last, max_date_last, count_images, count_categories
FROM piwigo_categories INNER JOIN piwigo_user_cache_categories
ON id = cat_id and user_id = 2
WHERE id_uppercat IS NULL OR uppercats REGEXP '^[0-9]+,[0-9]+$'
; in /var/www/vhosts/travelphotos24.com/httpdocs/hotels/include/dblayer/functions_mysql.inc.php on line 656

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/travelphotos24.com/httpdocs/hotels/include/dblayer/functions_mysql.inc.php on line 155

ddtddt · 2011-03-01 18:38:16

I made you an email with a direct link to the maintenance of your database

jochen2011 · 2011-03-02 08:52:56

OK, so this is the result. Is it a pure database error

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /var/www/vhosts/travelphotos24.com/httpdocs/hotels/include/dblayer/functions_mysql.inc.php on line 90

Warning: [mysql error 126] Incorrect key file for table './hotels_/piwigo_user_cache_categories.MYI'; try to repair it

SELECT DISTINCT user_id
FROM piwigo_user_cache_categories
; in /var/www/vhosts/travelphotos24.com/httpdocs/hotels/include/dblayer/functions_mysql.inc.php on line 656

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/travelphotos24.com/httpdocs/hotels/include/dblayer/functions_mysql.inc.php on line 202

plg · 2011-03-02 12:15:21

Hi Jochen,

Can you perform the following SQL query? (in PhpMyAdmin for example)

Code:

repair table piwigo_user_cache_categories;

jochen2011 · 2011-03-02 17:17:43

I just did all you told me, but nothing helps.

I am now changing the OS from CentOS to OpenSuse11.1 with Plesk.
After reinstall I will notice you again.

So far thank you very much for your help,

best regards, Jochen

plg wrote:
Hi Jochen,

Can you perform the following SQL query? (in PhpMyAdmin for example)
Code:
repair table piwigo_user_cache_categories;

jochen2011 · 2011-03-03 21:46:07

Hello once more, I just installed the latest version on OpenSuse11.3, removed the exif failure but now I still get other errors:

logged in as admin :

Warning: strftime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /srv/www/vhosts/travelphotos24.com/httpdocs/hotels/include/smarty/libs/Smarty_Compiler.class.php on line 400

logged out viewing the big photo:

Warning: mktime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /srv/www/vhosts/travelphotos24.com/httpdocs/hotels/include/functions.inc.php on line 510 Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /srv/www/vhosts/travelphotos24.com/httpdocs/hotels/include/functions.inc.php on line 510

I opened those mentioned files, but just commenting out some parts with // did not solve the problems.

Do you have an idea ?

Would begreat, thanks in advance, Jochen

jochen2011 wrote:
I just did all you told me, but nothing helps.

I am now changing the OS from CentOS to OpenSuse11.1 with Plesk.
After reinstall I will notice you again.

So far thank you very much for your help,

best regards, Jochen
plg wrote:
Hi Jochen,

Can you perform the following SQL query? (in PhpMyAdmin for example)
Code:
repair table piwigo_user_cache_categories;

Piwigo.org

Announcement

#1 2011-03-01 17:52:05

Database Error with latest version, after one day

#2 2011-03-01 18:38:16

Re: Database Error with latest version, after one day

#3 2011-03-02 08:52:56

Re: Database Error with latest version, after one day

#4 2011-03-02 12:15:21

Re: Database Error with latest version, after one day

Code:

#5 2011-03-02 17:17:43

Re: Database Error with latest version, after one day

plg wrote:

Code:

#6 2011-03-03 21:46:07

Re: Database Error with latest version, after one day

jochen2011 wrote:

plg wrote:

Code:

Board footer