Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

join not working
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: join not working
#29851
join not working 12 Years, 4 Months ago Karma: 0
Help would be appreciated.
This is my sql query:

{arijdatatable bPaginate="true"} {arisqltable} {arisqltablequery}SELECT id AS ID,firstname AS NAME, lastname AS Surname, cb_membershipcategory AS Category, cb_membersince AS MbSince, cb_renewaldate AS RenewDate, cb_organisationname AS Company, cb_city AS City, cb_country AS Country, cb_membershipstatus AS Status, email AS Email FROM qgth1_comprofiler INNER JOIN qgth1_users ON qgth1_comprofiler.id=qgth1_users.id {/arisqltablequery} {/arisqltable}{/arijdatatable

It returns a blank page.
But, SQL on one table without INNER JOIN works fine.
Many thanks for any suggestions.
The administrator has disabled public write access.
 
#29855
Re:join not working 12 Years, 4 Months ago Karma: 760
Hello,

The extensions supports all constructions which are supported by database. In your case a blank page appears because a PHP error occurs, it appears if "memory_limit" is exhausted.

Install PHP Settings plugin and try to increase value of "memory_limit" PHP variable. If it doesn't help, provide a link to a page where the problem occurs and a temporary access to your J! backend by email so we can investigate the problem.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1