Skip to main content
3 votes
Accepted

Quotes Displayed in Database Value

As far as I can tell from the profiles plugin code, the speech marks come from data being JSON encoded before being entered into the database. $tuples = array(); $order = 1; ...
RichardB's user avatar
  • 3,082
3 votes
Accepted

How to tell what WAS the local time of an article?

In database tables, dates are always in UTC. Coordinated Universal Time (French: Temps universel coordonné), abbreviated as UTC, is the primary time standard by which the world regulates clocks ...
Anibal's user avatar
  • 7,445
2 votes
Accepted

Joomla database tables have duplicates that start with bak_

You dont need to worry about these tables. They are generated from the Akeeba Backup extension when you perform a backup. You can drop these table and no, your site won't be affected.
Lodder's user avatar
  • 26.9k
2 votes

Correct ways to verify update query is successful under conditions

Here is a basic structure for isolating each outcome. $id = 2286; // you can jinput this or whatever $found = 0; // establish default value $affrows = 0; // establish default value $db = ...
mickmackusa's user avatar
  • 4,826
2 votes
Accepted

After joining two tables in phpMyAdmin how do I save the results as a dynamic table?

Unless you are magically updating the new table with fresh data then you will only see the data from the initial select statement. In this case you have a few options populate the new table with ...
sirobertson's user avatar
1 vote

How can I add an additional column to a database view in phpMyAdmin?

I solved it by using CREATE OR REPLACE VIEW rather than ALTER VIEW, like this: #_content_with_featured_two AS SELECT #_content.id AS f_id, #_content.title, #_content.featured, #...
Gillian's user avatar
  • 411
1 vote
Accepted

Mysqli query with regex to Joomla php syntax

quoteName() is something that you call when you are quote-wrapping identifiers. (REGEXP_SUBSTR(r.xml, \'[0-9]+\')) is not a table name or column name so it makes no sense to try to wrap it in quotes ...
mickmackusa's user avatar
  • 4,826
1 vote
Accepted

Joomla 4 - 503 service unavailable

I managed to solve this by setting up the myqsl_nd_pdo module in PHP
Eoin's user avatar
  • 1,976
1 vote

Quotes Displayed in Database Value

The profile_value field is a JSON encoded field, when it's empty it will be an empty quoted string as the default value. You don't want to mess with the way the data is stored. (unless you want to ...
Walt Sorensen's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible