Welcome Guest, Not a member yet? Register   Sign In
The TEXT type data view failed in CI4
#1

(This post was last modified: 09-25-2023, 12:45 AM by ozornick. Edit Reason: Format code )

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> 
Reply
#2

(This post was last modified: 09-24-2023, 05:54 PM by kenjis.)

The data is too big?
Check your CodeIgniter log files.
https://codeigniter4.github.io/CodeIgnit...error-logs
Reply
#3

@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.
Reply
#4

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/CodeIgnit...pment-mode
Reply
#5

Good read on MySQL Text Data Types.

MySQLTUTORIAL - The Basics Of MySQL TEXT Data Type
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply




Theme © iAndrew 2016 - Forum software by © MyBB