First off, thanks for the quick reply. I tried fixing that and uploading the new file(the one i've attached), but the same thing happens. What could i be doing wrong? Excuse my ignorance.
Printable View
First off, thanks for the quick reply. I tried fixing that and uploading the new file(the one i've attached), but the same thing happens. What could i be doing wrong? Excuse my ignorance.
the paod version of this offers no support whatsover, ive been trying t oget in tocu via contact form and supprot ticket, with no answers. Looks like im out my $65.
This guy cant handle all the support that goes with a paid mod and is in way over his head just collecting our money and not caring if we figure out how to use it or not.
wickerman - right we need to fault find...
Is this a downloaded file or one you have produced?
If not { download the attributes file and post that.}
else
{ you have a issue with your attribute values, which will be half your problem.}
You cannot have different values in the same column:
v_attribute_values_name_1_3_1
M (Black ONLY)
L Limited
M
L
M
L
M
L
They have to be the same value
v_attribute_values_name_1_3_1
M (Black ONLY)
M (Black ONLY)
M (Black ONLY)
M (Black ONLY)
M (Black ONLY)
M (Black ONLY)
M (Black ONLY)
so for every v_attribute_values_name column the value is the same (unique value)
so v_attribute_values_name_1_4_1 is
v_attribute_values_name_1_4_1
L (Black,Yellow Only)
L (Black,Yellow Only)
L (Black,Yellow Only)
L (Black,Yellow Only)
L (Black,Yellow Only)
L (Black,Yellow Only)
and you set them on or off by giving a value to the v_attribute_values_price column. If you set that column to +0.000 it shows the attribute with the product at the price setup in the product details, and if you set v_attribute_values_price to +1.500 it adds 1.50 to the basic price like wise you can set it to a minus figure as well. I think you haven't got to grips with the attribute concept, and you are using EP to change the settings before you understand how attributes work.
CnTGifts - Don't know anything about EPA Authors situation, usually he is helpful as you can see looking back at this thread, do remember Zencart is fully automatic and works with out human hands so of cause you can still pay for downloads and you get the files even if the author does look at his pc for weeks, whats your issue, we maybe able to help but cannot promise.
PriestB - I think you are talking about merging data supplied by your suppliers to EP format, you would need to write a script to merge it automatically other wise you need to do a little/alot of cutting and pasting in OO or excel.
when you buy the mod your buying 1 years support, hes aprantly to busy to supply 1 day of support
I take back everything i said. No need to worry about support issues he will get to you in a reasonable time.
Scrat, Thanks for helping me out. I've been using zencart for only a couple of weeks now, thats why i dont know the basic stuff. Hopefully i'll get the hang of it soon.
Ok, so i managed to correct the errors you told me about and i uploaded the file, the fields get but updated but not as expected. I am uploading both the file i uploaded(attrib.txt) and the EP generated file after the upload(Attributes-EP2007Dec24-1604.txt). Is this because all the values in v_attribute_values_name have to be the same? Thanks again for all the help.
Hi All I searched High and low for this but found nothing. So here is my problem I added all my items using EPA and as always it went in with no problem, but now I wanted to add a new product and it came back with this ID 2147483647 I know this is the magic number for the end or last product
so when I went to add one more product this popped up
1062 Duplicate entry '2147483647' for key 1
in:
[insert into products (products_quantity, products_type, products_model, products_price, products_date_available, products_weight, products_status, products_virtual, products_tax_class_id, manufacturers_id, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_discount_type, products_discount_type_from, products_price_sorter, products_image, products_date_added, master_categories_id) values ('1', '1', '2321', '2', null, '0', '1', '0', '0', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '', now(), '388')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I downloaded my store with EPA and the last Item # was 2147483647
the one before that ID number is 98378 any Ideas how to reset this?
when I go into Tools/EPA/ the Index Mode: products_id it says
Next products table id: 2147483647 how do I reset that back to 98379?
Thanks for your help.
And Happy Holidays to All!
Quote:
Originally Posted by CnTGifts
He has always replied to me in the past I have asked him a few questions recently and they have gone unanswered it appears he has either a family problem or a health problem He does the best he can and I'm sure when everything clears up he will be back on again.
Happy Holidays To ALL!
My Bad for being vague Scrat, I wanted to know if I could import all my download file attributes I offer ebooks and I had them set for instant download when they paid. can I import all these with out havening to write them all back again in the Attributes Controller?Quote:
Originally Posted by Scrat
like restore the option Names and values. or is that on the database itself?
Happy Holidays!
Tony
In Answering my own question I did a search for 2147483647 on my sql server and got a bunch of matches the one where I fixed the problem was in 1 match(es) inside table products_to_categories I changed 2147483647 to 1Quote:
Originally Posted by tonysebay
then went back to see and it was fixed. I am writing this here so if it ever happens again I can fix it fast!
Anyway Hope this helps someone else in the years to come :)
Tony