Announcement

#1 2011-03-21 10:12:32

jochen2011
Member
2011-02-28
20

[resolved] too mayny errors

Hi all,

after installing it for the 3rd time now -- > recently the prelast version 2.1.5 again,  many errors occur, but each time after a while, after uploading about 550 pictures (via piwigi uploader) I get the following errors.

Does anyone have an idea ?  I already tryed the maintenance links, but nothing helps.

Warning:  [mysql error 1017] Can't find file: 'uc' (errno: 2)

SELECT
    ui.*,
    uc.*,
    t.name AS theme_name
  FROM imgpiwiuser_infos AS ui
    LEFT JOIN imgpiwiuser_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN imgpiwithemes AS t ON t.id = ui.theme
  WHERE ui.user_id = 2
; in /var/www/vhosts/travelphotos24.com/httpdocs/images/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/images/include/dblayer/functions_mysql.inc.php on line 155

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 330

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 332

Notice: Undefined index: id in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 361

Notice: Undefined index: status in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 361


Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

SELECT cat_id
  FROM imgpiwiuser_access
  WHERE user_id =
; in /var/www/vhosts/travelphotos24.com/httpdocs/images/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/images/include/dblayer/functions_mysql.inc.php on line 202


Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

SELECT cat_id
  FROM imgpiwiuser_group AS ug INNER JOIN imgpiwigroup_access AS ga
    ON ug.group_id = ga.group_id
  WHERE ug.user_id =
; in /var/www/vhosts/travelphotos24.com/httpdocs/images/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/images/include/dblayer/functions_mysql.inc.php on line 202

Notice: Undefined index: level in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 369


Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

SELECT DISTINCT(id)
  FROM imgpiwiimages INNER JOIN imgpiwiimage_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level> in /var/www/vhosts/travelphotos24.com/httpdocs/images/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/images/include/dblayer/functions_mysql.inc.php on line 202

Notice: Undefined index: level in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 689


Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY c.id, c.global_rank' at line 8
SELECT c.id AS cat_id, global_rank,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM imgpiwicategories as c
  LEFT JOIN imgpiwiimage_category AS ic ON ic.category_id = c.id
  LEFT JOIN imgpiwiimages AS i
    ON ic.image_id = i.id
      AND i.level<=
  GROUP BY c.id, c.global_rank in /var/www/vhosts/travelphotos24.com/httpdocs/images/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/images/include/dblayer/functions_mysql.inc.php on line 155

Notice: Undefined index: status in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 390

Notice: Undefined index: id in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 417


Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

DELETE FROM imgpiwiuser_cache_categories
  WHERE user_id =  in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/dblayer/functions_mysql.inc.php on line 656


Notice: Undefined index: id in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 436


Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

DELETE FROM imgpiwiuser_cache
  WHERE user_id =  in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/dblayer/functions_mysql.inc.php on line 656


Notice: Undefined index: id in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 444


Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''false',1300696517,'0',503,'NOT IN','0')' at line 5

INSERT INTO imgpiwiuser_cache
  (user_id, need_update, cache_update_time, forbidden_categories, nb_total_images,
    image_access_type, image_access_list)
  VALUES
  (,'false',1300696517,'0',503,'NOT IN','0') in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/dblayer/functions_mysql.inc.php on line 656


Notice: Undefined index: status in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 239

Notice: Undefined index: nb_image_line in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 246

Notice: Undefined index: nb_line_page in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 246

Notice: Undefined index: adviser in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 1329

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/travelphotos24.com/httpdocs/images/include/dblayer/functions_mysql.inc.php:656) in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/page_header.php on line 98

Notice: Undefined index: adviser in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 1329

Notice: Undefined index: level in /var/www/vhosts/travelphotos24.com/httpdocs/images/plugins/rightClick/rightClick_protect.php on line 13

Notice: Undefined index: adviser in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 1329

Notice: Undefined index: adviser in /var/www/vhosts/travelphotos24.com/httpdocs/images/include/functions_user.inc.php on line 1329

Offline

 

#2 2011-03-21 10:22:37

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

Re: [resolved] too mayny errors

Hi jochen2011,

Which version of MySQL do you use?

Do you still have the imgpiwiuser_cache table in your database?

Offline

 

#3 2011-03-21 10:46:03

jochen2011
Member
2011-02-28
20

Re: [resolved] too mayny errors

Hi,  it is version 5

now I have already uploaded an  .htaccess  file with

AddType x-mapp-php5 .php AddHandler x-mapp-php5 .php


but still the same errors  :-(

Offline

 

#4 2011-03-21 10:51:59

jochen2011
Member
2011-02-28
20

Re: [resolved] too mayny errors

yes i still have those tables inside the database.  What shall I do with those tables ?

Offline

 

#5 2011-03-21 11:26:36

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

Re: [resolved] too mayny errors

jochen2011 wrote:

Hi,  it is version 5

Can you be more precise please?

Offline

 

#6 2011-03-21 11:56:15

jochen2011
Member
2011-02-28
20

Re: [resolved] too mayny errors

Hello again,

ok, it is version    5.0.77-4.el5_5.4

What about the table ? shall I keep it or delete it ?

Offline

 

#7 2011-03-22 08:53:39

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

Re: [resolved] too mayny errors

MySQL 5.0.77 should be fine.

With PhpMyAdmin or any other tool to manage your MySQL database, perform a:

Code:

repair table imgpiwiuser_cache;

Offline

 

#8 2011-05-11 15:22:03

jochen2011
Member
2011-02-28
20

Re: [resolved] too mayny errors

Hi ,

you can put this topic to the solved ones.

All those errors occured, because we did not have enough space available at our host.
After allocating enough space to the domain it is working very well.

Anyway thanks for your help,

br, Jochen

Offline

 

Board footer

Powered by FluxBB

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