Questions tagged [database]

A database is an organized collection of data typically used to model certain situations. Use this tag if you have questions about designing a database. If it is about a particular database management system, (e.g., MySQL), please use that tag instead.

Filter by
Sorted by
Tagged with
1
vote
2answers
350 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 ...
1
vote
2answers
32 views

Get the template I'm currently editing

I'm developing a custom form field for my template and I need to know the name of this template from inside this form field. While otherwise I would do a setQuery to look for client_id=0 and home=&...
1
vote
1answer
27 views

Joomla Select from DB AND / OR grouping

I did not found any guide on how to handle such queries in Joomla: I would like to select all items from db which are: Published AND (the publish up date is 0000-00-00 00:00:00 or smaller then datenow)...
4
votes
1answer
63 views

Create a table observer

I am trying to create a table observer in a module. I am using the Table Advanced API guide in the Joomla documentation https://docs.joomla.org/Table_Advanced_API_Guide. When I use the code provided, ...
5
votes
1answer
728 views

Joomla SQL drivers and prepared statements

Can you tell me if Joomla SQL drivers support prepared statements? As far as I understand, the MySQLi driver does not prepare SQL statements. But Joomla also supports MySQL PDO driver. Does this ...
2
votes
2answers
2k views

Failed to Read Session Data After Renaming DB

Joomla 3.9.11 Working on localhost, today I decided to rename my database from dbtest to dbnew. I did this using HeidiSQL > rename db When I visit my site I now see the following error; Warning: ...
0
votes
1answer
29 views

Component development, on installing an update, should/could J! ignore some database errors?

While developing a component the database can go through many changes. Updating the component then either goes through many schema update files, or causes problems. Re-applying a database change file (...
1
vote
0answers
23 views

writing my own code to import users

I need to batch create lots of users and I have their emails and some profile details like phone number and address. This data is in a google sheet. I just need to generate usernames and set initial ...
1
vote
1answer
34 views

Where does Joomla com_tags store the ordering data?

I want to dump tags by order from the #__tags database table, but there is no order column in the structure, though there is ordering capability in the tags component. I've viewed the relevant files ...
2
votes
1answer
25 views

Which files do i need to include to perform database query?

I am trying to practice Joomla database query. For learning purpose, I'd like to know in a blank PHP file under Joomla's root folder, which files do I need to include to be able to do $db = JFactory::...
0
votes
1answer
35 views

How to install custom component sample data?

I have a custom component for Joomla. I understand how to install some data using the sql file of component. Now I want to add some data to the database tables in a separate package. I can't find any ...
1
vote
1answer
87 views

Joomla database tables have duplicates that start with bak_

I have a Joomla website, and somehow, the database shows duplicate entries for every table row. The duplicates all start with bak_. I assume it was caused by some sort of backup process, but this has ...
0
votes
1answer
24 views

Joomla DB where statement not works as expected

I don't understand the world right now. I try to make a simple query from the DB, but it fails with the message that the column is not known. I do not understand why Joomla! tries to see the value I ...
2
votes
3answers
72 views

Cannot Connect To MSSQL Server

I am using php 7 and trying to connect to mssql server. I have this code: <?php $serverName = "server"; //serverName\instanceName $connectionInfo = array( "Database"=>"...
1
vote
1answer
125 views

Charts/Graphs for RSFORM using mysql for VChart and/or PlotaLot

I am working for a homeless organisation in Capetown. We are using RSForms to register our clients (about 3500 per year). We have a sizable database, but it's very hard to create a dashboard. We are ...
2
votes
2answers
42 views

Json encoding being escaped

I'm writing to the db (I'm automatically creating a module): $module = new stdClass(); $module->title = $moduleTitle; $module->note = ""; $module->content = ""; $module-&...
1
vote
6answers
2k views

Are there any alternatives to Fabrik for building a database application (ERM/CRM)?

I am building an internal database application for Joomla using Fabrik. I'm interested to know if there are any alternatives to Fabrik for me to use. Maybe some of them have more options? In my case, ...
1
vote
1answer
64 views

