Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
180 views

How to access user-submitted values from a dynamic form?

I want to insert a row in my db-table with inputs from users. The form the users fill out is made with a foreach-loop: foreach ($results as $row) { echo '<div class="vm_kampe"><input ...
0
votes
1answer
1k views

How can I save multiple dynamic values using check boxes?

I have a form which fetches and displays data from two databases (sessions, students) and allows a curriculum manager to select different combinations of students and classes by clicking check boxes. ...
0
votes
1answer
739 views

How to SET a user-defined MySQL variable and increment it to produce ranking values with JDatabaseQuery?

I'm trying to write this query: SET @rownumber = 0; UPDATE #__hikers SET rank = (@rownumber:=@rownumber+1) ORDER BY score DESC; like JDatabaseQuery, but still got an error. Please help UPDATE: I ...
0
votes
2answers
70 views

How to get banners clients when exists banners with this client?

I need to retrieve the banners_clients data only when exists banners for this client id: Example: banner one - client id 1 banner two - client id 1 banner three - client id 4 client id 1 - name ...
0
votes
1answer
1k views

Fabrik Cross database joins

I have two separate databases with the same credentials: in db1.table1 there is a column containing filepaths that I need to update with a filename that is stored in db2.table2 and that I can retrieve ...
0
votes
1answer
194 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
83 views

Can I insert custom attribute information into the MySQL content table?

I'd like to be able to give each article an additional attribute. Not sure if I can use the columns that exist in #_content. I'm concerned any modifications I do will be overwritten or cause errors. ...
0
votes
1answer
536 views

filter db by a single date - how to hack the standard calendar form field

I used component-creator.com to build a component. The component has a table with a date field and a frontend view which shows the contents of the table with a filter which can show the items between ...
0
votes
3answers
83 views

Field value picked from wrong table due to same field name in different tables

This is a code am using. However facing an issue due to common id field in all tables Problem vid='.$row->id.' - in url The id field in the url is showing from #__usedcar_products table, while i ...
0
votes
2answers
160 views

Accessing Jdatabase via JavaScript Or Passing PHP varibles to JavaScript

I want to use this SVG Pie Chart on my Joomla site but the problem is I need to access data from Jdatabase and feed it to its index.js $(function(){ $("#pieChart").drawPieChart([ { title: "Cash"...
0
votes
1answer
262 views

export user details from database via cron

Is there any way I can export user details from joomla database such as name, password, email address, and import them into owncloud database via a cronjob?
0
votes
1answer
142 views

Mysql syntax error in query to external using community builder autoaction

A couple of years ago, using joomla 2.5 and community builder with it's auto action plugin, I created a mysql script that registers a user on a secondary site after the user has registered on a ...
0
votes
1answer
151 views

Using jimport in ajax php file

I run a fantasy football website. My League Registration is handled through a form and mysql database. This all works well. Once I hire a manager, I want to create a Joomla user for the user. ...
0
votes
2answers
936 views

How to make a mysqli connection and execute a SELECT query in Joomla?

I am having an issue with a basic query in PHP. The query runs perfectly in PHPMyAdmin, but in the browser I am getting: Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, ...
0
votes
1answer
1k views

Select data from multiple tables with different name and columns

I have this problem that I can't resolve. In CMS Joomla I need to select data from table #__adsmanager_ads column ad_healine and from table #__modules column title. Then check if ad_headline == title ...
0
votes
2answers
293 views

What is the Joomla database code for the group_concat from tables joined by a third

I am looking to group_concat the results from the fields from multiple rows where there is a an intermediate table '#__ext_resources' a.id a.title 1 Blaa 2 Blee 3 Blii Joining table '#...
0
votes
2answers
300 views

Database error importing from localhost to live site?

I've been using Xampp for Mac and the latest version of Joomla. I uploaded the site/database to a live server a couple weeks ago for a developer to look at a problem I was having specifically with ...
0
votes
1answer
305 views

Smart search Indexer duplicate entry mysql error

I'm running Joomla 3.3.1 with MySQL 5.6.21 and I'm getting the following error when running an Index. It indexes 2 items and then stops. An Error Has Occurred Duplicate entry '1-0' for key '...
0
votes
1answer
1k 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
74 views

SQL syntax error while creating a form in JForms - where to correct the SQL code?

We have a Joomla 1.5.9 website with JForms component and MariaDB of unknown version, but definitely corresponding to MySQL 5.x. I have administered it through GUI (both backend and frontend) for two ...
0
votes
0answers
28 views

How to display external SQL table using Joomla?

I am looking for good free extensions I could use to display SQL tables on my website. I have tried a couple but, they either don't work or ask for indexing which my tables don't have. https://joodb....
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
21 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
8 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
338 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
1answer
60 views

Joomla 3 database query select with limit [duplicate]

How can I use this query with joomla 3 with limit to 3 SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(( $coorlat - latitude) * pi()/180 / 2), 2) +COS( $coorlat * pi()/180) * COS(latitude * pi()/180) * ...
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
1answer
2k views

MySQL update select one table from another

I'm struggling to get this MySQL query to work and hoping someone out there can help please. I wish to "copy" one record from table traincomprofiler to course_dates where both tables share the column ...
0
votes
2answers
867 views

Rows with same id in same div

I have a db-table called vm_kupon. It looks a little like this: |id |uid |bet | |1 |20 |1 | |2 |20 |2 | |1 |21 |X | |2 |21 |1 | |1 |22 |X | |2 |22 |X | I ...
0
votes
1answer
563 views

Update specific row in FOREACH loop

I've tried and tried, but I can't get this to work. I use Joomla and I have 2 articles/pages, one for edit and one for posting the form. I have a database with all the matches for the World Cup coming ...
0
votes
1answer
63 views

Copy users from one Joomla db to a slightly newer one

Assuming I have an earlier copy of a Joomla database can I simply copy the jos_users, jos_userkeys, jos_usernotes, jos_userprofiles and jos_usergroup_map tables to a newer copy of the database - by ...
0
votes
1answer
552 views

Calling a Model's Method from View [duplicate]

I have a function in my model to sum several columns of a table. public static function get_sums() { // Create a new query object. $db = $this->getDbo(); $query = $...
0
votes
1answer
79 views

Random token in DB on each login

I'm looking to somehow add a "token" on login and temperately store it in the database (same as table *_users) until next login (important). I have a game of sorts that uses a selected user and ...
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
1answer
97 views

How to sort a fabricated column in my view that I've stitched together with data from multiple columns?

I have a view that displays a list of data from a table (I'm targeting Joomla! 3.5+). However, I fabricated a column that stitches data together after some manipulation. I do this in the getItems() ...
0
votes
1answer
466 views

Issue with upgrade to php7 and new mysql

I upgraded everything from nginx to php to mysql and everything is configured correctly seeing as i can install a fresh version of joomla, but my previous project is now showing a blank page, no ...
0
votes
2answers
135 views

Upgrade 2.5 to 3.5 SQL error

I've recently upgraded a test site on 2.5.8 to 3.5.1. Before the upgrade all components were updated or disabled if not useable in 3.5.1. From here I used the Joomla Upgrade to get it to the latest ...
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
2answers
489 views

Slow query issue!

Maybe someone can help me with this issue. My site has a slow query: SELECT DISTINCT i.*, g.title AS groupname, c.name AS category, v.name AS author, w.name as moderator, u.name AS editor FROM ...
0
votes
1answer
157 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 ...
-1
votes
1answer
337 views

How to write a conditional check on a column value with a mysql query?

I am trying to setup a simple default statement on the results page of a testing system. This seems like it would be relatively simple, but I cannot get my if statement to process properly. The ...

1 2 3 4
5