Hi,
I use more prices (whole sale prices) in my site and I tried to look a bulk price modification procedure. One of them the import function.
I tested it. I exported whole sales price to CSV file and then I tried to import it back to the database. The procedure stopped with the following mistake:
Importing data
Creating Nagyker árak...29850. Updating links...
Database error: 1054 : Unknown column 'Array' in 'where clause'
Invalid query: SELECT COUNT(*) FROM cscart_product_prices WHERE lower_limit='' AND membership_id='0' AND Array
--------------------------------------------------------------------------------
Backtrace: File: C:\Program Files\Apache Group\Apache2\htdocs\dshop\webshop\admin.php
Line: 79
Function: include
File: C:\Program Files\Apache Group\Apache2\htdocs\dshop\webshop\targets\exim.php
Line: 35
Function: include
File: C:\Program Files\Apache Group\Apache2\htdocs\dshop\webshop\include\admin\exim.php
Line: 129
Function: fn_import
File: C:\Program Files\Apache Group\Apache2\htdocs\dshop\webshop\include\admin\exim.php
Line: 544
Function: db_get_field
File: C:\Program Files\Apache Group\Apache2\htdocs\dshop\webshop\core\fn_database.php
Line: 92
Function: db_query
File: C:\Program Files\Apache Group\Apache2\htdocs\dshop\webshop\core\db_mysql.php
Line: 94
Function: db_debug_error
I tried it with one product, but it can't help.
Have you any experience in this function or this problem solving.
Many thanks in advance
|