15.12.2013 20:17
|
|
settas
Name: ilias
23.02.2012
Posts: 13
|
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)
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25942
|
Aw: Characteristics not saved
See field type
table
jos_jshopping_products
extra_field_1?
extra_field_2?
....
(use phpmyadmin)
|
|
15.12.2013 21:29
|
|
settas
Name: ilias
23.02.2012
Posts: 13
|
Aw: Characteristics not saved
Hi again,
All the older extra fields works perfectly
I attach you the screenshot of table jshopping_products.
|
|
15.12.2013 21:41
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25942
|
Aw: Characteristics not saved
field type?
|
|
15.12.2013 21:56
|
|
settas
Name: ilias
23.02.2012
Posts: 13
|
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
|
|
settas
Name: ilias
23.02.2012
Posts: 13
|
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.
new_Field_After_Save.JPG
|
|
15.12.2013 22:51
|
|
settas
Name: ilias
23.02.2012
Posts: 13
|
Aw: Characteristics not saved
One more screenshot.
At table joomshopping_products the last saved field is the 191st.
Thanks again for your time
|
|
16.12.2013 00:26
|
|
settas
Name: ilias
23.02.2012
Posts: 13
|
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
|
|
16.12.2013 02:13
|
|
settas
Name: ilias
23.02.2012
Posts: 13
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25942
|
Aw: Characteristics not saved
Try change type to
varchar 16
or
text
Last change: 16.12.2013 08:08
|
|
16.12.2013 09:14
|
|
settas
Name: ilias
23.02.2012
Posts: 13
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25942
|
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();
}
|
|