CodeIgniter Forums
The TEXT type data view failed in CI4 - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Model-View-Controller (https://forum.codeigniter.com/forumdisplay.php?fid=10)
+--- Thread: The TEXT type data view failed in CI4 (/showthread.php?tid=88538)



The TEXT type data view failed in CI4 - nanohe - 09-24-2023

Hello,
I am using CI 4.4.1, this is my code snippet.
And my data type as below in MySQL.


I used findAll() method to show the whole table, there is no response and show only white web page. 
The code worked only when I commented the loginfo line.

I don't know why the TEXT  type data can't be viewed.
Any limitation for TEXT type or table data size in CI 4?

Thank you.
Nano
[Image: 20230925072122.png]

[Image: 20230925072519.png]

PHP Code:
          <tbody>
        <!--      ['companyid','loginfo','logby','date']-->
        <?php if($obj_log): ?>
            <?php foreach($obj_log as $log): ?>
                <tr>
                    <td class="my-nowrap"><?php echo $log['id']; ?></td>
                    <td class="my-nowrap"><?php echo $log['companyid']; ?></td>
<!--                    <td class="my-nowrap">--><?php //echo $log['loginfo']; ?><!--</td>-->
                    <td class="my-nowrap"><?php echo $log['logby']; ?></td>
                    <td class="my-nowrap"><?php echo $log['date']; ?></td>
                </tr>
            <?php endforeach; ?>
        <?php endif; ?>
          </tbody>
        </table> 



RE: The TEXT type data view failed in CI4 - kenjis - 09-24-2023

The data is too big?
Check your CodeIgniter log files.
https://codeigniter4.github.io/CodeIgniter4/installation/troubleshooting.html#codeigniter-error-logs


RE: The TEXT type data view failed in CI4 - nanohe - 09-26-2023

@kenjis Thanks for your advice, I checked the writeable/logs/ and there is no information related this issue. And I duplicated the same issue again. There is no any error log generated too.
I think the logger didn't record this kind of issue. And I agree that is due to the data is too big.
Thank you.


RE: The TEXT type data view failed in CI4 - kenjis - 09-26-2023

If you can see the log files like Apache log in your server, check them.

And set development mode, if it is not a production server.
https://codeigniter4.github.io/CodeIgniter4/installation/running.html#set-to-development-mode


RE: The TEXT type data view failed in CI4 - InsiteFX - 09-27-2023

Good read on MySQL Text Data Types.

MySQLTUTORIAL - The Basics Of MySQL TEXT Data Type