DBD::mysql::st execute failed: Table 'zm.Config' line 1627

Support and queries relating to all previous versions of ZoneMinder
Locked
User avatar
tek
Posts: 16
Joined: Sat Jan 22, 2005 7:59 pm
Location: Hayward CA
Contact:

DBD::mysql::st execute failed: Table 'zm.Config' line 1627

Post by tek »

Had to abbreviate the subject, here is the actual error

DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at ./zmconfig.pl line 1627.

So big question is what is going on? i am finding myself having to populate the DB manually each time. this is running on mandrake 9.2
here is the rest of the system versions
Server Version: Apache-AdvancedExtranetServer/2.0.47 (Mandrake
Linux/6.12.92mdk) mod_perl/1.99_09 Perl/v5.8.1 mod_ssl/2.0.47
OpenSSL/0.9.7b PHP/4.3.2

mysql Ver 12.21 Distrib 4.0.15, for mandrake-linux-gnu (i586)

I am trying to build this for my landlord/lady, someone keeps breaking into her house and we just want to catch them in the act, she has installed x10 camera's and a alarm system and they keep messing her systems up so they are not able to catch them in the act so we are trying to stream this out to a remote server and have a axis 260w camera.


Any help as to what is missing or going on would be most appreciated.
Thank in advance for your help and time
Tnt
User avatar
tek
Posts: 16
Joined: Sat Jan 22, 2005 7:59 pm
Location: Hayward CA
Contact:

additional info

Post by tek »

Forgot to add, i thought the DBD::mysql::st might been a missing perl module but i am unable find anything via CPAN.
The configure part actually completes without any errors but everything fails when running the perl ./zmconfig.pl

As its trying to query the database which was not getting populated with tables i assumed that might be the cause so i manually created the tables but still get the same error message.
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Post by zoneminder »

Can you post a little more context for the error you are getting?

When you first run zmconfig.pl there will be no database as zmconfig configures the schema script. Then you rerun it after you have created the DB (using the zmschema.sql script) and it populates the config then.

Phil
User avatar
tek
Posts: 16
Joined: Sat Jan 22, 2005 7:59 pm
Location: Hayward CA
Contact:

resolved this part, starting new thread

Post by tek »

dm was not being created correctly. it was reading the schema script and creating a db named ZM_DB_NAME and i was looking at my old zm db
Locked