• Resolved Gunu

    (@grafcom)


    Hello,

    because I’m going to change hosting I am moving the database.

    However, when importing one table – wp_wppa_photos

    I get the following message (you see only a part of it)

    Fout
    
    Statische analyse:
    
    1803 fouten werden gevonden tijdens de analyse.
    
        Een komma of een sluitingshaakje werd verwacht (near "jpg" at position 42556)
        31 waarden werden verwacht, maar 5 gevonden. (near "(" at position 42494)
        Onverwacht token. (near "', '" at position 42559)
        Onverwacht token. (near "01" at position 42563)
        Onverwacht token. (near "-1956" at position 42565)
        Onverwacht token. (near "-" at position 42570)
        Onverwacht token. (near "roryblock" at position 42571)
        Onverwacht token. (near "-" at position 42580)
        Onverwacht token. (near "lovinwhis" at position 42581)
        Onverwacht token. (near "." at position 42590)
        Onverwacht token. (near "jpg" at position 42591)
        Onverwacht token. (near "', '" at position 42594)
        Onverwacht token. (near "(" at position 42807)
        Onverwacht token. (near "218" at position 42808)

    An idea what I can do?

    Thanks

    https://ww.wp.xz.cn/plugins/wp-photo-album-plus/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter Gunu

    (@grafcom)

    Complementing previous post…

    MySQL meldt: Documentatie
    #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 'jpg', '01-1956-roryblock-lovinwhis.jpg', '#1956 Rory Block - Lovin’ Whiskey', ' at line 201
    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    During what operation ( which program ) did you get the errors?

    Thread Starter Gunu

    (@grafcom)

    phpMyAdmin export tabel from one hosting – phpMyAdmin version 4.0.10.10
    phpMyAdmin import tabel to new hosting. – phpMyAdmin version 4.5.0.2

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Are you sure both databases have the same charset? Preferrably utf8.

    Thread Starter Gunu

    (@grafcom)

    Yes, both are in the same charset uft8…

    I am now going to try it in csv format. Can I still encounter problems with that, do you know?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    The photos table contains text ( photo descriptions etc ) with quotes and other ‘funny’ characters, so you should indeed use a .csv file.

    Thread Starter Gunu

    (@grafcom)

    Goedemorgen Jacob 🙂

    Yes problem solved… .csv file that worked… No errors

    All the images displayed on the site again!

    Thanks

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Mooi!

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘database table errors’ is closed to new replies.