studio

site development

Welcome, Guest
Please Login or Register.    Lost Password?
Forum is locked
DB Error after Upgrading from 1.0.0 to ipricecalc plus 1.1.2 Forum is locked
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: DB Error after Upgrading from 1.0.0 to ipricecalc plus 1.1.2
*
#895
DB Error after Upgrading from 1.0.0 to ipricecalc plus 1.1.2 1 Year, 7 Months ago Karma: 0
Hello Igort,

After upgrade, cannot process an order- database needs updating- error is:

500 - DB function failed with error number 1054
Unknown column 'currcode' in 'field list' SQL=INSERT INTO jos_iprice_order_main ( orderno, orderdate, fio, firm, email, phone, comments , totalamount, currcode, totalratio, totalratioview , showtotalratio) VALUES ( 1, NOW() , 'Demo Account, 'Cloud Controllers', 'demo@cloudcontrollers.com', '415-494-2855', 'comments field', 0 ,'RUR', 0, 0, 1)


Could not find upgrade instructions, so I followed these steps:

  • backed up joomla database

  • backed up old ipricecalc component folder

  • uninstalled ipricecalc through the joomla admin console

  • installed pricecalc plus 1.1.2



Thanks!

-Jack
cloudcontrol
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
The topic has been locked.
 
#923
Re:DB Error after Upgrading from 1.0.0 to ipricecalc plus 1.1.2 1 Year, 7 Months ago Karma: 0
*Bump*
cloudcontrol
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
The topic has been locked.
 
#925
Re:DB Error after Upgrading from 1.0.0 to ipricecalc plus 1.1.2 1 Year, 7 Months ago Karma: 0
Solved. Deleting jos_iprice rows in database did the trick.
cloudcontrol
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
The topic has been locked.
 
Go to topPage: 1
Moderators: Igort
get the latest posts directly to your desktop

Announcements

Экономичность и качество.
Несовместимые ранее понятия стали возможными у нас благодаря применению новейших технологий сайтостроения. Современная система управления сайтом, тщательное тестирование, модульность сайта - все это позволило сократить затраты на производство.