|Anonymous | Login | Signup for a new account||2017-04-29 23:24 EDT|
|My View | View Issues | Change Log | Roadmap | Repositories | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0003911||ATutor||Modules||public||2009-08-11 03:08||2009-12-01 08:41|
|Target Version||Fixed in Version||1.6.4|
|Summary||0003911: SQL queries preceeded by comments are skipped on module installation|
|Description||If a module.sql file contains a "/*"-style comment (even on a separate line), during file parsing it gets prepended to the SQL query immediately following it instead of being discarded. Supposedly, function splitSqlFile() of include/classes/sqlutility.class.php is responsible for that bug.|
Once that happens, function prefixQuery() tries to detect a SQL command (like INSERT, UPDATE, CREATE TABLE etc.) at the start of the query and fails because of a comment being there. As a result, TABLE_PREFIX is never appended to the query in question and the query fails too.
That can (and, in fact, did) have effects as adverse as failing to create a table for a module to store data in.
The bug doesn't happen with "#"-style comments.
|Tags||No tags attached.|
SVN revision: 8895
Solution: handle comment signs "/* ... */". Now, the accepted comment signs in atutor sql files are: "# ", "/* ... */", "--". All comment start signs must be at the beginning of the line.
Affected scripts: include/classes/sqlutility.class.php
|2009-08-11 03:08||IndieRect||New Issue|
|2009-08-11 03:08||IndieRect||Affects version||=> SVN|
|2009-11-05 10:01||greg||Status||new => assigned|
|2009-11-05 10:01||greg||Assigned To||=> cindy|
|2009-11-09 10:09||cindy||Status||assigned => resolved|
|2009-11-09 10:09||cindy||Fixed in Version||=> 1.6.4|
|2009-11-09 10:09||cindy||Resolution||open => fixed|
|2009-11-09 10:09||cindy||Note Added: 0003851|
|2009-12-01 08:41||greg||Status||resolved => closed|
|Copyright © 2000 - 2017 MantisBT Team|