Auction software for online auctions

Welcome Visitor, Please Login or Register Now

Wednesday, April 24, 2024 01:10 AM

Forums Index > Mewsoft Products > Auctionawy > Affiliates

New Topic New Reply

Search for:

Author

Message

martin

Registered Member

Posts: 62

Joined: 04-04-06 02:34 PM

Location: Lanzarote

Visit member's website Canary Island Auctions

Affiliates

Edit Delete

Quote

First Post Posted on: 04-04-11 10:29 AM

I have uploaded all the 3 files you sent me. The affiliates works on my website subastascanariasonline.com but I have no joy with the affiliates link on my control pannel all i get is the error-\ \ \ \ \ \ SQL Error \ SQL Error: Unknown column 'Users' in 'field list'\ Query: \ SELECT SUM(Hits) as Hits, SUM(Users) as Users FROM AuctionAffiliateStats\ Line 52, File /home/martin/public_html/cgi-bin/auction/AffiliatesAdm.pm.\ \ \ Regards Martin

mewsoft

Administrator Team Member

Posts: 5381

Joined: 04-24-24 01:10 AM

Location: knxoville, TN, USA

Visit member's website Mewsoft Corporation

Re: Affiliates	Edit Delete Quote
Reply #: 1 Posted on: 04-04-11 10:43 AM

You need to have the latest version of the auction and click on

create sql tables in the setup wizard

Mewsoft Support
www.mewsoft.com

martin

Registered Member

Posts: 62

Joined: 04-04-06 02:34 PM

Location: Lanzarote

Re: Affiliates

Edit Delete

Quote

Reply #: 2 Posted on: 04-04-11 10:56 AM

