Page 1 of 1
SQL-errors after clicking a table field
Posted: 2014-07-19 11:17
by RonP
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?
- PhpMyAdmin
- Rol_00.PNG (20.13 KiB) Viewed 10543 times
- Defined in AppGini
- Rol_01.PNG (251.51 KiB) Viewed 10543 times
- Field Rol
- Rol_02.PNG (33.73 KiB) Viewed 10543 times
- Table Rollen in Browser
- Rol_03.PNG (80.79 KiB) Viewed 10543 times
- Error message
- Rol_04.PNG (33.65 KiB) Viewed 10543 times
Re: SQL-errors after clicking a table field
Posted: 2014-08-01 13:42
by RonP
Hi There,
Some help would be fine
Ron
Re: SQL-errors after clicking a table field
Posted: 2014-08-07 05:02
by udayvatturi
Hi,
I see and extra ' (inverted comma) near the ID, that is what is creating an issue. i think
Re: SQL-errors after clicking a table field
Posted: 2014-08-07 11:56
by RonP
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
Re: SQL-errors after clicking a table field
Posted: 2014-10-16 13:46
by RonP
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!
The error is, however, reproducable, so it looks like a
BUG 
Re: SQL-errors after clicking a table field
Posted: 2014-10-18 06:29
by a.gneady
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
Re: SQL-errors after clicking a table field
Posted: 2014-10-18 14:52
by RonP
Hi a.gneady,
I've just send the .APX file.
Good luck
Ron
Re: SQL-errors after clicking a table field
Posted: 2015-01-16 13:50
by Stevo2112
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
Re: SQL-errors after clicking a table field
Posted: 2015-01-20 18:21
by RonP
Indeed, problem still occurs.
Will it be solved in V5.32?
Ron
Re: SQL-errors after clicking a table field
Posted: 2015-01-23 21:36
by a.gneady
Yes, it's planned for fixing in 5.32.
Re: SQL-errors after clicking a table field
Posted: 2015-01-24 09:36
by RonP
Thanks for your answer I'll wait
Ron
Re: SQL-errors after clicking a table field
Posted: 2018-02-20 16:28
by RonP
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
Re: SQL-errors after clicking a table field
Posted: 2018-02-28 12:10
by a.gneady
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