Admin Error: BOX_REPORTS_STATS_AVERAGE

[yodergraphics]

Under Admin>Reports, the stats link displays the text "BOX_REPORTS_STATS_AVERAGE"

 

When you click on it, you get a 404 error page displaying:

 

"http://stitchpiecenpurl.com/catalog/admin/customer_export.php 70.61.234.157 /catalog/admin/FILENAME_STATS_AVERAGE stitchpiecenpurl.com Opera/9.02 (Macintosh; PPC Mac OS X; U; en) 404"

 

The server was recently upgraded to PHP version 5.0.4/MySQL version 4.1.21-standard, and may be causing this.

 

Is this a MySQL syntax error, and what file should I edit?

 

It may/may not be related to this, but just as background info, I also had to fix the common "1064 error":

 

1064 MySQL error:

http://www.oscommerce.com/forums/index.php?showtopic=144095

 

Bug Fix: http://www.oscommerce.com/community/bugs,1605

 

Thanks for your help!

 

[GulSar Ray's]

Under Admin>Reports, the stats link displays the text "BOX_REPORTS_STATS_AVERAGE"

 

When you click on it, you get a 404 error page displaying:

 

"http://stitchpiecenpurl.com/catalog/admin/customer_export.php 70.61.234.157 /catalog/admin/FILENAME_STATS_AVERAGE stitchpiecenpurl.com Opera/9.02 (Macintosh; PPC Mac OS X; U; en) 404"

 

The server was recently upgraded to PHP version 5.0.4/MySQL version 4.1.21-standard, and may be causing this.

 

Is this a MySQL syntax error, and what file should I edit?

 

It may/may not be related to this, but just as background info, I also had to fix the common "1064 error":

 

1064 MySQL error:

http://www.oscommerce.com/forums/index.php?showtopic=144095

 

Bug Fix: http://www.oscommerce.com/community/bugs,1605

 

Thanks for your help!

 

 

FILENAME_STATS_AVERAGE is not defined in includes/filename.php file

[yodergraphics]

FILENAME_STATS_AVERAGE is not defined in includes/filename.php file

 

Thanks!

 

This is what I did so far:

 

 

in Admin/Includes/filenames.php

 

added:

 

define('FILENAME_STATS_AVERAGE', 'stats_low_stock_attrib.php');

--------

in

admin/includes/boxes/filenames.php

 

added:

define('FILENAME_STATS_AVERAGE', 'stats_low_stock_attrib.php');

-----

 

In admin/includes/languages/english.php

 

Added

 

define('BOX_REPORTS_STATS_AVERAGE', 'Low Stock Report');

------

 

Now I get this error:

 

1146 - Table 'stitchpi_osc1.TABLE_PRODUCTS_STOCK' doesn't exist

 

SELECT products_stock_attributes, products_stock_quantity FROM TABLE_PRODUCTS_STOCK WHERE products_id=1871 AND products_stock_quantity < '5' ORDER BY products_stock_attributes

 

stitchpi_osc1 is the name of our MySQL database

[yodergraphics]

Now I get this error:

 

1146 - Table 'stitchpi_osc1.TABLE_PRODUCTS_STOCK' doesn't exist

 

SELECT products_stock_attributes, products_stock_quantity FROM TABLE_PRODUCTS_STOCK WHERE products_id=1871 AND products_stock_quantity < '5' ORDER BY products_stock_attributes

 

stitchpi_osc1 is the name of our MySQL database

 

 

TABLE_PRODUCTS_STOCK

is apparently not a standard osCommerce table, and is added by the Easy Populate contrib.

 

See Easy Populate Thread

[yodergraphics]

TABLE_PRODUCTS_STOCK

is apparently not a standard osCommerce table, and is added by the Easy Populate contrib.

 

See Easy Populate Thread

 

 

This may be related to a QTYpro / QTPro 4.2 clash with Easy Populate 2.76-MS2

 

 

From the QT Pro 4.0 sql database file:

 

DROP TABLE IF EXISTS products_stock;
CREATE TABLE products_stock (
 products_stock_id int(11) not null auto_increment,
 products_id int(11) default '0' not null ,
 products_stock_attributes varchar(255) not null,
 products_stock_quantity int(11) default '0' not null ,
 PRIMARY KEY (products_stock_id),
 UNIQUE idx_products_stock_attributes (products_id,products_stock_attributes)
);

 

Possibly need to gut out QT Pro and/or Easy Populate??

[GulSar Ray's]

This may be related to a QTYpro / QTPro 4.2 clash with Easy Populate 2.76-MS2

From the QT Pro 4.0 sql database file:

 

DROP TABLE IF EXISTS products_stock;
CREATE TABLE products_stock (
 products_stock_id int(11) not null auto_increment,
 products_id int(11) default '0' not null ,
 products_stock_attributes varchar(255) not null,
 products_stock_quantity int(11) default '0' not null ,
 PRIMARY KEY (products_stock_id),
 UNIQUE idx_products_stock_attributes (products_id,products_stock_attributes)
);

 

Possibly need to gut out QT Pro and/or Easy Populate??

Check whether TABLE_PRODUCTS_STOCK this is defined in includes/database_tables.php file or not

[yodergraphics]

Check whether TABLE_PRODUCTS_STOCK this is defined in includes/database_tables.php file or not

 

No, I didn't have that defined in either includes/database_tables.php or in admin/includes/database_tables.php

 

and I should have if this was fully installed correctly.

 

//++++ QT Pro: Begin Changed code
 define('TABLE_PRODUCTS_STOCK', 'products_stock');
//++++ QT Pro: End Changed Code

 

It seems like it was partially installed at some point.

 

I'm going to fully reinstall the current QT Pro 4.5 contrib., checking every file for missing code. There is missing code everywhere. Not sure why, other than we had a sever crash and old files may have been restored.

 

Thanks for your help.