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
2
votes
2answers
448 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
0answers
45 views

How to display value from a specific field in the db?

I want to display the com_tags tag title in a module while on the "Tagged Items" menu item page. My goal is for this code to display the title for the current tag. For example, when on ...
1
vote
2answers
431 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 ...
4
votes
4answers
2k 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
1answer
31 views

Restoring with Akeeba to a new site on cpanel

I've backed up my Joomla site with Akeeba, and I'm using Akeeba Kickstart to put the site into a dev environment on a different server with its own cpanel. The dev server has its own database and ...
0
votes
1answer
32 views

Dynamic Form based on Signed in User

I am a total noob in coding. Back in engineering school we had some coding classes and I was good at it but I never really focused on that. I know some python and c# and that is about it. I have a ...
1
vote
1answer
69 views

JTable, new row doesn't get inserted with table->save method

I'm trying to insert a row with the table->save() method, but the method executes an UPDATE instead. There is no row available, so it needs to be inserted. Does anyone know how to get it inserted? ...
1
vote
0answers
117 views

Table data are not shown in the depended field - BreezingForms - Mariadb [closed]

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
1k views

Connect two databases with one Joomla site

I have two Joomla sites with different databases. I want to share all data from one site to another site. For example, when I register a user in one website then it's updated on the second site's ...
2
votes
1answer
40 views

using Ajax to save contents of html how to make safe

I am using com_Ajax to save the contents of my editor (front end of the website in a module) Ajax and passing the content of the editor all works fine. I am concerned about security. To get the data (...
0
votes
0answers
40 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' ...
2
votes
2answers
40 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
41 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
99 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
760 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
3k 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
32 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
40 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
30 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
55 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
92 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
25 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
128 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
164 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
47 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
3k 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
140 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 ...
0
votes
2answers
49 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
32 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
3k 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! ...
2
votes
2answers
91 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
77 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
33 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
38 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
31 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
735 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
117 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
127 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
605 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
139 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
41 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
358 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
101 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
131 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
330 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 ...