Skip to main content

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.

18 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
0 answers
71 views

Joomla 4 Pre-Update Check Database Fail

I installed Joomla on my webhost (Siteground) using the one-click installer package. I'm currently on v4.3.2 Everything appears to be working as expected apart from the Joomla update option. It keeps ...
jonboy's user avatar
  • 3,613
2 votes
1 answer
131 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 ...
Nintendomi's user avatar
2 votes
0 answers
115 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 ...
Julie Baumer's user avatar
2 votes
0 answers
60 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 ...
shenkwen's user avatar
  • 1,389
2 votes
0 answers
61 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 ...
pkExec's user avatar
  • 183
1 vote
1 answer
37 views

Query with multiple joins and a variable

I have a query: $query->select( $db->quoteName( array_keys($fields), array_values($fields) )); $query->from($db->quoteName('#__receipts_patient_charge',...
user1616338's user avatar
1 vote
0 answers
321 views

Tables and needed columns in Joomla 4

On the Page https://www.dionysopoulos.me/book/com-tables.html#com-tables-get-object I read: The table MUST have the following columns: parent_id. The primary key of the parent node. Provides ...
agi's user avatar
  • 313
1 vote
2 answers
641 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 ...
Daniel Jensen's user avatar
1 vote
0 answers
19 views

Need some suggestion regarding strategy of scraping article view times from another webpage to use in K2 item

I am building a video blog page using Joomla 3.0 + k2 hosted on my own Ubuntu 14.04 server, the videos will be uploaded to sites like youtube or vimeo too. I want to show the viewed times of the ...
shenkwen's user avatar
  • 1,389
0 votes
0 answers
27 views

problems with updating database

I have some code to update a table: $updateLastAttempt = new stdClass(); $tempDate = new DateTime('now'); $formattedDate = $tempDate->format('Y-m-d H:i:s'); $updateLastAttempt->id = $pxobjUpdate-...
user1616338's user avatar
0 votes
0 answers
250 views

Connecting to an external database in Joomla 4 - further problem

I have seen the earlier question on this subject and tried the suggested code: $db = (new Joomla\Database\DatabaseFactory)->getDriver('mysqli', $options); but get an error: An error has occurred ...
johnonorvic's user avatar
0 votes
0 answers
30 views

How to know about errors when using Table class store method without using getError

I'm wondering how to find errors when a table class is used, inheriting from \Joomla\CMS\Table and using the store method? It appears that in Table, the store method traps errors in a try-catch ...
mbrampton's user avatar
  • 314
0 votes
1 answer
37 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 ...
Hailey Labelle's user avatar
0 votes
0 answers
197 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?
Daniel Kiptoo's user avatar
0 votes
0 answers
54 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 ...
modernmagic's user avatar
0 votes
0 answers
38 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 ...
Thiago Guimarães's user avatar
0 votes
0 answers
42 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 ...
Thiago Guimarães's user avatar
0 votes
0 answers
116 views

Custom Joomla plugin to catch specific database queries

Is it possible to make a plugin which will get triggered by specific database events in Joomla? I need to watch the $this->getTable() request in Joomla. For eg: $table = $this->getTable(); if (...
Perino's user avatar
  • 667