3

Found the answer. When I renamed the database I also had to re-assign the database user to this database.


3

json_encode() is correctly doing its thing. Double quoting is used to isolated keys and values; any double quotes inside of these data points must be escaped to maintain the integrity of the data (otherwise the data structure will break/fail when json decoded). If you tried to NOT json_encode() the iterable params data, then your code would fail because the ...


3

I had this issue now a second time on another system and tried to fix it the same way. I've recognized, that this could be fixed easier: Setup a new local Sytem of Joomla with the last running Joomla version (which was 3.9.3 in this case) Exported the database from the live system and imported it to my local Joomla Repaired all database failures with the ...


2

One of the last steps in the update process is to apply any schema changes, after files are copied in. If the one-click update fails, then the schema changes might not have been applied. This will result in warnings that your database is not up to date with the code. Navigate to Extensions > Manage > Database. If this is the problem, then you should see a ...


2

Although you could do this by direct database operations, when performing CRUD operations on records of Joomla core components it's best to use the Joomla Table class functionality, as this enables any associated data (eg data which is managed by plugins which register to receive notifications of record updates) to be updated. You can read about Table ...


2

For the purpose you are describing, your best bet is to create your own Joomla custom library. It's a type of Joomla extension alongside with plugins, modules and components, allowing you to put your custom common code. There is not much examples in Joomla documentation but Roberto Segura (phproberto) made an awesome example of a custom library available on ...


2

I see that Sharky has presented the best/correct solution, but I'd like to take a moment to build a bit of understanding around this occurrence. For the record, date is a MYSQL Keyword, but not a Reserved Keyword, so no quoteName() calls are necessary. First, what is the query that your script is generating... SELECT date FROM lmnop_db_reports WHERE 'date ...


2

The expression should not be quoted. ->where('date < NOW() - INTERVAL 30 DAY')


2

Articles are the small modular content inside the CMS content workflow, the Browser Page Title is managed by the structure of the MenĂº and the last part of this process comes from the direct assignment of the article title... by default. In the tab "Publishing" we have another options like Meta's, related to SEO, now, the option for add custom Browser Page ...


1

I think you are aware, that you can create hooks on install process. E.g. https://docs.joomla.org/J2.5:Managing_Component_Updates_(Script.php) https://docs.joomla.org/J3.x:Creating_a_simple_module/Adding_an_install-uninstall-update_script_file Here is my approach, where I after install publish plugin as an example https://github.com/gruz/NotificationAry/blob/...


1

JDatabaseDriver::quoteName() is for quoting SQL identifiers. Use JDatabaseDriver:quote() to quote and escape strings. $query->where($db->quoteName('element') . ' = ' . $db->quote('com_componentname'));


1

As @Sharky said, it seems like your SQLSRV extension isn't enabled. You can manually activate it by changing your php.ini file, enabling this extension and downloading the drivers. PHP Documentation says: The SQLSRV extension is enabled by adding appropriate DLL file to your PHP extension directory and the corresponding entry to the php.ini file. The SQLSRV ...


1

go to /administrator/index.php?option=com_installer&view=database click on fix


1

Checking the configuration.php file for specific IP addresses is probably a reasonable and sufficient precaution if you have reason to be concerned. In practice, and especially with shared hosting, server settings are usually set to "localhost" in the configuration.php file so there is no need to update any IP addresses in Joomla when moving to a new server....


1

This will rely heavily on the magic of a "pivot" technique. Here are some more examples in JSE to compare/contrast with https://joomla.stackexchange.com/questions/tagged/pivot. Basically, a WHERE clause will disqualify rows before grouping occurs. In this case, you only want to focus on data in the scope of FormId 14, so this should go in your ...


1

To connect Joomla! to a 3rd party app you will need an API connection. There are a few options: You can install Jbackend on Joomla and use rest API to access the database. https://extensions.joomla.org/extension/jbackend/ You can install TechJoomla's API https://techjoomla.com/free-downloads/rest-api-for-joomla You can wait for Joomla! 4 which is ...


1

Found a way by adding an another parameter as below: $db->updateObject('#__table2', $recObj, 'id', true); The 4th parameter determines whether null values can be used or not. Default this will be set as false. https://docs.joomla.org/API17:JDatabase::updateObject


1

I'd suggest running an Audit using Chrome Dev Tools. This will gauge your site performance and give you more details about what you can do to improve it. Alernatively, you can use https://web.dev which also uses Lighthouse behind the scenes. Seeing as you have a lot of assets, you'd ideally want to start lazy loading images. Chrome has a built-in attribute ...


1

The answer is that it's already an option! Just select Multiple: Yes in the field options; Multiple : if set to "No" the field will allow the selection of a single group of users, if set to "Yes" it will be possible to select multiple groups of users.


1

You should need to install "MS SQL server drivers for PHP" version 3.2 or 4.0. Unpack on php/ext folder and once done you have to enable the extension in php.ini such as extension=php_sqlsrv_7_x64.dll Notes: change dll filename based on your extracted files. don't mix x86 and x64 dlls you can use /path/to/file.dll instead of filename dll Finally ...


1

Zoo is another alternative. You can use Chronoforms and ChronoConnect. It isn't easy to setup. Chronoforms can't natively do "Join" on databases like Fabrik can. Here is a link to an example of Chronoforms & Connect together. https://blog.grimeymedia.com/chronoforms-chronoconnectivity-5-example/


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