Datafeedr Support Forums  

Go Back   Datafeedr Support Forums > Current Version (V3) Forum > Problems
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Important - The support forums are now in "read-only" mode as we transition to an alternative help desk solution. Feel free to contact us here with any of your questions or search the forums for an existing solution.
 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 6th, 2013, 02:38 PM
Sport1X2 Sport1X2 is offline
 
Join Date: Jun 2012
Posts: 34
Exclamation Updating procuts and updates dont work

Store ID:
Website URL: http://www.e-shopping.fi

Hi, im having problems with update the products. Suddenly few days ago i was able to update everything, but last couple of days the update seems to end just few megabytes before all products etc are downloaded. I have tryied like everything, but it just dont want to update my store products and settings.

I have a very huge store, and it prepairs the download fine, dowloands packets, but when the store is doing the final step, it just say try again etc. I have tryed to chance the packet sizes from degub page, dont help. Ive tryied to upload store file with FTP, dosent seem to work.

Store settings are updated when i enable griz settings, but products dont, either way.

Please help!
  #2  
Old January 6th, 2013, 03:01 PM
Sport1X2 Sport1X2 is offline
 
Join Date: Jun 2012
Posts: 34
Default

ERROR:
-Update cannot complete (database error), please try again (more info: http://www.datafeedr.com/go/err_update_mysql_error)

Technical details:
plugin/plugin:152 view=()
app/tracker:61 track: no referrer
app/response:6 out: error=(no_view)
app/update:103 BEGIN: status=read
ERROR:err_mysql(1136(Column count doesn't match value count at row 4):INSERT IGNORE INTO wp_dfr_shop_products_tmp(id,net_id,net_code,networ k,merchant_)
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.1
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.10
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.100
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.101
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.102
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.103
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.104
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.105
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.106
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.107
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.108
unlink /tmp/dfr_c1ea141caab714313420ad486ff888f9.109
  #3  
Old January 6th, 2013, 03:53 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi,

I think you are running out of room in your /tmp directory. Please try these steps:
http://www.datafeedr.com/videos?vide...rc=yt#videotop

Eric
  #4  
Old January 7th, 2013, 11:47 AM
Sport1X2 Sport1X2 is offline
 
Join Date: Jun 2012
Posts: 34
Default

Store is updating: reading 67.2Mb of 82.8Mb...

BOOM!

Update cannot complete (database error), please try again [More Info]

[Technical details...]
app/update:103 BEGIN: status=read
ERROR:err_mysql(1064(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't10','TradeDoubler Finland',37764,'Brandos','DC Shoes: DC Tonik SP Shoe kangaske' at line 7):INSERT IGNORE INTO wp_dfr_shop_products_tmp(id,net_id,net_code,networ k,merchant_)
unlink /home/eshoppin/public_html/wp-content/uploads/store/paivitys/dfr_dbf68ced6f5e6daed58e7d14876c9526
unlink /home/eshoppin/public_html/wp-content/uploads/store/paivitys/dfr_dbf68ced6f5e6daed58e7d14876c9526.1
unlink /home/eshoppin/public_html/wp-content/uploads/store/paivitys/dfr_dbf68ced6f5e6daed58e7d14876c9526.10
unlink /home/eshoppin/public_html/wp-content/uploads/store/paivitys/dfr_dbf68ced6f5e6daed58e7d14876c9526.100
unlink /home/eshoppin/public_html/wp-content/uploads/store/paivitys/dfr_dbf68ced6f5e6daed58e7d
  #5  
Old January 7th, 2013, 11:47 AM
Sport1X2 Sport1X2 is offline
 
Join Date: Jun 2012
Posts: 34
Default

Still not working
  #6  
Old January 7th, 2013, 11:49 AM
Sport1X2 Sport1X2 is offline
 
Join Date: Jun 2012
Posts: 34
Default

This is to inform you that the automatic update on your website (www.e-shopping.fi) has failed. Please see the error message(s) below:

ERROR:
-Store data cannot be read (invalid header) (more info: http://www.datafeedr.com/go/err_read_bad_header)

Technical details:
plugin/plugin:152 view=(product)
app/tracker:61 track: no referrer
app/view:71 cache: product: put
app/update:103 BEGIN: status=read
app/reader:58 header: found DROP+TABLE+IF+EXISTS+wp_dfr_shop_merchan
unlink /home/eshoppin/public_html/wp-content/uploads/store/paivitys/dfr_bd0633457fd55f612fbe7a58524890fc
unlink /home/eshoppin/public_html/wp-content/uploads/store/paivitys/dfr_bd0633457fd55f612fbe7a58524890fc.1
app/update:156 UPDATE FAILED
ERROR:err_read_bad_header() line=153

URL: /index.php
  #7  
Old January 7th, 2013, 11:50 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi

Can you PM me the following information:

BLOG LOGIN INFO with ADMINISTRATOR PERMISSIONS (Temporary login information preferred)
Admin URL:
Username:
Password:

FTP LOGIN INFORMATION (Temporary login information preferred)
Host:
Login:
Password:

cPanel (Control Panel) Login - Need access to phpMyAdmin
Host:
Login:
Password:

Thanks,
Eric
  #8  
Old January 7th, 2013, 01:28 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi,

Thanks. We're looking into this issue. I'll update this thread when we know more.

Eric
  #9  
Old January 7th, 2013, 01:36 PM
Sport1X2 Sport1X2 is offline
 
Join Date: Jun 2012
Posts: 34
Default

Thanks.
  #10  
Old January 7th, 2013, 04:02 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi,

After disabling gzip compression, the store updated successfully.

Before update: Categories: 281 Products: 97,651

After update: Categories: 286 Products: 89,239

Eric
  #11  
Old January 7th, 2013, 04:17 PM
Sport1X2 Sport1X2 is offline
 
Join Date: Jun 2012
Posts: 34
Default

Hi,

Thanks, yeah i kind of noticed it just few secons ago. However, i think i have to enable every time griz compression if i only want to update the settings (without products), since it reports me about invalid header when its disabled.. Lets see if this problem is solved.

Many thanks still!
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Store Products Dont Populate in WP download2 Problems 5 July 18th, 2011 10:30 AM


All times are GMT -5. The time now is 11:31 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.