Codeigntier occasional database connection error

Question

I'm using Codeigniter, and I have have not had any issues connecting to the database in the past.

I was doing some restructuring of the database (adding columns, inserting data, etc), and now I get an error that only occasionally appears. It does not appear on any specific page, and usually disappears after refresh. Only appears every 10-20 times I view a page.

A Database Error Occurred
Unable to select the specified database: www.site.com

Filename: core/Loader.php

Line Number: 242

Seems to be very similar to the problem here: Trouble with HMVC modular extensions for CodeIgniter

Looks like it could be a problem with the database itself? Any suggestions would be appreciated....

Have you analyzed your tables to see if any of them are in need of repair? — Chris Schmitz, Aug 06 '11 at 16:45
Analyzed tables returned with "OK" or "Table is already up to date." — Marty Thomas, Aug 07 '11 at 13:36

score 0 · Answer 1 · answered Apr 27 '14 at 07:53

0

It is a database issue. I would suggest you to :

Export the db file
Take a copy of the project
Use a new system and import the db + copy the project folder and see if the problem still remains the same.

Great way to debug the issue.

answered Apr 27 '14 at 07:53

prat1kk

408
5
12

score 0 · Answer 2 · answered Jan 19 '12 at 22:26

0

Looks like database problem to me, not CI. Maybe your database files are corrupted?

answered Jan 19 '12 at 22:26

lokers

2,106
2
18
19

Codeigntier occasional database connection error

2 Answers2