Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

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.

0
votes
2answers
15 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 ...
0
votes
1answer
10 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 ...
0
votes
0answers
21 views

Site synchronization between localhost site and live site

Is it possible to sync a Joomla website (Database and preferably files too) on localhost (example WampServer) with a live production website and vice versa? A customer has asked about this and a ...
1
vote
1answer
19 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-&...
1
vote
1answer
67 views

Convert line breaks in php textarea

I have a kind of a guestbook on my page. It's just a common textarea like this: echo ' <textarea name="msg"></textarea>'; and then I use a form to send me to the backend on submit: $db =...
3
votes
2answers
92 views

Check if INSERT query was successful or failed because of a duplicate UNIQUE KEY

I have a db-table called league where the mail column is the unique id: |name |mail | |Bryan|bryan@hotmail.com | I have a frontend where users can sign up and then I have this for ...
1
vote
2answers
35 views

Update multiple columns with plus 1

I have a website for my footballteam. I have some statistics and so on in there, fx how many games each player has played and so on. What I would like, is for me to write in the names of every player ...
2
votes
2answers
73 views

Trouble Connecting to External Database

Context: Joomla 3.8.5 MySQL Joomla database = berrien_dev External database = BMP PHP 5.6.33 I am attempting to access in a component I am writing an external database that sits in the same MySQL ...
0
votes
1answer
31 views

Joomla database tables have duplicates that start with bak_

I have a Joomla website, and somehow, the database shows duplicate entries for every table row. The duplicates all start with bak_. I assume it was caused by some sort of backup process, but this has ...
0
votes
0answers
20 views

Generating a list of content associations from Joomla database #_associations table

I'm in the process of transferring a multilingual Joomla 3.7.5 website to another platform (Wordpress). This is going well, except with the 700 posts, I'm hoping to avoid a bit of work when it comes ...
0
votes
2answers
69 views

Localize output of SQL query

