Adding New Product_types

**Darkwander** · 28 Sep 2005, 03:26 PM

okey , downloaded the book , went to the SQL part , pasted the sql files contence into the Executor and pressed send , then i get a funky error

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 ') TYPE=MyISAM' at line 1

Any ideas anyone ?

**hareslade** · 28 Sep 2005, 04:13 PM

Sorry not getting advice of the earlier post

Darkwander which sql file name are you using which gave the sql error? I can then check it specifically

Also sometimes bits get left off the copy/paste, such as an ending

Or one has to have notepad set not to wordwrap, as it cuts lines in two, then admin patch doesn't like it

--------
bpc... sorry that post's a long time back, did you give up?

**Darkwander** · 28 Sep 2005, 06:24 PM

Originally posted by hareslade@Sep 28 2005, 03:13 PM
Sorry not getting advice of the earlier post

Darkwander which sql file name are you using which gave the sql error? I can then check it specifically

Also sometimes bits get left off the copy/paste, such as an ending

Or one has to have notepad set not to wordwrap, as it cuts lines in two, then admin patch doesn't like it

--------
bpc... sorry that post's a long time back, did you give up?

Thanks , stupid copy and paste..

I tryed to add a new field called "rated" , made the table and everything , however in the admin and catalog i get it showing "TEXT_DVD_RATED instead of "Rated".

Example: http://www.delightsoftheflesh.com/store/in...roducts_id=3992

**Darkwander** · 28 Sep 2005, 06:41 PM

Okey , fixed the problem,

you also have to edit the files Language / English

in both the admin and Includes folder.

**Darkwander** · 28 Sep 2005, 06:56 PM

I want to make a new input called "Running time" , however i dont want it to be set like Format, i need it to be like Product ID and or Weight.

How would you go about doing this ?

**hareslade** · 28 Sep 2005, 07:30 PM

Hi Darkwander
You mean a number field not text?

Adding fields is a long job if you want to cover all the admin icon functions on right of an admin product list such as 'product copy'.

Personally I'd find an existing unwanted field of similar field type and rename it on the admin pages templates, and in product display.

Or you just sit there and find ALL the pages of that product type which process a particular field, and add in your own one. But there are places where an array pre-sets the possible field names used further down the code, so they have to have added entries as well.

Mind you it is how I added fields to the book product and its worth adding extra ones because you WILL suddenly decide later after doing it all, to add some more, by which time you forget what to do.. ::frust and then want to shoot yourself

**Darkwander** · 28 Sep 2005, 09:01 PM

What i did was change Publisher to Studio. The only problem is that there isnt a place where you can set "publisher" or "Studio" and it is a drop down box. So what i want to do is make it like "Subject" and have a option under Extra where you can add the options..

**Darkwander** · 29 Sep 2005, 03:28 PM

Help please....

I have done everything except for some reason it is not showing up when i click on "add product" the new field dosnt show up in the list..

Everything else as far as i know works. however it is just that.

Download: zen_demo_dvd.2.10

**Darkwander** · 29 Sep 2005, 06:22 PM

Hey guys , i am getting this error in the Admin panel when i goto edit a Product that belongs to the group Product DVD..

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 'from products p, products_description pd,

I also updated the download file that is linked on the last post incase you want to look at the coding.