search

ridwanskaterock / cicool

Cicool is a multifunctional application that is used to facilitate your work in creating a system, CMS, E-Comerce and others
20 stars 13 forks source link

Unable to see CRUD #530

Closed stokes84 closed 2 years ago

stokes84 commented 2 years ago

I'm currently unable to "see" new CRUD after creating the database then creating the CRUD.

This error does not occur if I utilize an existing table to generate the CRUD such as chat.

A Database Error Occurred Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DESC LIMIT 10' at line 4

SELECT test_db.* FROM test_db WHERE (test_db.asdf LIKE '%%' OR test_db.sdfg LIKE '%%' OR test_db.dfgh LIKE '%%' OR test_db.fghj LIKE '%%' OR test_db.ghjk LIKE '%%' ) ORDER BY test_db. DESC LIMIT 10

Filename: /var/www/vhosts/redacted.com/httpdocs/data/modules/test_db/models/Model_test_db.php

Line Number: 96

ridwanskaterock commented 2 years ago

Hello have you table field set for primarykey ? Thanks

Pada tanggal Min, 20 Nov 2022 08.07, Chris Stokes @.***> menulis:

I'm currently unable to "see" new CRUD after creating the database then creating the CRUD.

This error does not occur if I utilize an existing table to generate the CRUD such as chat.

A Database Error Occurred Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DESC LIMIT 10' at line 4

SELECT test_db.* FROM test_db WHERE (test_db.asdf LIKE '%%' OR test_db. sdfg LIKE '%%' OR test_db.dfgh LIKE '%%' OR test_db.fghj LIKE '%%' OR test_db.ghjk LIKE '%%' ) ORDER BY test_db. DESC LIMIT 10

Filename: /var/www/vhosts/ redacted.com/httpdocs/data/modules/test_db/models/Model_test_db.php

Line Number: 96

— Reply to this email directly, view it on GitHub https://github.com/ridwanskaterock/cicool/issues/530, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACGXJLJOJYH5QVLWQW45IILWJF2WFANCNFSM6AAAAAASFSTFFE . You are receiving this because you are subscribed to this thread.Message ID: @.***>

stokes84 commented 2 years ago

Hello have you table field set for primarykey ? Thanks Pada tanggal Min, 20 Nov 2022 08.07

Set and fixed, thanks!