jimdanforth

I have 2 installs of oscommerce running on different domains. Only 1 is getting this error and it is relatively new: It occurs almost anytime within the backed I use a search function. I confirmed with with my hosting company nothing was changed and feel it is within oscommerce. I see that somone else had a similar error and "added zip to php" to fix the error, but I am not understaning this resolution.

how many products? how much specialization was done?

Do you mean only 7 are displayed on the home page?

what?

Here is the result of this as well as my message to @pandrei just in case someone sees a similar problem: I apologize for the slow response. The issue is not OSCommerce, but actually a combination of things. UPS changed how they respond on the API and no longer include residential, oversize/overweight fees and only the base price with discount. It is also no longer the "counter" rate as if you walked into a UPS shipping store. I had to add a 100% upcharge to match the accurate rate. I was able to look at prior UPS invoices and adjust until I arrived at the correct surcharge which was 82% most of the time. Again, sorry for falling to OSCommerce being the problem and not updating you.

Please check your PMs again. The result you see now is because I had to add a $150 handling fee to stop losing money on 3 out of the 4 shipments in each order.

@pandrei I sent a message yesterday but you have not read it so I am tagging multiple oscommerce team here. This morning I lost $225 on an order due to the problem. @Ivan Holbi

That does sound pretty close. Thanks

Is there an option that I can create a "kit" that uses existing items? IE: Product 1 $10 Product 2 $10 Product 3 $10 Kit using all 3 products $25 Uses inventory control from individual products to determine availability. Just wondering if there is already something in OSCommerce and I am just not seeing it due to name? JImD

Log has the following: 024-03-08 16:44:52 [98.97.84.74][-][1lg4ef03qi5vfq9i8oke9r8a4k][error][yii\db\Exception] PDOException: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list in /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/db/Command.php:1302 Stack trace: #0 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/db/Command.php(1302): PDOStatement->execute() #1 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/db/Command.php(1168): yii\db\Command->internalExecute() #2 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/db/Command.php(453): yii\db\Command->queryInternal() #3 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/db/Query.php(320): yii\db\Command->queryColumn() #4 /home/tractor/public_html/osc/lib/backend/controllers/CategoriesController.php(701): yii\db\Query->column() #5 [internal function]: backend\controllers\CategoriesController->actionList() #6 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #7 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams() #8 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction() #9 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction() #10 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest() #11 /home/tractor/public_html/osc/lib/backend/web/index.php(31): yii\base\Application->run() #12 /home/tractor/public_html/osc/admin/index.php(25): require('/home/tractor/p...') #13 {main} Next yii\db\Exception: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list The SQL being executed was: SELECT DISTINCT `p`.`products_id` FROM `products` `p` LEFT JOIN `plain_products_name_to_products` ON `p`.`products_id` = `plain_products_name_to_products`.`products_id` LEFT JOIN `plain_products_name_search` ON `plain_products_name_to_products`.`plain_id` = `plain_products_name_search`.`id` WHERE (match( `plain_products_name_search`.search_details_be ) against('+70228621')) AND (`plain_products_name_search`.`language_id`=1) ORDER BY `p`.`products_id` in /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/db/Schema.php:676 Stack trace: #0 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/db/Command.php(1307): yii\db\Schema->convertException() #1 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/db/Command.php(1168): yii\db\Command->internalExecute() #2 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/db/Command.php(453): yii\db\Command->queryInternal() #3 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/db/Query.php(320): yii\db\Command->queryColumn() #4 /home/tractor/public_html/osc/lib/backend/controllers/CategoriesController.php(701): yii\db\Query->column() #5 [internal function]: backend\controllers\CategoriesController->actionList() #6 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #7 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams() #8 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction() #9 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction() #10 /home/tractor/public_html/osc/lib/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest() #11 /home/tractor/public_html/osc/lib/backend/web/index.php(31): yii\base\Application->run() #12 /home/tractor/public_html/osc/admin/index.php(25): require('/home/tractor/p...') #13 {main} Additional Information: Array ( [0] => HY000 [1] => 1191 [2] => Can't find FULLTEXT index matching the column list )

@Ivan Holbi certain products are generating the following error popup: DataTables warning: table id=categoriesTable - Ajax error. For more information about this error, please see http://datatables.net/tn/7 Its possible it has done it for a while and I only noticed now due to hitting the particular product

Only recently discovered. This is not sending the tracking to Paypal. I am having to go back an manually add the tracking in Paypal. Paypal will limit the account at certain thresholds if tracking is not uploaded.

Thank you very much. I greatly appreciate the help. This did resolve both needs.

Thank you. I will evaluate if that meets my needs. I only found it trying to resolve the shipping surcharge not working and saw this post. Not sure but it still will not show in my app shop. I tried searching with and without the space in the title. But if I decide to purchase I will use the link you provided.

OK. I dont see it in the app shop for purchase. Thank you.

Yes, typical US format has (name) (city) (state) (postal code) format and while it's not a major problem, it does look odd to my customers. I've also wondered why there are 2 phone fields, and wonder if I did something to cause that:

it does not show in library or app shop. I didn't see in the https://www.oscommerce.com/blog/managing-product-bundles link that it needed to be installed so I assumed it was part of the base install. Is it possible this is affecting my shipping surcharge also?

The bundles option in the linked page is not present:

@pandrei Did the post code before state get changed to allow re-ordering on checkout?

Has anyone used the shipping surcharge under the price/cost tab? I have not been able to have it affect the final shipping calculated rate.

Thank you. I will work with that.

So does it change the customer's account automatically after a backend update to the order? Since subsequent emails include the link even if the customer has made no changes I don't see why the original confirmation couldn't include it just as any update does. At a minimum, can I replace the "Link send Administrator"? It makes it look like an error?

Just discovered when a customer places an order the order confirmation has the following: Order Number: 23176 Detailed Invoice: Link send Administrator Date Ordered: Tuesday 13 February, 2024 If I use that same email template for a different status, or even the same status but cause the email to be created from the backend it works fine: (I removed the url from the link.) Order Number: 23176 Detailed Invoice: View Date Ordered: Tuesday 13 February, 2024 SO the same email template is used in both examples above with the only difference being the first was initiated when the customer ordered and the second when I updated status: I copied the order confirmation template so I would not change the original. JimD

I had the same problem. Couldn't figure out why some status would and others wouldn't.

Probably has to do with your order status. Each status can trigger an email and if the status you are holding at does not, nothing will be generated.