Search
Other Articles Anywhere questions
Forum

Two external databases on the same page. images and titles not showing

seereen's Avatar seereen
Hi,

Get data from an external database.
I have displayed two articles on two external databases on the same page.
Images are not showing and titles are not showing properly.
problem page link: http://202.139.216.17/centraldev/

202.183.164.148/demo/ar.jpg
        {article category="infographic" database="db1"}
        <div class="col">
            <div class="card-thumbnail">
                <p>[image-intro replace="src=\"images/=>src=\"http://202.139.216.17/amnatchrdev/images/"]</p>
                <div class="panel">
                    <a href="http://202.139.216.17/amnatchrdev/[url]">
                        <h4 class="media-heading">[title]</h4>
                    </a>
                    <p class="foot-thumbnail"><span class="published">[created format="d F Y"]</span> <span class="badge bg-69 float-end">จ. หนองคาย</span></p>
                </div>
            </div>
        </div>
        {/article}
    {article category="infographic" database="db2"}
    <div class="col">
        <div class="card-thumbnail">
            <p>[image-intro replace="src=\"images/=>src=\"http://202.139.216.17/bungkandev/images/"]</p>
            <div class="panel">
                <a href="http://202.139.216.17/bungkandev/[url]">
                    <h4 class="media-heading">[title]</h4>
                </a>
                <p class="foot-thumbnail"><span class="published">[created format="d F Y"]</span> <span class="badge bg-1 float-end">จ. กำแพงเพชร</span></p>
            </div>
        </div>
    </div>
    {/article}


Thanks for your help and advises.
Peter van Westen's Avatar Peter van Westen ADMIN
It looks like the images on the second database have a src that start with "/central/images", not "images/".
But hard to tel from just the final output, as the Joomla SEF plugin will change/correct URLs after rendering.
Please post a rating at the Joomla! Extensions Directory
seereen's Avatar seereen
Hi,Peter

Looks like it's forbidden to repeat. Is there a way to fix this or add multiple tag fields?

Two articles If something is different such as dates [modified format="d F Y"] and another [created format="d F Y"], it will be displayed. How to fix this?.

Thanks for your help and advises.
Peter van Westen's Avatar Peter van Westen ADMIN
Regarding the duplicate database issue, can you give me (super) admin and (s)ftp access so I can take a look?

You can use the 'Confidential information' button in the forum editor to hide sensitive information.

I don't understand what you mean with your question about the date tags...
Please post a rating at the Joomla! Extensions Directory
seereen's Avatar seereen
Confidential information:
(hidden)


Thanks in advance for your help
Peter van Westen's Avatar Peter van Westen ADMIN
I would also need the (s)ftp access to be able to see what is going on.
Please post a rating at the Joomla! Extensions Directory
seereen's Avatar seereen
Confidential information:
(hidden)
seereen's Avatar seereen
Hi,Peter

use an external database Articles cannot be duplicated.
There must be something different, it works,
can I create my custom such as [NKI], [ATG]? it's list of provinces in Thailand abbreviation.

th.wikipedia.org/wiki/รายชื่ออักษรย่อของจังหวัดในประเทศไทย

Thanks.
Peter van Westen's Avatar Peter van Westen ADMIN
Sorry, I have no idea what you are asking for.
What do the Thailand abbreviation have to do with anything in Articles Anywhere?

So what issues do you now exactly have? And can you reproduce this in a simple article online where I can clearly see that issue?
Please post a rating at the Joomla! Extensions Directory
seereen's Avatar seereen
I have a problem when creating more than one article. Images and titles will not display correctly.
I found that if I add [something] that makes the articles different. It will be able to display pictures and titles correctly.
So I'm going to fix the problem by using the provincial abbreviation. But I don't know how

202.139.216.17/centraldev/administrator/...xicontent&view=items
{article category="Infographic" database="อำนาจเจริญ"}
    <div class="col">
        <div class="card-thumbnail">
            <p>[image-intro replace="src=\"images/=>src=\"http://202.139.216.17/amnatchrdev/images/"]</p>
            <div class="panel">
                <a href="http://202.139.216.17/amnatchrdev/[url]">
                    <h4 class="media-heading">[title]</h4>
                </a>
                <p class="foot-thumbnail">
                    <span class="published">[publish-up format="d F Y"]</span> 
                    <span class="badge bg-71 float-end">จ. อำนาจเจริญ</span>
                </p>
            </div>
        </div>
    </div>
{/article}
{article category="Infographic" database="บึงกาฬ"}
    <div class="col">
        <div class="card-thumbnail">
            <p>[image-intro replace="src=\"images/=&gt;src=\"http://202.139.216.17/bungkandev/images/"]</p>
            <div class="panel">
                <a href="http://202.139.216.17/bungkandev/[url]">
                 <h4 class="media-heading">[title]</h4>
                </a>
                <p class="foot-thumbnail">
                    <span class="published">[publish-up format="d F Y"]</span> 
                    <span class="badge bg-59 float-end">จ. บึงกาฬ</span>
                </p>
            </div>
        </div>
    </div>
{/article}
{article category="Infographic" database="อ่างทอง"}
    <div class="col">
        <div class="card-thumbnail">
            <p>[image-intro replace="src=\"images/=&gt;src=\"http://202.139.216.17/angthongdev/images/"]</p>
            <div class="panel">
                <a href="http://202.139.216.17/angthongdev/[url]">
                    <h4 class="media-heading">[title]</h4>
                </a>
                <p class="foot-thumbnail">
                    <span class="published">[publish-up format="d F Y"]</span> 
                    <span class="badge bg-25 float-end">จ. อ่างทอง</span>
                </p>
            </div>
        </div>
    </div>
{/article}
<p>{article category="Infographic" database="อยุธยา"}</p>
    <div class="col">
        <div class="card-thumbnail">
            <p>[image-intro replace="src=\"images/=&gt;src=\"http://202.139.216.17/ayuttayadev/images/"]</p>
            <div class="panel">
                <a href="http://202.139.216.17/ayuttayadev/[url]">
                    <h4 class="media-heading">[title]</h4>
                </a>
                <p class="foot-thumbnail">
                    <span class="published">[publish-up format="d F Y"]</span>
                    <span class="badge bg-14 float-end">จ. อยุธยา</span>
                </p>
            </div>
        </div>
    </div>
<p>{/article}</p>

For example, 4 articles will be displayed correctly for only 1 article. (image and title correctly only 1 article)

Thanks in advance for your help.
Peter van Westen's Avatar Peter van Westen ADMIN
So again: can you link me to an URL on the frontend where I can clearly see the issue.
And tell me where exactly you have this Articles Anywhere code.
Please post a rating at the Joomla! Extensions Directory
seereen's Avatar seereen
URL frontend
202.139.216.17/centraldev/

URL Backend
202.139.216.17/centraldev/administrator/...xicontent&view=items

Articles Anywhere code is at Menu Components > FLEXIcontent > Items

Thanks.
Peter van Westen's Avatar Peter van Westen ADMIN
Please try the latest development version from:
regularlabs.com/development-releases
Please post a rating at the Joomla! Extensions Directory
seereen's Avatar seereen
Hi, Peter

I am very glad. It works now! thank you a lot!

you Goooood.
Peter van Westen's Avatar Peter van Westen ADMIN
Ok, great. I had to change quite a bit in the code (regarding the database stuff) to make it all work.
So this requires some more thorough testing before I release it.

If you find anything not working now, let me know.
Please post a rating at the Joomla! Extensions Directory
You can only post on the extension support forum if you have an active subscription and you log in

Buy a Pro subscription