All my Auction updates are up to date. so do i have the latest version of Auctionawy ? and I have clicked on\ create sql tables in the setup wizard but still no joy! \ \ Create SQL \ Error Creating Auction_MakeAnOffer Table: Table 'Auction_MakeAnOffer' already exists.\ Error Creating AuctionItemQuestions Table: Table 'AuctionItemQuestions' already exists.\ Error Creating Auction Views Log Table: Table 'Auction_Views_Log' already exists.\ Error Creating Auction Affiliate Accounts Table: Table 'AuctionAffiliateAccounts' already exists.\ Error Creating Auction Affiliate Pending Users Table: Table 'AuctionAffiliatePendingUsers' already exists.\ Error Creating Auction Affiliate Stats Table: Table 'AuctionAffiliateStats' already exists.\ Error Creating Auction Affiliate Commissions Table: Table 'AuctionAffiliateUsersCommissions' already exists.\ Error Creating Auction Affiliate Users Table: Table 'AuctionAffiliateUsers' already exists.\ Error Creating Auction Config Table: Table 'Auction_Config' already exists.\ Error Creating Credit_Cards Table: Table 'Credit_Cards' already exists.\ Error Creating Items Table: Table 'Items' already exists.\ Error Creating Items Cat_ID Index: Duplicate key name 'Items_idx1'.\ Error Creating Items Price Index: Duplicate key name 'Items_idx4'.\ Items Creating Links User_ID Index: Duplicate key name 'Items_idx7'.\ Error Creating Auction_Featured Table: Table 'Auction_Featured' already exists.\ Error Creating Announcements Table: Table 'Auction_Announcements' already exists.\ Error Creating Auction Categories Zones Table: Table 'Auction_Categories_Zones' already exists.\ Error Creating Auction Formats Table: Table 'Auction_Formats' already exists.\ Error Creating Auction Categories Table: Table 'Auction_Categories' already exists.\ Error Creating Auction Categories Name Table: Table 'Auction_Categories_Name' already exists.\ Error Creating Auction Categories Description Table: Table 'Auction_Categories_Description' already exists.\ Error Creating Auction Categories Meta Table: Table 'Auction_Categories_Meta' already exists.\ Error Creating Auction Categories Count Table: Table 'Auction_Categories_Count' already exists.\ Error Creating AuctionLocation Table: Table 'AuctionLocation' already exists.\ Error Creating AuctionLocationName Table: Table 'AuctionLocationName' already exists.\ Error Creating AuctionLocationDescription Table: Table 'AuctionLocationDescription' already exists.\ Error Creating Auction Favorites Categories Table: Table 'Auction_Favorites_Categories' already exists.\ Error Creating Auction Favorites Users Table: Table 'Auction_Favorites_Users' already exists.\ Error Creating Pending Users Table: Table 'Pending_Users' already exists.\ Error Creating Pending Users Index Table: Duplicate key name 'Pending_Users_idx1'.\ Error Creating Users Table: Table 'Users' already exists.\ Error Creating Users Index Table: Duplicate key name 'Users_idx1'.\ Error Creating Users_Info Table: Table 'Users_Info' already exists.\ Error Creating Whos_Online Table: Table 'Whos_Online' already exists.\ Error Creating Block_List Table: Table 'Block_List' already exists.\ Error Creating Bank_Accounts Table: Table 'Bank_Accounts' already exists.\ Error Creating Deposits Table: Table 'Deposits' already exists.\ Error Creating Deposits Index: Duplicate key name 'User_ID_idx3'.\ Error Creating Related Categories Table: Table 'Related_Cats' already exists.\ Error Creating Mail Table: Table 'Mail' already exists.\ Error Creating Mail Index Email Table: Duplicate key name 'Mail_idx1'.\ Error Creating Mail Index List Table: Duplicate key name 'Mail_idx2'.\ Error Creating Mail_Lists Table: Table 'Mail_Lists' already exists.\ Error Creating Search Terms Table: Table 'Terms' already exists.\ Error Creating Banner Accounts Table: Table 'Banner_Accounts' already exists.\ Error Creating Banner Accounts Index Table: Duplicate key name 'Banner_Accounts_idx'.\ Error Creating Banner Campaigns Table: Table 'Banner_Campaigns' already exists.\ Error Creating Banner Campaigns index Table: Duplicate key name 'Banner_Campaigns_idx'.\ Error Creating Banner Zones Table: Table 'Banner_Zones' already exists.\ Error Creating Banner Zones Index Table: Duplicate key name 'Banner_Zones_idx'.\ Error Creating Banners Table: Table 'Banners' already exists.\ Error Creating Banners Index Table: Duplicate key name 'Banners_idx'.\ Error Creating Banner Rotation Index Table: Table 'Banner_Rotation_Index' already exists.\ Error Creating Banner Rotation index Table: Duplicate key name 'Banner_Rotation_idx'.\ Error Creating Banner Daily Stats Table: Table 'Banner_Daily_Stats' already exists.\ Error Creating Banner Daily Stats index Table: Duplicate key name 'Banner_Daily_Stats_idx'.\ Error Creating Banner Hourly Stats Table: Table 'Banner_Hourly_Stats' already exists.\ Error Creating Banner Hourly Stats index Table: Duplicate key name 'Banner_Hourly_Stats_idx'.\ Error Creating Banner Click Log Table: Table 'Banner_Click_Log' already exists.\ Error Creating Banner Click Log index Table: Duplicate key name 'Banner_Click_Log_idx'.\ Error Creating Auction Bids Table: Table 'Auction_Bids' already exists.\ Error Creating Auction Bids Index: Duplicate key name 'User_ID_idx1'.\ Error Creating Item_Clicks Table: Table 'Item_Clicks' already exists.\ Error Creating Item_Views Table: Table 'Item_Views' already exists.\ Error Creating WatchList Table: Table 'Auction_Watchlist' already exists.\ Error Creating watch_idx1 Index: Duplicate key name 'watch_idx1'.\ Error Creating Auction_Wonlist Table: Table 'Auction_Wonlist' already exists.\ Error Creating Wonlist_idx1 Index: Duplicate key name 'Wonlist_idx1'.\ Error Creating Auction_Lostlist Table: Table 'Auction_Lostlist' already exists.\ Error Creating Lostlist_idx1 Index: Duplicate key name 'Lostlist_idx1'.\ Error Creating FeedbackRating Table: Table 'FeedbackRating' already exists.\ Error Creating FeedbackRating1 Cat_ID Index: Duplicate key name 'FeedbackRating1'.\ Error Creating FeedbackComments Table: Table 'FeedbackComments' already exists.\ Error Creating FeedbackComments1 Index: Duplicate key name 'FeedbackComments1'.\ Error Creating FeedbackComments2 Index: Duplicate key name 'FeedbackComments2'.\ Error Creating Auction_Views Table: Table 'Auction_Views' already exists.\ Error Creating Transactions Table: Table 'Transactions' already exists.\ Error Creating Transactions Index: Duplicate key name 'User_ID_idx4'.\ Error Creating Transactions ID Index: Duplicate key name 'ID_idx1'.\ Error Creating Auction_Invoices Table: Table 'Auction_Invoices' already exists.\ Error Creating Auction_Invoices1 Index: Duplicate key name 'Auction_Invoices1'.\ Error Creating Auction_Invoices_Track Table: Table 'Auction_Invoices_Track' already exists.\ Error Creating FeedbackTrackSeller Table: Table 'FeedbackTrackSeller' already exists.\ Error Creating FeedbackTrackSeller1 Index: Duplicate key name 'FeedbackTrackSeller1'.\ Error Creating FeedbackTrackSeller2 Index: Duplicate key name 'FeedbackTrackSeller2'.\ Error Creating FeedbackTrackBuyer Table: Table 'FeedbackTrackBuyer' already exists.\ Error Creating FeedbackTrackBuyer1 Index: Duplicate key name 'FeedbackTrackBuyer1'.\ Error Creating FeedbackTrackBuyer2 Index: Duplicate key name 'FeedbackTrackBuyer2'.\ Error Creating Auction_Stats Table: Table 'Auction_Stats' already exists.\ Error Creating BidderTrack Table: Table 'BidderTrack' already exists.\ Error Creating SellerTrack Table: Table 'SellerTrack' already exists.\ \ \ Copyright © 2000-2007 Mewsoft® Corporation. All Rights Reserved

mewsoft

Administrator Team Member

Posts: 5381

Joined: 04-24-24 01:10 AM

Location: knxoville, TN, USA

Re: Affiliates	Edit Delete Quote
Reply #: 3 Posted on: 04-04-11 02:34 PM

May be you have created the affiliates tables before with older versions. To correct, go to the dataabse and SQL manager, delete the tables that have any "affiliate" in it sname, then from the setup wizard click on Create SQL tables again.

Mewsoft Support
www.mewsoft.com