| Autor | darksweetys |
| Datum | 28.10.2008 10:01 |
| Beiträge: |  So, hab die SQL-Datei erfolgreich eingefügt. Einmal nach der Installation der Usermap, einmal vorher. Beides funktioniert nichtAuf jeden Fall weiss ich jetzt wie man Tabellen einfügt +fg+ Beim Installieren der Usermap erfolgt immernoch ne Weiße Seite. Beim Aufruf der Usermap noch folgende Meldung und keine Karte. -------------------------- RROR [512] mysql error: [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 '' at line 1] in EXECUTE("SELECT plz, lon, lat FROM opn_usermap WHERE plz = ") FOUND IN [include/opndb-errorhandler.php] FOUND AT 240 ERROR [512] mysql error: [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 '' at line 1] in EXECUTE("SELECT plz, lon, lat FROM opn_usermap WHERE plz = ") FOUND IN [include/opndb-errorhandler.php] FOUND AT 240 WARNING [8] Trying to get property of non-object FOUND IN [modules/usermap/index.php] FOUND AT 70 WARNING [8] Trying to get property of non-object FOUND IN [modules/usermap/index.php] FOUND AT 71 WARNING [8] Trying to get property of non-object FOUND IN [modules/usermap/index.php] FOUND AT 72 WARNING [8] Trying to get property of non-object FOUND IN [modules/usermap/index.php] FOUND AT 73 ERROR [2] Division by zero FOUND IN [modules/usermap/index.php] FOUND AT 77 ERROR [2] Division by zero FOUND IN [modules/usermap/index.php] FOUND AT 78 ERROR [512] mysql error: [1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='] in EXECUTE("SELECT u2.uname as uname, g.lon as lon, g.lat as lat, g.ort as ort, g.plz as plz FROM opn_user_adress u1 INNER JOIN opn_users u2 on u1.uid = u2.uid INNER JOIN opn_usermap g ON g.plz = u1.zip INNER JOIN opn_users_status stat ON stat.uid = u1.uid WHERE stat.level1>0 ORDER BY u2.uname") FOUND IN [include/opndb-errorhandler.php] FOUND AT 240 ------------------------------------- DarkSweetys |
