[SOLVED] ListIt2 does not show items

[frankmanl]

CMSMS 1.11.7 (fresh install), PHP5.3.3

I installed ListIt2 and added several items (after defining some fields, categories etc.).
Items are stored in the database (can also be exported), but not displayed on the admin page items. At the front of the site they are only displayed when I add parameter showall to the listit-tag.
Categories and custom made fields are displayed at the back.
What can be wrong?

Frank

----------------------------------------------

Cms Version: 1.11.7

Installed Modules:

CMSMailer: 5.2.1
CMSPrinting: 1.0.4
FileManager: 1.4.3
MenuManager: 1.8.5
MicroTiny: 1.2.5
ModuleManager: 1.5.5
News: 2.12.12
Search: 1.7.8
ThemeManager: 1.1.8
CGSimpleSmarty: 1.7
CGExtensions: 1.37
JQueryTools: 1.2.5
TinyMCE: 2.9.12
CGSmartImage: 1.11
Products: 2.19.6
ListIt2: 1.4
ListIt2concerten: 1.4
ListIt2ListItnieuw: 1.4


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 50000000
url_rewriting: none
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.3.3
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 8192
memory_limit: 128M
max_execution_time: 30
output_buffering: On
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 32M
upload_max_filesize: 50M
session_save_path: /tmp (0777)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysqli)
Server Db Version: 4.1.21
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable


----------------------------------------------

[Stikki]

Yo,

In 1.4 we added owner for each item.

If you upgraded from some older version, owner ID is not with in item.

If you are not system admin, each item misses owner ID and wont show cause it wont match your ID.

You need to add permission to user group, should look something like this:

listit2test: Modify all items

This is only possible reason that i can think of why items ain't visible to you.

[frankmanl]

I did not upgrade but installed ListIt2 1.4.
I'm the only user, ergo I have admin rights. I did check that, and just now I added another admin, which also can't see the items ...

Frank

[Stikki]

Okey,

Without more information i can't help you. I need at least clue why it's doing that.

[frankmanl]

What more info could you use? Please let me know. I could also PM login codes, so you can see for yourself.
BTW - I just installed ListIt2 in another site - same problem: items are not displayed ...

[Stikki]

Yo,

If you want me to check it, it's commercial support, means it costs.

You are so far only one that has this issue, so try to get around it some how, but honestly im out of ideas if you can't provide more information (error or something).

[frankmanl]

Sorry Stiki, I can't afford commercial help.
My host's error report gives this warning every 5 minutes, from July 12th. Has nothing to do with my CMSMS installation (which I installed days later). I'm going to try to fix this first.

[Fri Jul 12 17:18:15 2013] [error] [client 37.74.135.118] PHP Warning: Module 'pdo_mysql' already loaded in Unknown on line 0

Debugging CMSMS gives 2 errors on admin page Content > ListIt2mytest, tab items:

Debug: (0.134569) - (usage: 8485036) - (peak: 8614040)

(mysqli): SELECT A.* FROM BU_module_listit2mytest_item A
LEFT JOIN BU_module_listit2mytest_item_categories IB
ON A.item_id = IB.item_id
LEFT JOIN BU_module_listit2mytest_category B
ON IB.category_id = B.category_id WHERE (start_time IS NULL OR TIMESTAMPDIFF(DAY, CURDATE(), start_time) <= 0) AND (end_time IS NULL OR TIMESTAMPDIFF(DAY, end_time, CURDATE()) <= 0) GROUP BY A.item_id ORDER BY A.position ASC
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 '(DAY, CURDATE(), start_time) <= 0) AND (end_time IS NULL OR TIMESTAMPDIFF(DAY, e' at line 5

Debug: (0.13477) - (usage: 8486096) - (peak: 8617648)

(mysqli): SELECT A.* FROM BU_module_listit2mytest_item A
LEFT JOIN BU_module_listit2mytest_item_categories IB
ON A.item_id = IB.item_id
LEFT JOIN BU_module_listit2mytest_category B
ON IB.category_id = B.category_id WHERE (start_time IS NULL OR TIMESTAMPDIFF(DAY, CURDATE(), start_time) <= 0) AND (end_time IS NULL OR TIMESTAMPDIFF(DAY, end_time, CURDATE()) <= 0) GROUP BY A.item_id ORDER BY A.position ASC LIMIT 0, 20
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 '(DAY, CURDATE(), start_time) <= 0) AND (end_time IS NULL OR TIMESTAMPDIFF(DAY, e' at line 5