Where to find article page title in database?

When managing an article, there is a "Browser Page Title" field in article options tab. It's the last field in the tab, just below the "Read More Text". Why it's not in the publishing tab makes no ...
2
votes
1answer
288 views

Linking JOOMLA! database to a flutter application

I created a Joomla website which has some forms to be filled. Is it possible to link this form to a database that a flutter mobile application I developed can retrieve data from? For example, the ...
0
votes
2answers
29 views

Does Joomla Host Value under Server Database setting needs a change after change in ip address

need help. My web hosting recently sent email that they will perform an infrastructure upgrade and migrate my Cloud account to a new server with the latest hardware in Google facility. They now ...
1
vote
1answer
22 views

Custom Field Tag Style List

Joomla 3.9.11 I have created an SQL custom field for my joomla contacts called location, this allows me to assign a location to my contacts. The SQL simply selects location_name from a custom db ...
2
votes
3answers
2k views

Joomla 3.x: Installation using MSSQL as Database

I tried to do some research, but couldn't find one. Maybe someone can help! I want to install Joomla 3.x using MS SQL server as DB. Right now, I only can choose Mysql. PHP version - 5.6 + WAMP! ...
0
votes
0answers
65 views

Second set of fields does not show table results - BreezingForms - Mariadb

I have 2 set of fields: Set A (Field1, Field2), and Set B (Field3, Field4). Field1 loads data from Mariadb tableA according to user selection and then loads the corresponding data from tableA to ...
2
votes
2answers
74 views

Query with INTERVAL won't work

I have the following query: $query->select('date') ->from('#__db_reports') ->where($db->quote('date < NOW() - INTERVAL 30 DAY')) $db->setQuery($...
1
vote
1answer
60 views

Error saving an edit in a custom component `table_users` was not locked with LOCK TABLES

I'm getting an error when trying to save edits in my custom component. I have another edit.php that works well. I identified that the problem lies in the table file, specifically in the function ...
0
votes
0answers
32 views

Display a form and post it to dabase

I want to insert a form in a default.php file and post it to the database. How should it be done? By adding an XML form or creating a regular HTML form and posting it to the database through a ...
0
votes
0answers
37 views

Retrieve all fields using while in Joomla

I'm trying to retrieve data using while and it won't work. The page just keeps loading and ends up with a blank page; no errors or anything but, when i use foreach, it works. Any explanation? The ...
2
votes
0answers
26 views

Very slow initialization of Joomla when on remote database

Running Joomla 3.9.15. When I am using a remote database (still on the same local network though), I am facing massive slow downs on the "before preloadComponents" phase of Joomla init. The actual ...
0
votes
3answers
671 views

Count rows from multiple database tables

On a project of mine, I've recently moved from native PDO to the Joomla Database Framework package. Before, I prepared the following statement to count the number of rows from multiple tables (...
1
vote
1answer
69 views

How to update database module params

Could someone kindly help please? I'm creating a plugin and part of its job is to automatically add a 'Menu Class Suffix' to a chosen menu. I know it can be done manually from the advanced tab of ...
1
vote
2answers
2k views

MySQLi PHP Warning [closed]

I am getting the following errors (in this order) thousands of times in my error log: [08-Jun-2016 13:11:05 America/Detroit] PHP Warning: mysqli::stat(): Couldn't fetch mysqli in {...}/libraries/...
2
votes
2answers
73 views

Unable to update NULL via updateObject

We got 2 tables where one table is parent and another table as a child with primary and foreign key reference. Assume table1 is the parent and table2 is the child as below. table1: id <- ...
1
vote
1answer
575 views

Import Excel table rows as articles

I have a different products organized in Excel file. Every column means something - Title, Description, Weight, Price and so on. Can I import them in Joomla in such a way, that every row is a new ...
2
votes
1answer
90 views

Transfer Custom Code to Module / Plugin / Component

Joomla 3.9.12 I've been using Sourcerer in order to place custom code throughout my site, it's working well so far. I've created a custom html module, within this I have added PHP, JS, HTML and CSS. ...
2
votes
1answer
36 views

Tips On How To Optimise A Joomla Site

Joomla 3.9.12 What's the most effective way of optimising a Joomla website? I'm not sure if my site is particularly large, details below; Files / folders 28GB Database 314MiB When I take a backup ...
1
vote
3answers
2k views

Joomla 3.9.3 Articles: 500 Unknown column 'a.note' in 'field list'

I've updated to Joomla 3.9.3 and now when I open the articles pages, I get this error: 500 Unknown column 'a.note' in 'field list' I've tried to fix the database with the Joomla repair function, ...
1
vote
1answer
354 views

Delete items of database via CLI

I would like to delete some items with state "trashed" via CLI. Is it possible to call the delete-method of JTable from CLI? Thanks for your help :-)
2
votes
2answers
91 views

