1.4.9.6 - Inserting item

Hi,
i keep getting this message?? any ideas?

Error: Unknown column 'maximum' in 'field list'
Error No: 1054
INSERT INTO product SET model = 'Clutch', sku = '', location = '', quantity = '1', minimum = '1', maximum = '0', subtract = '0', stock_status_id = '7', date_available = '2011-11-17', manufacturer_id = '11', shipping = '0', price = '20', cost = '0', weight = '0', weight_class_id = '2', length = '0', width = '0', height = '0', length_class_id = '1', status = '1', tax_class_id = '0', sort_order = '1', date_added = NOW()

Bee

Clean install, update?

Worked before?

Hi
After updating all the patch's up to 1.4.9.6
now i m not able to insert any products!!

after entering the long details of products and finally getting to "insert button"

i get this message



Error: Unknown column 'maximum' in 'field list'
Error No: 1054
INSERT INTO product SET model = 'test', sku = '', location = '', quantity = '200', minimum = '1', maximum = '0', subtract = '1', stock_status_id = '5', date_available = '2011-11-17', manufacturer_id = '0', shipping = '1', price = '0', cost = '0', weight = '0', weight_class_id = '2', length = '0', width = '0', height = '0', length_class_id = '1', status = '1', tax_class_id = '0', sort_order = '1', date_added = NOW()

phpMyAdmin -> SQL

jang1200 wrote:phpMyAdmin -> SQL

Code: Select all

ALTER TABLE `product` ADD `maximum` int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER `minimum`;

i dont quite understand what you mean sorry.

and now i am also getting these message:

Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/catalog/controller/product/product.php on line 147Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/catalog/controller/product/product.php on line 239Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150

??
whats going on, of i click on a link = === i get this message
when i put something in a cart ==== i get this message?

should i reload the update again

please help

many many thanks

I believe you need to run some upgrade script to update to you current version.

i2Paq wrote:I believe you need to run some upgrade script to update to you current version.

where would you suggest i find these upgrades, i already did the ones from this website: http://code.google.com/p/opencart/downloads/list

When i click on a Product to view details in the live shop window i get this message:

Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/catalog/controller/product/product.php on line 147Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/catalog/controller/product/product.php on line 239


and when i add it to my cart i get this message:

Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 135Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 136Notice: Undefined index: maximum in /home/content/02/8283502/html/shop/system/library/cart.php on line 150

and for some reason the £ sign turns in to  ??

Any ideas what i should doo guys

thanks a million still

Bee
xxx

I have no idea where to look for the update script

bee

bee wrote:I have no idea where to look for the update script

bee

Are there none in the zip's you downloaded?

i already downloaded the Patch file for 1.4.9.6 and i uploaded the replaced files and followed the instruction just fine.

i2Paq wrote:

bee wrote:I have no idea where to look for the update script

bee

Are there none in the zip's you downloaded?

Although, i just opened that patch file up just now, and in there there are three txt files, (which dont need to be uploaded, as you know and in there the update.txt) did have a this writen at the bottom of it:


6. THERE ARE NO UPDATES TO THE DATABASE SO YOU WILL NOT NEED TO RUN THE UPGRADE SCRIPT

ermm..
did i miss something, when i was runnig all the update patchs, when i was upgrading from
1.4.9.3 to - 1.4.9.4 >> then 1.4.9.4 to 1.4.9.5 ... >> then 1.4.9.5 to1.4.9. 6 ..

bee wrote:I have no idea where to look for the update script

bee

you are RIGHTTTTTTTTTTTTTTTTTTTTTTT

i went back and did a re upload and its all fixed, i never did :-


6. THERE ARE UPDATES TO THE DATABASE SO YOU WILL NEED TO RUN THE UPGRADE SCRIPT
After the files are uploaded
Goto http://yoursite.com/install/upgrade.php

You should get the opencart upgrade success message

in the update patchs

i just keep up dating and then deleted the install
!!

you were right


i love u

xx
thanks a million billion

xx