SQL-errors after clicking a table field

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
User avatar
RonP
Veteran Member
Posts: 219
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

SQL-errors after clicking a table field

Post by RonP » 2014-07-19 11:17

Hi,
A very strange thing happens in version 5.30 rev628.
I've a very simple table: Rollen
Fields:
  • ID: Int --> Auto inc
    Rol: varchar
    Mut.date: timestamp
    Mutator: varchar
    Creator: varchar
    Create.date: timestamp
The table has 12 records, all displayed well in MySql AND in "rollen_view.php"

However, whenever I click on de column: Rol the message
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 'from `rollen` where `Id`='16'' at line 1"
appears.
I don't get it with the other 12 tables I have.

Falling back to Version 5.22 it works well.

What goes wrong?
Rol_00.PNG
PhpMyAdmin
Rol_00.PNG (20.13 KiB) Viewed 9079 times
Rol_01.PNG
Defined in AppGini
Rol_01.PNG (251.51 KiB) Viewed 9079 times
Rol_02.PNG
Field Rol
Rol_02.PNG (33.73 KiB) Viewed 9079 times
Rol_03.PNG
Table Rollen in Browser
Rol_03.PNG (80.79 KiB) Viewed 9079 times
Rol_04.PNG
Error message
Rol_04.PNG (33.65 KiB) Viewed 9079 times

User avatar
RonP
Veteran Member
Posts: 219
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: SQL-errors after clicking a table field

Post by RonP » 2014-08-01 13:42

Hi There,

Some help would be fine :)

Ron

udayvatturi
AppGini Super Hero
AppGini Super Hero
Posts: 85
Joined: 2014-06-14 03:08
Location: India
Contact:

Re: SQL-errors after clicking a table field

Post by udayvatturi » 2014-08-07 05:02

Hi,
I see and extra ' (inverted comma) near the ID, that is what is creating an issue. i think

User avatar
RonP
Veteran Member
Posts: 219
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: SQL-errors after clicking a table field

Post by RonP » 2014-08-07 11:56

Hallo Uday Vatturi

Thanks for your answer.
But then should this be a "bug"!. In all the other tables at works well, why not in this simple table?
Moreover.... How can I fix it without having a change that it reoccurs?

Ron

User avatar
RonP
Veteran Member
Posts: 219
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: SQL-errors after clicking a table field

Post by RonP » 2014-10-16 13:46

Hi,

Uday helped me out this day, He is solving an other "problem" for me and found out, for this post, that in file:
rollen_dmp.php
on line 223 the statement:

Code: Select all

$row['Creatiedatum']=sqlValue("select  from `rollen` where `Id`='".makeSafe($selected_id)."'");
has to be replace by:

Code: Select all

$row['Creatiedatum']=sqlValue("select  Creatiedatum from `rollen` where `Id`='".makeSafe($selected_id)."'"); // replaced by Uday 16-10-2014 //
I think this is strange, I've never made any alteration so is this a BUG? :?

Uday, Thank you so much! :D

The error is, however, reproducable, so it looks like a BUG :!:

User avatar
a.gneady
Site Admin
Posts: 1281
Joined: 2012-09-27 14:46
Contact:

Re: SQL-errors after clicking a table field

Post by a.gneady » 2014-10-18 06:29

Hi Ron,

I'll try to investigate this issue and fix it in the next release. Could you kindly send me the axp project file please? You may send it via a support request at http://bigprof.com/appgini/support-request
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

User avatar
RonP
Veteran Member
Posts: 219
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: SQL-errors after clicking a table field

Post by RonP » 2014-10-18 14:52

Hi a.gneady,

I've just send the .APX file.
Good luck

Ron

Stevo2112
Posts: 10
Joined: 2015-01-14 15:05

Re: SQL-errors after clicking a table field

Post by Stevo2112 » 2015-01-16 13:50

I am also having a similar problem. I have a hook that works in one table but returns a sql error when used in another table to do exactly the same thing, version 5.31

User avatar
RonP
Veteran Member
Posts: 219
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: SQL-errors after clicking a table field

Post by RonP » 2015-01-20 18:21

Indeed, problem still occurs.
Will it be solved in V5.32?

Ron

User avatar
a.gneady
Site Admin
Posts: 1281
Joined: 2012-09-27 14:46
Contact:

Re: SQL-errors after clicking a table field

Post by a.gneady » 2015-01-23 21:36

Yes, it's planned for fixing in 5.32.
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

User avatar
RonP
Veteran Member
Posts: 219
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: SQL-errors after clicking a table field

Post by RonP » 2015-01-24 09:36

Thanks for your answer I'll wait

Ron

User avatar
RonP
Veteran Member
Posts: 219
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: SQL-errors after clicking a table field

Post by RonP » 2018-02-20 16:28

Hi There,
After some time I'm back again with the SAME "bug", same table.
The strange thing is that this table is hardly updated on any record.
Yesterday I need to add a new record and the error was back.
I'm using Appgini V5.50. rev. 835
So somewhere in time the solution has been lost ?

I have made the same solution that Uday brought to me.
Question:
How did this bug came back??
Ron

User avatar
a.gneady
Site Admin
Posts: 1281
Joined: 2012-09-27 14:46
Contact:

Re: SQL-errors after clicking a table field

Post by a.gneady » 2018-02-28 12:10

Hello Ron,

Not sure if this bug appears in the current version of AppGini (5.70) or not as I don't have your AXP to test it ... however, since you're using an older version, would you please send me the generated file having the bug to check it and send you a correction? Either zip the file and attach it here, or through a support request form the site at https://bigprof.com/appgini/support-request
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

Post Reply