Announcement

#1 2012-12-22 23:42:04

CaptainStarbuck
Member
2012-12-22
9

PWG Stuffs SQL error

[extension by plg] PWG Stuffs v2.4.G

Add a block for "Last comments on albums". Accept all defaults. Refresh form for a logged-in user. SQL Error results:

Warning:  [mysql error 1054] Unknown column 'img.tn_ext' in 'field list'

SELECT
    cat.id,
    cat.name,
    cat.permalink,
    cat.uppercats,
    com.id as comment_id,
    img.id AS image_id,
    img.path,
    img.tn_ext
  FROM family2_categories AS cat
    LEFT JOIN family2_comments_categories AS com
      ON com.category_id = cat.id
    LEFT JOIN family2_user_cache_categories AS ucc
      ON ucc.cat_id = cat.id AND ucc.user_id = 3
    LEFT JOIN family2_images AS img
      ON img.id = ucc.user_representative_picture_id
  WHERE (cat.id NOT IN (1,3))
    AND cat.id IN (2)
; in /home/mypath/include/dblayer/functions_mysql.inc.php on line 770


Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/mypath/include/dblayer/functions_mysql.inc.php on line 153

Notice: Undefined index: 1 in /home/mypath/plugins/Comments_on_Albums/stuffs_module/main.inc.php on line 118

Notice: Undefined index: 1 in /home/mypath/plugins/Comments_on_Albums/stuffs_module/main.inc.php on line 119

Notice: Undefined index: 1 in /home/mypath/plugins/Comments_on_Albums/stuffs_module/main.inc.php on line 120

Warning: make_section_in_url category id not numeric in /home/mypath/include/functions_url.inc.php on line 342

Warning: make_section_in_url category name not set in /home/mypath/include/functions_url.inc.php on line 345

Notice: Undefined index: 1 in /home/mypath/plugins/Comments_on_Albums/stuffs_module/main.inc.php on line 129

Notice: Undefined index: 1 in /home/mypath/plugins/Comments_on_Albums/stuffs_module/main.inc.php on line 130

Notice: Undefined index: 1 in /home/mypath/plugins/Comments_on_Albums/stuffs_module/main.inc.php on line 146

Warning: Cannot modify header information - headers already sent by (output started at /home/mypath/include/dblayer/functions_mysql.inc.php:769) in /home/mypath/include/page_header.php on line 105

Last edited by CaptainStarbuck (2012-12-22 23:43:10)

Offline

 

#2 2012-12-23 00:46:56

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: PWG Stuffs SQL error

it's more a problem with Comment on Albums

I didn't really update the PWG Stuff module, sorry

Offline

 

Board footer

Powered by FluxBB

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