search

engaging-computing / phpSENSE

An educational data analytics platform.
http://isenseproject.org
14 stars 10 forks source link

Added a CSV file to exp 531 on live and got this error #579

Closed AlanRosenthal closed 11 years ago

AlanRosenthal commented 11 years ago

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 17SELECT sessions.session_id, sessions.owner_id, sessions.name, sessions.description, sessions.street, sessions.city, sessions.country, sessions.latitude, sessions.longitude, sessions.timecreated, sessions.timemodified, sessions.finalized, users.firstname, users.lastname FROM users, sessions WHERE users.user_id = sessions.owner_id AND sessions.session_id = 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 'AND experiments.experiment_id = experimentSessionMap.experiment_id' at line 1SELECT experiments.name, experiments.experiment_id FROM experimentSessionMap, experiments WHERE experimentSessionMap.session_id = AND experiments.experiment_id = experimentSessionMap.experiment_id

AlanRosenthal commented 11 years ago

uploading a CSV forces column matching which is broken

AlanRosenthal commented 11 years ago

Exp 531 does not work and Exp 532 works...