× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

linking subtables and templates

More
11 years 5 months ago - 11 years 5 months ago #1261 by adinet
linking subtables and templates was created by adinet
On my local server the links to the sub tables work

/*<div style="float:left;">
<label id="islabel" style="float:left; width: auto;" for="id_field" class="" aria-invalid="false">JooDB ⇐</label>
<select id="id_field" class="inputbox required" style="width: 80px" name="id_field" aria-required="true" required="required" aria-invalid="false">
<option>district_desc</option>
<option>id</option>
<option>district</option>
<option>state_id</option>
</select>
</div>*/

But on the database running on my providers server it result is

/*<div style="float:left;">
<label id="islabel" style="float:left; width: auto;" for="id_field" class="invalid" aria-invalid="true"></label>
<select id="id_field" class="inputbox required invalid" style="width: 80px" name="id_field" aria-required="true" required="required" aria-invalid="true">
<option></option>
</select>
</div>*/

On the providers site there are no options (hence not reading the table) and the JooDB ⇐ label is missing and the class="inputbox required invalid"
and aria-invalid="true". It is false on the local server. Any ideas

using Joomla 2.5.6 with Joodb pro
Last edit: 11 years 5 months ago by joest.

Please Log in to join the conversation.

More
11 years 5 months ago #1262 by Dirk
Replied by Dirk on topic Re: linking subtables and templates
More information please.
* Joomla version.
* Database version.

With Joomla 2.5
Go to "Site->System Information"
And look for "Database Version"

It's most likely a security problem.
Joodb uses ajax to get the table-list and the field-lists.
Can you see the table-list?

Use a debugger and check for javascript or xhr errors.

Please Log in to join the conversation.

More
11 years 5 months ago #1263 by adinet
Replied by adinet on topic Re: linking subtables and templates
joomla 2.5.6 and msql 5.1.66

Please Log in to join the conversation.

More
11 years 5 months ago #1264 by adinet
Replied by adinet on topic Re: linking subtables and templates
Cannot see any errors as yet and I can see the table list. I was using an external database and seen the problem so I copied them to the main joomla database with the same result.

Please Log in to join the conversation.

More
11 years 5 months ago #1265 by adinet
Replied by adinet on topic Re: linking subtables and templates
found this

SyntaxError: missing ) after argument list
[Break On This Error]

var tdesc = new Array("<?=JText::_( "RELATION1")?>","<?=JText::_( "RELATION2")?>...

jquery....min.js (line 2, col 37)


"CSS Usage: initializing extensions"

"NetworkError: 404 Not Found - tastradesmen.info//templates/trade/css/layout.css"

layout.css

"NetworkError: 404 Not Found - tastradesmen.info//templates/trade/css/personal.css"

personal.css

ReferenceError: getFieldList is not defined
[Break On This Error]

getFieldList();

index....nchange (line 2)

Please Log in to join the conversation.

More
11 years 5 months ago #1266 by Dirk
Replied by Dirk on topic Re: linking subtables and templates

adinet wrote: found this
var tdesc = new Array("<?=JText::_( "RELATION1")?>","<?=JText::_( "RELATION2")?>...


Well the problem is the "<?=" open tag.

99.9% of all sites have PHP short_open_tag set to ON.

Please try to set short_open_tag=on in your providers php.ini

Alternatively you can change all "<?=" to "<?php echo" in
/administrator/components/com_joodb/views/subitem/tmpl/default.php

And btw.: next time please post ALL relevant information.
joodb.feenders.de/forum/2-tutorials-and-...how-to-get-help.html
The following user(s) said Thank You: adinet

Please Log in to join the conversation.

Moderators: Dirkjoest