mysql.pm Already exists error

[zaphod]

PerlDesk 3.5
MySQL 5.0.46
DBD-MySQL 4.005
Centos 4.5 (Perl 5.8.5)

We're getting this error on our perdesk install when accessing staff.cgi:

Error executing run mode 'main': DBD::mysql::db do failed: Table 'perlDesk_staff' already exists at extlib/Class/PObject/Driver/mysql.pm line 218. at staff.cgi line 31

and admin.cgi:

Error executing run mode 'plogin': DBD::mysql::db do failed: Table 'perlDesk_staff' already exists at extlib/Class/PObject/Driver/mysql.pm line 218. at admin.cgi line 31

Basically means we're dead in the water.

Any ideas? Other threads point to a fix for an earlier version, but don't detail it. Thanks!

(Ticket lodged earlier today, 12116)

[John]

Hi zaphod,

This was an issue with MySQL which was rolled out a while ago, when you upgraded did you replace:

extlib/Class/PObject/Driver/mysql.pm

Or was this a new install?
Thanks

John

[zaphod]

Hi John,

This was a new install of 3.5. Looking at the patch file in another thread, those changes already exist in the mysql.pm file (that is, around line 206 the code is the updated code).

cheers,
Richard

[Yegor]

Hi Richard!

I've reported this issue to our developers, they'll take a look.

Sorry for inconvenience.

[zaphod]

Any progress? Our helpdesk is currently down because of this issue ...

[John]

Hi Richard

Would it be possible for you to PM me the installation information, we will take a look at it urgently for you.

Thanks

John

[zaphod]

We worked this one out, it was an issue with our DBI, not with PerlDesk. Thanks!