Questions tagged [mysql]

MySQL is a database system used by many websites on the Internet. Joomla is based on PHP and MySQL.

18 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
27 views

How to use Joomla's query building methods to generate a query containing joined subqueries?

I am trying to write a query using Joomla's query building methods, but I cannot manage to write the subquery into the query. Here is my desired raw sql with php variables: "SELECT track_type, ...
1
vote
0answers
32 views

Want to dynamically create users via database, how do I encrypt password?

I'm handling two websites a main one with a huge database and a secondary one, I want that when a user is created in the main one that it also creates it for the secondary one, I already connected the ...
1
vote
0answers
73 views

How to count total queries with limit for pagination in Joomla getDbo

I am trying to build an author page with the lists of your articles in com_contact (this option exists but it cannot paginate). I need it to be paginated. So I am creating arbitrarily without ...
1
vote
1answer
194 views

Delete query and left join with JDatabaseQuery doesn't work

I'm trying to convert a delete query with left join to use JDatabaseQuery, but I am encountering an issue in the query. The query that I'm trying to convert and which works is the following : $db->...
1
vote
2answers
383 views

UPDATE query to add 1 to multiple columns

I have a website for my football team. I have some statistics and so on in there, for example how many games each player has played and so on. What I would like, is for me to write in the names of ...
0
votes
2answers
50 views

Run model function in view file to insert default value into sql

I am new to Joomla and received a half-done component. It is a mostly database-dependent component. The component consists of a SQL file that inserts all the data and is able to display it. I am ...
0
votes
0answers
20 views

1146 Error when creating custom table

I have created a secondary user table to store other information in the Joomla database. However, when I try to insert information into that table, I get this error. 1146 Table 'database.#__vvuser' ...
0
votes
0answers
7 views

K2 can't search number from Database table Field

I can contact his to K2 but they can't help me to much... My problem Drop-down Selection of K2, I created them. 5 Years Old 6 Years Old 7 Years Old 8 Years Old 9 Years Old If I search "5 Ye",...
0
votes
1answer
42 views

Logged in users not logged into Kunena on second site

I have 2 sites, let's call them site1 and site2. They're setup as subdomains such as: site1.domain.com and site2.domain.com They're both running Joomla 3.9.24 and I have created a view on site2 ...
0
votes
1answer
40 views

Joomla Dev site accepting only prod credentials and directing to Prod site after replicating the Prod db dump to Dev DB

I have exported the Joomla DB dump from Production application and imported the same production sql dump file to my development environment. Now when i launch the development site then it logs me in ...
0
votes
0answers
62 views

Code works properly but shows data for all users

I am using the latest RS Form Pro with Joomla 3.9, Platform 13.1.0. My code is working properly (thank you guys!) But the data should be limited to each user. The user ID is is not in the table ...
0
votes
2answers
83 views

Jooma Article content to load from mysql based on ID in url?

On my old website, built in php i had a link on a page, wich picked an ID based on what line it was. <td width=124><a href="tp/package.php?ID=<?php echo $row[0];?>">Package</a>...
0
votes
0answers
336 views

Joomla 3.9.13 - Error: Failed to start application

I just installed version 3.9 joomla in local using xampp. Once the installation was finished correctly I tried to navigate the site and the backend. After loading a few pages, this annoying error ...
0
votes
0answers
36 views

Joomla! extensions table is not unique

The Joomla! extensions table is not editable in PHPMyAdmin. I believe there are non-unique values there too, so it cannot have an index. This is wreaking havoc with my install, I can't add any new ...
0
votes
2answers
134 views

Custom Component - Copy / Archive record when values change

For a custom component, I want to incorporate a way of keeping track of changes made to records in specific tables. For example, when the mileage value of a car is changed, the record having the old ...
0
votes
0answers
4k views

Error: Out of sort memory, consider increasing server sort buffer size

I have upgraded the joomla website to 3.5.1 and the module manager is showing error: Out of sort memory, consider increasing server sort buffer size SQL= SELECT a.id, a.title, a.note, a....
0
votes
1answer
156 views

Convert from MySQL query using SUBSTRING_INDEX into Joomla API query?

I have a query which gets the information that I want using SUBSTRING_INDEX in MySQL. I am trying to convert this to use the Joomla query building syntax, but I am not sure how it should be formatted? ...
0
votes
0answers
96 views

Joomla 1.5 creating or editing back end user

I have a website in joomla , the problem is that when i am creating new back end user (administrator/super user) from joomla user manager it makes an entry in the users table after that it deleted it ...