1054 Unknown column 'scriptname' in 'field list'

31.01.2015 12:50
#1
Romuba
User Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 34
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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: 34
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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: 34
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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: 34
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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: 34
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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: 34
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

How?

 
31.01.2015 21:55
#12
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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: 34
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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: 34
Quote
Aw: 1054 Unknown column 'scriptname' in 'field list'

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

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.