[appleballs]

Originally Posted by Staxed

for anyone that doesn't want to edit the file themselves, here's an updated product

I just installed Point Market System. I'm getting the following error when I try to edit a store item:

Invalid SQL:

UPDATE market_store SET
`name` = 'Target Gift Card',
`amount1` = '200',
`amount2` = '0',
`iscategory` = '0',
`parentid` = '1',
`payment` = '4',
`type` = '0',
`quantity_total` = '0',
`order` = '0',
`description` = '',
`instructions` = '',
`image_small` = '',
`image_big` = '',
`active` = '1'
where marketid='2';

MySQL Error : Unknown column 'image_big' in 'field list'

The 'market_store' table looks like this:

mysql> describe market_store;
+----------------+------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------------+------+-----+---------+----------------+
| marketid | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(50) | NO | | NULL | |
| parentid | int(6) unsigned | NO | | NULL | |
| iscategory | tinyint(3) unsigned | NO | | NULL | |
| amount1 | decimal(12,2) unsigned | NO | | NULL | |
| amount2 | decimal(12,2) unsigned | NO | | NULL | |
| payment | int(6) unsigned | NO | | NULL | |
| type | int(6) unsigned | NO | | NULL | |
| description | text | NO | | NULL | |
| instructions | text | NO | | NULL | |
| image_small | varchar(150) | NO | | NULL | |
| image_big_1 | varchar(150) | NO | | NULL | |
| image_big_2 | int(12) | NO | | NULL | |
| image_big_3 | int(12) | NO | | NULL | |
| image_big_4 | int(12) | NO | | NULL | |
| image_big_5 | int(12) | NO | | NULL | |
| rating_total | int(12) unsigned | NO | | NULL | |
| times_rated | int(12) unsigned | NO | | NULL | |
| quantity_total | int(6) unsigned | NO | | NULL | |
| order | int(6) unsigned | NO | | NULL | |
| active | int(6) unsigned | NO | | NULL | |
+----------------+------------------------+------+-----+---------+----------------+
21 rows in set (0.01 sec)

So the field 'image_big' does not exist in the table. What's the best way to fix this?