Welcome Visitor, Please Login or Register Now Sunday, April 28, 2024 09:27 PM 
Forums Index > Mewsoft Products > Auctionawy > AuctionAwy 8.2 Setup wizard create tables problem
New Topic   New Reply
Search for:
Author Message
liberal liberal's personal page
Registered Member
Posts: 27 Display member's posts
Joined: 04-28-24 09:27 PM
Member Offline
View Member's Profile Send private message
 
Back to top
AuctionAwy 8.2 Setup wizard create tables problem Edit Delete Reply with quote Quote
First Post Posted on: 09-09-08 02:39 PM next post first post
Hi, \ \ I have the following problem, when want to create clean files. I tried it many times.\ \ MySQL is: 4.0.22-standard under Linux\ \ Thanks for any help.\ \ **************************************************************\ Creating Auction System SQL Tables\ \ Credit Cards Table Successfully Created.\ Error Creating Items Table: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1 TEXT, Ad 2 TEXT, Ad 3 TEXT, Ad 4 TEXT, Ad 5 TEXT, Ad 6 TEXT, .\ Error Creating Items Cat_ID Index: Table 'tayfun_auctions.items' doesn't exist.\ Error Creating Items Price Index: Table 'tayfun_auctions.items' doesn't exist.\ Items Creating Links User_ID Index: Table 'tayfun_auctions.items' doesn't exist.\ Auction Featured Table Successfully Created.\ Announcements Table Successfully Created.\ Auction Categories Zones Table Successfully Created.\ Auction Formats Table Successfully Created.\ Auction Categories Table Successfully Created.\ Auction Categories Name Table Successfully Created.\ Auction Categories Description Table Successfully Created.\ Auction Categories Meta Table Successfully Created.\ Auction Categories Count Table Successfully Created.\ AuctionLocation Table Successfully Created.\ Error Creating AuctionLocation Name Table: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Name ( Cat_ID INT, Lang VARCHAR(50), Name .\ Error Creating AuctionLocation Description Table: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Description ( Cat_ID INT, Lang VARCHAR(50), .\ Auction Favorites Categories Table Successfully Created.\ Auction Favorites Users Table Successfully Created.\ Pending Users Table Successfully Created.\ Pending Users Index Table Successfully Created.\ Users Table Successfully Created.\ Users Index Table Successfully Created.\ Users_Info Table Successfully Created.\ Who's Online Table Successfully Created.\ Block_List Table Successfully Created.\ Bank Accounts Table Successfully Created.\ Deposits Table Successfully Created.\ Deposits Index Successfully Created.\ Related Categories Table Successfully Created.\ Mail Lists Table Successfully Created.\ Mail Email Index Successfully Created.\ Mail List Index Successfully Created.\ Mail Lists Count Table Successfully Created.\ Search Terms Table Successfully Created.\ Terms Term Index Successfully Created.\ Banner Manager Accounts Table Successfully Created.\ Accounts Index Successfully Created.\ Banner Manager Banners Table Successfully Created.\ Banners Index Successfully Created.\ Banner Manager Stats Table Successfully Created.\ Banner Zones Index Successfully Created.\ Banner Manager Banners Table Successfully Created.\ Banners Index Successfully Created.\ Banner Manager Rotation Index Table Successfully Created.\ Rotation Index Successfully Created.\ Banner Manager Stats Table Successfully Created.\ Banner Manager Stats Index Successfully Created.\ Banner Manager Hourly Stats Table Successfully Created.\ Banner Manager Hourly Stats Index Successfully Created.\ Banner Manager Click Log Table Successfully Created.\ Banner Manager Click Log Index Successfully Created.\ Auction Bids Table Successfully Created.\ Auction Bids Index Successfully Created.\ Item Clicks Table Successfully Created.\ Item Views Table Successfully Created.\ WatchList Table Successfully Created.\ Watchlist watch_idx1 Index Successfully Created.\ Auction_Wonlist Table Successfully Created.\ Wonlist_idx1 Index Successfully Created.\ Auction_Lostlist Table Successfully Created.\ Lostlist_idx1 Index Successfully Created.\ FeedbackRating Table Successfully Created.\ Featured FeedbackRating1 Index Successfully Created.\ FeedbackComments Table Successfully Created.\ FeedbackComments1 Index Successfully Created.\ FeedbackComments2 Index Successfully Created.\ Auction Views Table Successfully Created.\ Transactions Table Successfully Created.\ Transactions Index Successfully Created.\ Transactions ID Index Successfully Created.\ Auction_Invoices Table Successfully Created.\ Auction_Invoices1 Index Successfully Created.\ Auction_Invoices_Track Table Successfully Created.\ FeedbackTrackSeller Table Successfully Created.\ FeedbackTrackSeller1 Index Successfully Created.\ FeedbackTrackSeller2 Index Successfully Created.\ FeedbackTrackBuyer Table Successfully Created.\ FeedbackTrackBuyer1 Index Successfully Created.\ FeedbackTrackBuyer2 Index Successfully Created.\ Auction Stats Table Successfully Created.\ BidderTrack Table Successfully Created.\ SellerTrack Table Successfully Created.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-28-24 09:27 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: AuctionAwy 8.2 Setup wizard create tables problem Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 09-09-08 08:19 PM next post previous post

