Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Framework » Importing default values -> enclosed in quotes
Importing default values -> enclosed in quotes [message #7872] Fri, 27 September 2024 05:28 Go to next message
htManager is currently offline  htManager
Messages: 439
Registered: May 2014
Senior Member
When I import columns in the dictionary, the default values ar enclosed in quotes. Is this a problem with my settings?

For example: field foo_bar, varchar(Cool default value 00:00:00 will be shown in the dictionary as '00:00:00'. This leads to an error in the application because the field length is 10 and this is not entered.
Re: Importing default values -> enclosed in quotes [message #7873 is a reply to message #7872] Sat, 28 September 2024 07:57 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK
Senior Member
Can you give me a copy of your CREATE_TABLE script? I have looked at several examples of columns with default values in my code, such as the created_date and created_user columns on virtuslly every table, and I can see nothing wrong. None of the default values shown in the 2updtae Column" screen are enclosed in quotes.

Re: Importing default values -> enclosed in quotes [message #7874 is a reply to message #7873] Wed, 02 October 2024 11:42 Go to previous messageGo to next message
htManager is currently offline  htManager
Messages: 439
Registered: May 2014
Senior Member
I have inserted the create_table script of my local environment and of my server environment (1) in the zip file. Additionally I inserted a screen shot of the radicore column(list2).php site. The created date value is in quotes, too.
Re: Importing default values -> enclosed in quotes [message #7875 is a reply to message #7874] Fri, 04 October 2024 06:10 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK
Senior Member
I have imported that table definition into my test database and I do not see the problem you have reported. However, I have recently made some changes to my code to remove some deprecation notices that appeared with PHP version 8.3 which I have included in the attached zip file. Can you try these out to see it they solve the issue?

Re: Importing default values -> enclosed in quotes [message #7876 is a reply to message #7875] Fri, 04 October 2024 07:38 Go to previous messageGo to next message
htManager is currently offline  htManager
Messages: 439
Registered: May 2014
Senior Member
Unfortunately the same result. In my local environment I have php 8.2.0 installed and in my server environment 8.2.24.

I also have problems with concat_ws with the following code:

$outer_sql_select .= ", CONCAT_WS(' ', CONCAT_WS(' ', spiele_ma_heim_name, spiele_ma_heim_id), ' - ', CONCAT_WS(' ', spiele_ma_fremd_name, spiele_ma_fremd_id)) AS spiele_gegner";

I got an error message, which I attached.

[Updated on: Fri, 04 October 2024 10:03]

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7878 is a reply to message #7876] Tue, 12 November 2024 10:56 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK
Senior Member
Can you give me a copy of the database scheam which produced this error, plus a copy of the errorlog (the HTML file, not an image) so that I can run it om my PC with my versions of PHP and MySQL.

Re: Importing default values -> enclosed in quotes [message #7879 is a reply to message #7878] Tue, 12 November 2024 17:24 Go to previous messageGo to next message
htManager is currently offline  htManager
Messages: 439
Registered: May 2014
Senior Member
I hope I have uploaded what you need.
Re: Importing default values -> enclosed in quotes [message #7880 is a reply to message #7879] Wed, 13 November 2024 05:02 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK
Senior Member
The generated sql query contains invalid syntax
,' - '--,' / '//,' - '--,
which is why it fails. There is nothing in the RADICORE framework which does this. There must be something in your PHP configuration which does this, such as MAGIC_QUOTES. What version of PHP are tou using? I am currently on 8.3.13


Re: Importing default values -> enclosed in quotes [message #7882 is a reply to message #7880] Thu, 14 November 2024 05:31 Go to previous messageGo to next message
htManager is currently offline  htManager
Messages: 439
Registered: May 2014
Senior Member
I am using 8.2.0 at the moment. I will install 8.3.13 and see if it works.
Re: Importing default values -> enclosed in quotes [message #7891 is a reply to message #7882] Tue, 26 November 2024 06:50 Go to previous messageGo to next message
htManager is currently offline  htManager
Messages: 439
Registered: May 2014
Senior Member
I found the error in my code: I have to enclose the select statement with " and not with '. If I do this, everything works fine.
Re: Importing default values -> enclosed in quotes [message #7892 is a reply to message #7891] Wed, 27 November 2024 03:58 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK
Senior Member
I have been caught out by this on several occasions, but as soon as the error is reported I know how to fix it.

Re: Importing default values -> enclosed in quotes [message #7893 is a reply to message #7892] Wed, 27 November 2024 04:12 Go to previous message
htManager is currently offline  htManager
Messages: 439
Registered: May 2014
Senior Member
I read the documentation of mariadb and I can say the following:

there can either only be "spaces" in the string \'  \' or only other characters! \'(\' both together -> error \' ( \'

If I have a string like ' ( ' then I need to split it in three strings, than it works. \' \', \'(\', \' \',
Previous Topic: DropDown Field values - changing in runtime
Next Topic: Introduction to the Radicore framework
Goto Forum:
  


Current Time: Sun Dec 01 01:35:54 EST 2024

Total time taken to generate the page: 0.01355 seconds