Error uploading database for auction site

[SeanF]

I have created the database assigned the user with full privilages but when I select to upload the file I get the following error:

Error
SQL query:

CREATE TABLE bidware_bids(

id int( 11 ) NOT NULL AUTO_INCREMENT ,
auctionid int( 11 ) NOT NULL default '0',
bidderid int( 11 ) NOT NULL default '0',
bidamount double( 16, 2 ) NOT NULL default '0.00',
date datetime NOT NULL default '0000-00-00 00:00:00',
quantity int( 11 ) NOT NULL default '0',
proxy double( 16, 2 ) NOT NULL default '0.00',
out tinyint( 4 ) NOT NULL default '0',
invalid tinyint( 4 ) NOT NULL default '0',
emailsent tinyint( 4 ) NOT NULL default '0',
deleted tinyint( 4 ) NOT NULL default '0',
PRIMARY KEY ( id )
) TYPE = MYISAM PACK_KEYS =0 COMMENT = 'Table with bids';



MySQL said:

#1064 - 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 'out tinyint(4) NOT NULL default '0',
invalid tinyint(4) NOT NULL default '0',
' at line 9

I am mysql illiterate so I have no idea. The company is offering to install it for me for a fee but I have the feeling they intentionally messed up there code so they could get the extra money for installation. Any help you can give me would be greatly appreciated.

[lnxcode]

Welcome to the HostICan Forum!

Have you checked out:

HostICan - Support - Pre-Sales, E-Mail, and so many more answers... :: Why do I get a MySQL Import error?

HostICan - Support - Pre-Sales, E-Mail, and so many more answers... :: Importing MySQL (in a different language)

The above links might be what you're looking for.

[SeanF]

Ok I have tried both of those here is the top of the sql file that they gave me to upload

-- MySQL dump 9.11
--
-- Host: localhost Database: auction
-- ------------------------------------------------------
-- Server version 4.0.25-standard
--
-- Table structure for table `auction_category`
--

DROP TABLE IF EXISTS auction_category;
CREATE TABLE auction_category (
cat_id int(8) NOT NULL auto_increment,
parent_id int(8) NOT NULL default '0',
cat_name varchar(50) NOT NULL default '',
child_cat smallint(1) NOT NULL default '0',
cat_status smallint(1) NOT NULL default '1',

Please let me know if I am doing something wrong.

Is there anyway to e-mail the dump file to someone to see if they can get it to upload?

[lnxcode]

Seems you're currently (from the above) are using MySQL 4.0 and we're using MySQL 5.0 so what you need to do is:

PHPMyAdmin >> Select the database >> Import >> Compatibility 4.0 >> Browse >> Select the db and hit open (and import).

[SeanF]

I had noticed that last night after I had posted and so I tried that last night. Today I tried deleting the database and starting from scratch. I created the database and the user with full privilages, assigned it to the database then opened up phpmydmin, selected the database, then selected import, selected the mysql40, then selected the file to upload. I tried uploading both with the utf8 selected and when that didn't work I selected latin1. I still get the same exact error code. The place I got the software from is obviously saying it is a problem with your server. Of course they are trying to get me to host on there server or get me to pay $50 to have them install this software on this server but I want to make sure that I am doing everything right and that there is not a problem on the server side.

[lnxcode]

Originally Posted by SeanF

I had noticed that last night after I had posted and so I tried that last night. Today I tried deleting the database and starting from scratch. I created the database and the user with full privilages, assigned it to the database then opened up phpmydmin, selected the database, then selected import, selected the mysql40, then selected the file to upload. I tried uploading both with the utf8 selected and when that didn't work I selected latin1. I still get the same exact error code. The place I got the software from is obviously saying it is a problem with your server. Of course they are trying to get me to host on there server or get me to pay $50 to have them install this software on this server but I want to make sure that I am doing everything right and that there is not a problem on the server side.

Did you get this resolved?