How to solve /opt/lampp/bin/mysql.server: line 261: log_success_msg: command not found

After installing xampp in my linuxmanjaro, I encountered this error. Previously, even with this error, it worked fine the first time I opened phpmyadmin and executed some queries. But somehow phpmyadmin shows blank screen. How can I solve it? Update: The black screen no longer appears, but the warni...

P粉056618053 2023-11-08 08:46:06 0  1  1050

MYSQL SEARCH WHERE VALUE matches comma separated string

I have a field PROPERTY_TYPE in my table Property_types which contains a single value such as Residential, Business or Office. When running the query select*fromproperty_typeswherepropertytypelike'%Residential,office%' gets all properties but returns nothing. How should I rewrite the query to select...

P粉155551728 2024-02-21 21:27:02 0  1  363

How to animate height with transform without squeezing content

In my project, I've been using jQueryslideUp() to slide elements up in a 200-item list when the user clicks a button. However, CSS height animations are known to require reflow, resulting in unstable animations. The animation is an integral part of the application and I'm willing to do a lot of work...

P粉208469050 2024-01-01 11:51:20 0  1  430

CSS styles were not successfully applied to Flickity

Fairly simple question, I think it might be related to this issue, but in Vue instead of Angular. The CSS styles I'm trying to apply to my Flickity carousel are not rendering in my Vue3 application. In the IDE the styles are grayed out, but when I edit them in the browser via inspection (e.g. changi...

P粉412533525 2023-08-26 20:25:09 0  1  605

Best Practice: How to attach components to the DOM in Vue 3

I want to dynamically create a component in my Vue3 application, inside a Single File Component (SFC), and append it to the DOM. I'm using a <scriptsetup> style component and that's another question. This seems unnecessarily difficult. Here's roughly what I want to do: get some data. H...

P粉362071992 2023-08-24 19:51:03 0  2  597

Html code automatically fixed on staging but not on production

I have a website built on Hugo and while implementing new functionality I made a mistake by improperly closing the tag. Strangely, this bug didn't show up in the staging environment, the markup was fixed for users in different browsers and countries (automatically fixed by the browser I think). Howe...

P粉464113078 2023-09-15 22:46:29 0  1  1059

Enhance table functionality with sorting, filtering and paging components in Vue.js 3.

I've been researching for a while but can't seem to find a recent component for Vue.js 3 that can add sorting, filtering and pagination functionality to tables. The frontend already has all the data and no additional requests to the backend API are required. What I've seen so far is either outdated,...

P粉419164700 2023-08-03 20:02:22 0  1  633

Can PHP directly call functions in a class without using new?

I have to do something new every time, which is very unaccustomed. Can I use the functions in the class directly? The purpose of using the class is to look at the static attributes inside, so that when operating redis or mysql, automatic connection and connection reuse can be realized without the ne...

只争朝夕 2022-12-23 12:12:24 0  1  1956

Move a varchar column containing CSV format to another table

The database I created 15 years ago was poorly designed. I have a varchar column containing comma separated strings: '5,8,13'. The string does not contain spaces and trailing commas, but the number of values ​​is variable. What I want to do is create a new table and move these values ​​paired with t...

P粉478188786 2023-09-10 19:59:25 0  1  514

Safe way to update mysql table entries using dictionary in python (prevent SQL injection)

I'm writing a helper function for my web application that updates the database based on some information obtained from an external API (not user input). I have the following code, but it is marked as "unsafe" by the Banditpython package. Ideally I could write a function in a way that hardc...

P粉627427202 2023-09-08 20:06:07 0  1  691

The employment dilemma faced by high school students who learn PHP by themselves

I only have a high school education, and as a fresh graduate I have been doing backbreaking physical labor. Later, I felt unwilling to accept it and went to a training institution to study. However, after two-thirds of the study, I couldn't persist due to financial reasons (I was really helpless at ...

..... 2018-04-28 23:55:37 5  61  8926

Ways to fix issue 2003 (HY000): Unable to connect to MySQL server 'db_mysql:3306' (111)

I recently tried to containerize my FastAPIPython server (also for replication/doubling purposes). Before, I had just a MySQL server in a Docker container and everything was fine, but when I also made my web server a service, it couldn't connect to the MySQL server, so now the application doesn't wo...

P粉178132828 2023-09-05 11:18:47 0  1  767

Experiment with sorting after query limit

So this is my first question here, please forgive me if something is wrong. I'm trying to make a sort query based on constraints. So there is a Customers table with 90 records. I want to first perform a query limited to 3 records, and then sort the results of this query by a column called ContactNam...

P粉237125700 2023-09-05 14:46:42 0  1  699

CSS Grid: Create new row when child content overflows column width

I have a two column layout based on CSS grid. When the content of the second column exceeds 1fr I want to create a new row. As it currently stands, the content simply overflows the column. One requirement of this layout is that the items in the right menu column are in one row. I achieve this with: ...

P粉212114661 2023-09-05 15:18:28 0  1  591

PHP full text search functionality using AND, OR and NOT operators

Newbie question: I'm trying to implement a full text search on a search string using php and eloquent. $searchstring="+(victimsuspect)+crime-covid";$searchresult=RssItem::whereRaw("MATCH(description)AGAINST('$searchstring'INBOOLEANMODE)")->ge

P粉076987386 2023-09-05 15:06:32 0  1  551

Shortest way to convert all PHP types to string

I'm writing a general system that I hope can one day be applied to fields like medicine (i.e. it's "scientific"). I think the best way is to represent all the data in php with strings (true will be "true", false will be "false" and so on). The reason for this is that in...

P粉369196603 2023-09-05 15:34:44 0  1  978

How to get average of DATETIME column in MySQL while grouping by other columns

I'm creating and populating a MySQL table using the following query: SETtime_zone='+00:00';CREATETABLEtimestamp_n_datetime(idINT,timeDATETIME,avg_timeDATETIME);INSERTINTOtimestamp_n_datetime(id,time,avg_time)VALUES("1","2023-01-0310:

P粉460377540 2023-09-05 11:46:21 0  1  495

Multi-device (mobile phone) synchronization - React Native

I'm trying to create a Lightshow that will launch on all users' mobile devices at the same time (can have up to 2000-3000 users). All users will use the Internet (Wi-Fi or mobile data). In our FE we use Apollo for subscriptions and it works like a charm. But the problem is, user A can get subscribed...

P粉151466081 2023-09-05 11:58:38 0  1  682