Make sure the files createTables.pm is not corrupted during your upload. Also delete the database and create it again before creating the tables.


Mewsoft Support
www.mewsoft.com
liberal liberal's personal page
Registered Member
Posts: 27 Display member's posts
Joined: 04-28-24 09:27 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: AuctionAwy 8.2 Setup wizard create tables problem Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 09-09-08 11:59 PM next post previous post
Hi,\ \ I did it 2-3 times again as you advice, but it gives same errors! \ \ The files are not corrupted and uploaded as text.\ \ Have you an other advice?\ \ Thanks
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-28-24 09:27 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: AuctionAwy 8.2 Setup wizard create tables problem Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 09-10-08 02:43 PM next post previous post

Post the URL to your testserver.cgi script.


Mewsoft Support
www.mewsoft.com
liberal liberal's personal page
Registered Member
Posts: 27 Display member's posts
Joined: 04-28-24 09:27 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: AuctionAwy 8.2 Setup wizard create tables problem Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 09-10-08 05:47 PM next post previous post
This is the address:\ \ http://www.ajans.com/cgi-bin/auction/testserver.cgi
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-28-24 09:27 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: AuctionAwy 8.2 Setup wizard create tables problem Edit Delete Reply with quote Quote
Reply #: 5 Posted on: 09-11-08 12:10 PM next post previous post
This link is giving me Browser Time Out, I can see your home page image but not any script. This means your installation is not complete or correct. Try to use our Auto installer it may help you and change permissions if not set by the installer.

Mewsoft Support
www.mewsoft.com
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-28-24 09:27 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: AuctionAwy 8.2 Setup wizard create tables problem Edit Delete Reply with quote Quote
Reply #: 6 Posted on: 09-11-08 10:13 PM next post previous post

I tried again and the link worked, I found your admin.cgi with no login so I finished your installation and set a login for the admin. Email me to send your admin.cgi login.


Mewsoft Support
www.mewsoft.com
liberal liberal's personal page
Registered Member
Posts: 27 Display member's posts
Joined: 04-28-24 09:27 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: AuctionAwy 8.2 Setup wizard create tables problem Edit Delete Reply with quote Quote
Reply #: 7 Posted on: 09-11-08 11:55 PM next post previous post
Hi,\ \ I was reinstalled AuctionAwy as you say over the script 'install.cgi' before you take the the controlle in admin. This script transferred and chmoded all files and then I created the tables over admin.cgi without any problem. \ \ When I saw the login window, without seeing your message here, over FTP modified 'sysconfig.pm' and reenter admin user and password over admin.cgi.\ \ So, I don't need login pair any more!\ \ Many thanks for your help!
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-28-24 09:27 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: AuctionAwy 8.2 Setup wizard create tables problem Edit Delete Reply with quote Quote
Reply #: 8 Posted on: 09-12-08 12:32 AM last post previous post
GOOD

Mewsoft Support
www.mewsoft.com
Page 1 of 1
Go to page:

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

  Mewsoft and Mewsoft Logos are registered trademarks. ® Corporation. All Rights Reserved.  Copyright -  Privacy -  Terms of Use  Page Load: 0.2485 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation