Characteristics not saved

15.12.2013 20:17
#1
settas
Joomshopping forum user no avatar
Name: ilias
23.02.2012
Posts: 13
Quote
Characteristics not saved

Hi everybody,

We run the basic module filters 3.4.0. Everything was perfectly until today.

The problem is: when i create new product, desired characteristics not saved yet.
Have you please any idea to help me?

I attach you screeshots before and after the save.

Thank you

ps. For existing products the characteristics works fine (frontend & backend)
Characteristics not saved
After_Save.JPG


Joomla: 2.5.11
JoomShopping: 3.5.12
PHP: 5.3.26
Website Url: my-marketbook.gr
 
15.12.2013 20:30
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: Characteristics not saved

See field type
table
jos_jshopping_products
extra_field_1?
extra_field_2?
....

(use phpmyadmin)

 
15.12.2013 21:29
#3
settas
Joomshopping forum user no avatar
Name: ilias
23.02.2012
Posts: 13
Quote
Aw: Characteristics not saved

Hi again,

All the older extra fields works perfectly

I attach you the screenshot of table jshopping_products.
Aw: Characteristics not saved

 
15.12.2013 21:41
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: Characteristics not saved

field type?

 
15.12.2013 21:56
#5
settas
Joomshopping forum user no avatar
Name: ilias
23.02.2012
Posts: 13
Quote
Aw: Characteristics not saved

It begins yesterday, when we created new field for multiple Listing.
But today we have the same problem also for single list.

Then we run BackUp which we taken 5 days ago, but the problem stays.

 
15.12.2013 22:30
#6
settas
Joomshopping forum user no avatar
Name: ilias
23.02.2012
Posts: 13
Quote
Aw: Characteristics not saved

Just create new field. I requested at existing product and we have the same problem.
Here is the screenshot.

Im very confused about this problem.

Please help me with any advice/suggession.
Aw: Characteristics not saved
new_Field_After_Save.JPG

 
15.12.2013 22:51
#7
settas
Joomshopping forum user no avatar
Name: ilias
23.02.2012
Posts: 13
Quote
Aw: Characteristics not saved

One more screenshot.
At table joomshopping_products the last saved field is the 191st.


Thanks again for your time
Aw: Characteristics not saved

 
16.12.2013 00:26
#8
settas
Joomshopping forum user no avatar
Name: ilias
23.02.2012
Posts: 13
Quote
Aw: Characteristics not saved

Hi,

Just i tryed to put manualy the column extra_field_192 at table joomshopping_products.. and returns this warning message : " #1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs "

Have you any idea about this?

Here is the Screenshot.
Thank you
Aw: Characteristics not saved

 
16.12.2013 02:13
#9
settas
Joomshopping forum user no avatar
Name: ilias
23.02.2012
Posts: 13
Quote
Aw: Characteristics not saved

Ok! Maybe it solved... At table joomshopping_products i changed the type of extra_fields_(1 to 200) from varchar(100) to String text.

So the new fields and products saved normally at the site. But also the new extra_fields created as varchar(100).

Any idea to make the type text as default for extra_fields?

I would like to read your opinion about... if you agree this solution or you suggest something else.

Thank you

 
16.12.2013 08:08
#10
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: Characteristics not saved

Try change type to
varchar 16
or
text


Letzte Ă„nderung: 16.12.2013 08:08
 
16.12.2013 09:14
#11
settas
Joomshopping forum user no avatar
Name: ilias
23.02.2012
Posts: 13
Quote
Aw: Characteristics not saved

Good morning,

Is it possible to have any problem at the near future from joomshopping updates if we change the type of extra_fields?

As i said, we changed manually the type for the existing extra_fields, but when we create (in admin area) new field it takes automatically the type varchar(100).

How could we make default the type text for the next requested extra_dields?

Thank you

 
16.12.2013 16:08
#12
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: Characteristics not saved

administrator\components\com_jshopping\controllers\productfields.php

change code

if (!$id){
$query = "ALTER TABLE `#__jshopping_products` ADD `extra_field_".$productfield->id."` varchar(100) NOT NULL";
$db->setQuery($query);
$db->query();
}

 
Copyrights MAXXmarketing GmbH. All Rights Reserved