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?

[SeanF]

No it is the same even with all of the different options I tried that were spelled out in my previous message and there it still will not upload. I get the same error no matter what I try.

[lnxcode]

So basically its just a MySQL 4 version of the DB and you want to import it? I dont see any reason why it would cause issues... just simply set computability and leave the rest to auto and that should do it... what error message does it throw back at you?

[SeanF]

Here is the same message I have been getting the whole entire time.

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 have tried every different compatibility mode now and get the same message every time. If you want you can e-mail me and I will send you all the info and the file so you can see it for yourself. I appreciate your help this just seems like such an easy thing to be able to do and I can't understand why it is not working. I have uploaded databases on other servers without incident but not this particular one.

[SeanF]

Well I just had a brilliant idea and went and uploaded the file to another website I am running on godaddy and it uploaded like a charm so it is a problem with this site. I did notice that godaddy had the option to select which server version to run. I haven't seen that on your server. Is this a possibility? Please let me know because I really want to get this up and running and this is the first time I have tried your hosting and so far am less than impressed.