DBD::mysql::db error

Support and queries relating to all previous versions of ZoneMinder
Locked
kevin1ab
Posts: 13
Joined: Tue Jan 27, 2004 5:47 am

DBD::mysql::db error

Post by kevin1ab »

Hello,
I'm starting a new thread as I decided that it would be best to re-install the latest version
of ZM.

I started fresh, ./configure... runs fine but when running 'perl ./zmconfig.pl', I get the following
error:

Saving config to 'zmconfig.txt'
Saving config to DB
DBD::mysql::db do failed: Table 'zm.Config' doesn't exist at ./zmconfig.pl line 1270, <> line 74.
Can't do 'delete from Config': Table 'zm.Config' doesn't exist at ./zmconfig.pl line 1270, <> line 74.

Looks like it's not creating zm.Config [?] and it didn't create the schema file to import into the db.
I tried installing 1.17.1 again with the same error so I must be doing something wrong as I had
1.17.1 basically running.

Any help is appreciated greatly,
TIA

Kevin
kevin1ab
Posts: 13
Joined: Tue Jan 27, 2004 5:47 am

Re: DBD::mysql::db error

Post by kevin1ab »

Hello,

Just found this after posting. I'll work on it.

http://www.zoneminder.com/forum_install ... 94290c5a22

Kevin
kevin1ab
Posts: 13
Joined: Tue Jan 27, 2004 5:47 am

Re: DBD::mysql::db error

Post by kevin1ab »

Well, the database does exist so I must have some other problem going on.
Is this error happening at the point where the script tries to contact the database??

Kevin
pchan
Posts: 50
Joined: Thu Jan 15, 2004 9:38 pm

Re: DBD::mysql::db error

Post by pchan »

Maybe my other thread will shed a little light:

http://www.zoneminder.com/forum_install ... 0862d66601

I got the exact "error" that you got above.
Sounds like you have the database created but no tables. Try to drop the database as Phil suggests in the above thread.
kevin1ab
Posts: 13
Joined: Tue Jan 27, 2004 5:47 am

Re: DBD::mysql::db error

Post by kevin1ab »

Hi

Thanks
That was exactly the problem. I had manually created the database so I dropped it
and let the script create it.

Thanks

Kevin
Locked