View Issue Details

IDProjectCategoryView StatusLast Update
0023118mantisbtdb oraclepublic2023-04-28 14:06
ReporterSurya Teja Assigned Todregad  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionunable to reproduce 
Product Version2.5.1 
Summary0023118: Getting Missing comma error while inserting the data into m_user table at check and install Database step
Description

BAD
INSERT INTO m_user( username, realname, email, password, date_created, last_visit, enabled, protected, access_level, login_count, lost_password_request_count, failed_login_count, cookie_string ) VALUES ( 'administrator', '', 'root@localhost', '63a9f0ea7bb98050796b649e85481845', ''2017-07-17 06:58:38'', ''2017-07-17 06:58:38'', '1', '0', 90, 3, 0, 0, 'dbf8d7a4ee1106191352840948693df57d8b0663e5e1b815cc497b51b0b737cb' )
ORA-00917: missing comma

When i tried this query in sql developer it was shown that there is as issue with the time in the query. It was expecting a comma in between the two single quotes before the time (''2017-07-17 06:58:38'', ''2017-07-17 06:58:38''). and one more is the columns 'date_created' and 'last_visit' are of date datatype but the query in schema.php is given with timestamp to insert.

Steps To Reproduce
  1. open http://orb14.orbit8.com/mantisbt/admin/install.php in web browser
  2. Give the db details
  3. click Install/Upgrade Database
TagsNo tags attached.
Attached Files
Error Screenshot.JPG (68,189 bytes)   
Error Screenshot.JPG (68,189 bytes)   

Activities

dregad

dregad

2023-04-17 05:33

developer   ~0067664

A bit late to the party, sorry. I assume this is no longer a problem and you somehow managed to work around the problem since then.

Just in case, the generated SQL seems strange - I would expect the timestamps to look like timestamp'yyyy-mm-dd hh:mm:ss' (since 1.3.0) and not this weird doubled single-quotes shown in your report.
If you can, please confirm that the problem persists in the latest version.