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 August 8th, 2012, 07:54 AM
macfink macfink is offline
 
Join Date: Feb 2011
Posts: 685
Default No categories, or products?

I cant update, the error is stating can you help Eric?

ERROR:
-Update cannot complete (database error), please try again, Technical details:
ERROR:err_mysql_no_table:1146:Table 'arobinson1_blog.wp_dfr_shop_products' doesn't exist:SELECT * FROM wp_dfr_shop_products WHERE id='177200200229042'
ERROR:err_mysql_no_table:1146:Table 'arobinson1_blog.wp_dfr_shop_cats' doesn't exist:SELECT * FROM wp_dfr_shop_cats ERROR:err_mysql_no_table:1146:Table 'arobinson1_blog.wp_dfr_shop_products' doesn't exist:SELECT * FROM wp_dfr_shop_products WHERE id='177200200229042'
plugin/plugin:152 view=none
app/tracker:61 track: no referrer
app/update:103 BEGIN: status=read
unlink /home/arobinson1/public_html/tmp/dfr_7d0b567878de6d24e5bc2f789c15b123
ERROR:err_mysql:1074:Column length too big for column 'image' (max = 255); use BLOB or TEXT instead:CREATE TABLE IF NOT EXISTS wp_dfr_shop_products_tmp ( id bigint(20) unsigned NOT NULL, net_id int unsigned NOT NULL default 0, net_code varchar(255) NOT NULL default '', network varchar(255) NOT NULL default '', merchant_id int unsigned NOT NULL default 0, merchant varchar(255) NOT NULL default '', name varchar(255) NOT NULL default '', slug varchar(255) NOT NULL default '', description TEXT, price DECIMAL(10,2), image varchar(2040) NOT NULL default '', thumbnail varchar(2040) NOT NULL default '', url varchar(2040) NOT NULL default '', tags varchar(255) NOT NULL default '', saleprice DECIMAL(10,2), brand varchar(255) NOT NULL default '', currency varchar(255) NOT NULL default '', sku varchar(255) NOT NULL default '', model varchar(255) NOT NULL default '', ean varchar(255) NOT NULL default '', isbn varchar(255) NOT NULL default '', asin varchar(255) NOT NULL default '', amlocale int unsigned NOT NULL default 0, shipprice DECIMAL(10,2), sprice DECIMAL(10,2), promo TEXT, specs TEXT, site_link varchar(1020) NOT NULL default '', cat_id int unsigned NOT NULL default 0, state int unsigned NOT NULL default 0, legacy_id varchar(255) NOT NULL default '', qrnd int unsigned NOT NULL default 0, cfields varchar(255) NOT NULL default '', views int unsigned NOT NULL default 0, clicks int unsigned NOT NULL default 0, compset_status int unsigned NOT NULL default 0, upd_ts int unsigned NOT NULL default 0, drip_ts int default 0, PRIMARY KEY (id), FULLTEXT(name, description, tags), KEY(qrnd), KEY(state,views,clicks), KEY(cat_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
app/update:155 UPDATE FAILED
ERROR:err_update_mysql_error::147

URL: /index.php
__________________
ID 30949
Website:
http://www.freakfish.co.uk/
  #2  
Old August 8th, 2012, 08:01 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi

What version of MySQL are you using? You can find that here: WordPress Admin Area > Tools > Datafeedr > Debug > System Information > [Show] > mysql:

Eric
  #3  
Old August 8th, 2012, 08:03 AM
macfink macfink is offline
 
Join Date: Feb 2011
Posts: 685
Default

Thanks for the fast reply

Faster than my new crap hosting!

System
----------------
mysql: 4.1.22-standard
os: Linux coral.gocreations.co.uk 2.6.18-308.8.2.el5.028stab101.1PAE #1 SMP Sun Jun 24 21:40:20 MSD 2012 i686
php: 5.2.10
sapi: cgi

Wordpress
----------------
admin_email: freakfish@me.com
charset: UTF-8
domain: www.rideonsurfshop.co.uk
is_admin: 1
language: en-US
permalinks: 1
trailing_slash: 1
url: http://www.rideonsurfshop.co.uk
url_prefix:
version: 3.4.1
wpurl: http://www.rideonsurfshop.co.uk

Plugin
----------------
path: /home/arobinson1/public_html/wp-content/plugins/datafeedr
url: http://www.rideonsurfshop.co.uk/wp-c...ins/datafeedr/
version: 3.6.4006

Local options
----------------
admin_email: freakfish@me.com
backup_dir: /home/arobinson1/public_html/wp-content/uploads/store/backups
charset: UTF-8
conn_key: u75zhp3kt85saq6g
domain: www.rideonsurfshop.co.uk
factory_host: 75.101.166.188
image_dir: /home/arobinson1/public_html/images/product
image_url: /images/product
is_admin: 1
language: en-US
lmtime: 1344429694
logo_dir: /home/arobinson1/public_html/images/merchant_logo
logo_url: /images/merchant_logo
permalinks: 1
plugin_dir: /home/arobinson1/public_html/wp-content/plugins/datafeedr
plugin_full_version: 3.6.4006
plugin_url: http://www.rideonsurfshop.co.uk/wp-c...ins/datafeedr/
plugin_version: 3.6
start_time: 1344430951.21
temp_dir: /home/arobinson1/public_html/tmp
thumbnail_dir: /home/arobinson1/public_html/wp-content/uploads/store/products/thumbnails
thumbnail_url: /wp-content/uploads/store/products/thumbnails
trailing_slash: 1
update_csize: 500
update_end_time: 1344429694
update_start_time: 1344429218
url: http://www.rideonsurfshop.co.uk
url_prefix:
version: 3.4.1
wpurl: http://www.rideonsurfshop.co.uk


Browser
----------------
appCodeName: Mozilla
appName: Netscape
appVersion: 5.0 (Windows)
buildID: 20120713134347
cookieEnabled: true
doNotTrack: unspecified
language: en-US
onLine: true
oscpu: Windows NT 6.1; WOW64
platform: Win32
product: Gecko
productSub: 20100101
userAgent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101 Firefox/14.0.1
vendor:
vendorSub:
__________________
ID 30949
Website:
http://www.freakfish.co.uk/
  #4  
Old August 8th, 2012, 08:04 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi

You must be using MySQL 5.0.3+ as per the Datafeedr Requirements.

Eric
  #5  
Old August 8th, 2012, 08:12 AM
macfink macfink is offline
 
Join Date: Feb 2011
Posts: 685
Default

I will bash some heads. This is stupid, been an hour and nobody has got back to me. Change back to my old server hosting i think!
__________________
ID 30949
Website:
http://www.freakfish.co.uk/
  #6  
Old August 8th, 2012, 08:13 AM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

In my opinion, no webhost should be providing MySQL 4.x by default. It's very old.
  #7  
Old August 8th, 2012, 08:15 AM
macfink macfink is offline
 
Join Date: Feb 2011
Posts: 685
Default

Yes, you are totally right. Im so peeved at this. I'm losing sales as well as products not being indexed!

Thanks for your reply, i will get back to you.
__________________
ID 30949
Website:
http://www.freakfish.co.uk/
 


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
2 Questions about Categories & Products frugalmom Questions 2 June 8th, 2012 09:32 PM
how to put custom products in categories? tblogster Questions 2 June 2nd, 2011 04:01 PM


All times are GMT -5. The time now is 01:09 PM.


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