1054 Unknown column 'scriptname' in 'field list'

31.01.2015 12:50
#1
Romuba
User Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 20
Quote
1054 Unknown column 'scriptname' in 'field list'

I have performed a migration from Joomla 2.5 with JoomShopping Version 3.12.3 to Joola 3.3 and Joomshopping Version 4.8.1. Everything is working perfectly except for three problems.

1) In the Admin area if I click on the Joomshopping Orders I get the following error: 1054 Unknown column 'scriptname' in 'field list' SQL=SELECT payment_id, `name_en-GB` as name, `description_en-GB` as description , payment_code, payment_class, scriptname, payment_publish, payment_ordering, payment_params, payment_type FROM `pool_jshopping_payment_method` ORDER BY payment_ordering

2) In Admin if I click on Clients I get the error: 1054 Unknown column 'U.number' in 'field list' SQL=SELECT U.number, U.u_name, U.f_name, U.l_name, U.email, U.user_id, UM.block, UG.usergroup_name FROM `pool_jshopping_users` AS U INNER JOIN `pool_users` AS UM ON U.user_id = UM.id left join pool_jshopping_usergroups as UG on UG.usergroup_id=U.usergroup_id where 1 order by u_name asc LIMIT 0, 100

3) On the front end when one proceeds to checkout and then Confirm Order the follow screen displays this error: 1146 - Table 'romuba_poolren.pool_jshopping_attr_groups' doesn't exist SQL=SELECT A.attr_id, A.`name_en-GB` as name, A.`description_en-GB` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_en-GB` as groupname FROM `pool_jshopping_attr` as A left join `pool_jshopping_attr_groups` as G on A.`group`=G.id ORDER BY G.ordering, A.attr_ordering

Please help.


Joomla: 3.3.6
JoomShopping: 4.8.1
PHP: 5.5.12
MySQL: 5.6.17
Website Url: localhost
 
31.01.2015 14:18
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

Problem in your update. (NEED step teo step!)

http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/forum/posts/7/4884.html?lang=en

 
31.01.2015 14:46
#3
Romuba
User Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 20
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

I did follow those steps correctly in the first post. I migrated the website using MigratemePlus.

I upgraded Joomshopping to version 4 before the migration and did receive the error and then did the migration and all seemed fine until I tried to process an order and hit the error when I got to the final stage of Checkout.

 
31.01.2015 15:39
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

1. need update
Component Update 3.12.3 -> 3.13.0
Component Update 3.13.0 -> 3.13.1
...
Component Update 3.19.2 -> 3.20.0

2. update joomla

3. Component Upgrade 3.20.0 -> 4.8.0 (Befere update joomla 2.5-3.0)

 
31.01.2015 16:27
#5
Romuba
User Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 20
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

I have now done the following:

On the Joomla 2.5 website I updated using each update package in turn until I got an error and that was when I updated to 4.7.0.

I then migrated Joomla to 3.3 using MigratmePLUS

Then I updated Joomshopping further using each update package until I got to 4.9.0

The errors still happen when I click on the following:

Clients: 1054 Unknown column 'U.number' in 'field list' SQL=SELECT U.number, U.u_name, U.f_name, U.l_name, U.email, U.user_id, UM.block, UG.usergroup_name FROM `mmp_renov_jshopping_users` AS U INNER JOIN `mmp_renov_users` AS UM ON U.user_id = UM.id left join mmp_renov_jshopping_usergroups as UG on UG.usergroup_id=U.usergroup_id where 1 order by u_name asc LIMIT 0, 100

 
31.01.2015 18:28
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

Skiped other update.

Try fixed
http://www.webdesigner-profi.de/joomla-webdesign/shop/addons/check-db-structure-table-shop.html?lang=en

 
31.01.2015 18:42
#7
Romuba
User Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 20
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

I installed the DB for this version. When I run the Test I get the following:

Version Joom Shopping 4.9.0
# Name table Column Column Type Error
1 config image_product_original_width No column -image_product_original_width
2 config image_product_original_height No column -image_product_original_height
3 config id int Invalid column type, the type must be -tinyint
4 orders invoice_date No column -invoice_date
5 order_item weight float, Invalid column type, the type must be -decimal,
6 payment_method show_bank_in_order No column -show_bank_in_order
7 payment_method order_description No column -order_description
8 products_attr count int Invalid column type, the type must be -decimal,
9 products_reviews time date Invalid column type, the type must be -datetime
10 users number No column -number
11 vendors benef_bic_bic No column -benef_bic_bic

 
31.01.2015 19:05
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

Checked and click fixed

 
31.01.2015 19:29
#9
Romuba
User Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 20
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

Did and then got: 1068 Multiple primary key defined SQL=ALTER TABLE `mmp_renov_jshopping_config` CHANGE `id` `id` tinyint(1) NOT NULL PRIMARY KEY

 
31.01.2015 19:36
#10
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

Skip this field.

 
31.01.2015 21:22
#11
Romuba
User Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 20
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

How?

 
31.01.2015 21:55
#12
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

Not checked.

Checked all problem and click fix


Letzte Ă„nderung: 31.01.2015 21:56
 
01.02.2015 06:58
#13
Romuba
User Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 20
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

I have attached images. I checked all boxes and the clicked Fix and the error displays.
Aw: 1054 Unknown column 'scriptname' in 'field list'
error_after_Fix.png

 
01.02.2015 18:17
#14
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

Not checked 1.

 
01.02.2015 19:49
#15
Romuba
User Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 20
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

Thank you very much. That looks like it has been sorted.

 
Copyrights MAXXmarketing GmbH. All Rights Reserved