I am getting the same error, so this must be an issue with displaying articles by category.

I am also looking for the same advice [1.5.24 to 1.7.2 -- I have purchased SP Upgrade to perform the migration].
I have a 1.7.2 installation that is serving as a test site, where I installed K2 2.5.1, and attempted to import articles/items and I received this error:
"Fatal error: Class 'JSimpleXML' not found in /heXYZes/boXYZeb/weXYZ4/bXYZ7/sXYZnc/public_html/mXYZ172a/administrator/components/com_k2/models/items.php on line 716"

Clicking 'Parameters' [no icon visible BTW] opens a pop-up with this error:
"Fatal error: Call to a member function loadByOption() on a non-object in /heXYZes/boXYZeb/wXYZ4/bXYZ7/sXYZc/public_html/mXYZ172a/administrator/components/com_k2/models/settings.php on line 38"

On the Items tab, I have this error:
"Warning: Invalid argument supplied for foreach() in /heXYZes/boXYZeb/weXYZ34/bXYZ7/slXYZsdanc/public_html/mplXYZ172a/administrator/components/com_k2/views/items/tmpl/default.php on line 112"

On the Users tab, I have this error:
"Warning: Invalid argument supplied for foreach() in /heXYZes/boXYZeb/weXYZ4/bXYZ7/slXYZsdanc/public_html/mpXYZj172a/administrator/components/com_k2/models/users.php on line 222"

The three (3) K2 plug-in's are enabled: system, search, users

I will continue to search the Forum in case this was already addressed (didn't find it in a search).

Also, is there a calendar within K2, or is that a 3rd party extension (displayed in demo)? I am currently using JEvents but willing to switch if one is incorporated in K2 already.

My System Info:
Web Server Apache/2
PHP version 5.2.17
MySQL version 5.0.91-log
GD image library bundled (2.0.34 compatible)
Multibyte string support Enabled
Upload limit 8M
Memory limit 64M
Open remote files (allow url fopen) Yes

This is my first install of K2 and K2 Store. I have K2 installed and I got the Blog working on the front end which is what I wanted.

Now I want to add the store. I unzipped the current component and used the install manager as usual. It says that it was installed properly... all except this one error.

Warning: Invalid argument supplied for foreach() in /home/trishah/public_html/libraries/joomla/database/database/mysql.php on line 678

This relates to the last function on this page which I have shown below. Is this something I need to fix? If so, how?

UPDATE: I have tried to create my first product and there is no Buy Now button. I have gone over all the instructions several times and cannot find the problem. Could the above error have caused this?

Seeing errors in the component panel, unable to load samples and create categories:

Warning: Invalid argument supplied for foreach() in /hermes/bosweb/web091/b911/ipg.deusermaster1/love4ed/administrator/components/com_fpss/views/slides/view.html.php on line 51

Warning: Invalid argument supplied for foreach() in /hermes/bosweb/web091/b911/ipg.deusermaster1/love4ed/administrator/components/com_fpss/views/slides/tmpl/default.php on line 62

After trying to create category:
FPSSCategory: :store failed
Unknown column 'ordering' in 'field list' SQL=INSERT INTO `jml_fpss_categories` (`id`,`name`,`published`,`ordering`,`language`,`params`) VALUES ('','New Articles','1','','*','{\"imageWidth\":\"500\",\"imageQuality\":\"90\",\"thumbWidth\":\"100\",\"thumbQuality\":\"75\",\"previewWidth\":\"900\",\"previewQuality\":\"90\",\"title\":\"1\",\"text\":\"1\",\"tagline\":\"1\",\"category\":\"1\",\"author\":\"1\",\"readmore\":\"1\",\"target\":\"_self\",\"liveData\":\"1\"}')

I am building a new site in Joomla 1.7, and I am getting an error in K2 that will not allow me to view the articles in the category.

Link to see the error: knowndonorregistry.com/index.php/articles/itemlist/category/5-how-to

Error:
Warning: mysqli_close() [function.mysqli-close]: Couldn't fetch mysqli in /home/knowndon/public_html/libraries/joomla/database/database/mysqli.php on line 148

Does anyone know what this is or how to fix it? I really need K2 for this site...

Success!! :D It must have been the quote thing, because now I'm getting output "Item ID is : 27"! Thank you so much :D:D:D

Let it be known (in case anyone out there hasn't noticed) that SQL is a HUGE pain in the neck if you don't get the syntax right!

Here's the working code for reference:And the output is "Item ID is : 27"

(Thanks again!)

Hola!

Quisiera saber por que ocurre este error en la instalacion del componente k2 v 2.2.

Warning: Invalid argument supplied for foreach() in Home...........\mysql.php on line 676

trabajo con la version de joomla 1.5.8

gracias.

I've just finished upgrading and used jupgrade. I still have the upgrade sitting in the jugrade folder while I set up the template.

Still after the upgrade I cannot get the frontend submititem menu working. The add link from the profile works well. I also have the menu set up as render. Not sure if it matters, but I'm with Bluehost.

I have checked the SQL database and have the following link for the menu item

index.php?option=com_k2&view=item&layout=itemform&task=add

The params are

{"theme":"default","category":"2","menu-anchor_title":"","menu-anchor_css":"","menu_image":"","menu_text":1,"page_title":"","show_page_heading":0,"page_heading":"","pageclass_sfx":"","menu-meta_description":"","menu-meta_keywords":"","robots":"","secure":0}

Is there anything else I can check? Getting 404 error component not found.

Thanks

Hi,
I get installer error in Joomla 1.5.23 trying to install FPSS, see details belowJInstaller::install: SQL Error. DB function failed with error number 1005
Can't create table 'jos_fpss_categories' (errno: 13) SQL=CREATE TABLE IF NOT EXISTS `jos_fpss_categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `published` tinyint(1) unsigned NOT NULL, `ordering` int(11) NOT NULL, `language` char(7) NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`), KEY `published` (`published`), KEY `ordering` (`ordering`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SQL = CREATE TABLE IF NOT EXISTS `jos_fpss_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `published` tinyint(1) unsigned NOT NULL,
  `ordering` int(11) NOT NULL,
  `language` char(7) NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `published` (`published`),
  KEY `ordering` (`ordering`),
  KEY `language` (`language`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1005
Can't create table 'jos_fpss_categories' (errno: 13) SQL=CREATE TABLE IF NOT EXISTS `jos_fpss_categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `published` tinyint(1) unsigned NOT NULL, `ordering` int(11) NOT NULL, `language` char(7) NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`), KEY `published` (`published`), KEY `ordering` (`ordering`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SQL = CREATE TABLE IF NOT EXISTS `jos_fpss_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `published` tinyint(1) unsigned NOT NULL,
  `ordering` int(11) NOT NULL,
  `language` char(7) NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `published` (`published`),
  KEY `ordering` (`ordering`),
  KEY `language` (`language`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;