please help error

[LuisDesigns]

hey guys, installing my application i came accross this error:
Error: SQL import error while executing line 23 ") ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;".
MySql error: 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6' at line

can someone help me out please?
txs

[Günter_Schenk]

Please post your complete query -- this error message usually points to something within your query that´s preceeding the "ENGINE=..." hint, so without knowing your query it´s impossible to find out what it could be. BTW, it may well be that you just used a MySQL reserved word " for a table name.

[LuisDesigns]

Error:SQL import error while executing line 23 ") ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;".
MySql error: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 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6' at line

this is the table:

CREATE TABLE `skadate_ads_position` (
`position_id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
PRIMARY KEY (`position_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;


i use version MySQL 4.0.16 .

txs

[LuisDesigns]

please someone help 😞

[Günter_Schenk]

the CREATE TABLE stuff you posted seems OK (and I just added this SQL to a database without problems), but the error message actually complains about ") preceeding the "ENGINE" -- wonder where the double quote (") comes from, but it shouldn´t be there

[LuisDesigns]

hmmm, so there is no way for me to get this table to work?
txs

[LuisDesigns]

can someone help me please, i have the whole tables in a script, i can email to if someone wouldn't mind looking at it.

txs

[Günter_Schenk]

please send me a private message and post your email there

[LuisDesigns]

sent 🙂

[LuisDesigns]

someone help please? i in panic here................................' ' ' ' ' ' lol
txs

[bsoliman]

Luis, I had the same problem recently when exporting tables from a testing server (running MySQL 4.x) to a production server (running 3.23). It turned out that I should have been exporting the tables to be compatible with MySQL 3.23 rather than using the default settings. When I re-exported them for 3.23 the problem went away.

When I compared the exported files I noticed that the only difference was the part that said DEFAULT CHARSET=latin1, so try removing that and see if it works.

Bev

[Günter_Schenk]

sorry for the delay, Luis -- all of a sudden I had to deal with a *nasty* spyware (actually a fake "Microsoft piracy control" that told me my registration key has now been registered by someone else, and please register again and leave your credit card number) on XP which actually blocked everything else :-(

Did Bev´s suggestion work for you ?

[LuisDesigns]

oh no, please don't apologise, i just am glad you guys are willing to help me. No, i haven't tried it yet, but i will tonight. I will let you guys know if it works or not. Meanwhile, can i send you the file i have with the tables, it seems that every table has same problem.
Thank you again.

PS-Hope you got that spyware fixed.

[Günter_Schenk]

Hi Luis,

>>
Meanwhile, can i send you the file i have with the tables
>>

no, better try Bev´s solution first 😉 You say that all your tables suffer from this, and I *think* that´s really pointing to an incompatibility between MySQL versions -- I once had a similar issue BTW with a 3rd party "CREATE TABLE" snippet which failed to import just because my DB version didn´t know how to handle the unsupported "DEFAULT CHARSET=whatever" as well and just happily threw errors.

>>
PS-Hope you got that spyware fixed.
>>

Yes fortunately, that took about 1 day (20 hours were admittedly spent on just panicking 😉, but believe it or not -- the folks at Microsoft happened to be *extremely* helpful and experienced, already knew this rather new spyware variant, and guided me through all the "howto get rid of this" steps very well !

[LuisDesigns]

I am glad to hear you got it fix. Yeah i can panic really easy when i get a virus or similar, specialy if t to lose, lucky i have work that i dont wanky that my McAfee is doing a good job on that department, lol.
So, i will try that bsoliman recommended me, hopefully it will work, if not can i send you the file?
Thanks buddy

[Günter_Schenk]

>>
So, i will try that bsoliman recommended me, hopefully it will work, if not can i send you the file?
>>

yes sure -- if it doesn´t work, just leave a message here, and I´ll contact you per email

[LuisDesigns]

thank you

[LuisDesigns]

Do i need to replace the ENGINE to TYPE since i am running old myqgl version?
and i remove DEFAULT CHARSET=latin1 from all tables right?

[LuisDesigns]

now i get this:
MySql connection failed

[bsoliman]

Luis, are you asking me the question?

Below is an example of an actual table I successfully epxorted from MySQL 4.x and imported into MySQL 3:23:

CREATE TABLE `mgt_forsale` (
`id` int(10) NOT NULL auto_increment,
`propertyID` varchar(10) default NULL,
`state` varchar(10) default NULL,
`county` varchar(50) default NULL,
`city` varchar(50) default NULL,
`street` varchar(50) default NULL,
`units` smallint(5) unsigned default NULL,
`price` int(10) unsigned default NULL,
`contact` varchar(50) default NULL,
`phone` varchar(25) default NULL,
`email` varchar(30) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

[bsoliman]

Luis Wrote:

now i get this:
MySql connection failed

---

AFAIK a failed connection is a separate issue unrelated to the creation of the table. Maybe your server is down or some connection setting is wrong.

[LuisDesigns]

yes, i tried that, i got the" Mysql connection failed" but after i went to configs.php
and found this:
<?php

define( 'DIR_ROOT', '------/' );

define( 'URL_HOME', ' http://localhost/skadate/' );

define( 'MYSQL_DATABASE_HOST', 'localhost' );
define( 'MYSQL_DATABASE_USER', '----' );
define( 'MYSQL_DATABASE_PASS', '-----' );
define( 'MYSQL_DATABASE_NAME', '----' );
define( 'DB_PREFIX', 'skadate_' );

?>

I know i have to replace it with my details, but what do i put in here ?? :
define( 'DIR_ROOT', '------/' );

define( 'URL_HOME', ' http://localhost/skadate/' );

thanks for helping me

[LuisDesigns]

BTW this are the errors i get now:
Warning: main(therainbowpride.comlayouts/victory/layout.php): failed to open stream: No such file or directory in /home/therainb/public_html/inc/inc.header.php on line 188

Fatal error: main(): Failed opening required 'therainbowpride.comlayouts/victory/layout.php' (include_path='.:/usr/local/lib/php') in /home/therainb/public_html/inc/inc.header.php on line 188

[LuisDesigns]

did u read this message i sent ? Just in case u missed it cos i sent it almost 5 secs after, sorry:
BTW this are the errors i get now:
Warning: main(therainbowpride.comlayouts/victory/layout.php): failed to open stream: No such file or directory in /home/therainb/public_html/inc/inc.header.php on line 188

Fatal error: main(): Failed opening required 'therainbowpride.comlayouts/victory/layout.php' (include_path='.:/usr/local/lib/php') in /home/therainb/public_html/inc/inc.header.php on line 188

[LuisDesigns]

ok, got that one fixed, now i get this, OMG, its a non stop lol

Error: Table 'therainb_skadate5.skadate_profile_field' doesn't exist

in query: "SELECT `field`.*, `match_field_name`.`name` AS `matching`, `match_field`.`match_type` AS `matching_type` FROM `skadate_profile_field` AS `field` LEFT JOIN `skadate_link_profile_field_match` AS `match_field` ON `field`.`profile_field_id`=`match_field`.`match_profile_field_id` LEFT JOIN `skadate_profile_field` AS `match_field_name` USING ( `profile_field_id` )"
debug string: ""