Hello we was using Joomla 2.5 with Joomshopping 3.16.1. I have upgrades first from 3.16.1 do 4.7.1 with help of Upgrade 3.14.3 => 4.2.2. Then I did the upgrade to Joomla Joomla! 3.3.6. After that I upgraded from 4.2.2 to 4.7.1.
Now I get this error when i want do see the customers in the backend with joomshopping.
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 `jos_jshopping_users` AS U INNER JOIN `jos_users` AS UM ON U.user_id = UM.id left join jos_jshopping_usergroups as UG on UG.usergroup_id=U.usergroup_id where 1 order by u_name asc LIMIT 0, 20
What do I have do to, to fix this errors?
Thanks for your help.
Regards Marco
Joomla: Joomla! 3.3.6
JoomShopping: 4.7.1
PHP: 5.4.32
MySQL: 5.5.35
Website Url: http://new.fleecespieli.ch/
JoomShopping: 4.7.1
PHP: 5.4.32
MySQL: 5.5.35
Website Url: http://new.fleecespieli.ch/