#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

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

How to decompile jsxbin to jsx

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