How to get specific database error location in codeigniter?

Question

In codeIgniter I see that if query has error codeignter only show database error. but codeigniter doesn't say which file's line error. here a example

A Database Error Occurred

Error Number: 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 
      //some thing goes here
Filename: C:\xampp\htdocs\bata_shop\system\database\DB_driver.php

Line Number: 330

Sometimes it difficult to find which query is wrong. How do I get specific database error location in codeigniter?

It however tells you which queries went wrong, this can be leveraged. But to your point, codeigniter's limitation is there. Perhaps time to switch to more modern framework (if you are still early on in your development stage)? — JofryHS
– JofryHS, Commented Sep 12, 2013 at 3:35

Suvash sarker · Accepted Answer · 2013-09-18 15:02:43Z

3

A dirty Solution for CI 2 and it helped me:-

Go and edit system\database\DB_driver.php and add the following code on line 321:-

echo "<pre>";
debug_print_backtrace();
echo "</pre>";

answered Sep 18, 2013 at 15:02

Suvash sarker

3,1451 gold badge21 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Imran Over a year ago

I knew this idea. but I'm little afraid for use this. Because If It is suitable, why CI could not use directly?

saurabh kamble · Accepted Answer · 2013-09-13 12:53:54Z

1

This is happening due the database.php file not set correctly please check your database file and all database related problem are in that file only

answered Sep 13, 2013 at 12:53

saurabh kamble

1,5492 gold badges25 silver badges44 bronze badges

2 Comments

Imran Over a year ago

I am not understand your answer. If I was not set my database how was running correct query.

saurabh kamble Over a year ago

I was Trying to tell you that if there an database connection error they there is problem in that database.php file only this for the connection purpose

Collectives™ on Stack Overflow

How to get specific database error location in codeigniter?

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related