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
0 votes
1 answer
18 views

I am new to Joomla and I'm trying to figure out if I need to install the software or if I can just log in online to make changes

I recently started a summer job and it requires some website management. The company that hired me already has their website through Joomla! and I am just trying to figure out if I need to download ...
user avatar
0 votes
0 answers
38 views

An exception occurred while executing 'INSERT INTO

I am trying to sign up in a portal but I am getting the following error; "SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'password' cannot be null How do I solve this problem?
user avatar
2 votes
1 answer
142 views

What is the difference between mysqli and mysqlnd php extensions?

I'm considering upgrading from PHP7.4 to PHP8.0 on a Joomla 3.10.8 installation. I was surprised to find that my hosting provider only offers mysqlnd as a PHP extension in PHP 8.0, but not mysqli. ...
user avatar
2 votes
0 answers
21 views

Joomla MEMORY tables cause an error in creating/editing articles

I am encountering an error with Joomla 4 that has never occurred to me in previous installations. When I try to create/edit an article, a category or to index contents in smart search, I get the ...
user avatar
1 vote
1 answer
20 views

Omit previously imported articles by comparing existing articles aliases with generated aliases

I am needing to compare the generated articles aliases of items imported from an external news API against those that are already stored in the com_content database to ensure that duplicates are ...
user avatar
2 votes
0 answers
25 views

Transfer of the site, with change of the database (MySQL to MariaDB)

I built my website with Joomla4 and a MySQL8.0 database. Unfortunately, I need to transfer my site to a server using MariaDB10.4, which isn't compatible with MySQL8.0. I'm not a programmer and ...
user avatar
0 votes
0 answers
47 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 ...
user avatar
2 votes
1 answer
41 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 ...
user avatar
  • 31
0 votes
1 answer
42 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 ...
user avatar
  • 1
1 vote
1 answer
140 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? ...
user avatar
  • 325
2 votes
1 answer
55 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 (...
user avatar
2 votes
2 answers
42 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=&...
user avatar
  • 395
1 vote
1 answer
56 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)...
user avatar
  • 483
4 votes
1 answer
130 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, ...
user avatar
  • 63
0 votes
1 answer
30 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 (...
user avatar
  • 113
2 votes
0 answers
44 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 ...
user avatar
  • 1,369
1 vote
1 answer
54 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 ...
user avatar
  • 178
2 votes
1 answer
43 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::...
user avatar
  • 1,369
0 votes
1 answer
68 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 ...
user avatar
  • 213
0 votes
1 answer
28 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 ...
user avatar
  • 483
2 votes
3 answers
176 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"=>"...
user avatar
2 votes
2 answers
54 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-&...
user avatar
1 vote
1 answer
196 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 ...
user avatar
  • 213
0 votes
2 answers
59 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 ...
user avatar
  • 375
1 vote
1 answer
182 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 ...
user avatar
  • 47
1 vote
0 answers
128 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 ...
user avatar
2 votes
2 answers
108 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($...
user avatar
2 votes
2 answers
568 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 ...
user avatar
  • 31
0 votes
0 answers
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 ...
user avatar
1 vote
1 answer
102 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 ...
user avatar
0 votes
0 answers
39 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 ...
user avatar
2 votes
0 answers
41 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 ...
user avatar
  • 183
2 votes
2 answers
166 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 <- ...
user avatar
  • 2,651
1 vote
1 answer
158 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 ...
user avatar
  • 43
2 votes
1 answer
164 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. ...
user avatar
  • 3,501
2 votes
1 answer
45 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 ...
user avatar
  • 3,501
1 vote
1 answer
47 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 ...
user avatar
  • 3,501
2 votes
2 answers
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: ...
user avatar
  • 3,501
3 votes
1 answer
135 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 ...
user avatar
  • 155
4 votes
4 answers
3k 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 ...
user avatar
  • 1,089
1 vote
3 answers
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, ...
user avatar
0 votes
1 answer
32 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(); ?
user avatar
  • 344
0 votes
3 answers
1k views

Can Joomla! read from a CSV file?

I'm building a Joomla! Website (currently running 3.9.0). It's a website of a Sports Club and we would like to add Live Score, Scoreboard and Last Result. The Sport Association told us the only two ...
user avatar
  • 43
2 votes
2 answers
1k views

How to check if specific table names exist in a database?

All I want to do is check if a table exists or not and I can't figure it out. I've tried: for ($r = 0; $r < count($tableArray); $r++) { $db = JFactory::getDbo(); $query = $db->getQuery(...
user avatar
1 vote
1 answer
47 views

Joomla table DESCRIBE

I'm trying to DESCRIBE a table in joomla 3.x I want to get the column names and the associated details (type etc) into an array. I want to get Name Type Collation Attributes Null ...
user avatar
2 votes
2 answers
280 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 ...
user avatar
  • 155
4 votes
1 answer
1k views

with insert on duplicate key update - updating multiple rows at once

With latest joomla version I try to achieve one query to the database and updating multiple rows at once. I want to make a query like this: INSERT INTO `tablename` (`id`,`date`) VALUES ('79','2018-...
user avatar
1 vote
2 answers
29 views

User Showing in User Manager but not Data base

Problem, users are showing in User MGR and they can login, but the users are not showing in the data base. I've created new database and reinstalled same issue, Tried creating a test user with the ...
user avatar
  • 31
0 votes
1 answer
133 views

Can't login to Joomla! admin updating password in PHP MyAdmin doesn't work

I cannot log into the Joomla! admin. Updating the password in PHP My Admin does not work. It always says that my username and password do not match, the user does not exist or I have not been ...
user avatar
  • 1,829
1 vote
1 answer
159 views

Why does the truncateTable() method create an empty string for a query and fail to delete rows?

I have the following code attempting to truncate a table. The Joomla documentation makes me believe this will work, but it does not. What am I missing? $db = JFactory::getDbo(); truncate_query = $db-&...
user avatar
  • 173