31.01.2015 12:50
|
|
Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 34
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25919
|
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
|
|
Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 34
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25919
|
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
|
|
Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 34
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25919
|
|
|
31.01.2015 18:42
|
|
Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 34
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25919
|
Aw: 1054 Unknown column 'scriptname' in 'field list'
Checked and click fixed
|
|
31.01.2015 19:29
|
|
Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 34
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25919
|
Aw: 1054 Unknown column 'scriptname' in 'field list'
Skip this field.
|
|
31.01.2015 21:22
|
|
Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 34
|
Aw: 1054 Unknown column 'scriptname' in 'field list'
How?
|
|
31.01.2015 21:55
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25919
|
Aw: 1054 Unknown column 'scriptname' in 'field list'
Not checked.
Checked all problem and click fix
Last change: 31.01.2015 21:56
|
|
01.02.2015 06:58
|
|
Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 34
|
Aw: 1054 Unknown column 'scriptname' in 'field list'
I have attached images. I checked all boxes and the clicked Fix and the error displays.
error_after_Fix.png
|
|
01.02.2015 18:17
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25919
|
Aw: 1054 Unknown column 'scriptname' in 'field list'
Not checked 1.
|
|
01.02.2015 19:49
|
|
Romuba
Name: Ross Bartholomew
11.05.2011
Posts: 34
|
Aw: 1054 Unknown column 'scriptname' in 'field list'
Thank you very much. That looks like it has been sorted.
|
|