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?
Go to bottomPage: 123
TOPIC: SQL Error
#20685
SQL Error 13 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 13 Years, 6 Months ago Karma: 763
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 13 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 13 Years, 5 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 13 Years, 5 Months ago Karma: 763
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 13 Years, 5 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