Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001473TestLinkDatabase MySQLpublic2008-04-08 19:192008-11-07 19:45
Reportergunter 
Assigned Toschlundus 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.8 Beta 1 
Fixed in Version1.8 Beta 3 
Summary0001473: SQL Error on importing testcases
DescriptionI have exported testcases from 1.7.4 with keywords.
Then i have changed in 1.8.beta1 the follow lines:

//define('TL_IMPORT_LIMIT', '204800'); // in bytes
define('TL_IMPORT_LIMIT', '1024000'); // in bytes

/** maximum line size of the imported file */
//define('TL_IMPORT_ROW_MAX', '10000'); // in chars
define('TL_IMPORT_ROW_MAX', '100000'); // in chars

all other is original.

Most Testcases will imported but i get some Errors:

ERROR ON exec_query() - database.class.php
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 - INSERT INTO object_keywords (fk_id,fk_table,keyword_id) VALUES (960,'nodes_hierarchy',)

THE MESSAGE :: SQL [5479] executed [took 0.0049 secs][all took 31.8427 secs]: INSERT INTO object_keywords (fk_id,fk_table,keyword_id) VALUES (960,'nodes_hierarchy',) Query failed: errorcode[1064] errormsg: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
ERROR ON exec_query() - database.class.php
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 - INSERT INTO object_keywords (fk_id,fk_table,keyword_id) VALUES (1066,'nodes_hierarchy',)

THE MESSAGE :: SQL [6107] executed [took 0.0031 secs][all took 34.9061 secs]: INSERT INTO object_keywords (fk_id,fk_table,keyword_id) VALUES (1066,'nodes_hierarchy',) Query failed: errorcode[1064] errormsg: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

TagsNo tags attached.
Database (MySQL,Postgres,etc)
BrowserFirefox 2.0.0.13
PHP Version5.2.0
TestCaseID
QA Team - Task Workflow Status
Attached Fileszip file icon all_testsuites.zip [^] (350,632 bytes) 2008-04-09 12:45

- Relationships

-  Notes
(0003429)
fman (administrator)
2008-04-09 00:45

please attach here in zip file your export

- Issue History
Date Modified Username Field Change
2008-04-08 19:19 gunter New Issue
2008-04-08 19:19 gunter Browser => Firefox 2.0.0.13
2008-04-08 19:19 gunter PHP Version => 5.2.0
2008-04-09 00:45 fman Note Added: 0003429
2008-04-09 12:45 gunter File Added: all_testsuites.zip
2008-04-15 02:28 schlundus Status new => assigned
2008-04-15 02:28 schlundus Assigned To => schlundus
2008-05-12 05:12 schlundus Status assigned => resolved
2008-05-12 05:12 schlundus Fixed in Version => 1.8 RC 1 (planned)
2008-05-12 05:12 schlundus Resolution open => fixed
2008-09-16 02:31 mhavlat Fixed in Version next development 1.8 RC 1 => 1.8 Beta 3
2008-11-07 19:45 mhavlat Status resolved => closed



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker