Fatal Errors in OSC in Admin and catalog when installing QtPro 4.6

[jgrammes]

I have installed Qtpro 4.6.1. I have read through many postings, and frankly am a bit new to OSC.

 

I have followed the instructions precisely per the manual (I think) but I am getting errors in the admin of the site, as well as on the site. Here they are:

 

In the Admin:

 

When I click on Categories/Products under catalog as if to add another product, I get a white page that displays this error:

 

Fatal error: Call to undefined function qtpro_doctor_investigate_product() in /home/content/30/7314430/html/catalog/admin/categories.php on line 17

 

 

Also, I notice when I click on "Prod Info (Qtpro)" under configuration, and then on "Product Info Attributes Display Plugin", it shows this error:

 

Fatal error: Call to undefined function tep_cfg_pull_down_class_files() in /home/content/30/7314430/html/catalog/admin/configuration.php(106) : eval()'d code on line 1

 

In the Catalog:

 

When I click on a product and it opens, I see this error:

 

'ota1126512420765.TABLE_PRODUCTS_STOCK' doesn't exist

 

SELECT products_stock_attributes, products_stock_quantity FROM TABLE_PRODUCTS_STOCK WHERE products_id=60 ORDER BY products_stock_attributes

 

[TEP STOP]

 

And also under the product description it displays "1146-Table".

 

Can any help? What am I doing wrong? Are both of these errors linked together? The website is www.otaeshoes.com

 

Thanks in advance.

Edited October 4, 2011 by jgrammes

[Guest]

Jason,

 

It appears you failed to run the SQL statement to update your database for use with QTPro

 

 

 

 

Chris

[jgrammes]

Can you advise me how to do that?

[Guest]

Jason,

 

In the QTPro download there is an SQL file. Log into your hosting account database and use phpmyadmin to run the statement. This will create the tables and fields needed for the contribution.

 

 

 

 

Chris

[jgrammes]

I have done so...I think. I went to 'import' and selected the SQL file, clicked go, and this is the error it gave me:

 

Error

 

SQL query:

# ===== QTPro =====

# These are database changes for a store that does not have a previous version of QT Pro installed.

# These database changes must be run uppon installation for the contribution to work.

# ====================

# Add new column to products_options to indicate if stock should be tracked for an option

ALTERTABLE products_options ADD products_options_track_stock tinyint( 4) default'0' NOTNULL AFTER products_options_name;

MySQL said:

#1060 - Duplicate column name 'products_options_track_stock'

 

 

Was there something else or another was I was to do this?

[jgrammes]

Can anyone help me with the above problems?