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


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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?

How to verify arisqltable settings
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: How to verify arisqltable settings
#41590
How to verify arisqltable settings 4 Years, 4 Months ago Karma: 0
Hi!
I try to use arisqltable for the first time and get nothing.
I have succeeded using csv, but when trying sql it is nothing when viewing.

Like this:
{arisqltable} {ariconnectionstring dbHost="localhost" dbUser="xxxxxxx" dbPass="xxx" dbName="xxxxx" dbType="mysql" } {arisqltablecolumns} {arisqltablecolumn id="MyID" alias="ID" className="idg"} {/arisqltablecolumns} {arisqltablequery} SELECT `MyID` FROM `xxx_MyID` {/arisqltablequery} {/arisqltable}


How can I verify that the attributes are set correctly?
The administrator has disabled public write access.
 
#41607
Re:How to verify arisqltable settings 4 Years, 4 Months ago Karma: 666
Hello,

Download and upgrade the component then temporary set "Site -> Global Configuration -> Server -> Error Reporting" parameter to "Development" value on Joomla! configuration page.

After this page with "ARI JDataTable" should show PHP errors (warnings) if something works wrong.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#41719
Re:How to verify arisqltable settings 4 Years, 4 Months ago Karma: 0
Hi!
I did what you stated but still nothing. If I remove the ariconnectionstring section then an error appears, error 0.
But as I need the settings in the connectionstring I have to add it again and then nothing...
I have even removed the arisqltablecolumns to simplify it even more but still nothing.
It is as if the Error reporting setting didn't work.
Any more hints?
I use joomla 3.
The administrator has disabled public write access.
 
#41722
Re:How to verify arisqltable settings 4 Years, 4 Months ago Karma: 0
Hi again!
When I changed from mysql to msqli it started to work.
The administrator has disabled public write access.
 
#41730
Re:How to verify arisqltable settings 4 Years, 4 Months ago Karma: 666
Hello,

We suppose according to PHP configuration, it can't work with "mysql" driver, but it supports "mysqli".

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