[Phpmyadmin-devel] User with import error

Isaac Bennetch bennetch at gmail.com
Tue Aug 13 00:50:36 CEST 2013


A user is in IRC with some trouble doing an export from phpMyAdmin and 
import to another machine. The machine he's importing to

#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 ''pageclass_sfx=\nback_button=\nitem_title' at line 52

The slightly obscured relevant section of the SQL file reads

INSERT INTO `jos_contact_details` (`id`, `name`, `con_position`, 
`address`, `suburb`, `state`, `country`, `postcode`, `telephone`, `fax`, 
`misc`, `image`, `imagepos`, `email_to`, `default_con`, `published`, 
`checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, 
`catid`, `access`) VALUES
(1, 'Joe', '', 'foo', 'Arima', 'State', 'bar', '', 'baz', '(868) 642 
3164', 'Miscellanous info', '', 'top', 'foo', 0, 0, 0, '0000-00-00 
00:00:00', 10, 
62, 12, 0)

Nothing looks odd there, and indeed it works properly for me to import 
on the demo server. He's using MySQL 5 and phpMyAdmin 4.1 for the 
import. Any thoughts about why he's having trouble? I don't see any 
obviously incompatible statements.

More information about the Developers mailing list