Database errors after moving remote db to localhost

I've recently run into a strange issue after upgrading to 3.6.5. I've been trying to resolve issues with a failed one-click-update to my live site. Thankfully, I had a pre-updated backup living on a ...
3
votes
1answer
127 views

How to separate database results into 2 columns?

I saw the examples of how to do the odd even way, but I want the order to flow from one whole column to the next and not alternating left to right for each alphabetical item. Can this be done? Here ...
5
votes
2answers
4k views

How to do SQL exception / error handling compatible with 2.5 and 3.x?

I was trying to develop Joomla 2.5 and 3 component. As many things deprecated between these two versions and the way to throw and catch database and other errors, I could not find ways yet to make ...
1
vote
2answers
2k views

How to fix Joomla site both frontend and backend shows error page (site down) after fix database?

I have Joomla 3.4.8 site (multilingual site) that shows this error on the front-end that said : **Fatal error:** Call to undefined method JLanguageMultilang::getSiteLangs() in **/mysite/public_html/...
10
votes
1answer
318 views

Migrate meta keywords to tags

Is there an easy way to migrate or copy existing meta keywords for articles so that they become article tags, in Joomla 3.6? The situation is: Joomla, until a few versions ago, didn't have a tag ...
1
vote
3answers
1k views

JFactory::getDbo() deprecated— what's the replacement?

I'm running Joomla 3.9.5 and I'm attempting to update my JFactory::getDbo() calls (which are deprecated) to the newer format using the container. However, I'm getting the following error: Call to ...
2
votes
2answers
2k views

Preprocessing form data before saving to the database

I have a series of checkboxes on my form that together form an array when POST'ed. I want to save this data as a string instead (e.g., "##,##,##") before committing to the database. Here's what I ...
2
votes
2answers
1k views

Joomla 2.5, how to use “HAVING” using Query Object

"SELECT *, ((ACOS(SIN($lat * PI() / 180) * SIN(latitude * PI() / 180) + COS(78 * PI() / 180) * COS(latitude * PI() / 180) * COS((87 - longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance ...
31
votes
4answers
4k views

Method for creating a subquery using JDatabase

At http://docs.joomla.org/Selecting_data_using_JDatabase, there isn't a documented method for writing a subquery using JDatabase. https://gist.github.com/gunjanpatel/8663333 exemplifies one way of ...
4
votes
2answers
3k views

Creating a module to search the database and display the results

I have got a table in the database called #__magazines, this holds data for magazines (date published, issue number etc..). I have created a Component, Plugin and Module which is for Joomla 3.x, I ...
4
votes
5answers
5k views

MySQL error: Unknown storage engine 'InnoDB'

I have a couple of Joomla 3.3.6 websites, and suddenly this morning I started to get random error messages, like this: Error displaying the error page: Application Instantiation Error: Unknown ...
4
votes
1answer
950 views

Table marked as crashed and repair failed

My Joomla 1.5.16 website has started to display the error below. I don't think this is a hack, and I can't find any evidence in the logs of someone trying to get in or any changes to files that ...
0
votes
1answer
31 views

Connect to two MySQL db's [duplicate]

I want to use a second database for the product data. Is it possible to connect to two database and using of JFactory::getDbo(); ?