Radicore Forum: Framework » Importing default values -> enclosed in quotes

Home » RADICORE development » Framework » Importing default values -> enclosed in quotes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing default values -> enclosed in quotes [message #7872]

Fri, 27 September 2024 05:28

htManager
Messages: 433
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.

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7873 is a reply to message #7872]

Sat, 28 September 2024 07:57

AJM
Messages: 2367
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.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7874 is a reply to message #7873]

Wed, 02 October 2024 11:42

htManager
Messages: 433
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.

Attachment: radicore column import.zip
(Size: 78.82KB, Downloaded 36 times)

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7875 is a reply to message #7874]

Fri, 04 October 2024 06:10

AJM
Messages: 2367
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?

Attachment: RADICORE-patch-2024-10-04.zip
(Size: 277.11KB, Downloaded 29 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7876 is a reply to message #7875]

Fri, 04 October 2024 07:38

htManager
Messages: 433
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.

Attachment: radicore concat_ws.jpg
(Size: 639.13KB, Downloaded 102 times)

[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

AJM
Messages: 2367
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.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7879 is a reply to message #7878]

Tue, 12 November 2024 17:24

htManager
Messages: 433
Registered: May 2014

Senior Member

I hope I have uploaded what you need.

Attachment: concat_ws.zip
(Size: 2.85KB, Downloaded 11 times)

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7880 is a reply to message #7879]

Wed, 13 November 2024 05:02

AJM
Messages: 2367
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

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7882 is a reply to message #7880]

Thu, 14 November 2024 05:31

htManager
Messages: 433
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.

Report message to a moderator

Previous Topic:	DropDown Field values - changing in runtime
Next Topic:	Introduction to the Radicore framework

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 21 02:38:27 EST 2024

Total time taken to generate the page: 0.01256 seconds