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
Hi jochen2011,
Which version of MySQL do you use?
Do you still have the imgpiwiuser_cache table in your database?
Offline
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
yes i still have those tables inside the database. What shall I do with those tables ?
Offline
jochen2011 wrote:
Hi, it is version 5
Can you be more precise please?
Offline
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
MySQL 5.0.77 should be fine.
With PhpMyAdmin or any other tool to manage your MySQL database, perform a:
repair table imgpiwiuser_cache;
Offline
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