#1064 - You have an error in your SQL syntax; - Joomla! Forum - community, help and support


hi there, have searched forums , found other posts similar problem none of suggestions have helped.
i'm stumped:
exported database using phpmyadmin version 2.10.1 sql version 5, new database version 5 , following error:

sql query:

-- phpmyadmin sql dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- host: localhost
-- generation time: oct 04, 2009 @ 03:53 pm
-- server version: 5.0.45
-- php version: 5.2.5
set sql_mode = "no_auto_value_on_zero"

#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near '-- phpmyadmin sql dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- ' @ line 1


now thing changed removed 'create database' because can't create server, it's created me. here first line of sql:

-- phpmyadmin sql dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- host: localhost
-- generation time: oct 04, 2009 @ 03:53 pm
-- server version: 5.0.45
-- php version: 5.2.5

set sql_mode="no_auto_value_on_zero";

--
-- database: `dbhutch`
--

use `dbhutch`;

--

can see wrong this? have been doing same thing sites , never have had error. frustrating! have spent 2 hours on this!

hi,

what did, exported database in zipped or none format,

you can try this, if export value in none format queries, in that
please note line
" engine=myisam auto_increment=4 default charset=latin1 auto_increment=4 ;"
remove line in create table queries , copy , paste in sql section of new database,
there might other option instead of removing these, no ideal that,
this try,

regards,





Comments

Popular posts from this blog

How to decompile jsxbin to jsx

Gavik Photoslide GK2: Not able to upload photos - Joomla! Forum - community, help and support

Phoca Guestbook logger registret bruger af - Joomla! Forum - community, help and support