This is a new instance of ListIt2 without any items added.

[frankmanl]

OK, I tried again:
• a brand new installation of CMSMS 1.11.7, uploaded in binary mode, checksum checks
• after installation of the core I installed ListIt2, using Module Manager, which succeeded
• in ListIt2 I created 1 instance and for that instance I created 1 item, without changing anything to the default settings
• this item is not listed on the admin page, but can be exported, so it does exist

Debugging the admin page gives the same errors:

Debug: (0.16234) - (usage: 6930400) - (peak: 7049312)

(mysqli): SELECT A.* FROM cmstest_module_listit2agenda_item A
LEFT JOIN cmstest_module_listit2agenda_item_categories IB
ON A.item_id = IB.item_id
LEFT JOIN cmstest_module_listit2agenda_category B
ON IB.category_id = B.category_id WHERE (start_time IS NULL OR TIMESTAMPDIFF(DAY, CURDATE(), start_time) <= 0) AND (end_time IS NULL OR TIMESTAMPDIFF(DAY, end_time, CURDATE()) <= 0) GROUP BY A.item_id ORDER BY A.position ASC
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 '(DAY, CURDATE(), start_time) <= 0) AND (end_time IS NULL OR TIMESTAMPDIFF(DAY, e' at line 5

Debug: (0.162649) - (usage: 6931476) - (peak: 7053208)

(mysqli): SELECT A.* FROM cmstest_module_listit2agenda_item A
LEFT JOIN cmstest_module_listit2agenda_item_categories IB
ON A.item_id = IB.item_id
LEFT JOIN cmstest_module_listit2agenda_category B
ON IB.category_id = B.category_id WHERE (start_time IS NULL OR TIMESTAMPDIFF(DAY, CURDATE(), start_time) <= 0) AND (end_time IS NULL OR TIMESTAMPDIFF(DAY, end_time, CURDATE()) <= 0) GROUP BY A.item_id ORDER BY A.position ASC LIMIT 0, 20
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 '(DAY, CURDATE(), start_time) <= 0) AND (end_time IS NULL OR TIMESTAMPDIFF(DAY, e' at line 5

The only options I can think of are:
1) There is indeed an error in the syntax, since it says <= 0 in stead of <= 0, but I have no idea how this happened and how to prevent this ...
2) Something in my system / PHP settings causes this, but again: no idea what that could be, or how to solve it ...

Anyone an idea?

Frank



----------------------------------------------

Cms Version: 1.11.7

Installed Modules:

CMSMailer: 5.2.1
CMSPrinting: 1.0.4
FileManager: 1.4.3
MenuManager: 1.8.5
MicroTiny: 1.2.5
ModuleManager: 1.5.5
News: 2.12.12
Search: 1.7.8
ThemeManager: 1.1.8
ListIt2: 1.4
ListIt2agenda: 1.4


Config Information:

php_memory_limit:
process_whole_template:
max_upload_size: 50000000
url_rewriting: none
page_extension:
query_var: page
image_manipulation_prog: GD
auto_alias_content: true
locale:
default_encoding: utf-8
admin_encoding: utf-8
set_names: true


Php Information:

phpversion: 5.3.3
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
E_DEPRECATED: 8192
memory_limit: 128M
max_execution_time: 30
output_buffering: On
safe_mode: Off (False)
file_uploads: On (True)
post_max_size: 32M
upload_max_filesize: 50M
session_save_path: /tmp (0777)
session_use_cookies: On (True)
xml_function: On (True)
xmlreader_class: On (True)


Server Information:

Server Api: cgi-fcgi
Server Db Type: MySQL (mysqli)
Server Db Version: 4.1.21
Server Db Grants: Found a "GRANT ALL" statement that appears to be suitable


----------------------------------------------

[Stikki]

Your Server DB version is rather low. Try upgrading it to 5.x that should fix it.

So upgrade MySQL.

[frankmanl]

That's the solution: MySQL 5!
Thanks, Stikki.