Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysql
Search options answers only
not deleted
user 174
MySQL is a database system used by many websites on the Internet. Joomla is based on PHP and MySQL.
2
votes
Modified database layer to use Amazon RDS's read replicas and master in MySQL
To play with MySQL configutation, the solution is beyond a system plugin. It has to catch every query and manage the applied configuration. …
- 7,445
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 a …
- 7,445
1
vote
Jdatabase : Sorting two selections?
In a similar way, you have to compose a query to return the results that your require. Something like:
SELECT P.roll_num+A.roll_num FROM PRESENT P, ABSENT A
WHERE
P.subject_co = A.subject_co AND P. …
- 7,445
2
votes
Joomla 3.3.6 Union SQL Issue
To debug the issue: $query is an object that generates the SQL statement to be executed. Then, you can echo $query->__toString() and compare the outputs.
In a complex case, it may be necessary to gen …
- 7,445
4
votes
Filter strings before saving them in the database
To avoid MySQL-Injection-Attacks, you can have to properly escape and quote special characters. For example:
$query = 'SELECT * FROM #__table WHERE ' . $db->quoteName( $field-name ) . '=' . …
- 7,445
0
votes
Accepted
Error loading module MySQL server has gone away
It's a MySQL issue. … It may be:
MySQL Bug
MySQL Internal Inconsistency
MySQL Load Restriction / Timeout
Since error is MySQL server has gone away, the connection is closed, and the MySQL process may have died. …
- 7,445
1
vote
Database error importing from localhost to live site?
Transferring sites between platforms can be tricky. As you discovered, Akeeba Backup (or similar backup extensions) simplify this error-prone task.
- 7,445
2
votes
I can load data from Joomla database and external database?
To solve the requirement, it is better if you enable the acces at MySQL level. If the two databases are local, you can just a ssign permissions to access the second database to your database user. … In this way, the multi-database query is solved efficiently by MySQL server. …
- 7,445
3
votes
Join an existing table with a generated table of dates and count rows for each date?
You can just execute it in the same way than a simple query.
db->setQuery($my_big_query);
$row = $db->loadObject();
Of course, it would be very difficult to translate the SQL statement to …
- 7,445