HI,
Joomla fronted show this error but backed is working fine. i don't understand  what is the issue.

1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-08-21 10:4' at line 1

Select all Open in new window

Please help me.
Thanx

To activate some paid themes or plugins for websites (cms), buyers need a code. Otherwise the addons are not activated. I'm interested by this functionnality, but i have no idea where to start. Can someone point me in the right direction ? I have some addons and also websites for demo purpose, but i need to protect them. This kind of addons i'm talking about, need a code only once. Then the addon/website or whatever is accessible for everyone.
 I'm using php/css/html/javascript. The passcode/key protection i'm looking for is used by plugins and graphic themes sellers. To ensure the buyer has paid the addon and/or don't use it more than once. The target cms are wordpress, joomla, magento ...
Thank you.
X. Lin

In my Joomla template the field that shows user chosen states and countries is: <?php echo $field->value;?> <?php } ?> from code below:

ON the front-end the result looks like:

Arizona,Colorado,New Mexico,Oklahoma,Texas, Germany,New Zealand

I need all states and countries to be in a list and also represented graphically. Perhaps, there is a grayish image of the world, and Arizona,Colorado, etc are selected somehow. It needs to be light, so I was thinking of using CSS, but perhaps someone has other ideas, like Google KLM. I do not have the graphics set for the Staes and countries. MY countries and states list used on the site is attached below.

sample page where this will be used, look at "swap for": http://tradeproperty.org/index.php/listing/listing-with-all-fields-or-most
that area is about 400-500px wide and can be tall. You can use php, CSS, javascript.

<span class="label label-default"><div class="editlinktip hasTip" title="<?php echo $field->field_label;?>::<?php echo $field->field_description?>">
														<?php echo $field->field_label;?>
													</div></span>
												<?php
												}else{
													?>
													<?php echo $field->field_label;?>
												<?php
												}
											}
											?>
											<?php
											if($field->displaytitle == 1){
												?>
												:&nbsp;
											<?php } ?>
											<?php if(($field->displaytitle == 1) or ($field->displaytitle == 3)){?>
												<?php 

Select all Open in new window

…

I'm running Joomla 3.8.7 When I make a category the default home page all the articles cut off like there was a "read more" character in the article with the exception that there is no "read more" button. I cannot figure out what I have done to cause this behavior. I've tested my process on another 3.8.7 site and things behave as expected so it's got to be something I'm doing on the current site. I'd be happy to use the new site except there is so much content to transfer. Any suggestions would be gratefully accepted. The site is dataqualitynetwork.net

Hello!
I use Joomla 3.8.6 and I was trying to upgrade Virtuemart to its the most recent version. I couldn't complete an upgrade unless I switched MySQL to MySQLi type of db in Joomla's "Global Configuration". Now everything seems to be working fine with both Joomla and VM. Still, I wonder what was it and is it Okay Joomla-wise to switch to MySQLi from MySQL just like that?

Cannot make joomla tags work again for my custom joomla component.
I did all steps regarding conent type adding from here https://docs.joomla.org/J3.x:Using_Tags_in_an_Extension
My table My content type

INSERT INTO `dbasenew`.`iis_content_types` (`type_id`, `type_title`, `type_alias`, `table`, `rules`, `field_mappings`, `router`, `content_history_options`) VALUES (NULL, 'Sermon', 'com_sermonials.sermon', '{"special":{"dbtable":"#__sermonials_sermons","key":"id","type":"Sermon","prefix":"SermonsTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}} ', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"state","core_alias":"null","core_created_time":"date","core_modified_time":"null","core_body":"about", "core_hits":"null","core_publish_up":"null","core_publish_down":"null","core_access":"null", "core_params":"null", "core_featured":"null", "core_metadata":"null", "core_language":"null", "core_images":"null", "core_urls":"null", "core_version":"null", "core_ordering":"ordering", "core_metakey":"null", "core_metadesc":"null", "core_catid":"null", "core_xreference":"null", "asset_id":"asset_id"}, "special": {"author":"author", "scripture":"scripture", "chapter":"chapter", "verse":"verse", "when":"when", "scripture2":"scripture2"}} ', '', '{"formFile":"administrator\\/components\\/com_sermonials\\/models\\/forms\\/field.xml", 

Select all Open in new window

…

Hello Experts

I’m currently using a booking application for Joomla by a company called Koparent www.koparent.com. It is designed for users who want to lease any kind of service.

Unfortunately, for some reason the ability to convert currency from one currency to another has been lost - it can’t be done even on there demo site. I have tried reaching out to them for them to fix it, but I’m not getting any response. Therefore, can someone please let me know of any other booking application for Joomla?

I would very much appreciate any recommendations

Cheers

Carlton

I need to display a module on mobile only.  I put it on the desktop in the top right position and set the module class suffix as [space]hidden-desktop.  It does show on the mobile, but still shows on the desktop.  Is there another setting to make, so it won't show on the desktop?  Thanks.

I'm looking to understand the Joomla account activation string. It ends with 'menuid' and 'Itemid' numbers. But I've played with these, and they don't seem to do anything. I was hoping that changing these would enable me to land the activating user on whatever page I wanted, but this doesn't seem to be the case.

Here's an example:

https://site.com/component/users/?task=registration.activate&token=d0f0b518c5597e26c4bba17cf5fce984&menuid=319&Itemid=256

Select all Open in new window

What is the purpose of the 'menuid' and 'Itemid' numbers in the Joomla activation link query string?

Thanks,
Jonathan

what are the free web hosting  and blogging service providers/services that allow monetization ( eg: google adsense)

I am trying to move a website to a new Linux server.  The Server has Apache httpd service running.  I have unzipped the home directory of the site to its original folder which is /home/user1/www.websitename.com/web/httpdocs.  The files are below this.  I am not able to browse to the website when I connect to the folder.  How can I get this to work?