Questions tagged [sql]
Structured Query Language (SQL) is a language for querying databases.
0
votes
0answers
35 views
How to construct a JOIN query with Joomla's query methods?
I'm really new to SQL queries but now stuck with this one.
I need the first and last name of a user
from table #__comprofiler
where their cb_job_role = 'Team Leader' and their cb_service_name = [the ...
2
votes
2answers
45 views
How to query certain rows from a table based on other associated rows in the same table?
I'm trying to query my jos_rsform_submission_values table for FieldValue data in rows with a FieldName of Container# which shares a SubmissionId with another row where the FieldValue is "Pending" and ...
2
votes
3answers
41 views
Confusion about using two select() method calls in one query
I am using Joomla's JDatabaseQuery methods to select some columns from two joined tables, but I don't understand something about the following snippet.
//Initialize variables.
$db = JFactory::getDbo()...
1
vote
1answer
32 views
Delete row from custom made SQL when deleting article in Joomla
I´m still new to Joomla and to coding SQL.
I was thinking about how I should manage a big system I made with information that is saved in a sql table, that contains some user input and the "id" of an ...
0
votes
3answers
65 views
Convert PHP code to Jooma PHP syntax?
I'm running a query on phpmyadmin which has the "IN" function included. It is to extract data from the same column for different fields' (Waybill1, Waybill2 etc.)
I shall post the SQL query below:
...
2
votes
2answers
42 views
What does sql_select=“e.*” do?
On https://docs.joomla.org/SQL_form_field_type it talks about using the SQL fields.
I'm wondering what sql_select="e.*" does.
I know that the star is a wildcard for everything. I'm just not sure ...
1
vote
2answers
36 views
How to re-write sql for joomla JDatabase
I am new to custom Joomla coding so excuse me for this, I want to execute the following statement:
"SELECT
MAX(CASE WHEN v.FieldName = 'Team_Name' THEN v.FieldValue END) 'Team_Name'
, MAX(...
2
votes
1answer
40 views
Joomla Migrating Live Site To Localhost -Navigation Not Working
I just migrated a Joomla site from live to localhost. Have the front end up and can access the backend without problem.
Front end wise none of the menu items work.
I have renamed the live site ...
1
vote
1answer
98 views
Error when populating a database table while installing a module
I am using the following code for creating tables in my .sql file as part of a module.
CREATE TABLE IF NOT EXISTS `#__gruposlocales` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(...
1
vote
1answer
47 views
How to select records one by one using JDatabaseQuery
In programming languages there are 2 patterns for selecting records from the database:
//prepare SELECT statement
while($record = $query->fetchRow())
{
//do the job
}
And the second:
//...
1
vote
1answer
46 views
Join two similar table SQL [on hold]
In database it shows:
-Table 1 data show discount_category_id as: 1 2 3
-Table 2 data show category_id as: ,1, ,2, ,3,
So is anything wrong or any syntax error with my code because i tried print_r ...
1
vote
2answers
61 views
Rewriting code as per Joomla guide, but page showing 404 error
I am rewriting some old code according to the latest reference,
although the page description is coming out correctly in the old code.
But when rewritten into new code, the page is redirecting to ...
0
votes
1answer
97 views
Join two list views without a shared key
I have a front end list view for a table called #_students and a separate front end list view for a table called #_sessions. The two tables have no shared foreign key and the two data sets are ...
0
votes
1answer
146 views
Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
I am trying to install joomla 3.7.5. I am facing an Error message:
Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
The table '#...
1
vote
1answer
201 views
Retrieve article URL from phpMyAdmin
I am migrating a site from Joomla to WordPress. The migration tool didn't setup redirects for the old urls so I'm planning to write something to do them for me. I need a way to output all the current ...
-1
votes
1answer
38 views
add text after value that is retrieving from SQL in php [closed]
This is the code that i retrieve data from sql in this case ¨Km¨ is added before value but i will ¨Km¨ after value ..
example :
now is like this : Km 129.000
but i will 129.000 km
$insert1 =" /// ...
-1
votes
1answer
40 views
Component - Site Model Question
I've been developing a Real Estate component for several of my clients. I have most everything working, except getting images from a separate table.
One example of a site model is City. Within the ...
2
votes
1answer
97 views
Run Stored Procedure From Page Load
I have a html table that has a hyperlink in it, when the hyperlink is pressed 3 parameters are passed to a secondary page. The query that is run is a CTE SQL Server statement, and from my ...
2
votes
2answers
113 views
Transfer Joomla data from PHPMyAdmin SQL Dump
My friend's web page was created with Joomla (c. 2013), and she wants to transfer her site to a new host. Her current host sent her a SQL Dump generated by PHPMyAdmin, which contains what I assume is ...
1
vote
1answer
64 views
Adding a stand alone php (with sql queries built using mysql phpgenerator) to existing Joomla application
I am totally new to Joomla development in specific but have done good old prog days (C, Oracle, Sybase etc). So i use a Library software in Joomla and do all the installation, admin etc thing.. i want ...
0
votes
1answer
206 views
Joomla 3x sql field NOT Filtering on Change
I am using Joomla 3x sql field to filter between two select fields..
The problem is that the second field does not filter as expected. It is just populated with all the result and when I select a ...
0
votes
1answer
112 views
Dynamic component SQL parameter type
I'm looking to add a Component field which will display a list of Joomla users who have a relationship with current the Component item.
Below is some sample XML where by I would like [current ...
5
votes
1answer
198 views
Joomla 3.6 How to migrate data from repeatable to subform
The new field type subform does not retrieve old data repeatable, even fields have the same names.
I created many posts with repeatable. The data are stored in extra fields of com_conent. attribs ...
1
vote
4answers
9k views
The MySQL adapter mysqli is not available - how to resolve this issue?
My website www.EliteMaths.com.au has been active until early this week. When I tried to access it this morning I got the following error message:
Error displaying the error page: Application ...
1
vote
0answers
139 views
Mapping “asset_id” and “ordering” fields of joomla content table using RSform pro mapping feature
I am creating articles in Joomla 3.5.1 using the mapping feature in RSForm Pro 1.5.14 (senting field values on joomla table _content) . The only fields that I can't map correctly are asset_id and ...
0
votes
1answer
258 views
Copy user data into custom table on user registration
upon creating a user in joomla i would need fields copied from jmla_users table to another jmla_new_users.
jml_users - jmla_new_users
with the following fields, (username,firstname,lastname,email)
...
0
votes
2answers
327 views
Joomla 3.4.8 Component SQL Update Not Working
As the title says I'm using joomla 3.4.8 I'm trying to customize the system component "com_content" what I want to do is to add an another columns on the '#__content" table in the database but the ...
0
votes
1answer
153 views
joomla 2.5 / K2 - SQL Query to delete trashed items taking care of data integrity
I have not a testing environment where put this to the test:
delete from k2_items where trash = 1
Of course this will remove everything that is marked as trash, but is there any other table that has ...
1
vote
2answers
154 views
getting some sql error
I have recently restored my joomla website and it was working perfectly fine, but suddenly I am receiving the following error:
1064 : You have an error in your SQL syntax; check the manual that ...
4
votes
3answers
559 views
How to rewrite SQL-query with CASE/WHEN to Joomla-based “format”
I have the following SQL-query to database:
$jinput = JFactory::getApplication()->input;
$category_id = $jinput->get('virtuemart_category_id');
$db = JFactory::getDBO();
$query = $db->...
0
votes
2answers
88 views
Do I need a custom field for a db field alias?
When viewing an individual record, I'm using a calculated field from a sql query to display as a read only field in my form. However I'm unable to get it to display (no error, just blank). Curious, do ...
0
votes
1answer
383 views
Update all rows primary key columnin a table - Joomla 3.4.8
I have a temp table created with a list of "master tasks". These need to be duplicated so they can be assigned to users as needed. The problem I have is the table column 'id' is a primary key set to ...
4
votes
4answers
542 views
How to only transfer new column values from one table to another?
I'm attempting to create a new table: _clients that will be simply populated with, for now, with the user_id column from #__user_usergroup_map.
Ideally, the below code should pull all id's from #...
1
vote
3answers
36 views
Trying to set up new joomla from old joomla files
So basically my Joomla site was attacked a few weeks ago by SQL injection and was taken down.
What I am hoping to do, is to go into the file manager and download all of my articles, categories, ...
1
vote
2answers
542 views
After Joomla update duplicate or create new module get id : 0
Joomla is updated to 3.3 and create of a new module or duplicate existing module with no success.
Its possible to create a new, or duplicate modules but module id is 0 for each new module I create, ...
4
votes
3answers
2k views
How can I get the names of the columns in an object or table with Joomla's SQL?
With the existing output I have from a basic query, what would be the best way to get the names of the columns in the resultant output object without having to run an additional COLUMNS query on the ...
3
votes
2answers
542 views
JDatabase JOIN on multiple values
What is the JDatabase syntax for a JOIN statement that joins two tables on a variable that is either equal to x or is null? Eg it joins on multiple values.
I have found some examples that show me you ...
0
votes
2answers
580 views
Get current language and DB Query to select content by language
I'm trying to select data from content table in Joomla (3.4) filtered by language field. When I pass a value, it doesn't change in the SQL statement
Here is my code:
public function articlesar()
{
...
1
vote
0answers
224 views
Achieve k2 item SEF URLS
I am working on Joomla! and I am trying to retrieve the sef URL of k2 item. I try to make it outside of the k2 on other component. So I have right on function, it makes a sef URL with the item but ...
3
votes
4answers
2k views
How to write my MySQL query with JOIN logic using JDatabase methods?
I'm having a difficult time translating this SQL script to JDatabase methods because I can't find the AND query method.
SELECT user.firstname, user.lastname, leadership.leadname, leadership.lead_des
...
1
vote
2answers
1k views
Retrieving multiple results from the database
I don't have much Joomla or PHP experience so I'm probably missing something really simple. I'm trying to load a certain list of user IDs into an array. This code works except it only loads one result....
4
votes
2answers
310 views
Join an existing table with a generated table of dates and count rows for each date?
I would like to use this complex mysql query in my joomla model to generate a timeline and count entries within a specific date range.
My SQL Query is:
SELECT T.calendar, COUNT(DATE(M.date)) as ...
0
votes
1answer
866 views
Use different mysql table for users
I need to integrate a users table instead of the default Joomla _user table.
The table pref_users has simple id/user/email/password fields (not hashed). Is there anyway I can make Joomla use it ...
0
votes
1answer
340 views
Joomla MVC Component: Run SQL before deleting record
I have a course listing component, and each course as zero, one, or more corresponding sections for that course. Basically different versions of that course that run at different times at different ...
0
votes
1answer
287 views
How to merge joomla tag using SQL query from phpMyadmin?
Since Joomla does not have a tag merging feature, I'm looking for a way to merge existing tags using SQL query in phpmyadmin.
Old tag_id=1
New tag_id=2
This query works as long as all of the ...
1
vote
2answers
427 views
Extension install scripts without raw sql
I am new to Joomla development, coming from Magento.
Working through the tutorials with a certain extension in mind I stumbled upon a little problem.
By now Joomla supports MySql and MSSQL and more ...
1
vote
1answer
126 views
Joomla 2.5 and Virtuemart 3 installation problems
I've tried installing Joomla 2.5 and Virtuemart 3 (full install download from Virtuemart's website) and I went through the installation process ok. However I've had a lot of errors come up and don't ...
3
votes
2answers
3k views
Error 1146 while installing K2 extension
While installing K2 extension, Joomla 3.0, GoDaddy hosting) received error message:
Table 'iWebazoid.bq1ry_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM bq1ry_k2_categories
Unable to ...
1
vote
2answers
637 views
How to Create a Foreach Loop that Returns Users In a Specific Usergroup
My goal is to create an html select box via a foreach loop that returns all users within a specific custom usergroup (ex. usergroup = Agents).
Once, the query pulls in all records (users) for that ...
20
votes
1answer
10k views
How to combine ANDs and ORs in the WHERE clause using a Query Object?
Given the desired SQL below, where Cond1 and Cond2 must be met OR Cond3 must be met for selection, what is the correct way to use getQuery() to achieve it?
Desired SQL: Condition1 and Condition2 ...
