Unknown column 'GroupingID' in 'field list'

I am seeing the following (Unknown column 'GroupingID' in 'field list') on every page on my live server. store.strikephoto.com

nothing else below the top navigation bar. I have checked my globals, database, and localhost php files as per the instructions and this forum and am beyond frustrated.

I am ready to give up on this "easy to implement" software

Any help would be greatly appreciated

oh, and this is happening on both my test server and live server.. still stumped.

the productoptions tabel in your database has not been properly set up. have you run the store.sql file on your database to create all of the tables needed for power store? see the "How to import a MySQL (.SQL) file to your database" tutorial in the How To Section of the PowerStore support page:

powerstore/

Thanks Jason!!! i am going to give that a try.. I have been on this for almost a week now..

is there a difference between the free database supplied and the one that came with my Powerstore2?

Also, is this why i can only see the tops of the pages and no content?

Neil

Yes, the eCommerce database is different from the PowerStore database, you must use the PowerStore database with the PowerStore Solution pack.


The error is causing the rest of the page not to be processed.

that seemed to pix the sit!! Thanks!!

Now, when i click on the contact us or order history, i get the following error: Fatal error: Call to undefined function getsqlvaluestring() in /home/strikeph/public_html/store/CSSMenuWriter/intermediate.php on line 22

any ideas?

try adding the following at line 1 of the CSSMenuWriter/intermediate.php file:

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }



  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);



  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;    

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}

?>

PERFECT!! Thanks!!