Using the "admin" section causes error

maddhouz · 8-26-03, 06:02 PM

Whenever I insert a new item in my cart, I get this error:

1226 - User 'XXXX' has exceeded the 'max_questions' resource (current value: 36000)

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]

I then change the user name manually in my configure file in the admin/includes folder so that I may continue adding products. As soon as I enter another item, I get the same error after saving the product.

Is there a way to stop this error? I'm only able to enter one product each time and then I get the error. How is it that I'm exceeding the max question just by entering one product? Is it the codes?

I use "username1" in the catalog/includes/configure.php so that my visitors won't get that error. I've notice that works fine.

I use "username2" and "username3" in the admin/includes/configure.php.

Now I have to wait for both username2 & 3 to reset. Can someone Help?

maddhouz · 9-4-03, 12:35 AM

Here's my configure code:

<?php
/*
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2003 osCommerce

Released under the GNU General Public License
*/

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://domain.com'); // eg, http://localhost or - https://localhost should not be empty for productive servers
define('HTTP_CATALOG_SERVER', 'http://domain.com');
define('HTTPS_CATALOG_SERVER', 'https://domain.com');
define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module
define('DIR_FS_DOCUMENT_ROOT', '/www/d/domain/htdocs/'); // where the pages are located on the server
define('DIR_WS_ADMIN', '/Store/admin/'); // absolute path required
define('DIR_FS_ADMIN', '/www/d/domain/htdocs/Store/admin/'); // absolute pate required
define('DIR_WS_CATALOG', '/Store/catalog/'); // absolute path required
define('DIR_FS_CATALOG', '/www/d/domain/htdocs/Store/catalog/'); // absolute path required
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

// define our database connection
define('DB_SERVER', 'mysql02.powweb.com'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'username3');
define('DB_SERVER_PASSWORD', 'xxxxxxxxxx');
define('DB_DATABASE', 'xxxxxxxxx');
define('USE_PCONNECT', 'false'); // use persisstent connections?
define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'
?>

stevel · 9-4-03, 11:21 AM

I note that mysql02 has been flaky - there is an announcement about it. That might be your problem.

maddhouz · 9-4-03, 11:29 PM

Stevel, that's not the problem. I'm getting the same error after mysql02 was put online again.

I'm only able to input 1 product before I get the error. Something is wrong. How is it that I'm exceeding the max question (36000) just by entering one product? Is something looping?

stevel · 9-5-03, 09:17 AM

I don't know what to tell you - I never see this problem on my site and don't know enough about tbe inner workings to help diagnose it. Is this a new install of osc? Are you using PowWeb's version or something newer? Have you added any "contributions" to the code?

maddhouz · 9-5-03, 03:15 PM

It's not a new install. I'm using Powweb ver with no added codes.

It started one day after mysql02 went down. At that time, I was able to update at least 5 products before getting max out, which was no better.

My catalog is using "username1" which never max out for my customers. I'm using the other 2 username for the Admin section only.

Song · 9-6-03, 03:52 PM

Hi MadHouz,

I was recieving that error at the begining also. I dont quite remember what I did but after looking at your config.php (admin), I see slight descrepancy from mine. See if you can adapt it. Also, look closely at the Config.php(Catalog) area also. I will be visiting the forum to see how you are fairing. Good Luck!

----Song
"I still haven't figure out why penguins walk...It annoys me"
----------------------------------------------------------------------------------

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://www.yourdomain.com'); // eg, http://localhost - should not be empty for productive servers
define('HTTP_CATALOG_SERVER', 'http://www.yourdomain.com');
define('HTTPS_CATALOG_SERVER', 'https://www03.powweb.com:XXXXX');
define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module
define('DIR_FS_DOCUMENT_ROOT', '/www/X/XXXXX/htdocs/catalog/'); // where the pages are located on the server
define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required
define('DIR_FS_ADMIN', '/www/X/XXXXX/htdocs/catalog/admin/'); // absolute pate required
define('DIR_WS_CATALOG', '/catalog/'); // absolute path required
define('DIR_FS_CATALOG', '/www/X/XXXXX/htdocs/catalog/'); // absolute path required
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

// define our database connection
define('DB_SERVER', 'mysql03.powweb.com'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'XXXXX');
define('DB_SERVER_PASSWORD', 'XXXXX');
define('DB_DATABASE', 'XXXXX');
define('USE_PCONNECT', 'false'); // use persisstent connections?
define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

maddhouz · 9-8-03, 08:49 PM

Hey Song,

Thanks for the help.

Before: define('STORE_SESSIONS', ''); added "mysql" between quotes.

After: define('STORE_SESSIONS', 'mysql');

Before: define('DIR_FS_DOCUMENT_ROOT', '/www/d/domain/htdocs/'); added "Store" after htdocs/

After: define('DIR_FS_DOCUMENT_ROOT', '/www/d/domain/htdocs/Store/');

Your code helped a great deal. After I changed my code, I updated 3 files in a row with no problems, something I wasn't able to do before. Also updated quick. Before it took around 10 seconds, this time 1 sec.

Thanks Again,

Maddhouz

Song · 9-8-03, 09:25 PM

Hello Madhouze,

The following recommendations came to my mind as I joggled my memory. Please compare them to yours and please remember to backup any files before trying them.

Good Luck to you!

--- Song
"The dilemma was resolved when I found out that Penguins and Chihuahuas are really human beings...they are unsually little"

------------------------------------------------------------------------------------

LOGGING (Back office - admin/My store)

Title Value Action
Store Page Parse Time = false
Log Destination = /var/log/www/tep/page_parse_time.log
Log Date Format =
%d/%m/%Y %H:%M:%S
Display The Page Parse Time = true
Store Database Queries = false

-----------------------------------------------------------------------------------

CACHE (Back office - Admin/ My store configuration)

Title Value Action
Use Cache = false
Cache Directory= /tmp/
-----------------------------------------------------------------------------------

Config.php (catalog Area):

*/

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://www.yourdomain.com'); // eg, http://localhost - should not be empty for productive servers
define('HTTPS_SERVER', 'https://XXXXX.powweb.com:XXXXX'); // eg, https://localhost - should not be empty for productive servers
define('ENABLE_SSL', 'true'); // secure webserver for checkout procedure?
define('HTTP_COOKIE_DOMAIN', 'www.yourdomain.com');
define('HTTPS_COOKIE_DOMAIN', 'XXXXX.powweb.com:XXXXX');
define('HTTP_COOKIE_PATH', '/catalog/');
define('HTTPS_COOKIE_PATH', '/catalog/');
define('DIR_WS_HTTP_CATALOG', '/catalog/');
define('DIR_WS_HTTPS_CATALOG', '/catalog/');
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
define('DIR_FS_CATALOG', '/www/v/viladdia/htdocs/catalog/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// define our database connection
define('DB_SERVER', 'mysql03.powweb.com'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'USERNAME');
define('DB_SERVER_PASSWORD', 'PASSWORD');
define('DB_DATABASE', 'XXXXX');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

maddhouz · 9-9-03, 12:00 PM

I did back up my files before I made the changes. It is working correctly.

Many Thanks.

8-26-03, 06:02 PM	#1
maddhouz Madd Radio Join Date: Dec 2002 Location: Chicago, IL Posts: 92 Reputation: 7	exceeding the max question just by entering one product? Whenever I insert a new item in my cart, I get this error: 1226 - User 'XXXX' has exceeded the 'max_questions' resource (current value: 36000) select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] I then change the user name manually in my configure file in the admin/includes folder so that I may continue adding products. As soon as I enter another item, I get the same error after saving the product. Is there a way to stop this error? I'm only able to enter one product each time and then I get the error. How is it that I'm exceeding the max question just by entering one product? Is it the codes? I use "username1" in the catalog/includes/configure.php so that my visitors won't get that error. I've notice that works fine. I use "username2" and "username3" in the admin/includes/configure.php. Now I have to wait for both username2 & 3 to reset. Can someone Help? Last edited by maddhouz : 9-4-03 at 12:26 AM.

9-4-03, 11:21 AM	#3
stevel XPW Join Date: Jun 2002 Location: New Hampshire, USA Posts: 9,464 Reputation: 265	I note that mysql02 has been flaky - there is an announcement about it. That might be your problem. __________________ Steve

9-5-03, 09:17 AM	#5
stevel XPW Join Date: Jun 2002 Location: New Hampshire, USA Posts: 9,464 Reputation: 265	I don't know what to tell you - I never see this problem on my site and don't know enough about tbe inner workings to help diagnose it. Is this a new install of osc? Are you using PowWeb's version or something newer? Have you added any "contributions" to the code? __________________ Steve

9-8-03, 08:49 PM	#8
maddhouz Madd Radio Join Date: Dec 2002 Location: Chicago, IL Posts: 92 Reputation: 7	Hey Song, Thanks for the help. Before: define('STORE_SESSIONS', ''); added "mysql" between quotes. After: define('STORE_SESSIONS', 'mysql'); Before: define('DIR_FS_DOCUMENT_ROOT', '/www/d/domain/htdocs/'); added "Store" after htdocs/ After: define('DIR_FS_DOCUMENT_ROOT', '/www/d/domain/htdocs/Store/'); Your code helped a great deal. After I changed my code, I updated 3 files in a row with no problems, something I wasn't able to do before. Also updated quick. Before it took around 10 seconds, this time 1 sec. Thanks Again, Maddhouz Last edited by maddhouz : 9-9-03 at 11:54 AM.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

9-4-03, 12:35 AM	#2
maddhouz Madd Radio Join Date: Dec 2002 Location: Chicago, IL Posts: 92 Reputation: 7	Here's my configure code: <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License / // Define the webserver and path parameters // DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://domain.com'); // eg, http://localhost or - https://localhost should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://domain.com'); define('HTTPS_CATALOG_SERVER', 'https://domain.com'); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/www/d/domain/htdocs/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/Store/admin/'); // absolute path required define('DIR_FS_ADMIN', '/www/d/domain/htdocs/Store/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/Store/catalog/'); // absolute path required define('DIR_FS_CATALOG', '/www/d/domain/htdocs/Store/catalog/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); // define our database connection define('DB_SERVER', 'mysql02.powweb.com'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'username3'); define('DB_SERVER_PASSWORD', 'xxxxxxxxxx'); define('DB_DATABASE', 'xxxxxxxxx'); define('USE_PCONNECT', 'false'); // use persisstent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' ?>

9-4-03, 11:29 PM	#4
maddhouz Madd Radio Join Date: Dec 2002 Location: Chicago, IL Posts: 92 Reputation: 7	Stevel, that's not the problem. I'm getting the same error after mysql02 was put online again. I'm only able to input 1 product before I get the error. Something is wrong. How is it that I'm exceeding the max question (36000) just by entering one product? Is something looping?

9-5-03, 03:15 PM	#6
maddhouz Madd Radio Join Date: Dec 2002 Location: Chicago, IL Posts: 92 Reputation: 7	It's not a new install. I'm using Powweb ver with no added codes. It started one day after mysql02 went down. At that time, I was able to update at least 5 products before getting max out, which was no better. My catalog is using "username1" which never max out for my customers. I'm using the other 2 username for the Admin section only.

9-6-03, 03:52 PM	#7
Song Join Date: Jul 2003 Location: Pittsburgh Posts: 55 Reputation: 5	Hi MadHouz, I was recieving that error at the begining also. I dont quite remember what I did but after looking at your config.php (admin), I see slight descrepancy from mine. See if you can adapt it. Also, look closely at the Config.php(Catalog) area also. I will be visiting the forum to see how you are fairing. Good Luck! ----Song "I still haven't figure out why penguins walk...It annoys me" ---------------------------------------------------------------------------------- // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://www.yourdomain.com'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://www.yourdomain.com'); define('HTTPS_CATALOG_SERVER', 'https://www03.powweb.com:XXXXX'); define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/www/X/XXXXX/htdocs/catalog/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required define('DIR_FS_ADMIN', '/www/X/XXXXX/htdocs/catalog/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/catalog/'); // absolute path required define('DIR_FS_CATALOG', '/www/X/XXXXX/htdocs/catalog/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); // define our database connection define('DB_SERVER', 'mysql03.powweb.com'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'XXXXX'); define('DB_SERVER_PASSWORD', 'XXXXX'); define('DB_DATABASE', 'XXXXX'); define('USE_PCONNECT', 'false'); // use persisstent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?>

9-8-03, 09:25 PM	#9
Song Join Date: Jul 2003 Location: Pittsburgh Posts: 55 Reputation: 5	Hello Madhouze, The following recommendations came to my mind as I joggled my memory. Please compare them to yours and please remember to backup any files before trying them. Good Luck to you! --- Song "The dilemma was resolved when I found out that Penguins and Chihuahuas are really human beings...they are unsually little" ------------------------------------------------------------------------------------ LOGGING (Back office - admin/My store) Title Value Action Store Page Parse Time = false Log Destination = /var/log/www/tep/page_parse_time.log Log Date Format = %d/%m/%Y %H:%M:%S Display The Page Parse Time = true Store Database Queries = false ----------------------------------------------------------------------------------- CACHE (Back office - Admin/ My store configuration) Title Value Action Use Cache = false Cache Directory= /tmp/ ----------------------------------------------------------------------------------- Config.php (catalog Area): / // Define the webserver and path parameters // DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://www.yourdomain.com'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://XXXXX.powweb.com:XXXXX'); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', 'true'); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'www.yourdomain.com'); define('HTTPS_COOKIE_DOMAIN', 'XXXXX.powweb.com:XXXXX'); define('HTTP_COOKIE_PATH', '/catalog/'); define('HTTPS_COOKIE_PATH', '/catalog/'); define('DIR_WS_HTTP_CATALOG', '/catalog/'); define('DIR_WS_HTTPS_CATALOG', '/catalog/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/www/v/viladdia/htdocs/catalog/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); // define our database connection define('DB_SERVER', 'mysql03.powweb.com'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'USERNAME'); define('DB_SERVER_PASSWORD', 'PASSWORD'); define('DB_DATABASE', 'XXXXX'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?>

9-9-03, 12:00 PM	#10
maddhouz Madd Radio Join Date: Dec 2002 Location: Chicago, IL Posts: 92 Reputation: 7	I did back up my files before I made the changes. It is working correctly. Many Thanks.