Forums Index > Mewsoft Products > Auctionawy > category SQL problem
bidzonline First Post Posted on: 10-22-08 10:29 PM
category SQL problem

Hi all,\ \ I finally had the courage to upgrade from NetAuctions to Auctionawy 8.x\ \ I followed instructions on installation and migration of data files. Now, whenever I try to add or edit a category I get the following error:\ \ SQL Error: Unknown column 'Icon' in 'field list'\ Query: \ UPDATE Auction_Categories set Parent=0, Active=1, Accept=1, Sort=0, Teaser=0, Adult=0, Login=0, Icon='', Format='', Template='' WHERE Cat_ID=3 \ Line 442, File /home/virtual/site480/fst/var/www/cgi-bin/auctionv8/CategoriesAdmin.pm.\ \ As a matter of fact, I did get the similar message when working with Upgrade8.cgi.\ \ Can anyone help? I already have registered sellers and listed auctions, so I'd rather not lose their information.\ \ Thanks in advance.

Grigor K.

webmaster

www.bidzonline.com

mewsoft Reply #: 1 Posted on: 10-23-08 12:07 PM
Re: category SQL problem

If you followed the Migration tool instructions exactly, you should have no errors. Double check the steps on the migration tool. You should fully install Auctionawy 2005 on a new directory and use a new MySQL database then use the migration tool.

Mewsoft Support
www.mewsoft.com