|
|
| Author |
Message |
A7V
Contributor
Joined: 18 Jun 2004
Posts: 53
Location: Lisbon, Portugal
|
 Posted: Mon Oct 04, 2004 6:09 pm Post subject: DB_ERROR: Sorry, a database error occured. |
 |
|
Just got the following error:
| Code: |
| DB_ERROR: Sorry, a database error occured. We cannot continue. Please contact the administrator and let them know what you were doing when the problem occured |
I just selected a device, Recached Intefaces, selected all interfaces and pressed "Monitor/Graph All Checked"
I tried selecting just one interface and even deleting the device and adding it again with no luck, I always get the same error message.
This is the first time it has ever happened and I can replicate the issue easily.
Any hints?  |
|
| Back to top |
|
 |
validan
Contributor
Joined: 12 May 2004
Posts: 37
|
| Posted: Mon Oct 04, 2004 6:33 pm Post subject: |
|
|
| Can you paste in a copy of the Listing of the interfaces? |
|
| Back to top |
|
|
keb
Contributor
Joined: 09 Jul 2003
Posts: 44
Location: Camp Hill, PA, USA
|
| Posted: Tue Oct 05, 2004 5:05 am Post subject: |
|
|
Set dbdebug to true in config.php and perform the same steps you took to get the error. This will show you the db query that failed and will assist us in finding the source of the problem.
Also, is this in 0.17 or an earlier version?
Thanks,
Kevin |
|
| Back to top |
|
|
A7V
Contributor
Joined: 18 Jun 2004
Posts: 53
Location: Lisbon, Portugal
|
| Posted: Wed Oct 06, 2004 2:44 pm Post subject: |
|
|
| Code: |
DB_ERROR: Couldn't execute query:
INSERT INTO sub_devices SET dev_id='129', type=2, name='PIX Firewall 'INTERNET' interface'
You have an error in your SQL syntax near 'INTERNET' interface'' at line 1 |
OK, the reason is something I though off, but since I have 2 more devices with similar names I guessed it wouldn't be a problem: the ' character. I have 2 more devices that are currently being graphed and who's interfaces have the same naming scheme and were added with no issues 
I wasn't the one to add the old ones, so I can precise if the interface names was like this at the time they were added to NetMRG.
Comments? |
|
| Back to top |
|
|
keb
Contributor
Joined: 09 Jul 2003
Posts: 44
Location: Camp Hill, PA, USA
|
| Posted: Wed Oct 06, 2004 11:43 pm Post subject: |
|
|
| A7V wrote: |
| OK, the reason is something I though off, but since I have 2 more devices with similar names I guessed it wouldn't be a problem: the ' character. I have 2 more devices that are currently being graphed and who's interfaces have the same naming scheme and were added with no issues |
The error is because the name isn't being escaped correctly. bug#295 was created to deal with these escaping issues. This should be resolved by the next release (either 0.17.1 or 0.18).
- Kevin |
|
| Back to top |
|
|
A7V
Contributor
Joined: 18 Jun 2004
Posts: 53
Location: Lisbon, Portugal
|
| Posted: Thu Oct 07, 2004 1:14 pm Post subject: |
|
|
Thank you for the help.
I guess I owe everyone an apology as I did what should never be done: submit a new problem without searching if anyone had reported it already  |
|
| Back to top |
|
|
|
