Piwigo.org

glomme · 2017-05-03 08:46:27

Hello,

after I updated Piwigo first the tour starts. So far so good after the 4th screen of the tour suddenly a error pops up.

Fatal error: Call to a member function fetch_assoc() on boolean in /homepages/41/d558802264/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 893

Also when I call the gallery direct the error occurs (maybe cookie). When I open the gallery in a other browser I can see the gallery without error.

Can someone help me with this problem?

Can't upload a screenshot so here a link: https://db.tt/oKs86LM3N4

Piwigo version: 2.9
PHP version: 5.6
MySQL version: MySQL5.1
Piwigo URL: http://gallery.glomme.us

Last edited by glomme (2017-05-03 09:13:02)

plg · 2017-05-04 12:46:30

Hi glomme,

Unfortunately, the error message is cut. We need to see it completely to understand what goes wrong :-)

plg · 2017-05-04 14:13:37

Another user has reported exactly the same error on [Github] Piwigo issue #663

Can you edit file admin/batch_manager_global.php line 549, after:

Code:

if (count($page['cat_elements_id']) > 0)
{

insert

Code:

echo '<pre>'; print_r($page['cat_elements_id']); echo '</pre>';

and go again on admin.php?page=batch_manager&filter=prefilter-duplicates-checksum to tell us what this print_r outputs? I think an id is null or empty, which breaks the query.

glomme · 2017-05-04 23:27:25

Hello,

Sorry for my late response, but was only now able to answer.

After I changed the file the output was:

Code:

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 '1539,1530,1342,1343,1528,1521,1,1143)
    AND (
      ic.category_id != i.storag' at line 5

SELECT
    DISTINCT(category_id) AS id
  FROM piwigo_image_category AS ic
    JOIN piwigo_images AS i ON i.id = ic.image_id
  WHERE ic.image_id IN (785,766,765,764,763,762,761,760,759,758,757,756,755,754,753,752,767,768,769,784,783,782,781,780,779,778,777,776,775,774,773,772,771,770,751,750,749,730,729,728,727,726,725,724,723,722,721,720,719,718,717,716,731,732,733,748,747,746,745,744,743,742,741,740,739,738,737,736,735,734,715,856,837,836,835,834,833,832,831,830,829,828,827,826,825,824,823,838,839,840,855,854,853,852,851,850,849,848,847,846,845,844,843,842,841,822,821,820,801,800,799,798,797,796,795,794,793,792,791,790,789,788,787,802,803,804,819,818,817,816,815,814,813,812,811,810,809,808,807,806,805,786,714,642,623,622,621,620,619,618,617,616,615,614,613,612,611,6 in /homepages/41/d558802264/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 845


Fatal error: Call to a member function fetch_assoc() on boolean in /homepages/41/d558802264/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 893

Hope that helps to find the error.

Thank you for the help
Hans

Last edited by glomme (2017-05-04 23:28:48)

zjohn13 · 2017-05-30 19:44:21

Hi

I have the same Fatal error message after updating to 2.9.
Is there a way to recover please?

Thanks,
John

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 ')
AND (
ic.category_id != i.storage_category_id
OR i.storage_cat' at line 5

SELECT
DISTINCT(category_id) AS id
FROM piwigo_image_category AS ic
JOIN piwigo_images AS i ON i.id = ic.image_id
WHERE ic.image_id IN (278,293,294,295,296,297,298,299,300,301,302,303,292,291,290,279,280,281,282,283,284,285,286,287,288,289,304,305,306,321,322,323,324,325,326,327,328,329,330,331,320,319,318,307,308,309,310,311,312,313,314,315,316,317,332,223,238,239,240,241,242,243,244,245,246,247,248,237,236,235,224,225,226,227,228,229,230,231,232,233,234,249,250,251,266,267,268,269,270,271,272,273,274,275,276,265,264,263,252,253,254,255,256,257,258,259,260,261,262,277,333,389,404,405,406,407,408,409,410,411,412,413,414,403,402,401,390,391,392,393,394,395,396,397,398,399,400,415,416,417,432,433,434,435,436,437,438,439,440,441,442,431,430,429,418,419,420,4 in /home/bvgicdaf/public_html/piwigo_test/include/dblayer/functions_mysqli.inc.php on line 845

Fatal error: Call to a member function fetch_assoc() on a non-object in /home/bvgicdaf/public_html/piwigo_test/include/dblayer/functions_mysqli.inc.php on line 893

Apache Version 2.4.12
PHP Version 5.3.29
MySQL Version 5.5.54-cll
Piwigo URL http://www.piwigotest.chilternphoto.org.uk

Last edited by zjohn13 (2017-05-30 19:47:24)

zjohn13 · 2017-05-31 00:43:53

Following on from user glomme's comment at head of this thread, I accessed my website in another browser, MS Edge in this case.
Logged in and added theme and plugins that update disabled. (Theme was already at latest version and I had already updated any out of date plugins prior to running update).

I can now access the website OK via my original browser, Chrome.

I have no idea why problem happened but website now functions.
Hope that this helps others.

John

Piwigo.org

Announcement

#1 2017-05-03 08:46:27

Error after update to Piwigo 2.8 -> 2.9

#2 2017-05-04 12:46:30

Re: Error after update to Piwigo 2.8 -> 2.9

#3 2017-05-04 14:13:37

Re: Error after update to Piwigo 2.8 -> 2.9

Code:

Code:

#4 2017-05-04 23:27:25

Re: Error after update to Piwigo 2.8 -> 2.9

Code:

#5 2017-05-30 19:44:21

Re: Error after update to Piwigo 2.8 -> 2.9

#6 2017-05-31 00:43:53

Re: Error after update to Piwigo 2.8 -> 2.9

Board footer