Welcome Visitor, Please Login or Register Now Thursday, April 18, 2024 06:05 AM 
Forums Index > Mewsoft Products > Auctionawy > Errors in MySQL Syntax In Both Auctionawry and ClassifiedsAwry on Create Tables
New Topic   New Reply
Search for:
Author Message
purple purple's personal page
Registered Member
Posts: 6 Display member's posts
Joined: 12-31-05 07:43 AM
Member Offline
View Member's Profile Visit member's website http:// Send private message
 
Back to top
Errors in MySQL Syntax In Both Auctionawry and ClassifiedsAwry on Create Tables Edit Delete Reply with quote Quote
First Post Posted on: 07-08-09 03:35 PM next post first post
Auction Config Table Successfully Created.\ 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, Ad 7 TEXT, Ad 8 T' at line 91.\ Error Creating Items Cat_ID Index: Table 'tarantula.Items' doesn't exist.\ Error Creating Items Price Index: Table 'tarantula.Items' doesn't exist.\ Items Creating Links User_ID Index: Table 'tarantula.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 VARCHAR(150) ' at line 1.\ 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), Description TEX' at line 1.\ 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-18-24 06:05 AM
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: Errors in MySQL Syntax In Both Auctionawry and ClassifiedsAwry on Create Tables Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 07-09-09 02:02 AM next post previous post
Try to delete the database and create it again, what type of your server OS, mysql version?, if same error again emailme your ftp info to check it.

Mewsoft Support
www.mewsoft.com
purple purple's personal page
Registered Member
Posts: 6 Display member's posts
Joined: 12-31-05 07:43 AM
Member Offline
View Member's Profile Visit member's website http:// Send private message
 
Back to top
Re: Errors in MySQL Syntax In Both Auctionawry and ClassifiedsAwry on Create Tables Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 07-09-09 02:52 PM next post previous post
Red Hat Fedora Core 4 (64-bit) Linux, Apache 2.054, Perl 5.008006, MySQL 4.16\ \ I'm going to try setting up the database on an older database server we have (running MySQL 4.018) and it see if the database errors continue. I'll give you the FTP info if that doen't work.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-18-24 06:05 AM
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: Errors in MySQL Syntax In Both Auctionawry and ClassifiedsAwry on Create Tables Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 07-10-09 06:46 AM last post previous post
You need to setup a regular FTP (NOT SFTP) account for your domains
and make this account not the root user so you can access your server remotely
with that user instead of the root for security.
 
Anyway, I transferred the auction files to your server
and installed the auction software and configured it and everything is working
fine:
 
 
There was no problems with the software, it is all your installation steps
Note also that, the .zip files you download from our site you need to unzip on your computer
and use an FTP program to upload to the server because it is zipped on windows or if
you unzip o the server direct then you need to convert the files from DOS format to unix form
using the dos2unix.

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.1119 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation