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


Recent Events
  • 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.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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?
Go to bottomPage: 123
TOPIC: SQL Error
#20685
SQL Error 12 Years, 6 Months ago Karma: 0
I installed Smart Content 1.8.1 on a Joomla 1.7 server. When I enable the plug-in, I get a blank home page. When I turn on debugging, it get the error message in the attached screen capture.
File Attachment:
File Name: Capture.zip
File Size: 50512
Last Edit: 2011/10/15 05:05 By msm_portata.
The administrator has disabled public write access.
 
#20686
Re:SQL Error 12 Years, 6 Months ago Karma: 747
Hello,

It doesn't look like "ARI Smart Content" error. Probably you use JoomFish or similar extension? We suppose this error related to language extension.

PS: If you provide temporary access to your J! backend by email, we will investigate the issue in more details.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#20687
Re:SQL Error 12 Years, 6 Months ago Karma: 0
When I disable Smart Content, the site works OK, so there is some conflict. We have Jooomlart and ARI Data installed as well as a few others.

I would give you access, but we are behind a corp firewall.

I will do some more digging.
The administrator has disabled public write access.
 
#21050
Re:SQL Error 12 Years, 6 Months ago Karma: 0
While poking around with the Joomla 1.7.1=>1.7.2 upgrade, I found the following two SQL files

administrator/components/com_admin/sql/updates/mysql/1.7.0-2011-06-06.sql
administrator/components/com_admin/sql/updates/mysql/1.7.0-2011-06-06-2.sql

I manually ran the code which created the missing column and solved the aforementioned problem.

I am now getting a the following new error:
JDatabaseMySQL::query: 1146 - Table 'Joomla.jos_arisc_config' doesn't exist SQL=SELECT ParamName,ParamValue FROM jos_arisc_config

Any ideas?
The administrator has disabled public write access.
 
#21053
Re:SQL Error 12 Years, 6 Months ago Karma: 747
It seems "jos_arisc_config" table was dropped. Execute the next SQL query to restore the table:

Code:


CREATE TABLE IF NOT EXISTS `jos_arisc_config` (
  `ParamName` varchar(100) NOT NULL,
  `ParamValue` varchar(255) NOT NULL,
  PRIMARY KEY  (`ParamName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



Regards,
ARI Soft
The administrator has disabled public write access.
 
#21114
Re:SQL Error 12 Years, 6 Months ago Karma: 0
We are getting closer.

I ran the SQL to create the table. Now when I enabled the Smart Content plug-in, the site no longer returns a blank screen. It looks like it works OK. However, the code in the articles does not get run. It just shows as the raw tags.

I tried to re-install Smart Content 1.8.1. The install message comes back as "Installing component was successful." but also includes this message:

Warning: Invalid argument supplied for foreach() in /ysi/www/html/libraries/joomla/database/database/mysqli.php on line 391

Is this an indication of more missing tables?

BTW, the Joomla version is 1.7.2. I also have ARI Data Tables installed.
The administrator has disabled public write access.
 
Go to topPage: 123