Announcement

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

jochen2011
Member
2011-02-28
20

Database Error with latest version, after one day

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

Offline

 

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

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7046

Re: Database Error with latest version, after one day

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


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

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

jochen2011
Member
2011-02-28
20

Re: Database Error with latest version, after one day

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

Offline

 

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

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13548

Re: Database Error with latest version, after one day

Hi Jochen,

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

Code:

repair table piwigo_user_cache_categories;

Offline

 

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

jochen2011
Member
2011-02-28
20

Re: Database Error with latest version, after one day

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;

Offline

 

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

jochen2011
Member
2011-02-28
20

Re: Database Error with latest version, after one day

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;

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact