i have tons of debug logs

[DrByte]

Okay, here's how the code works:
1. It checks to see if there's a missing entry for 0-1-TEXT
2. If there is no such entry, it attempts to insert it.

Yours is failing because it didn't find the entry and tried to insert it, but found that the entry is actually already there.

How is that possible?

Perhaps you have other addons in your site that tamper with normal SQL operation, such as old caching tools like old QueryCache or something like that.

[Dashizna]

Okay, here's how the code works:
1. It checks to see if there's a missing entry for 0-1-TEXT
2. If there is no such entry, it attempts to insert it.

Yours is failing because it didn't find the entry and tried to insert it, but found that the entry is actually already there.

How is that possible?

Perhaps you have other addons in your site that tamper with normal SQL operation, such as old caching tools like old QueryCache or something like that.

i have no idea how can i uninstall anything like that?

[DrByte]

I was hoping you might at least know what plugins you've installed on your own site.

[neteasy]

Okay, here's how the code works:
1. It checks to see if there's a missing entry for 0-1-TEXT
2. If there is no such entry, it attempts to insert it.

Yours is failing because it didn't find the entry and tried to insert it, but found that the entry is actually already there.

How is that possible?

Perhaps you have other addons in your site that tamper with normal SQL operation, such as old caching tools like old QueryCache or something like that.

It's possible when you have another language installed and that language pack translated the "TEXT" into something else.

I have the same issue because "TEXT" is translated into "文字" in the database so the query will not be able to find the value and try to insert 0-1-TEXT

[Dashizna]

I was hoping you might at least know what plugins you've installed on your own site.

The new one i didn't install anything with the query. But who knows on the old sites we done so many

[Dashizna]

It's possible when you have another language installed and that language pack translated the "TEXT" into something else.

I have the same issue because "TEXT" is translated into "文字" in the database so the query will not be able to find the value and try to insert 0-1-TEXT

i don't have any other languages on this new site i think we might have had one on our old site but i can't remember

[Ajeh]

I was hoping not to take this route, but we need to see what is in your table:
zen_products_options_values

Go to phpMyAdmin, and look at your database table names ...

1 do they all start with zen_

2 find the table:
zen_products_options_values

and browse it ...

Do you see a row with the values:
products_options_values_id 0
language_id 1
products_options_values_name TEXT

[Dashizna]

I was hoping not to take this route, but we need to see what is in your table:
zen_products_options_values

Go to phpMyAdmin, and look at your database table names ...

1 do they all start with zen_

2 find the table:
zen_products_options_values

and browse it ...

Do you see a row with the values:
products_options_values_id 0
language_id 1
products_options_values_name TEXT

ok actually i have 2 of everything one has the prefix one doesn't ....

[Ajeh]

Without posting your sercret_admin_dir, or the database username and password, from the server, can you post the two files:
/includes/configure.php
/your_sercret_admin/includes/configure.php

[Dashizna]

includes/config file

<?php
/**
* @package Configuration Settings circa 1.3.8
* @copyright Copyright 2003-2007 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/


/*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/
/*************** The 2 files should be kept separate and not used to overwrite each other. ***********/

// Define the webserver and path parameters
// Main webserver: eg-http://www.your_domain.com -
// HTTP_SERVER is your Main webserver: eg-http://www.Ad-Discountperformance.com
// HTTPS_SERVER is your Secure webserver: eg-https://www.AD-Discountperformance.com
// HTTP_CATALOG_SERVER is your Main webserver: eg-http://www.AD-DiscountPerformance.com
// HTTPS_CATALOG_SERVER is your Secure webserver: eg-https://www.AD-Discountperformance.comm
/*
* URLs for your site will be built via:
* HTTP_SERVER plus DIR_WS_ADMIN or
* HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or
* HTTP_SERVER plus DIR_WS_CATALOG or
* HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG
* ...depending on your system configuration settings
*
* If you desire your *entire* admin to be SSL-protected, make sure you use a "https:" URL for all 4 of the following:
*/
define('HTTP_SERVER', 'http://ad-discountperformance.com');
define('HTTPS_SERVER', 'https://ad-discountperformance.com');
define('HTTP_CATALOG_SERVER', 'http://ad-discountperformance.com');
define('HTTPS_CATALOG_SERVER', 'https://ad-discountperformance.com');

// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_ADMIN', '/*********************/');
define('DIR_WS_CATALOG', '/');
define('DIR_WS_HTTPS_ADMIN', '/**************/');
define('DIR_WS_HTTPS_CATALOG', '/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
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', DIR_WS_CATALOG . 'pub/');
define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

define('DIR_WS_PHPBB', '/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_ADMIN', '/home2/pwcforum/public_html/***********/');
define('DIR_FS_CATALOG', '/home2/pwcforum/public_html/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_CHARSET', 'latin1');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '***********');
define('DB_SERVER_PASSWORD', '***********');
define('DB_DATABASE', '***********');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'database');
define('DIR_FS_SQL_CACHE', '/home2/***********/public_html/cache');

// EOF