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
3
votes
1answer
1k views

Date or DateTime in database for Component Development using timezones?

Our component manages Television programming, so dates & times are critical - here's the scenario: Our server and most producers are all on local, Pacific Time (America/Los_Angeles, UTC+8) Joomla ...
5
votes
2answers
2k views

Joomla MVC Component File upload w/ Database field update

So I find this a little weird because the DB field was updating without much effort on my part, until I started writing in file upload functionality. Now the database doesn't seem to be updating, but ...
1
vote
1answer
1k views

Empty result when selecting [closed]

Wordpress guy attempting to help out a client with a Joomla project he's stuck on (favor time basically), and I'm hitting a wall. I believe I'm doing my select correctly, and get no "blank page" ...
1
vote
2answers
73 views

Text disappeared after taking style from database params

I've decided to extract the params for my module directly from the database, to put them in my variable stylesheet. I know this is not the recommended way, but for learning sake I find this to be a ...
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 ...
5
votes
2answers
953 views

JForm with custom SQL statements

I have a JForm, which inserts records in the database and relies on its own controller, model, view and table, derived by JTable. However, the database table contains one special field representing ...
0
votes
2answers
3k views

Multiple database connection for integration with other system

I need to my portal that I'm building to be able to integrate with an existing system. The portal just have to pull data from the system database so that any update made from the system, the portal ...
1
vote
1answer
1k views

I can load data from Joomla database and external database?

It is possible to join 2 databases at the same time in a single query? For example: I want to see how many users I have on my server and how many users I have on an external server, all in a single ...
4
votes
2answers
411 views

Using Separate Databases for Each Component

My client is a Data Center Architect. Due to his experience with his work (many customers come to him because they have suffered great data loss in the past), he would like me to configure his ...
1
vote
1answer
2k views

Module to display dropdown options from database table

I have a module which has dropdown select boxes. I have a table in the database, which is associated to a component, which the module is associated with. If the component database table has data in ...
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 ...
1
vote
1answer
984 views

Database error, do i need to worry about it?

I am getting this error in my error_log file. Do I need to worry about it? Although, I am having broken image link problems and SEF problems on some pages. [06-Sep-2014 20:55:05 UTC] PHP Warning: ...
2
votes
2answers
527 views

Uploading Tags In Bulk

I was wondering if it's possible to upload a list of tags to the database in bulk, and if so, how? I need to upload a few hundred tags (all years 1901, 1902, 1903 etc...). The reason I want to do ...
2
votes
2answers
2k views

Search engine for a custom component

I need to add search engine to my component. In database I have three feilds: name, post, address. How to add searching with this fields separatly? For example in the view I add three fields and ...
3
votes
1answer
112 views

Using variables from a database like source

I have a google sheet (no, the data does not need to permanently reside there.) Which contains data for T-Shirts of my design Name Source Thumbnail Commision ...
6
votes
1answer
802 views

Database query where() value is a number

As we know, any values that are defined in a database query should always be escaped in Joomla using $db->quote($value). When defining numbers as a variable, one would normally use (int) to set ...
1
vote
1answer
136 views

Does anyone know which component has tmp_object_relations as a table?

Bit of a long shot but does anyone know which Joomla component/plugin/module has tmp_object_relations as a table? I have inherited a site with a lot of components and thought it might be a SobiPro ...
3
votes
1answer
808 views

Installing PostgreSQL database - Error connecting to PGSQL database

I try to install Joomla 3.3.1 on a new site, with PostgreSQL database. I did all correctly, and I tried many times, did lot of verifications, etc, and I have always the return : "Impossible de ...
2
votes
3answers
1k views

Advice on creating a custom searchable db within Joomla

I have been asked by a friend if I can make their existing Library db more modern and user friendly, whilst incorporating it into their existing website. The existing db is a simple access db ...
7
votes
2answers
518 views

Recommended practices regarding transfering database from Joomla 1.5 to Joomla 3

I want to transfer about 300 articles from a Joomla 1.5 website to a Joomla 3.3.1 website. I have access only to the Joomla 1.5 database but not to the backend (I have access to both for the joomla ...
0
votes
1answer
5k views

#1062 - Duplicate entry '1' for key 'PRIMARY' Joomla

When I importing from a "working" Joomla! DB I get this error: #1062 - Duplicate entry '1' for key 'PRIMARY' The complete error is: -- -- Dumping data for table azzdx_ak_profiles -- INSERT ...
0
votes
1answer
529 views

Blank page when executing a database query?

What's wrong with this code? I'm getting a blank page for this? <?php define( '_JEXEC', 1 ); define('JPATH_BASE', __DIR__); require_once ( JPATH_BASE .'/includes/defines.php' ); require_once ( ...
2
votes
2answers
3k views

How to save checkbox values in a table?

How can i insert data from a html form to a table in Joomla database. Sample code of the form: Name : <input type="textbox" name="username"> Selection1 : <input type="checkbox" name="choice1" ...
2
votes
2answers
537 views

JModelList Group by Category

I have a Component with the following table: +------------------+------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default ...
9
votes
1answer
2k views

Making Custom HTML User Profile Page by using Joomla Variables

I guess its going to be complicated but i will try my best to make you understand, what i want to achieve. All i want, is to make a custom HTML page, which will show the information of the user who ...
11
votes
1answer
11k views

Can I use PostgreSQL with Joomla 3.3

Can I use PostgreSQL with Joomla a 3.3 production site (not for testing) and if so is there anything I should be aware of? I would appreciate some feedback from someone who has actual installed and ...
7
votes
2answers
112 views

Options for backups, restoring, and staging?

What are some options for Backing Up & Restoring Joomla! instances? Preferably ones suitable for staging.
4
votes
1answer
979 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 ...
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 ...
11
votes
2answers
10k views

Catching exception/error in database transaction

I am using the following way in joomla 2.5 and 3 to execute database query - $database = JFactory::getDBO(); $database->setQuery $database->execute(); but how do I catch errors/exceptions if ...
13
votes
2answers
2k views

How can I programmatically get the Joomla database prefix using php?

I sometimes access the Joomla DB via external scripts. The problem I have is that if I ever need to change the prefix, I'll need to edit my scripts again too. Is there a way to programmatically ...
32
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 ...

1 2 3
4