Question: Problem In Listing - All

Problem In Listing - All

If I hit List, whether is List Users, List Product, all the data are not showed. This happens with List Users, List Products, etc

SB

Seth Bourne

Asked
If I hit List, whether is List Users, List Product, all the data are not showed.
This happens with List Users, List Products, etc
Attachments
  • MS

    Mian Saleem

    Answered
    Hello,

    Please check your server's php error logs and let me know the error details so that I can suggest.

    Just a though, try to increase the `memory_limit` and see.

    Thank you
  • SB

    Seth Bourne

    Answered
    i dont get it.. i checked, and sma_sessions is there, and data is available.

    ERROR - 2021-10-15 11:01:59 --> Query error: Table 'inven.sma_sessions' doesn't exist - Invalid query: SELECT `data`
    FROM `sma_sessions`
    WHERE `id` = '17mcddq5rt37tl1hgnmj940u81j75p7p'
    ERROR - 2021-10-15 11:01:59 --> Query error: Table 'inven.sma_settings' doesn't exist - Invalid query: SELECT *
    FROM `sma_settings`
    ERROR - 2021-10-15 11:01:59 --> Severity: error --> Exception: Call to a member function num_rows() on bool /var/www/inven/app/models/Site.php 305
    ERROR - 2021-10-15 11:01:59 --> Query error: Table 'inven.sma_sessions' doesn't exist - Invalid query: INSERT INTO `sma_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('17mcddq5rt37tl1hgnmj940u81j75p7p', '192.168.8.5', 1634292119, '__ci_last_regenerate|i:1634292119;')
    ERROR - 2021-10-15 11:01:59 --> Severity: Warning --> session_write_close(): Failed to write session data using user defined save handler. (session.save_path: /var/lib/php/sessions) Unknown 0
    ERROR - 2021-10-15 11:02:01 --> Query error: Table 'inven.sma_sessions' doesn't exist - Invalid query: SELECT 1
    FROM `sma_sessions`
    WHERE `id` = '17mcddq5rt37tl1hgnmj940u81j75p7p'
    ERROR - 2021-10-15 11:02:01 --> Query error: Table 'inven.sma_sessions' doesn't exist - Invalid query: SELECT `data`
    FROM `sma_sessions`
    WHERE `id` = '17mcddq5rt37tl1hgnmj940u81j75p7p'
    ERROR - 2021-10-15 11:02:01 --> Query error: Table 'inven.sma_sessions' doesn't exist - Invalid query: INSERT INTO `sma_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('17mcddq5rt37tl1hgnmj940u81j75p7p', '192.168.8.5', 1634292121, '__ci_last_regenerate|i:1634292121;error|s:128:\"<h4>404 Not Found!</h4><p>The page you are looking for can not be found.</p>http://inven.bit-clicks.com/install/index.php?step=3\";__ci_vars|a:1:{s:5:\"error\";s:3:\"new\";}')
    ERROR - 2021-10-15 11:02:01 --> Severity: Warning --> session_write_close(): Failed to write session data using user defined save handler. (session.save_path: /var/lib/php/sessions) Unknown 0
    ERROR - 2021-10-15 11:02:01 --> Query error: Table 'inven.sma_sessions' doesn't exist - Invalid query: SELECT 1
    FROM `sma_sessions`
    WHERE `id` = '17mcddq5rt37tl1hgnmj940u81j75p7p'
    ERROR - 2021-10-15 11:02:01 --> Query error: Table 'inven.sma_sessions' doesn't exist - Invalid query: SELECT `data`
    FROM `sma_sessions`
    WHERE `id` = '17mcddq5rt37tl1hgnmj940u81j75p7p'
    ERROR - 2021-10-15 11:02:01 --> Query error: Table 'inven.sma_settings' doesn't exist - Invalid query: SELECT *
    FROM `sma_settings`
    ERROR - 2021-10-15 11:02:01 --> Severity: error --> Exception: Call to a member function num_rows() on bool /var/www/inven/app/models/Site.php 305
    ERROR - 2021-10-15 11:02:01 --> Query error: Table 'inven.sma_sessions' doesn't exist - Invalid query: INSERT INTO `sma_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('17mcddq5rt37tl1hgnmj940u81j75p7p', '192.168.8.5', 1634292121, '__ci_last_regenerate|i:1634292121;')
    ERROR - 2021-10-15 11:02:01 --> Severity: Warning --> session_write_close(): Failed to write session data using user defined save handler. (session.save_path: /var/lib/php/sessions) Unknown 0
  • SB

    Seth Bourne

    Answered
    **[Mian Saleem](/u/saleem)** where to check php error logs ?
  • MS

    Mian Saleem

    Answered
    Hello,

    This error seems to be logged before the installation.

    Please change `log_threshold` to 1 in `app/config/config.php` and then try to load the listing pages again. Lastly check the latest log file in the `app/logs/` folder.

    Thank you
  • MS

    Mian Saleem

    Answered
    Hello,

    For server's php error logs, you need to check with your server admin. Please try my previous comment and see if there are any app errors in app logs.

    Thank you
  • SB

    Seth Bourne

    Answered
    <?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "username"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "password"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "first_name"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "last_name"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "username"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "email"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "phone"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "company"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "gender"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "password"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "confirm_password"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "first_name"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "last_name"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "username"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "email"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "phone"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "company"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "gender"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "product_code"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "product_name"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "cname"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "barcode_symbology"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "product_unit"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "product_price"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "contact_person"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "company"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "email_address"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "address"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "city"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "phone"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "first_name"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "last_name"
    ERROR - 2021-10-20 19:25:36 --> Could not find the language line "email"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "username"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "password"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "first_name"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "last_name"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "username"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "email"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "phone"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "company"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "gender"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "password"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "confirm_password"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "first_name"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "last_name"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "username"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "email"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "phone"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "company"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "gender"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "product_code"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "product_name"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "cname"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "barcode_symbology"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "product_unit"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "product_price"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "contact_person"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "company"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "email_address"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "address"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "city"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "phone"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "first_name"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "last_name"
    ERROR - 2021-10-20 19:39:23 --> Could not find the language line "email"
    ERROR - 2021-10-20 19:51:04 --> Severity: Core Warning --> Module 'iconv' already loaded Unknown 0
    ERROR - 2021-10-20 19:51:10 --> Severity: Warning --> Invalid argument supplied for foreach() /var/www/inven/themes/default/admin/views/products/add.php 133
    ERROR - 2021-10-20 19:51:10 --> Severity: Warning --> Invalid argument supplied for foreach() /var/www/inven/themes/default/admin/views/products/add.php 160
    ERROR - 2021-10-20 19:51:10 --> Severity: Core Warning --> Module 'iconv' already loaded Unknown 0
    ERROR - 2021-10-20 19:51:12 --> Severity: Core Warning --> Module 'iconv' already loaded Unknown 0
    ERROR - 2021-10-20 19:51:52 --> Severity: Core Warning --> Module 'iconv' already loaded Unknown 0
    ERROR - 2021-10-20 19:54:03 --> Severity: Core Warning --> Module 'iconv' already loaded Unknown 0
  • MS

    Mian Saleem

    Answered
    Hello,

    There is nothing in the log about the issue you are facing.

    Please let me know the site link with owner account details in private reply, I will try to check.

    Thank you
  • SB

    Seth Bourne

    Answered
    **[Mian Saleem](/u/saleem)** any luck ?
  • MS

    Mian Saleem

    Answered
    Hello,

    I have checked. The response for ajax call to load table data is not json but encoded and wrapped in html. I suggest reinstall the item, if still same check with your server admin about this behavior.

    Thank you
  • SB

    Seth Bourne

    Answered
    great.. thanks... solved the problem.. thank you.
  • Login to Reply
We use cookies, by continuing to browse the site you are agreeing to our use of cookies. Read more