Welcome Visitor, Please Login or Register Now Sunday, September 19, 2021 10:57 PM 
Forums Index > Mewsoft Products > Auctionawy > Affiliates
New Topic   New Reply
Search for:
Author Message
martin martin's personal page
Registered Member
Posts: 62 Display member's posts
Joined: 04-04-06 02:34 PM
Location: Lanzarote
Member Offline
View Member's Profile Visit member's website Canary Island Auctions PM
 
Back to top
Affiliates Edit Delete Reply with quote Quote
First Post Posted on: 04-04-11 10:29 AM next post first post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 09-19-21 10:57 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Affiliates Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 04-04-11 10:43 AM next post previous post
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 martin's personal page
Registered Member
Posts: 62 Display member's posts
Joined: 04-04-06 02:34 PM
Location: Lanzarote
Member Offline
View Member's Profile Visit member's website Canary Island Auctions PM
 
Back to top
Re: Affiliates Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 04-04-11 10:56 AM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 09-19-21 10:57 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Affiliates Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 04-04-11 02:34 PM next post previous post

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

martin martin's personal page
Registered Member
Posts: 62 Display member's posts
Joined: 04-04-06 02:34 PM
Location: Lanzarote
Member Offline
View Member's Profile Visit member's website Canary Island Auctions PM
 
Back to top
Re: Affiliates Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 04-05-11 12:12 AM last post previous post
Thanks Ahmed that seems to have solved it.
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print