foutmelding inlezen database dump

Status
Niet open voor verdere reacties.

mariannevanh

Terugkerende gebruiker
Lid geworden
14 dec 2004
Berichten
2.085
Bij het inlezen van een dump van een database die ik in 2014 maakte, krijg ik de melding die begint met:

Code:
Fout
Statische analyse:

67 fouten werden gevonden tijdens de analyse.

Onverwachte letter. (near "\" at position 1626)
Onverwachte letter. (near "\" at position 1628)
Onverwachte letter. (near "\" at position 1694)
Onverwachte letter. (near "\" at position 1696)

De data die eronder wordt weergegeven is:

Code:
INSERT INTO `tng_places` (`ID`, `gedcom`, `place`, `longitude`, `latitude`, `zoom`, `placelevel`, `temple`, `geoignore`, `notes`) VALUES (84842, 'familie', 'Fayette County, Ohio, USA', '-83.4643551', '39.5919809', 10, 4, 0, 0, 'Fayette County is a county located in the state of Ohio, United States. As of the 2000 census, the population was 28,433. Its county seat is Washington Court House. It was named for the Marquis de Lafayette, a Frenchman who was an officer in the American Army in the Revolution, when established on March 1, 1810.\r\nThe Washington Court House Micropolitan Statistical Area includes all of Fayette County.\r\nHistory\r\nFayette County was formed on March 1, 1810 from portions of Highland County and Ross County. It was named after Marie-Joseph Motier, Marquis de La Fayette, a French general and politician who took the side of the Colonials during the American Revolutionary War and who played an important role in the French Revolution\r\nCommunities\r\nCity\r\n Washington Court House\r\n Villages\r\n Bloomingburg\r\n Greenfield+\r\n Jeffersonville\r\n Milledgeville\r\n New Holland, (84845, 'familie', 'Cass Lake, Cass County, Minnesota, USA', '-94.60713386535645', '47.380980682089785', 15, 3, 0, 0, 'Cass Lake is a city in Cass County, Minnesota, United States, located within the boundaries of the Leech Lake Indian Reservation, and is surrounded by Pike Bay Township. Cass Lake had a population of 770 in the 2010 census. It is notable as the headquarters location of the Chippewa National Forest, as well as the Minnesota Chippewa Tribe and Leech Lake Band of Ojibwe.\r\nCass Lake is part of the Brainerd Micropolitan Statistical Area.\r\nThe city is located on the shore of its namesake Cass Lake, which in turn was named in honor of Michigan Governor Lewis Cass.\r\nHistory\r\nThe village was established in 1898 with the construction of the Great North Railway. The post office was originally established as ''Tuller'' in December 1898, named after the brother-in-law of the first postmaster. However, once this decision became known, the residents quickly lodged protests with the Postamaster General and by the end of March 1899 it was renamed ''Cass Lake''.\r\nThe former wood treating plant operated by Wheeler Lumber within the city limits is a Federal Superfund site, due to soil and groundwater contamination by wood treating compounds.\r\nA previous mayor, Elaine Fleming, was the first Native American to hold that position.'), (84846, 'familie', 'Dawson, Richardson County, Nebraska, USA', '-95.83056449890137', '40.13230055299992', 16, 3, 0, 0, 'Dawson is a village in Richardson County, Nebraska, United States. The population was 209 at the 2000 census.'),

Wie kan mij vertellen wat er fout is?

Vriendelijke groet,
Guido
 
Wat zegt mysqli_error()
 
Zonder een foutmelding te kennen
Ik gok op de regellengte.... meer dan 2000 karakters dat vinden veel programma's niet echt leuk
De foutmeldingen staat op plaatsen waar +\r\n in de regel staan. Is er een verband ?
Kan je exporteren van je database andere optie's kiezen? dat brengt misschien een oplossing

Gr. Peter
 
phpMyAdmin geeft zelf een duidelijke error.
En volgens mij komt jouw gegeven error niet uit phpMyAdmin?
 
Is de database groot of bevat deze bedrijfsgevoelige informatie ?
Zo niet stuur dan even een email, dan lees ik m ff in naar een bestand naar keuze.

Gr.Peter
 
Er valt me overigens iets op. Na het plakken van de tekst uit de SQL-dump verschijnt er een foutmelding onderin beeld:
Code:
Er is een fatale JavaScript-fout opgetreden. Wil u een foutmeldingsverslag verzenden?

Is dat een oorzaak van de foutmelding?
 
Status
Niet open voor verdere reacties.
Steun Ons

Nieuwste berichten

Terug
Bovenaan Onderaan