Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Whole sales price import problem Rate Topic   - - - - -

 
  • idede.idline
  • Junior Member
  • Members
  • Join Date: 23-Oct 07
  • 1 posts

Posted 23 December 2007 - 07:46 PM #1

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