I make a query directly on the database like this: SELECT title,id, DATE_FORMAT(publish_up, "%d %M %Y") AS 'GEORGE' FROM #__k2_items WHERE published=1 AND trash=0 AND created_by=[id] ORDER BY ...
0
votes
0answers
42 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 (...
1
vote
2answers
39 views

Variables do not work in email form

I made a simple email form to send an attachment (image). All sender information is taken from the joomla database, the user selects from the dropdown list (populated from database) new name of image. ...
0
votes
0answers
93 views

JModelAdmin load data from multiple tables

I created a component called clients with 2 tables: CREATE TABLE `#__clients` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ...
2
votes
1answer
29 views

How to edit the text string “Contact Form”

How to edit the text string "Contact Form". Client wants it to say Inquiries. People are using it to make booking which he would like to avoid. Thanks. http://chrisgarsidepodiatry.com.au/index.php/...
2
votes
2answers
245 views

I am trying to connect two database with one Joomla site

I have two joomla site with different database.And I want to share all data one site to Another site .For example when I register A user in one website then it's updated on second site database also....
1
vote
1answer
51 views

Why my custom query only returns one result?

$dbwsk = JFactory::getDBO(); $querywsk = "SELECT `title` FROM `#__content` WHERE 1"; $dbwsk->setQuery($querywsk); $rowswsk = $dbwsk->loadResult(); var_dump($rowswsk); I've been working and ...
0
votes
1answer
51 views

Error on upgrade of database

I manually upgraded a Joomla 3.3 to 3.4.8, but Extensions > Manage > Database showed: The Joomla! Core database tables have not been converted yet to UTF-8 Multibyte (utf8mb4). I clicked ...
3
votes
1answer
384 views

How can I increase the maximum length of article titles?

I need to create a few articles with very long titles, but it seems like Joomla has a maximum article title length of around 256. How can I increase this limit?
2
votes
2answers
166 views

Custom Component load data

I'm fairly new to Joomla and I'm taking over a project from a previous developer. In a custom component we are capturing user data in a form. Before the name and address is entered into the database ...
1
vote
1answer
178 views

Get user id from user form field type

I have a custom database table created with my component that has a user id linked by foreign key to #__usersand I have a form field type in Joomla 3.x mvc <field name="modified_user_id" type="...
2
votes
1answer
39 views

Overwrite the global database driver

JFactory has a getDbo method, but no setDbo. Why? It can be useful for unit-testing to be able to overwrite the global database driver. Any other way to do this? EDIT: $database is a public property ...
1
vote
2answers
322 views

Joomla 3.7 change value in database after form button press

I want to do something really simple, but have to use Joomla what makes it probably complicated because I have less experience in Joomla development. I have field with a value (a number) which is ...
2
votes
1answer
424 views

Access external database connection in function?

I have the following code in an article using Sourcerer and it works fine but I would like to move the connection section out of the function so that I only need to create it once for multiple ...
1
vote
1answer
131 views

Import Excel table rows as articles

I have a different products organized in Excel file. Every column means something - Title, Description, Weight, Price and so on. Can I import them in Joomla in such a way, that every row is a new ...
2
votes
1answer
465 views

custom table display - help turning static html to dynamic php

I am trying to modify the list view of my Joomla component to display my table's data in a more user-friendly fashion. It currently simply displays all data in a regular table with columns and rows, ...
1
vote
1answer
237 views

Migration from MySQL to MSSQL database

I've a Joomla 3.6 project which is built on mysql db. I want to know how can I migrate to mssql db? Maybe someone could do step by step guide and suggest some tool for migration?
2
votes
2answers
1k views

Joomla 3.x: Installation using MSSQL as Database

I tried to do some research, but couldn't find one. Maybe someone can help! I want to install Joomla 3.x using MS SQL server as DB. Right now, I only can choose Mysql. PHP version - 5.6 + WAMP! ...
5
votes
2answers
234 views

How to prevent Joomla from reporting database error information

I'm currently investigating SQL injection attack vectors in my application. Currently, Joomla is reporting database error output when returning a HTTP 500 error page. How do I prevent this? The ...
3
votes
1answer
72 views

Extension to edit multiple articles in a same pattern?

I am trying to fix an old joomla site so it can be responsive. In the articles, every image comes with style="width:1150px;height:650px", I need to replace all these occurrences with style="width:100%...
1
vote
1answer
39 views

Why joomla doesn't use relation views and foreign keys?

As it's obvious, joomla doesn't use relation views and foreign keys. It seems that everything is handling in the application level (not in the database). For example, a reference value can be deleted ...
2
votes
1answer
240 views

select data from multiple table in joomla and form it into json

i'm beginner in joomla i have been working in java i wrote these query for getting data from 3 different table which has one simillar column.. but it throughs error 500 internal server error **the ...
0
votes
2answers
132 views

Store data from URL in Joomla website database

I just came through a scenario regarding joomla website. The scenario is: Data in URL is passed to Joomla website and from the URL Joomla must store the data into the database. Is this possible in ...
0
votes
2answers
44 views

Database to multi-language website doesn't have user but log in possible with the user

I have a rather peculiar problem. The web-developer before me run away for some reason and we cannot get ahold of him for the admin password. Luckily we have access to the database according to some ...
1
vote
1answer
37 views

Mysql Error 1273 when moving DB from dev to live server

So, I recently updated to version 3.6.5. I initially tested the update on a test server before moving the update to my live server. The issue I'm running into is Mysql 1273 Error CREATE TABLE `...
2
votes
1answer
62 views

Database errors after moving remote db to localhost

I've recently run into a strange issue after upgrading to 3.6.5. I've been trying to resolve issues with a failed one-click-update to my live site. Thankfully, I had a pre-updated backup living on a ...
1
vote
2answers
2k views

Fix database after failed update

So, I recently had an issue with a failure with updating to Joomla 3.6.5. It looks like I was mostly able to recover from the error by manually updating, however there seem to be issues with the ...
4
votes
1answer
194 views

Delete all demo data

Many templates come with demonstration data that may be installed to show off the features of a template. Is there a simple method of deleting all this data or am I going to be forced to delete each ...
2
votes
2answers
107 views

Transfer Joomla data from PHPMyAdmin SQL Dump

My friend's web page was created with Joomla (c. 2013), and she wants to transfer her site to a new host. Her current host sent her a SQL Dump generated by PHPMyAdmin, which contains what I assume is ...
1
vote
2answers
29 views

I can only grab the global keywords and not the article keywords

I can only retrieve the global keywords. Is there a way to retrieve the article's keywords? I am trying to modify the Administrator template. I want to add each article's keywords to the Articles ...
9
votes
1answer
199 views

Migrate meta keywords to tags

Is there an easy way to migrate or copy existing meta keywords for articles so that they become article tags, in Joomla 3.6? The situation is: Joomla, until a few versions ago, didn't have a tag ...
1
vote
1answer
2k views

No configuration file found and no installation code available. Exiting… | Not true

I'm using ALtervista to host my website. I've just installed joomla 2.5 using the auto-installation of Altervista. Exported a database in sql.gz format and imported it into my new database on ...
0
votes
1answer
47 views

Joomla!3.6.x - BDD - ACL inconsistent

I have got a too amazing feature regarding ACL : a category and a sub-category for which ACL of three user groups is inconsistent. One group's got herited right at sub-category however it hasn't right ...
2
votes
6answers
209 views

Database Error At Busy Times

My Joomla 3.6 website up time is pretty good, however at times of high traffic, my site shows a white page with the following text; Error displaying the error page: Application Instantiation Error: ...
1
vote
2answers
643 views

How to create bulk articles by using php script?

I have seen this post and it was really helpful Create categories, subcategories and articles using php but I am not able to create articles by using same script. I have modified the script but ...
1
vote
2answers
58 views

What would be the best approach to modify multiple articles' content programatically?

Joomla 3.6 + k2 2.7 hosted on my own linux server. I am assuming someone else's webmaster job. He has had hundreds of k2 items on hte site, with a major problem: most of the articles have some ...
1
vote
5answers
1k views

Are there any alternatives to Fabrik for building a database application (ERM/CRM)?

I am building an internal database application for Joomla using Fabrik. I'm interested to know if there are any alternatives to Fabrik for me to use. Maybe some of them have more options? In my case, ...
3
votes
2answers
759 views

How to save image in specified folder in joomla directory and save file name in db

I am working on a custom component, where at the backend interface - we want the admin user to be able to upload image and let that image directly save to a specified folder - /images/uploads/variants/...
1
vote
1answer
57 views

Rewriting Query for Fetching Database Value

I am trying to rewrite below query to fetch on database value off Models But am failing on in the new code, can any one help in to rewrite in query based on joomla latest standards Old Code <?...
2
votes
1answer
384 views

Get K2 Extra Field Name Using Id

I'm building a module that will read parameters from the current page's K2 extra fields, and use them to load modules. I've successfully loaded the current page's item, but it's "extra_fields" array ...