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
5
votes
2answers
942 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
410 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
973 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
511 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
110 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
768 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
135 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
782 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
516 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
525 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
517 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
950 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
9k 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 ...
31
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