[Phpmyadmin-devel] User with import error

[Isaac Bennetch]

On Aug 13, 2013, at 8:52 AM, Marc Delisle <marc at infomarc.info> wrote:

> Le 2013-08-13 00:50, Isaac Bennetch a écrit :
>> Hi,
>> 
>> 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, 
>> 'menu_image=-1\npageclass_sfx=\nprint=\nback_button=\nname=2\nposition=1\nemail=0\nstreet_address=1\nsuburb=1\nstate=1\ncountry=1\npostcode=1\ntelephone=1\nfax=1\nmisc=1\nimage=1\nvcard=0\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=0\ndrop_down=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=', 
>> 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.
> 
> It got interrupted at the first \n sequence, so somehow this was
> incorrectly interpreted. Was he running on a Windows server?
> 
> "phpMyAdmin 4.1", you mean he's running the development version of
> phpMyAdmin?

Good point; this is what he reported to me, I'll have to ask again

Thanks

> 
> 
> -- 
> Marc Delisle
> http://infomarc.info
> 
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead. 
> Download for free and get started troubleshooting in minutes. 
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel